⚡ 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 { DEFAULT_ROLE_NAMES } from "@kaneo/permissions";
import { and, eq } from "drizzle-orm";
import { schema } from "../database";
import type { DbOrTx } from "../project-access/db-or-tx";
export async function isAssignableWorkspaceRole(
database: DbOrTx,
workspaceId: string,
role: string,
): Promise<boolean> {
if (role.includes(",") || role === "owner") return false;
if ((DEFAULT_ROLE_NAMES as readonly string[]).includes(role)) return true;
const [custom] = await database
.select({ id: schema.workspaceRoleTable.id })
.from(schema.workspaceRoleTable)
.where(
and(
eq(schema.workspaceRoleTable.workspaceId, workspaceId),
eq(schema.workspaceRoleTable.role, role),
),
)
.limit(1);
return Boolean(custom);
}