-
Notifications
You must be signed in to change notification settings - Fork 1
/
queries.js
47 lines (40 loc) · 1.48 KB
/
queries.js
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
46
47
require('dotenv').config(); //Allows retriving variables from the .env file
//For Heroku postgres
const { Pool } = require('pg');
const pool = new Pool({
connectionString: process.env.NODE_ENV == 'production' ? process.env.PRODUCTION_DATABASE : process.env.DEVELOPMENT_DATABASE,
ssl: true,
});
async function testFunction (request, response) {
console.log('Request for data received by testFunction');
response.status(200).json("Request for data received by testFunction");
}
async function testGet (request, response) {
console.log('Request for data received by testGet');
try{
const dbase = await pool.connect();
const rowList = await dbase.query('SELECT * FROM userrecords ORDER BY username ASC');
response.status(200).send(rowList);
} catch (error){
response.status(400).json('SERVER RESP: Error retrieving userrecords. Log:'+error)
console.log('Error retrieving userrecords. Log:')
console.log(error);
}
}
async function testHerokuPg (request, response) {
console.log('Request for data received by testHerokuPg');
try{
const dbase = await pool.connect();
const result = await dbase.query('SELECT * FROM test_table');
const results = { 'results': (result) ? result.rows : null};
response.status(200).send(results);
} catch (error){
console.error(error);
response.send("Error " + error);
}
}
module.exports = {
testFunction,
testGet,
testHerokuPg
}