-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathapp.js
More file actions
65 lines (55 loc) · 1.48 KB
/
app.js
File metadata and controls
65 lines (55 loc) · 1.48 KB
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
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
const express = require('express');
const app = express();
const uuid = require('node-uuid');
const pg = require('pg');
const conString = process.env.DB; // "postgres://username:password@localhost/database";
// Routes
app.get('/api/status', function(req, res) {
pg.connect(conString, function(err, client, done) {
if(err) {
console.log("Postgre connection failed!")
return res.status(500).send('error fetching client from pool');
}
client.query('SELECT now() as time', [], function(err, result) {
//call `done()` to release the client back to the pool
done();
if(err) {
console.log("Postgre query failed!")
console.log(err)
return res.status(500).send('error running query');
}
return res.json({
request_uuid: uuid.v4(),
time: result.rows[0].time
});
});
});
});
// catch 404 and forward to error handler
app.use(function(req, res, next) {
var err = new Error('Not Found');
err.status = 404;
constt(err);
});
// error handlers
// development error handler
// will print stacktrace
if (app.get('env') === 'development') {
app.use(function(err, req, res, next) {
res.status(err.status || 500);
res.json({
message: err.message,
error: err
});
});
}
// production error handler
// no stacktraces leaked to user
app.use(function(err, req, res, next) {
res.status(err.status || 500);
res.json({
message: err.message,
error: {}
});
});
module.exports = app;