⚡ 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, ne, or, sql } from "drizzle-orm";
import type db from "../database";
import { projectTable } from "../database/schema";
export function isSameProjectKey(a: string, b: string) {
return (
a.normalize("NFKC").toLowerCase() === b.normalize("NFKC").toLowerCase()
);
}
export function mayMatchProjectKey(key: string) {
return or(
sql`lower(${projectTable.slug}) = lower(${key.normalize("NFKC")})`,
sql`octet_length(${projectTable.slug}) <> char_length(${projectTable.slug})`,
);
}
export async function findProjectKeyConflict(
database: Pick<typeof db, "select">,
workspaceId: string,
key: string,
{ excludeProjectId }: { excludeProjectId?: string } = {},
) {
const projects = await database
.select({ name: projectTable.name, slug: projectTable.slug })
.from(projectTable)
.where(
and(
eq(projectTable.workspaceId, workspaceId),
mayMatchProjectKey(key),
excludeProjectId ? ne(projectTable.id, excludeProjectId) : undefined,
),
);
return projects.find((project) => isSameProjectKey(project.slug, key));
}
export function projectKeyTakenMessage(key: string, projectName: string) {
return `This workspace already has a project using the key "${key}" (${projectName}). Choose a different key.`;
}