1 | // Copyright 2019 Zaiste & contributors. All rights reserved.
|
2 | //
|
3 | // Licensed under the Apache License, Version 2.0 (the "License");
|
4 | // you may not use this file except in compliance with the License.
|
5 | // You may obtain a copy of the License at
|
6 | // http://www.apache.org/licenses/LICENSE-2.0
|
7 | //
|
8 | // Unless required by applicable law or agreed to in writing, software
|
9 | // distributed under the License is distributed on an "AS IS" BASIS,
|
10 | // WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
|
11 | // See the License for the specific language governing permissions and
|
12 | // limitations under the License.
|
13 |
|
14 | const config = require('config');
|
15 |
|
16 | const Logger = require('./logger');
|
17 |
|
18 | const pg = require('pg');
|
19 | const sqorn = require('@sqorn/pg');
|
20 |
|
21 | const connection = config.get('db');
|
22 |
|
23 | const pool = new pg.Pool(connection);
|
24 |
|
25 | pool.connect(error => {
|
26 | if (error) {
|
27 | Logger.printError(error, 'Data Layer');
|
28 |
|
29 | process.exit(1);
|
30 | }
|
31 | });
|
32 |
|
33 | module.exports = Object.assign(
|
34 | sqorn({ pg, pool }),
|
35 | {
|
36 | execute: async (statement) => {
|
37 | const { rows } = await pool.query(statement);
|
38 | return rows;
|
39 | }
|
40 | }
|
41 | );
|