-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathindex.js
More file actions
32 lines (27 loc) · 670 Bytes
/
Copy pathindex.js
File metadata and controls
32 lines (27 loc) · 670 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
import { Pool } from 'pg';
import dotenv from 'dotenv';
dotenv.config();
const pool = new Pool({
connectionString: process.env.CONNECTION_STRING
});
// const connectionString =
// 'postgresql://postgres:postgres@localhost:5432/reflection_db';
// const pool = new Pool({ connectionString: connectionString });
pool.on('connect', () => {
console.log('Connected to the database');
});
// Query Database
export default {
query(text, params) {
return new Promise((resolve, reject) => {
pool
.query(text, params)
.then(res => {
resolve(res);
})
.catch(err => {
reject(err);
});
});
}
};