Added quote deletion

1 files changed, 12 insertions, 1 deletions

diff --git a/quotes/index.js b/quotes/index.js
index c0014c6..9683009 100644
--- a/quotes/index.js
+++ b/quotes/index.js
@@ -22,9 +22,20 @@ app.post("/api/add", checkUser, async (req, res) => {
 
 app.get("/api/list", checkUser, async (req, res) => {
     const quotes = await db.query(
-        "SELECT q.id, a.name, a.middlename, a.surname, q.quote, c.name AS class FROM quotes AS q INNER JOIN users AS a ON author_id = a.id INNER JOIN class AS c ON a.class_id = c.id ORDER BY a.name"
+        "SELECT q.id, a.name, a.middlename, a.surname, q.quote, c.name AS class FROM quotes AS q INNER JOIN users AS a ON author_id = a.id INNER JOIN class AS c ON a.class_id = c.id ORDER BY a.name",
     );
     res.json(quotes);
 });
 
+app.delete("/api/delete/:id", checkUser, async (req, res) => {
+    if (!req.params.id) return res.send("error");
+    try {
+        await db.query("DELETE FROM quotes WHERE id = ? AND user_id = ?", [req.params.id, req.session.uid]);
+        res.send("ok");
+    } catch (e) {
+        console.error(e);
+        res.send("error");
+    }
+});
+
 module.exports = app;