/** Jetable. Quel niveau porte chaque poste de direction ? */
import { asc, sql } from "drizzle-orm"

import { db } from "@/lib/db/client"
import { positions, tierOf } from "@/lib/db/schema"

const rows = await db
  .select({ level: positions.level, n: sql<number>`count(*)::int` })
  .from(positions)
  .groupBy(positions.level)
  .orderBy(asc(positions.level))

console.log(rows.map((r) => ({ ...r, tier: tierOf(r.level) })))

const top = await db
  .select({ title: positions.title, level: positions.level })
  .from(positions)
  .where(sql`${positions.title} ilike '%director%' or ${positions.title} ilike '%กรรมการ%'`)
console.log(top)

process.exit(0)