import { openDb } from "../server/src/db.js";
import { loadConfig } from "../server/src/config.js";
const db = openDb(loadConfig().dbPath);
for (const r of db.prepare("SELECT id,product_id,role FROM source_assets WHERE id IN ('src_efd67f14-da72-4933-b90e-7a3dea42bba5','src_c3a4e1df-81c6-4dcf-83a6-a87972aeb729' , 'src_78934b64-9b83-4ee1-8d30-87934b649b83','src_c8975155-9969-4dd5-97d2-7daa1b7b5a0f','src_b5296bca-95bb-4872-a9fb-f8c740f8ce82','src_c3a4e1df-81c6-4dcf-b3c5-a1a87972aeb7','src_78934b64-9b83-4ee1-9f03-87d1b7d88a4d')").all() as Array<Record<string,unknown>>) console.log(JSON.stringify(r));
console.log("--- links ---");
for (const r of db.prepare("SELECT * FROM source_asset_products").all() as Array<Record<string,unknown>>) console.log(JSON.stringify(r));