forked from hasura-imad/imad-2016-app
-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathserver.js
155 lines (140 loc) · 5.96 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
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
var express = require('express');
var morgan = require('morgan');
var path = require('path');
var app = express();
app.use(morgan('combined'));
var Pool = require('pg').Pool;
var articles={
'article-one':{
title:'Article one - manju',
heading:'article-one',
date:'oct 12 , 2016',
content:`<p>
This is the content of article one !!!..This is the content of article one !!!..This is the content of article one !!!..This is the content of article one !!!..This is the content of article one !!!..This is the content of article one !!!..
</p>
<p>
This is the content of article one !!!..This is the content of article one !!!..This is the content of article one !!!..This is the content of article one !!!..This is the content of article one !!!..This is the content of article one !!!..
</p>
<p>
This is the content of article one !!!..This is the content of article one !!!..This is the content of article one !!!..This is the content of article one !!!..This is the content of article one !!!..This is the content of article one !!!..
</p>`
},
'article-two':{
title:'Article two - manju',
heading:'article-two',
date:'oct 14 , 2016',
content:`<p>
This is the content of article two !!!..This is the content of article two !!!..This is the content of article two !!!..This is the content of article two !!!..This is the content of article two !!!..This is the content of article two !!!..
</p>
<p>
This is the content of article two !!!..This is the content of article two !!!..This is the content of article two !!!..This is the content of article two !!!..This is the content of article two !!!..This is the content of article two !!!..
</p>
<p>
This is the content of article two !!!..This is the content of article two !!!..This is the content of article two !!!..This is the content of article two !!!..This is the content of article two !!!..This is the content of article two !!!..
</p>`
},
'article-three':{
title:'Article three- manju',
heading:'article-three',
date:'oct 16 , 2016',
content:`<p>
this is the content of article three!!!...this is the content of article three!!!...this is the content of article three!!!...this is the content of article three!!!...this is the content of article three!!!...this is the content of article three!!!...
</p>
<p>
this is the content of article three!!!...this is the content of article three!!!...this is the content of article three!!!...this is the content of article three!!!...this is the content of article three!!!...this is the content of article three!!!...
</p>
<p>
this is the content of article three!!!...this is the content of article three!!!...this is the content of article three!!!...this is the content of article three!!!...this is the content of article three!!!...this is the content of article three!!!...
</p>`
}
};
var config = {
user: 'manjunathrvce',
database: 'manjunathrvce',
host: 'db.imad.hasura-app.io',
port: '5432',
password : process.env.DB_PASSWORD
};
function createTemplate(data){
var heading=data.heading;
var date=data.date;
var title=data.title;
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>
<hr/>
</div>
<h3>
${heading}
</h3>
<div>
${date}
</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',function(req,res){
//make a request
res.sendFile('hello world');
//return the response with the results
pool.query('SELECT * FROM test',function(err,result){
if(err){
res.status(500).send(err.toString());
}else{
res.send(JSON.stringfy(result));
}
});
});
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){// Query- TYPE URL://submit-name?name=xxxxx
// this is for /submit-name/:name type var name = req.params.name;
var name = req.query.name;
names.push(name);
//JSON JavaScript Object Notation
res.send(JSON.stringify(names));
});
app.get('/ui/madi.png', function (req, res) {
res.sendFile(path.join(__dirname, 'ui', 'madi.png'));
});
app.get('/:articleName',function(req,res){
// :articleName==article-one
// articles[articlesName] == {} contents for article one
var articleName=req.params.articleName;
res.send(createTemplate(articles[articleName]));
});
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'));
});
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}!`);
});