Skip to content

armgit / kaneo

Public Imported from GitHub
0

⚡ Project management that doesn't become the project. Boards, Gantt charts, and GitHub integration. Self-host it or use Kaneo Cloud.

1.9 KB
Raw Blame
import { count, eq, sql } from "drizzle-orm";
import db from "../../database";
import {
  instanceRoleTable,
  instanceSettingsTable,
  userTable,
} from "../../database/schema";
import { ApiError } from "../../errors/api-error";
import type { AdminAuditRequest } from "../audit/admin-audit-request";
import { recordAdminAction } from "../audit/record-admin-action";
import { lockInstanceRole } from "../roles/lock-instance-role";

/** Delete a role nobody has. Assignments share-lock the role row first. */
async function deleteInstanceRole(roleId: string, audit: AdminAuditRequest) {
  return db.transaction(async (tx) => {
    const role = await lockInstanceRole(roleId, tx);
    const [assigned] = await tx
      .select({ value: count() })
      .from(userTable)
      .where(sql`${role.name} = ANY(string_to_array(${userTable.role}, ','))`);
    const userCount = assigned?.value ?? 0;
    if (userCount > 0) {
      throw new ApiError(409, {
        code: "ROLE_IN_USE",
        message: `This role is assigned to ${userCount} ${userCount === 1 ? "user" : "users"}. Give them another role first.`,
      });
    }

    const [defaultFor] = await tx
      .select({ id: instanceSettingsTable.id })
      .from(instanceSettingsTable)
      .where(eq(instanceSettingsTable.defaultRoleId, roleId))
      .limit(1);
    if (defaultFor) {
      throw new ApiError(409, {
        code: "ROLE_IS_DEFAULT",
        message:
          "New users get this role. Choose another default role in instance settings first.",
      });
    }

    await tx.delete(instanceRoleTable).where(eq(instanceRoleTable.id, roleId));
    await recordAdminAction(
      {
        ...audit,
        action: "role.deleted",
        targetType: "role",
        targetId: roleId,
        targetLabel: role.name,
        metadata: { permissions: role.permissions },
      },
      tx,
    );
    return { id: roleId };
  });
}

export default deleteInstanceRole;