package
Requires sql files and export functions for querying via pg
npm install pg-require-sqlGitHub-flavored package documentation.
Across all versions, last 30 days.
48 in 30 days
Runtime metadata.
Tagged topics.
Estimated unpacked size across 3 packages.
1.2 MB
Includes dependencies.
Latest published Jul 17, 2015
Registry package owners.
'Require' sql files for use with pg-connect.
Given a project like
|- index.js
|- sql-directory
|- get-record.sqlthe 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
})