mypg

Opinionated wrapper around PostgreSQL client API.

API

"Promises" means "returns promise".

Methods insert, update, remove require context (this) to have user record for audit reasons. They also are built with expectation that each table has creator_id, updater_id, remover_id, created_at, updated_at, removed_at fields.

query(sql, paramsArray)

Promises array of results.

db.query('select * from products where name = $1', ['beer']).then(console.log);

querySingle(sql, paramsArray)

Promises first row of results.

insert(tableName, record)

Promises identifier of record that is being inserted.

db.insert('products', { name: 'beer' }).then(console.log);

update(tableName, record)

Promises identifier of record that is being updated. Record must have identifier value.

db.update('products', { id: 20, name: 'fish' }).then(console.log);

remove(tableName, id)

Promises removal of record with given identifier from specified table.

db.remove('products', 20).then(function () {
    console.log('Product 20 was removed');
});

find(tableName, id)

Promises record with given identifier taken from specified table.

License

BSD