forked from hasura-imad/imad-2016-app
-
Notifications
You must be signed in to change notification settings - Fork 0
/
server.js
112 lines (99 loc) · 3.14 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
101
102
103
104
105
106
107
108
109
110
111
112
var express = require('express');
var morgan = require('morgan');
var path = require('path');
var Pool = require('pg').Pool;
var config = {
user: 'ankitrajsingh',
databse: 'ankitrajsingh',
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 heading=data.heading;
var date=data.date;
var Content=data.content;
var htmlTemplate = `<html>
<head>
<title>${title}</title>
<meta name="viewport" content="width=device-width,
initial-scale=1" />
<link href="/ui/style.css" rel="stylesheet" />
</head>
<body>
<div class="container">
<div>
<a href="/">Home</a>
</div>
<hr/>
<h3>
${heading}
</h3>
<div>
${date.toDateString()}
</div>
<div>
${Content}
</div>
</div>
</body>
</html>`;
return htmlTemplate;
}
app.get('/', function (req, res) {
res.sendFile(path.join(__dirname, 'ui', 'index.html'));
});
var pool = new Pool(config);
app.get('/test-db', function(req,res){
// make a select request
//return response with result
pool.query('SELECT * FROM test', function(err,result){
if(err){
res.status(500).send(err.toString());
}else{
res.send(JSON.stringify(result.rows));
}
});
});
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){ // /submit-name?name=xxxx
//Get the name from the request
var name = req.query.name;
names.push(name);
res.send(JSON.stringify(names));
});
app.get('/articles/:articleName',function(req,res){
pool.query("SELECT * FROM article 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}!`);
});