-
Notifications
You must be signed in to change notification settings - Fork 0
/
router.js
122 lines (106 loc) · 3.64 KB
/
router.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
//==============================================================================
// ■ Router (router.js)
//------------------------------------------------------------------------------
// Router entry point.
//==============================================================================
const express = require("express");
const router = express.Router();
const YAML = require("json2yaml");
//------------------------------------------------------------------------------
// ► Exports
//------------------------------------------------------------------------------
module.exports = router;
//------------------------------------------------------------------------------
// ● Database
//------------------------------------------------------------------------------
const odb = require("0db");
//******************************************************************************
// 🔻 Routes
//******************************************************************************
router.use(express.static("./static"));
router.use(async (req, res, next) => {
req.db = await odb();
next();
});
//------------------------------------------------------------------------------
// ● READ
//------------------------------------------------------------------------------
router.get("(/read)?", async (req, res) => {
// Get-Items
const users = await req.db("users").read();
// Get-Message
let { message } = req.session;
req.session.message = undefined;
// Render
res.render("./", { message, items: users });
});
//------------------------------------------------------------------------------
// ● CREATE
//------------------------------------------------------------------------------
router.get("/create", async (req, res, next) => {
try {
// Get-Data
const { name } = req.query;
if (!name) throw Error("Name is empty");
// Create-Item
const createdUser = await req.db("users").create({ name });
// Set-Message and Redirect
req.session.message = {
title: "CREATED",
content: YAML.stringify(createdUser),
};
res.redirect("/");
} catch(err) {
next(err);
}
});
//------------------------------------------------------------------------------
// ● UPDATE
//------------------------------------------------------------------------------
router.get("/update/:id", async (req, res, next) => {
try {
// Get-Data
const { id: $id } = req.params;
const { name } = req.query;
// Update-Item
const updatedUsers = await req.db("users").update({ $id }, { name });
// Set-Message and Redirect
req.session.message = {
title: "UPDATED",
content: YAML.stringify(updatedUsers),
};
res.redirect("/");
} catch(err) {
next(err)
}
});
//------------------------------------------------------------------------------
// ● DELETE
//------------------------------------------------------------------------------
router.get("/delete/:id", async (req, res, next) => {
try {
// Get-Data
const { id: $id } = req.params;
// Delete-Item
const deletedUsers = await req.db("users").delete({ $id: req.params.id });
// Set-Message and Redirect
req.session.message = {
title: "DELETED",
content: YAML.stringify(deletedUsers),
};
res.redirect("/");
} catch(err) {
next(err);
}
});
//------------------------------------------------------------------------------
// ● Error-Handler
//------------------------------------------------------------------------------
router.use((err, req, res, next) => {
const { name, message } = err;
req.session.message = {
title: "Error",
content: YAML.stringify({ name, message }),
};
res.redirect("/");
});