mdot_mqtt/lib/server/db-connector.js

'uses strict';
/**
 *
 * User: Martin Donnelly
 * Date: 2016-03-11
 * Time: 10:22
 *
 */

var pgp = require('pg-promise')();

/*
var cn = {
  host: 'localhost',
  port: 5432,
  database: 'mdot',
  user: 'postgres',
  password: ''
};
*/

// ElephantSql settings

var cn = {
  host: 'qdjjtnkv.db.elephantsql.com',
  port: 5432,
  database: 'gxwxnqoh',
  user: 'gxwxnqoh',
  password: 'LN5Uk39GNcBCxCHv5dfL8aKuowFT6WKG'
};


exports.dbConnection = pgp(cn);