forked from mapmeld/postgis-india
/
app.js
37 lines (31 loc) · 879 Bytes
/
app.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
const express = require('express');
const bodyParser = require('body-parser');
const cookieParser = require('cookie-parser');
const compression = require('compression');
const cors = require('cors');
const ropg = require('read-only-pg');
client = new ropg.Client({
database: 'pyindia',
user: 'py',
host: 'localhost',
password: 'zim'
});
client.connect((err) => {
console.log(err || 'verified read-only')
});
var app = express();
app.use(cors());
app.use(express['static'](__dirname + '/static'));
app.use(bodyParser.json({ limit: '50mb' }));
app.use(bodyParser.urlencoded({ extended: true }));
app.use(compression());
app.use(cookieParser());
app.post('/sql', (req, res) => {
client.query(req.body.sql, (err, response) => {
return res.json(err || response.rows);
});
});
app.listen(8000, () => {
console.log('app is running');
});
module.exports = app;