spb/note-spboucher-ai

1import { desc, eq } from "drizzle-orm";2import { handler } from "@/lib/api";3import { db, schema } from "@/db";4/** GET → the current user's registered passkeys (register/delete go through /api/auth/passkey). */5export const GET = handler(async ({ user }) => {6  const rows = await db.select({ id: schema.webauthnCredentials.id, label: schema.webauthnCredentials.label, deviceType: schema.webauthnCredentials.deviceType, backedUp: schema.webauthnCredentials.backedUp, transports: schema.webauthnCredentials.transports, createdAt: schema.webauthnCredentials.createdAt, lastUsedAt: schema.webauthnCredentials.lastUsedAt }).from(schema.webauthnCredentials).where(eq(schema.webauthnCredentials.userId, user.id)).orderBy(desc(schema.webauthnCredentials.createdAt));7  return Response.json(rows);8});9