⚡ 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 { and, eq } from "drizzle-orm";
import { HTTPException } from "hono/http-exception";
import db from "../../database";
import { projectTable } from "../../database/schema";
async function archiveProject(id: string, workspaceId: string) {
const [existingProject] = await db
.select()
.from(projectTable)
.where(
and(eq(projectTable.id, id), eq(projectTable.workspaceId, workspaceId)),
);
if (!existingProject) {
throw new HTTPException(404, {
message:
"Project doesn't exist or doesn't belong to the specified workspace",
});
}
const [archivedProject] = await db
.update(projectTable)
.set({ archivedAt: new Date() })
.where(eq(projectTable.id, id))
.returning();
if (!archivedProject) {
throw new HTTPException(500, {
message: "Failed to archive project",
});
}
return archivedProject;
}
export default archiveProject;