import { eq, sql } from "drizzle-orm"
import { db } from "@/lib/db/client"
import { domainEvents, notifications, taskInstances } from "@/lib/db/schema"

const s = await db
  .select({ s: taskInstances.status, n: sql<number>`count(*)::int` })
  .from(taskInstances).groupBy(taskInstances.status).orderBy(taskInstances.status)
console.log("statuts :", s)

const [victim] = await db
  .select({ id: taskInstances.id, s: taskInstances.status, st: taskInstances.startedAt })
  .from(taskInstances)
  .where(eq(taskInstances.id, "5ea2cdd2-92c3-4149-898a-e17cecdb58e2"))
console.log("la ligne de ma premiere sonde :", victim)

const [e] = await db.select({ n: sql<number>`count(*)::int` }).from(domainEvents)
const [n] = await db.select({ n: sql<number>`count(*)::int` }).from(notifications)
console.log("evenements / notifications :", e?.n, n?.n)
process.exit(0)