mirror of
https://github.com/Tria-plc/edr-platform.git
synced 2026-08-26 12:41:04 +00:00
10 lines
501 B
JavaScript
10 lines
501 B
JavaScript
import pg from 'pg';
|
|
import fs from 'fs';
|
|
const env = Object.fromEntries(fs.readFileSync('.env','utf8').split('\n').filter(l=>/^[A-Z_]+=/.test(l)).map(l=>{const i=l.indexOf('=');return [l.slice(0,i),l.slice(i+1).replace(/^"|"$/g,'')]}));
|
|
const c = new pg.Client({host:env.DB_HOST,port:+env.DB_PORT,database:env.DB_NAME,user:env.DB_USER,password:env.DB_PASSWORD});
|
|
await c.connect();
|
|
const sql = process.argv[2];
|
|
const r = await c.query(sql);
|
|
console.log(JSON.stringify(r.rows,null,1));
|
|
await c.end();
|