⚡ 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, sql } from "drizzle-orm";
import { HTTPException } from "hono/http-exception";
import db from "../../database";
import { projectTable } from "../../database/schema";
import { findProjectKeyConflict } from "../project-key";
async function unarchiveProject(id: string, workspaceId: string) {
return db.transaction(async (tx) => {
await tx.execute(
sql`SELECT pg_advisory_xact_lock(1524, hashtext(${workspaceId}))`,
);
const [existingProject] = await tx
.select()
.from(projectTable)
.where(
and(eq(projectTable.id, id), eq(projectTable.workspaceId, workspaceId)),
)
.for("update");
if (!existingProject) {
throw new HTTPException(404, {
message:
"Project doesn't exist or doesn't belong to the specified workspace",
});
}
const keyConflict = await findProjectKeyConflict(
tx,
workspaceId,
existingProject.slug,
{ excludeProjectId: id },
);
if (keyConflict) {
throw new HTTPException(409, {
message: `This workspace already has a project using the key "${existingProject.slug}" (${keyConflict.name}). Change one of the keys before unarchiving this project.`,
});
}
const [unarchivedProject] = await tx
.update(projectTable)
.set({ archivedAt: null })
.where(eq(projectTable.id, id))
.returning();
if (!unarchivedProject) {
throw new HTTPException(500, {
message: "Failed to unarchive project",
});
}
return unarchivedProject;
});
}
export default unarchiveProject;