pg-require-sql

'Require' sql files for use with pg-connect.

Installation

Usage

Given a project like

|- index.js
|- sql-directory
  |- get-record.sql

the following will query

var Promise = require('bluebird')
var path = require('path')
var getConnection = require('pg-connect')(connectionString)
var requireSql = require('pg-require-sql')
 
var sql = requireSql(path.join(__dirname, 'sql-directory'))
 
Promise.using(
  getConnection(),
  sql.getRecord(['foo'])
).
then(function (results) {
  // ... use the results
})