Some thingies

1 files changed, 20 insertions, 2 deletions

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;