import { openDb } from "../server/src/db.js";
import { loadConfig } from "../server/src/config.js";
const db = openDb(loadConfig().dbPath);
const cols = db.prepare("PRAGMA table_info(shot_refs)").all() as Array<{name:string}>;
console.log("shot_refs cols:", cols.map(c=>c.name).join(","));
const p = db.prepare("SELECT id FROM products WHERE slug='oskar-tilia'").get() as {id:string};
const rows = db.prepare("SELECT * FROM shot_refs WHERE product_id=? LIMIT 30").all(p.id) as Array<Record<string,unknown>>;
for (const r of rows) console.log(JSON.stringify(r));