ehsan-dashboards/dashboards/old_hermes/check_all_pings.js

24 lines
700 B
JavaScript

const { Client } = require("C:/Users/new/AppData/Roaming/npm/node_modules/n8n/node_modules/pg");
const client = new Client({
host: "5.61.31.155",
port: 15432,
user: "postgres",
password: "fEL77zeZ3bcNmVEviZ2W",
database: "postgres",
connectionTimeoutMillis: 5000
});
async function checkAllPings() {
try {
await client.connect();
const res = await client.query('SELECT * FROM "crawler_internet access" ORDER BY id ASC;');
console.log("=== CRAWLER PING TABLE ===");
console.log(JSON.stringify(res.rows, null, 2));
await client.end();
} catch (e) {
console.error("DB Query Error:", e.message);
}
}
checkAllPings();