-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathdb.js
More file actions
47 lines (36 loc) · 889 Bytes
/
db.js
File metadata and controls
47 lines (36 loc) · 889 Bytes
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
const pg = require('pg');
const users = require('./models/users');
const company = require('./models/company');
const vouchers = require('./models/vouchers');
const url = require ('url');
if( process.env.DATABASE_URL ){
const params = url.parse(process.env.DATABASE_URL);
const auth = params.auth.split(':');
//make the configs object
var configs = {
user: auth[0],
password: auth[1],
host: params.hostname,
port: params.port,
database: params.pathname.split('/')[1],
ssl: true
};
}
else {
const configs = {
user: 'smu',
host: '127.0.0.1',
database: 'Tallify',
port: 5432
};
}
const pool = new pg.Pool(configs);
pool.on('error', function (err) {
console.log('idle client error', err.message, err.stack);
});
module.exports = {
pool: pool,
users: users(pool),
vouchers: vouchers(pool)
// company: company(pool)
};