forked from arjun555/project3-coding-test
-
Notifications
You must be signed in to change notification settings - Fork 0
/
server.js
127 lines (99 loc) · 2.67 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
const _ = require('lodash')
// start up server with npm start
// read more: https://expressjs.com/
const express = require('express');
const app = express();
const port = process.env.PORT || 8080;
app.listen(port, () => {
console.log(`listening on port: ${port}`)
})
// pg for interfacing to database
// read more: https://node-postgres.com/
const { Client } = require('pg')
let databaseOptions = {}
if (process.env.PRODUCTION) {
databaseOptions.connectionString = process.env.DATABASE_URL
} else {
databaseOptions.database = 'project3'
// databaseOptions.user = 'bam' // for bam
// databaseOptions.password = '12345' // for bam
}
const client = new Client(databaseOptions)
// Database Parameters.
// Data Table names, etc.
const dt_words = "words"
const dt_tags = "tags"
const dt_leaderboard = "leaderboard"
const getRandomWords = (words, num) => _.sampleSize(words, num)
// Connect to client
function connect() {
// check client is not connected
if(!client.connection.stream.connecting){
client.connect()
}
console.log(`Connection Status: ${client.connection.stream.connecting}`)
}
// theres a bug in the connect function - ask dave and dt
// connect();
function getWords() {
connect()
client.query(`SELECT * FROM ${dt_words}`)
.then(res => {
return ((res.rows))
})
.catch(e => console.log(e))
}
// set the view directory to ./views
app.set("views", `./views`)
// express setting to use ejs as render engine
// read more: https://ejs.co/
app.set('view engine', 'ejs')
// middleware function to serve static files from public
// read more: https://expressjs.com/en/starter/static-files.html
app.use(express.static('public'));
// body parsing
// read more: https://github.com/expressjs/body-parser#readme
var bodyParser = require('body-parser')
app.use(bodyParser.urlencoded({ extended: false }));
// ------- Routes -------
app.get('/', (req, res) => {
res.render('index', {
greeting: 'im mister',
name: 'meeseeks'
});
})
app.get('/glossary', (req, res) => {
connect()
client.query('SELECT * FROM words', [], (err, dbresponse) => {
res.render('glossary', {
words: dbresponse.rows
})
})
})
app.get('/api/words', (req, res) => {
connect()
client.query(`SELECT * FROM ${dt_words}`)
.then(db_res => {
res.send(getRandomWords(db_res.rows, 10))
})
.catch(e => console.log(e))
})
app.get('/game', (req, res) => {
res.render('game', {
name: "Peter Griffin"
});
})
app.post('/game', (req, res) => {
userName = req.body.name
res.render('game', {
name: userName
});
})
app.get('/results', (req, res) => {
res.render('results', {
});
})
app.get('/main', (req, res) => {
res.render('main', {
});
})