rain-util-postgres
Generator based, co/koa compatible utility for accessing postgres
npm i rain-util-postgres
const $Postgres = require('rain-util-postgres');
data access
queries, data access objects, transactions
const conn = { host: 'localhost', db: 'postgres', user: 'postgres', password: 'postgres' };
const $postgres = new $Postgres(conn); // connection string also acceptable
if($postgres) {
// create a test table
const tableName = 'testers';
const testTable = `DROP TABLE IF EXISTS ${tableName}; CREATE TABLE ${tableName}(id CHARACTER VARYING(40))WITH(OIDS=FALSE);ALTER TABLE ${tableName} OWNER TO postgres;`;
yield $postgres.db.query(testTable);
// load created table into $postgres object
$postgres.table(tableName);
// add a record
const recordId = '4a2b';
yield $postgres.tables[`${tableName}`].upsert({id: recordId});
// find created record using dao
const daoRecord = yield $postgres.tables[`${tableName}`].findOne('id = ?', recordId);
// find created record using sql
const findRecordSQL = `SELECT * FROM ${tableName} WHERE id = '${recordId}'`;
const sqlRecord = (yield $postgres.db.query(findRecordSQL)).rows[0];
}
schema info
// for each table, provide info on columns, indexes, and constraints
const schemaInfo = yield $postgres.schema();