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.role,a.path,a.sha256 FROM assets a WHERE a.product_id=? AND a.variant_id IS NULL AND a.status='approved' ORDER BY a.role"
).all(p.id) as Array<{id:string;role:string;path:string;sha256:string}>;
for (const r of rows) console.log(r.role, r.path);