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};
  console.log("===",slug,"===");
  const rows = db.prepare(
    `SELECT sr.shot_role, sr.ref_kind, sa.id sid, sa.original_name FROM shot_refs sr JOIN source_assets sa ON sa.id=sr.source_id WHERE sr.product_id=? ORDER BY sr.shot_role`
  ).all(p.id) as Array<{shot_role:string;ref_kind:string;sid:string;original_name:string}>;
  for (const r of rows) console.log(r.shot_role.padEnd(16), r.ref_kind.padEnd(8), r.sid.slice(0,22), r.original_name);
}