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.1 KB
Raw Blame
import { desc, eq } from "drizzle-orm";
import db from "../../database";
import { apikeyTable } from "../../database/schema";
import { findAdminTargetUser } from "../find-admin-target-user";

const iso = (date: Date | null) => (date ? date.toISOString() : null);

/** A user's API keys as metadata only: never the key or its hash. */
async function listUserApiKeys(userId: string) {
  await findAdminTargetUser(db, userId);
  const rows = await db
    .select({
      id: apikeyTable.id,
      name: apikeyTable.name,
      start: apikeyTable.start,
      enabled: apikeyTable.enabled,
      createdAt: apikeyTable.createdAt,
      lastRequest: apikeyTable.lastRequest,
      expiresAt: apikeyTable.expiresAt,
    })
    .from(apikeyTable)
    .where(eq(apikeyTable.referenceId, userId))
    .orderBy(desc(apikeyTable.createdAt), desc(apikeyTable.id));

  return {
    apiKeys: rows.map((row) => ({
      id: row.id,
      name: row.name,
      start: row.start,
      enabled: row.enabled ?? true,
      createdAt: row.createdAt.toISOString(),
      lastUsedAt: iso(row.lastRequest),
      expiresAt: iso(row.expiresAt),
    })),
  };
}

export default listUserApiKeys;