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
|
const express = require('express');
const bodyParser = require('body-parser');
const cookieParser = require('cookie-parser');
const Op = require('sequelize').Op;
const server = express();
server.use(cookieParser())
server.use(bodyParser.json());
function listen(port) {
server.listen(port, () => console.info(`Listening on port ${port}!`));
}
function load(gamePath, models, jwtFunctions, database) {
const game = require(gamePath);
game.setUpRoutes(server, models, jwtFunctions, database);
}
function setUpRoutes(models, jwtFunctions, database) {
server.use(function (req, res, next) {
console.debug(new Date(), req.method, req.originalUrl);
next()
})
server.get('/', (req, res) => res.sendFile(__dirname + "/index.html"))
server.get('/setScore', (req, res, next) => {
let game = req.query.game
let username = req.query.username
let score = req.query.score
console.log(game, username, score)
models.scores.create({
game: req.query.game,
username: req.query.username,
score: req.query.score
})
res.status(200)
})
server.get('/scores', async (req, res, next) => {
var games = await database.query(`SELECT DISTINCT game FROM scores`, { type: database.QueryTypes.SELECT });
var scoresByGames = {}
for(var i = 0; i < games.length; i++){
scoresByGames[games[i].game] = await models.scores.findAll({ atttributes: ["username", "score", "createdAt"], where : {game: {[Op.eq]: games[i].game}}, order: [['score', 'DESC']], limit: 15}).map(x => x.get({ plain: true }))
};
res.status(200).send(scoresByGames);
})
server.get('/highscore.js', (req, res) => res.sendFile(__dirname + "/highscores.js"))
server.get('/highscores', (req, res) => res.sendFile(__dirname + "/scores.html"))
}
module.exports = {
listen,
setUpRoutes,
load
};
|
