1.0.5 • Published 1 year ago

node-pg-helper v1.0.5

Weekly downloads
5
License
MIT
Repository
github
Last release
1 year ago

node-pg-helper

common helper functions for node-postgres

Examples

Setup postgres connection

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

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

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

Set the client as Pool

db.setClient(pool);

example insert

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

example upsert

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

example update

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

select all the rows in a table

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

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

1 year ago

1.0.4

2 years ago

1.0.3

3 years ago

1.0.2

3 years ago

1.0.1

5 years ago

1.0.0

5 years ago