simple-pg
A simplified api against Postgresql using promises and objects
Install
npm install --save simple-pg
Use
select
pgm // DON'Tpgm
insert
pgm // id assumed to be .id // logs {id: INSERTED_ID} pgm // id is .user_id // logs {user_id: INSERTED_ID}
upsert
pgm // id assumed to be .id // logs user pgm // id is .user_id // logs user
update
pgm // where id = user.id // logs array of {id: UPDATED_ID} pgm // where user_id = user.user_id // logs array of {user_id: UPDATED_ID} pgm // where user_id = 1 AND taxonomy_handle = '16' AND section = 'experience' // logs array of {id: UPDATED_ID} pgm
delete
pgm // deletes all rows from the table 'users'pgm // logs 'Missing WHERE clause'pgm // where user_id = 1 AND taxonomy_handle = '16' AND section = 'experience'
truncate
pgm