/
routes.js
78 lines (61 loc) · 1.96 KB
/
routes.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
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
const express = require('express')
const router = express.Router()
const createData = require('../lib/createData');
// Add your routes here - above the module.exports line
var {devices, expertise, resources} = require('../lib/constants');
const { Client } = require('pg');
// landing page
router.get("/", function (req, res, next) {
res.render("index", {
devices: devices,
expertise: expertise,
resources: resources
});
});
router.get('/error', function(req, res, next) {
res.render('error', { content : {error: {message: "Internal server error"}}});
});
router.post("/submit", function (req, res, next) {
try{
var data = req.body;
console.log(req.body)
const { fields, positions, json, values } = createData(data);
var sql = "INSERT INTO companies(" + fields + ") VALUES (" + positions + ");"
console.log(sql);
// check for data
console.log("check json " + json.length);
console.log("check json " + json.length);
const query = {
text: sql,
values: values,
}
// query["text"] = "INSERT INTO companies( info ) values ( $1 )"
// query["values"] = [json]
console.log(query);
try {
const client = new Client({
connectionString: process.env.HEROKU_POSTGRESQL_RED_URL || process.env.DATABASE_URL,
ssl: true,
});
client.connect();
}
catch(err){
throw new err('Failed to connect to database')
}
console.log("connect");
client.query(query, (err, res) => {
console.log(res);
client.end();
if (err) next(err);
});
res.render("confirm", {
});
}
catch(err){
res.render('error', { content : {error: {message: "Internal server error"}}});
}
});
router.get("/submit", function (req, res, next) {
res.render("confirm", {});
});
module.exports = router