import { openDb } from "../server/src/db.js";
import { loadConfig } from "../server/src/config.js";
const db = openDb(loadConfig().dbPath);
const slug = process.argv[2]!;
const p = db.prepare("SELECT id FROM products WHERE slug=?").get(slug) as {id:string};
const rows = db.prepare(
  "SELECT id, role, path FROM assets WHERE product_id=? AND variant_id IS NULL AND status='candidate' ORDER BY role"
).all(p.id) as Array<{id:string;role:string;path:string}>;
for (const r of rows) console.log(r.id, r.role, r.path);