import pg from "pg";

const pool = new pg.Pool({ 
  connectionString: "postgresql://tenderpilot:jqrmilIBr6imtT0fKS01@localhost:5432/tenderpilot" 
});

console.log("=== Sample URLs per source ===");
const sources = ["pcs_scotland", "sell2wales", "ted_eu"];

for (const source of sources) {
  const result = await pool.query("SELECT notice_url FROM tenders WHERE source = $1 LIMIT 2", [source]);
  console.log("\n" + source + ":");
  result.rows.forEach(row => console.log("  " + row.notice_url));
}

await pool.end();