17 lines
517 B
JavaScript
17 lines
517 B
JavaScript
|
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();
|