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.

667 B
Raw Blame
import { count } from "drizzle-orm";
import db, { schema } from "../../database";
import { instanceAdminRoleSql } from "../../utils/instance-admin-role";
import { hasRegisteredUsers } from "../../utils/instance-bootstrap";

export type InstanceStatus = {
  hasUsers: boolean;
  hasAdmin: boolean;
};

async function getInstanceStatus(): Promise<InstanceStatus> {
  const hasUsers = await hasRegisteredUsers();
  const [adminRow] = await db
    .select({ value: count() })
    .from(schema.userTable)
    .where(instanceAdminRoleSql(schema.userTable.role));

  return {
    hasUsers,
    hasAdmin: (adminRow?.value ?? 0) > 0,
  };
}

export default getInstanceStatus;