-
Notifications
You must be signed in to change notification settings - Fork 1
/
app.js
108 lines (93 loc) · 2.85 KB
/
app.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
const path = require('path');
const mysql = require('mysql');
const bodyParser = require('body-parser');
const cookieParser = require('cookie-parser');
const session = require('express-session');
const database = require('./database');
const express = require('express');
const app = express();
var cors = require('cors');
app.use(cors());
app.use((req, res, next) => {
res.header('Access-Control-Allow-Origin', '*');
res.header('Access-Control-Allow-Headers', 'Origin, X-Requested-With, Content-Type, Accept');
next();
});
app.use(bodyParser.json()); // Important
app.use(cookieParser());
// Define Session Obj
app.use(session({
key: 'user_sid',
secret: 'shhh',
resave: true,
saveUninitialized: false,
rolling: true,
cookie: {
expires: 3600000
}
}));
// Check if cookie is still in browser
app.use((req, res, next) => {
if (req.cookies.user_sid && !req.session.user) {
res.clearCookie('user_sid');
} else {
next();
}
});
// Establish our static path
app.use(express.static(path.join(__dirname, "/client/build")));
// Establish database connection
let pool = mysql.createPool({
connectionLimit: 10,
host: process.env.DB_HOST,
user: process.env.DB_USER,
password: process.env.DB_PASS,
database: process.env.DB_DB
});
// Session Getters
app.get('/getSession', (req, res) => {
const email = req.session.user;
if (email) {
database.query(`SELECT username FROM User WHERE user_email='${email}'`, pool)
.then(result => {
req.session.email = req.session.user;
req.session.username = result[0].username;
console.log('getSession', JSON.stringify(req.session));
res.send(req.session);
}).catch(err => console.error(err));
} else {
res.send(req.session);
}
});
// Check Session, have dashboard redirect to login page if user
// is not logged in
app.get('/dashboard', (req, res, next) => {
if (!req.session.user | !req.cookies.user_sid) {
res.redirect('/login');
} else {
next();
}
});
// Route modules
const homeRoutes = require("./routes/homeRoutes.js")(pool);
const searchRoutes = require("./routes/searchRoutes.js")(pool);
const userRoutes = require("./routes/userRoutes.js")(pool);
const gameRoutes = require("./routes/gameRoutes.js")(pool);
const scoreRoutes = require("./routes/scoreRoutes.js")(pool);
// API Routes
app.use("/home", homeRoutes);
app.use("/search", searchRoutes);
app.use("/game", gameRoutes);
app.use("/user", userRoutes);
app.use("/score", scoreRoutes);
// Default Route
app.get('/*', (req, res) => {
res.sendFile(path.join(__dirname, "/client/build/index.html"));
});
// Error Handling
app.use((err, req, res, next) => {
res.status(422).send({error: err._messsage});
});
// Port handling
const port = process.env.PORT || 8000;
app.listen(port);