jeeng-pg

A helper function to handle frequent postgres operations. Using 'node-postgres' package underneath the hood. Better suited for serverless functions

install

npm install --save jeeng-pg

Usage

1. Import package:

const { DB } = require('jeeng-pg')

2. Create a new db instance:

const db = new DB(<CONNECTION STRING>)

3. Create the queries class:

const { GenericQueries } = require('jeeng-pg')

export const Queries extends GenericQueries {
    sampleQuery() {
        const q = 'SELECT 1 AS test_value'
        return this.DB.resolveQuery(q, ({rows}) => rows.length & rows[0].test_value)
    }
}

4. Instiantiate queries class and execute:

const queries = new Queries(DB)
queries.sampleQuery()
    .then(...)
    .catch(...)