const { Pool } = require('pg');

const db = require('node-pg-helper');

const pool = new Pool({
    connectionString: process.env.DATABASE_URL,
    ssl: { rejectUnauthorized: false }
});

db.setClient(pool);

await db.insert('users', {
    'id': 100,
    'firstname': 'john',
    'lastname': 'smith'
})

await db.upsert('users', {
    'id': 100,
    'firstname': 'john',
    'lastname': 'snow'
}, 'id');

await db.update('users',{
    'lastname': 'snow'
},
{
    'id': 100
});

let rows = await db.selectAllRows("users");

rows.forEach(row => {
    console.log(row);
});