-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathserver.js
More file actions
executable file
·78 lines (67 loc) · 2.12 KB
/
server.js
File metadata and controls
executable file
·78 lines (67 loc) · 2.12 KB
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
const express = require('express')
const app = express()
const bodyParser = require('body-parser')
const MongoClient = require('mongodb').MongoClient
const { ObjectId } = require('mongodb');
var db, collection;
const url = "mongodb+srv://sandboxer:AKZdKrMvsSZDxleU@sandboxcluster.er1seez.mongodb.net/?appName=SandboxCluster";
const dbName = "bug-tracker";
app.listen(8080, () => {
MongoClient.connect(url, { useNewUrlParser: true, useUnifiedTopology: true }, (error, client) => {
if (error) {
throw error;
}
db = client.db(dbName);
console.log("Connected to `" + dbName + "`!");
});
});
app.set('view engine', 'ejs')
app.use(bodyParser.urlencoded({ extended: true }))
app.use(bodyParser.json())
app.use(express.static('public'))
app.get('/', (req, res) => {
db.collection('bugs').find().toArray((err, result) => {
if (err) return console.log(err)
res.render('index.ejs', { bugs: result })
})
})
app.post('/bugs', (req, res) => {
const currentDate = new Date();
db.collection('bugs').insertOne({
bug: req.body.bug,
status: req.body.status,
priority: req.body.priority,
assignedTo: req.body.assigned,
creationDate: `${currentDate.getMonth() + 1}/${currentDate.getDate()}/${currentDate.getFullYear()}`
}, (err, result) => {
if (err) return console.log(err)
console.log('saved to database')
res.redirect('/')
})
})
app.delete('/bugs', (req, res) => {
db.collection('bugs').findOneAndDelete({ "_id": ObjectId(req.body.id.trim()) }, (err, result) => {
if (err) return res.send(500, err)
res.send('Bug deleted!')
})
})
app.put('/bugs/status', (req, res) => {
db.collection('bugs')
.findOneAndUpdate({ "_id": ObjectId(req.body.id.trim()) }, {
$set: { status: req.body.status }
}, {
}, (err, result) => {
if (err) return res.send(err)
res.send(result)
})
})
app.put('/bugs/priority', (req, res) => {
db.collection('bugs')
.findOneAndUpdate({ "_id": ObjectId(req.body.id.trim()) }, {
$set: { priority: req.body.priority }
}, {
}, (err, result) => {
if (err) return res.send(err)
res.send(result)
})
})