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(variants)").all() as Array<{name:string}>).map(c=>c.name);
console.log("variant cols:", cols.join(","));
for (const slug of ["oskar-lumo","oskar-tilia"]) {
  const p = db.prepare("SELECT id FROM products WHERE slug=?").get(slug) as {id:string};
  console.log("===",slug,"===");
  const rows = db.prepare("SELECT * FROM variants WHERE product_id=? ORDER BY shade_code,side").all(p.id) as Array<Record<string,unknown>>;
  for (const r of rows) console.log(r.id, r.side, r.shade_code);
}