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 DISTINCT sa.id,sa.path,sa.role,sa.original_name,sa.created_at FROM source_assets sa
 WHERE sa.product_id=? OR EXISTS(SELECT 1 FROM source_asset_products l WHERE l.source_id=sa.id AND l.product_id=?)
 ORDER BY sa.created_at`).all(p.id,p.id) as Array<{id:string;path:string;role:string;original_name:string}>;
rows.forEach((r,i)=>console.log(i+1, r.id.slice(0,22), (r.role??'-').padEnd(8), r.original_name, r.path));