Zitate

From 91f4af6e9a3a5d770f98d4a5b75c729c18861cc1 Mon Sep 17 00:00:00 2001 From: Marvin Borner Date: Thu, 1 Oct 2020 17:33:08 +0200 Subject: Some thingies --- auth/index.js | 5 ++++- auth/public/index.html | 4 ++-- db.js | 2 +- quotes/index.js | 22 ++++++++++++++++++++-- quotes/public/index.html | 6 +++--- quotes/public/script.js | 17 ++++------------- 6 files changed, 34 insertions(+), 22 deletions(-) diff --git a/auth/index.js b/auth/index.js index 9bc3f58..b726a25 100644 --- a/auth/index.js +++ b/auth/index.js @@ -9,6 +9,9 @@ const app = express.Router(); app.use("/", express.static(__dirname + "/public")); -app.get("/api/list", (req, res) => {}); +app.get("/api/list", async (req, res) => { + const users = await db.query("SELECT id, name, middlename, surname FROM users"); + res.json(users); +}); module.exports = app; diff --git a/auth/public/index.html b/auth/public/index.html index 8bf9ecd..e927b13 100644 --- a/auth/public/index.html +++ b/auth/public/index.html @@ -18,9 +18,9 @@

Login Username - + Passwort - + Angemeldet bleiben diff --git a/db.js b/db.js index 398df92..f2cf13d 100644 --- a/db.js +++ b/db.js @@ -50,7 +50,7 @@ class DB { const password = await bcrypt.hash(pwd, 12); await this.query( "INSERT INTO users (username, name, middlename, surname, password, class_id, type_id) VALUE (?,?,?,?,?,?,?)", - [username, names[0], middlename, surname, password, classIndex + 1, 2] + [username, names[0].replace("\r", ""), middlename, surname, password, classIndex + 1, 2] ); } }); diff --git a/quotes/index.js b/quotes/index.js index e90dd80..66aeb5e 100644 --- a/quotes/index.js +++ b/quotes/index.js @@ -4,8 +4,26 @@ const app = express.Router(); app.use("/", express.static(__dirname + "/public")); -app.get("/api/list", (req, res) => { - res.send("ok\n"); +app.post("/api/add", async (req, res) => { + if (!req.body.author || !req.body.quote) return res.send("error"); + try { + await db.query("INSERT INTO quotes (user_id, author_id, quote) VALUE (?,?,?)", [ + 72, // TODO: Add actual user identification + parseInt(req.body.author), + req.body.quote, + ]); + res.redirect("/quotes"); + } catch (e) { + console.error(e); + res.json("error"); + } +}); + +app.get("/api/list", async (req, res) => { + const quotes = await db.query( + "SELECT quotes.id, name, middlename, surname, quote FROM quotes INNER JOIN users AS a ON author_id = a.id" + ); + res.json(quotes); }); module.exports = app; diff --git a/quotes/public/index.html b/quotes/public/index.html index abe85cc..0c7b327 100644 --- a/quotes/public/index.html +++ b/quotes/public/index.html @@ -14,13 +14,13 @@ Zitate - diff --git a/quotes/public/script.js b/quotes/public/script.js index 3fbc676..7a87486 100644 --- a/quotes/public/script.js +++ b/quotes/public/script.js @@ -6,7 +6,7 @@ function append(response) { response.forEach((elem) => { dropdown.insertAdjacentHTML( "beforeend", - `` ); @@ -14,15 +14,6 @@ function append(response) { } // TODO: Add api list endpoint -// fetch("/auth/api/list") -// .then((response) => response.json()) -// .then((response) => append(response)); - -const exampleJson = [ - { id: 1, name: "Lars", middlename: null, surname: "Baum" }, - { id: 2, name: "Marvin", middlename: null, surname: "Giraffe" }, - { id: 3, name: "Dominik", middlename: null, surname: "Apfel" }, - { id: 4, name: "Daniel", middlename: null, surname: "Torte" }, -]; - -append(exampleJson); +fetch("/auth/api/list") + .then((response) => response.json()) + .then((response) => append(response)); -- cgit v1.2.3