forked from hasura-imad/imad-app-v2
/
server.js
100 lines (87 loc) · 2.32 KB
/
server.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
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
var express = require('express');
var morgan = require('morgan');
var path = require('path');
var Pool = require('pg').Pool;
var config = {
user: 'paraskumarsahu',
database: 'paraskumarsahu',
host: 'db.imad.hasura-app.io',
port: '5432',
password: process.env.DB_PASSWORD
};
var app = express();
app.use(morgan('combined'));
function createTemplate (data) {
var title = data.title;
var date = data.date;
var heading = data.heading;
var content = data.content;
var htmlTemplate = `
<html>
<head>
<title>
${title}
</title>
<link href="/ui/style.css" rel="stylesheet" />
</head>
<body>
<div>
${date}
</div>
<div class="center text-big bold">
<h1>${heading}</h1>
</div>
<div class="center bold">
<a href="/">HOME</a>
</div>
<div class="center">
${content}
</div>
</body>
</html>`
return htmlTemplate;
}
var counter=0;
app.get('/counter', function (req, res) {
counter=counter+1;
res.send(counter.toString());
});
var names = [];
app.get('/submit-name', function (req, res) {
var name = req.query.name;
names.push(name);
res.send(JSON.stringify(names));
});
app.get('/', function (req, res) {
res.sendFile(path.join(__dirname, 'ui', 'index.html'));
});
var pool = new Pool(config);
app.get('/articles/:articleName' , function (req, res) {
pool.query('SELECT * FROM articles WHERE title = $1', [req.params.articleName], function(err, result){
if(err){
res.status(500).send(err.toString());
}else{
if(result.rows.length === 0)
{
res.status(404).send('Article not found');
}
else{
var articleData = result.rows[0];
res.send(createTemplate(articleData));
}
}
});
});
app.get('/ui/style.css', function (req, res) {
res.sendFile(path.join(__dirname, 'ui', 'style.css'));
});
app.get('/ui/main.js', function (req, res) {
res.sendFile(path.join(__dirname, 'ui', 'main.js'));
});
app.get('/ui/madi.png', function (req, res) {
res.sendFile(path.join(__dirname, 'ui', 'madi.png'));
});
var port = 8080; // Use 8080 for local development because you might already have apache running on 80
app.listen(8080, function () {
console.log(`IMAD course app listening on port ${port}!`);
});