-
Notifications
You must be signed in to change notification settings - Fork 0
/
index.js
executable file
·149 lines (142 loc) · 4.46 KB
/
index.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
const express = require('express')
const path = require('path')
const bodyParser = require("body-parser")
const PORT = process.env.PORT || 6000
const mongo = require('mongodb');
var MongoClient = mongo.MongoClient,
co = require('co'),
assert = require('assert'),
env = require('dotenv')
env.config()
var url = process.env.MONGOLAB_URI
const find = function (db, col) {
return co(function * () {
// Get the documents collection
const dbo = db.db('trainspotted');
const collection = dbo.collection(col);
const docs = yield collection.find({}).toArray();
return docs;
})
};
const sortedEntries = function(entries, lines) {
entries.map((entry, index) => {
entry.engines.map((engine) => {
const matchedLine = lines.find(line => line.name === engine.line);
engine.color = matchedLine.color;
})
entry.number = index;
})
return entries.sort((a, b) => new Date(b.date) - new Date(a.date));
};
express()
.use(express.static(path.join(__dirname, 'client/build')))
.use(bodyParser.urlencoded({ extended: false }))
.use(bodyParser.json())
.get('/', (req, res) => res.render('client/build/index.html'))
.get('/getEntries', function(req, res) {
co(function * () {
console.log(url);
const db = yield MongoClient.connect(url, { useNewUrlParser: true })
const entries = sortedEntries(
yield find(db, 'entries'),
yield find(db, 'trainlines')
);
res.end(JSON.stringify(entries))
db.close()
}).catch(err => console.log(err))
})
.get('/getLines', function(req, res) {
co(function * () {
const db = yield MongoClient.connect(url, { useNewUrlParser: true })
const lines= yield find(db, 'trainlines')
lines.sort(function(a, b) {
var nameA = a.name.toUpperCase();
var nameB = b.name.toUpperCase();
if (nameA < nameB) {
return -1;
}
if (nameA > nameB) {
return 1;
}
return 0;
});
res.end(JSON.stringify(lines))
db.close()
}).catch(err => console.log(err))
})
.post('/addEntry', function(req, res) {
co(function * () {
const db = yield MongoClient.connect(url, { useNewUrlParser: true })
var dbo = db.db('trainspotted')
var doc = {
date: req.body.date,
direction: req.body.direction,
engines: req.body.engines,
id: req.body.id,
notes: req.body.notes,
time: req.body.time
}
dbo.collection('entries').updateOne(
{ id: req.body.id },
{ $set: doc },
{ upsert: true }
)
const entries = sortedEntries(
yield find(db, 'entries'),
yield find(db, 'trainlines')
);
res.end(JSON.stringify(entries))
db.close();
}).catch(err => console.log(err))
})
.post('/deleteEntry', function(req, res) {
co(function * () {
const db = yield MongoClient.connect(url, { useNewUrlParser: true });
let dbo = db.db('trainspotted');
dbo.collection('entries').deleteOne(
{ _id: new mongo.ObjectId(req.body.id) },
);
const entries = sortedEntries(
yield find(db, 'entries'),
yield find(db, 'trainlines')
);
res.end(JSON.stringify(entries));
db.close();
}).catch(err => console.log(err));
})
.post('/addTrainLine', function(req, res) {
co(function * () {
const db = yield MongoClient.connect(url, { useNewUrlParser: true })
var dbo = db.db('trainspotted')
var doc = {
name: req.body.lineName,
id: req.body.id,
color: req.body.lineColor,
short: req.body.lineShortName
}
dbo.collection('trainlines').updateOne(
{ id: req.body.id },
{ $set: doc },
{ upsert: true }
)
const entries = sortedEntries(
yield find(db, 'trainlines'),
);
res.end(JSON.stringify(entries))
db.close();
}).catch(err => console.log(err))
})
.post('/login', function(req, res) {
co(function * () {
const db = yield MongoClient.connect(url, { useNewUrlParser: true })
const arr = yield find(db, 'users')
for (var i = 0; i <arr.length; i++) {
if (arr[i].user === req.body.user && arr[i].password === req.body.password) {
res.end(JSON.stringify([{"success": "success"}]))
return
}
}
res.end(JSON.stringify([{"success": "error"}]))
}).catch(err => console.log(err))
})
.listen(PORT, () => console.log(`Listening on ${ PORT }`))