⚡ 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 db from "../../database";
import { projectTable } from "../../database/schema";
import {
insertUnplacedProject,
placeProject,
} from "../../project/controllers/insert-project";
import { createWithUniqueKey } from "./create-with-unique-key";
type Transaction = Parameters<Parameters<typeof db.transaction>[0]>[0];
type CreatedProject = NonNullable<
Awaited<ReturnType<typeof insertUnplacedProject>>
>;
export type ImportProjectInput = {
workspaceId: string;
name: string;
userId: string;
preferredKey?: string;
};
export async function createImportProject<T>(
{ workspaceId, name, userId, preferredKey }: ImportProjectInput,
fill: (tx: Transaction, project: CreatedProject) => Promise<T>,
): Promise<T> {
const existing = await db
.select({ slug: projectTable.slug })
.from(projectTable)
.where(eq(projectTable.workspaceId, workspaceId));
return createWithUniqueKey(
name,
existing.map((row) => row.slug),
(slug) =>
db.transaction(async (tx) => {
const project = await insertUnplacedProject(tx, {
workspaceId,
name,
icon: "Layout",
slug,
userId,
});
if (!project) throw new Error("Failed to create the imported project");
const result = await fill(tx, project);
await placeProject(tx, { workspaceId, projectId: project.id, slug });
return result;
}),
{ preferredKey },
);
}