/**
 * Jetable. Vérifie que la semaine de six jours atteint vraiment le moteur :
 * compte les instances tombant un samedi avant et après un passage du job.
 */
import { sql } from "drizzle-orm"

import { db } from "@/lib/db/client"
import { taskInstances } from "@/lib/db/schema"
import { runDailyJob } from "@/lib/services/generation"

const saturdays = () =>
  db
    .select({ day: taskInstances.dueDate, n: sql<number>`count(*)::int` })
    .from(taskInstances)
    .where(sql`extract(dow from ${taskInstances.dueDate}::date) = 6`)
    .groupBy(taskInstances.dueDate)
    .orderBy(taskInstances.dueDate)

console.log("samedis avant :", await saturdays())
const report = await runDailyJob("2026-08-04")
console.log("job :", report)
console.log("samedis après :", await saturdays())

process.exit(0)