function createTable() { pg.connect(connectionString, function (err, client, done) { if (err) throw err; var query = client.query('CREATE TABLE IF NOT EXISTS testuserscards(card_id SERIAL PRIMARY KEY, username varchar(100), cc bytea)'); query.on('end', function () { client.end(); }); }); }
function insertData(data) { var pubKey = fs.readFileSync('public.key').toString(); pg.connect(connectionString, function (err, client, done) { if (err) throw err; var sql = `INSERT INTO testuserscards(username, cc) VALUES ('${data.username}', pgp_pub_encrypt('${data.cc}', dearmor('${pubKey}')))` var query = client.query(sql); query.on('end', function () { client.end(); }); }); }
app.use(function(req, res, next) { var connstr = 'postgres://habibi:@localhost/authpg_db'; pg.connect(connstr, function(err, client, done){ if (err) { console.error('ERROR: '+err); } else { console.log('db connected'); req.db = client; next(); } }); });
// var pgURL = config.pg_local_url; function pgQuery(queryString, callback) { pg.connect(pgURL, function(err, client, done) { if (err) { callback(err); } client.query(queryString, function(err, result) { if (err) { return console.error('Error running query ', err); } callback(null, result); client.end(); }); }); }
function createPool (cb) { setup(function () { var connector if (semver.satisfies(pgVersion, '<6.0.0')) { queryable = pg connector = function connector (cb) { return pg.connect({ database: 'test_elastic_apm', user: process.env.PGUSER || 'postgres' }, cb) } } else { var pool = new pg.Pool({ database: 'test_elastic_apm', user: process.env.PGUSER || 'postgres' }) queryable = pool connector = function connector (cb) { return pool.connect(cb) } } cb(connector) }) }
/* GET users listing. */ router.get('/', function(req, res, next) { pg.connect(conString, function(err, client, done) { if(err) { done(); console.log(err); return res.status(500).json({ success: false, data: err}); } client.query('SELECT * FROM users', [], function(err, result) { //call `done()` to release the client back to the pool done(); if(err) { return res.status(500).json({ success: false, data: err}); } // return results as json object return res.json(result.rows) }); }); });
// initiate first connection to db and grab existing messages pg.connect(app.get('DATABASE_URL'), function(err, client, done) { if (err) throw err; console.log('Connected to postgres:' + app.get('DATABASE_URL')); client.query('CREATE TABLE IF NOT EXISTS message (id SERIAL, timestamp integer NOT NULL, name varchar(40), message varchar(255));', function(err, result) { if (err) { // TODO console.log(err); } else { // TODO console.log(result); } }); client.query('SELECT * FROM message ORDER BY timestamp DESC', function(err, result) { done(); if (err) { // TODO console.log(err); } else { // set server messages to result from DB messages = result.rows; } }); });
http.createServer(function(req, res) { pg.connect(conString, function(err, client, done) {
pg.connect(process.env.DATABASE_URL, function(err, client, done) {
pg.connect(this.connectionString, (err, client, done) => { if(err) { return callback(err, null);
function selectData() { var secretKey = fs.readFileSync('secret.key').toString(); pg.connect(connectionString, function (err, client, done) { if (err) throw err; var sql = `SELECT username, pgp_pub_decrypt(cc, dearmor('${secretKey}'), 'Palomino1!') As ccdecrypt FROM testuserscards` var query = client.query(sql); query.on('row', function(row) { console.log(row); }); query.on('end', function () { client.end(); }); }); }
let cleanDatabase = (callback) => { pg.connect(connectionString, (err, client, done) => { let query = ` drop schema public cascade; create schema public; create extension pgcrypto; create extension bedquilt; `; client.query(query, [], (err, result) => { if(err) { throw err; } else { done(); return callback(); } }); }); }
// With connString build the function to execute one query. function query(queryString, queryArgs, callback) { // Connect, handle any error or execute the query. pg.connect(conString, function(err, client, done) { if (err) { callback(err); } else { // Make the query, free the connection call callback. client.query(queryString, queryArgs, function(err, result) { done(); callback(err, result); }); } }); }
// check bedquilt version on db server pg.connect(connectionString, (err, db, done) => { let q = "select bq_util_assert_minimum_version($1::text)"; if (err) { return callback(err, null); } db.query(q, [MINIMUM_SERVER_VERSION], (err, result) => { done(); if (err) { // update cached value with the error and throw cache[connectionString].error = err; throw err; } else { // finally invoke the callback with client instance return callback(null, client); } }); return null; });