forked from azamtau/p5game
-
Notifications
You must be signed in to change notification settings - Fork 0
/
server.js
102 lines (85 loc) · 2.18 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
const express = require('express');
const bodyParser = require('body-parser');
const Sequelize = require('sequelize');
const app = express();
app.use(bodyParser.urlencoded({ extended: true }));
app.use(bodyParser.json());
app.use(express.static('public'));
const sequelize = new Sequelize('database', process.env.DB_USER, process.env.DB_PASS, {
host: '0.0.0.0', // localhost
dialect: 'sqlite',
pool: {
max: 5,
min: 0,
idle: 10000
},
storage: 'db.sqlite'
});
sequelize.authenticate()
.then(() => {
console.log('Connection has been established successfully.');
Top = sequelize.define('top', {
username: {
type: Sequelize.STRING
},
score: {
type: Sequelize.INTEGER
}
});
//dbSetup();
})
.catch(err => {
console.error('Unable to connect to the database:', err);
});
function dbSetup() {
Top.sync({force: true})
.then(function(){
Top.create({ username: "Bot", score: 100});
});
}
function dbAdd(username, score) {
Top.create({ username: username, score: score }).then(top => {
console.log("Auto-generated ID:", top.id);
});
}
function dbGetTop(num) {
return Top.findAll({
limit: num,
order: [
['score', 'DESC']
]
}).then(tops => tops);
}
function dbGetAll() {
Top.findAll().then(tops => {
tops.forEach(top => {
console.log(top.username, top.score);
});
});
}
app.listen(process.env.PORT || 3000, () => {
console.log('Server listening on port 3000!');
});
app.get('/', function(request, response) {
response.sendFile(__dirname + '/views/index.html');
});
app.get('/top/:n', function(req, res) {
//request.params.n
dbGetTop(3).then(tops => {
res.send({"top": JSON.stringify(tops)});
});
});
app.post('/save', (req, res) => {
try {
let username = req.body.name.toString();
let score = parseInt(req.body.score);
dbAdd(username, score);
res.send({"status":"successefully saved"});
}
catch (e) {
console.log("Some error occured:" + e);
res.send("Wrong data was sent");
}
});
// > heroku config:set API_KEY=wfewe;fo8u23t3
// > heroku config