import { openDb } from "../server/src/db.js";
import { loadConfig } from "../server/src/config.js";
const db = openDb(loadConfig().dbPath);
const p = db.prepare("SELECT id FROM products WHERE slug='oskar-tilia'").get() as {id:string};
const rows = db.prepare(
  `SELECT a.id,a.path,v.side,v.shade_code,a.role FROM assets a JOIN variants v ON v.id=a.variant_id
   WHERE a.product_id=? AND a.variant_id IS NOT NULL AND a.status='candidate' AND a.role='hero' ORDER BY v.shade_code,v.side`
).all(p.id) as Array<{id:string;path:string;side:string;shade_code:string}>;
for (const r of rows) console.log(r.shade_code, r.side, r.path);