⚡ Project management that doesn't become the project. Boards, Gantt charts, and GitHub integration. Self-host it or use Kaneo Cloud.
TypeScript honoissue-managementissue-trackerjira-alternativekanbanlinear-alternativemcpproject-managementreactself-hostedtypescript
import { eq } from "drizzle-orm";
import { HTTPException } from "hono/http-exception";
import db from "../../database";
import { columnTable } from "../../database/schema";
import { publishEvent } from "../../events";
import { getProjectSubtaskParentProjects } from "../../task/get-subtask-parent-projects";
async function updateColumn(
id: string,
data: {
name?: string;
icon?: string | null;
color?: string | null;
isFinal?: boolean;
},
) {
const existing = await db.query.columnTable.findFirst({
where: eq(columnTable.id, id),
});
if (!existing) {
throw new HTTPException(404, { message: "Column not found" });
}
const [updated] = await db
.update(columnTable)
.set({
...(data.name !== undefined && { name: data.name }),
...(data.icon !== undefined && { icon: data.icon }),
...(data.color !== undefined && { color: data.color }),
...(data.isFinal !== undefined && { isFinal: data.isFinal }),
})
.where(eq(columnTable.id, id))
.returning();
if (!updated) {
throw new HTTPException(500, { message: "Failed to update column" });
}
if (existing.isFinal !== updated.isFinal) {
await publishEvent("column.finality_changed", {
projectId: updated.projectId,
status: updated.slug,
isFinal: updated.isFinal,
});
const parents = await getProjectSubtaskParentProjects(
updated.projectId,
updated.slug,
);
await publishEvent("subtask-parents.refresh", {
projects: [
{ projectId: updated.projectId },
...parents.filter((p) => p.projectId !== updated.projectId),
],
});
}
await publishEvent("project.updated", { projectId: updated.projectId });
return updated;
}
export default updateColumn;