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-lumo'").get() as {id:string};
const rows = db.prepare(
  `SELECT a.id,a.role,a.path,v.side,v.shade_code 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 ((v.shade_code='30' AND v.side='L' AND a.role='detail') OR (v.shade_code='55' AND v.side='P' AND a.role='sleep') OR (v.shade_code='40' AND v.side='P' AND a.role='storage'))`
).all(p.id) as Array<{id:string;role:string;path:string;side:string;shade_code:string}>;
for (const r of rows) console.log(r.shade_code, r.side, r.role, r.path);