-
Notifications
You must be signed in to change notification settings - Fork 4
/
menus.js
98 lines (89 loc) · 2.8 KB
/
menus.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
const express = require('express');
const menusRouter = express.Router();
const sqlite3 = require('sqlite3');
const db = new sqlite3.Database(process.env.TEST_DATABASE || './database.sqlite');
const menuItemsRouter = require('./menu-items');
const validateMenu = (req, res, next) => {
req.title = req.body.menu.title;
if (!req.title) {
return res.sendStatus(400);
}
else {
next();
}
};
menusRouter.param('menuId', (req, res, next, menuid) => {
db.get('SELECT * FROM Menu WHERE id = $id', {$id: menuid},
(err, data) => {
if (err) {
next(err);
} else if (data) {
req.menu = data;
next();
} else {
res.sendStatus(404);
}
});
});
menusRouter.use('/:menuId/menu-items', menuItemsRouter);
menusRouter.get('/', (req, res, next) => {
db.all('SELECT * FROM Menu',
(err, data) => {
if (err) {
next(err);
} else {
res.status(200).json({menus: data});
}
});
});
menusRouter.get('/:menuId', (req, res, next) => {
res.status(200).json({menu: req.menu});
});
menusRouter.post('/', validateMenu, (req, res, next) => {
db.run(`INSERT INTO Menu (title) VALUES ("${req.title}")`,
function(err) {
if (err) {
next(err);
} else {
db.get(`SELECT * FROM Menu WHERE id = ${this.lastID}`,
(err, data) => {
res.status(201).json({menu: data});
});
}
});
});
menusRouter.put('/:menuId', validateMenu, (req, res, next) => {
db.run(`UPDATE Menu SET title = "${req.title}" WHERE id = ${req.params.menuId}`,
function(err) {
if (err) {
next(err);
} else {
db.get(`SELECT * FROM Menu WHERE id = ${req.params.menuId}`,
(err, data) => {
res.status(200).json({menu: data});
});
}
});
});
menusRouter.delete('/:menuId', (req, res, next) => {
db.get(`SELECT * FROM MenuItem WHERE menu_id = ${req.params.menuId}`,
function(err, data) {
if (err) {
next(err);
} else {
if (data) {
res.sendStatus(400);
} else {
db.run(`DELETE FROM Menu WHERE id = ${req.params.menuId}`,
(err) => {
if (err) {
next(err);
} else {
res.sendStatus(204);
}
});
}
}
});
});
module.exports = menusRouter;