import { openDb } from "../server/src/db.js";
import { loadConfig } from "../server/src/config.js";
const db = openDb(loadConfig().dbPath);
for (const slug of ["oskar-lumo","oskar-tilia"]) {
  const p = db.prepare("SELECT id FROM products WHERE slug=?").get(slug) as {id:string};
  const rows = db.prepare(
    "SELECT role,status,count(*) n,group_concat(substr(id,1,16)) ids FROM assets WHERE product_id=? AND variant_id IS NULL AND role IN ('hero','packshot_front','packshot_34','side','back','sleep','storage','detail') GROUP BY role,status ORDER BY role"
  ).all(p.id) as Array<{role:string;status:string;n:number;ids:string}>;
  console.log("===",slug,"===");
  for (const r of rows) console.log(r.role.padEnd(16),r.status.padEnd(10),r.n,r.ids.slice(0,60));
}