Skip to content

Open source file-system and knowledge based agent template. Build AI agents that stay up to date with your knowledge base

780 B
Raw Blame
import { db, schema } from '@nuxthub/db'
import { desc, eq } from 'drizzle-orm'

export default defineEventHandler(async (event) => {
  await requireAdmin(event)

  return db
    .select({
      id: schema.apikey.id,
      name: schema.apikey.name,
      prefix: schema.apikey.prefix,
      start: schema.apikey.start,
      referenceId: schema.apikey.referenceId,
      enabled: schema.apikey.enabled,
      expiresAt: schema.apikey.expiresAt,
      createdAt: schema.apikey.createdAt,
      userName: schema.user.name,
      userEmail: schema.user.email,
      userImage: schema.user.image,
      userRole: schema.user.role,
    })
    .from(schema.apikey)
    .leftJoin(schema.user, eq(schema.user.id, schema.apikey.referenceId))
    .orderBy(desc(schema.apikey.createdAt))
})