A helper function to handle frequent postgres operations. Using 'node-postgres' package underneath the hood. Better suited for serverless functions
npm install jeeng-pg
npm install --save jeeng-pg
`Usage
1. Import package:
`
const { DB } = require('jeeng-pg')
`
2. Create a new db instance:
`
const db = new DB()
`
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(...)
``