One step closer to the end

1 files changed, 49 insertions, 0 deletions

diff --git a/backend/ts/api/login.ts b/backend/ts/api/login.ts
new file mode 100644
index 0000000..5b38c62
--- /dev/null
+++ b/backend/ts/api/login.ts
@@ -0,0 +1,49 @@
+import { Request, Response } from "express";
+import { makeQuery } from "../helpers";
+
+interface Colors {
+  blue: number;
+  red: number;
+  green: number;
+  yellow: number;
+  0: number;
+  1: number;
+  2: number;
+  3: number;
+}
+
+interface fiaTable {
+  id: number;
+  data: Array<object>;
+  started: boolean;
+}
+
+const Color: Colors = {
+  blue: 0,
+  red: 1,
+  green: 2,
+  yellow: 3,
+  0: 0, 1: 1, 2: 2, 3: 3
+}
+
+export default async function apiLogin(req: Request, res: Response) {
+  if (req.session === undefined) {
+    res.send(/* html */`<script>alert("Something went wrong, try to reload the page")</script>`);
+    return;
+  }
+  req.session.uid = req.session.id;
+  let c = await makeQuery("SELECT * FROM `fia` WHERE `started`= false LIMIT 1", []),
+    row: fiaTable;
+  if (c === "") {
+    let data = { id: req.session.uid, color: Color.blue };
+    makeQuery("INSERT INTO `fia`(`data`, `started`) VALUES (?, ?)", [JSON.stringify(data), "0"]);
+  }
+  else {
+    row = JSON.parse(c);
+    row.data.push({ id: req.session.uid, color: Color[row.data.length as keyof Colors] });
+    makeQuery("UPDATE `fia` SET `data`=? WHERE `id`=?", [JSON.stringify(row.data), row.id.toString()]);
+    if(row.data.length === 4)
+      makeQuery("UPDATE `fia` SET `started` = 1 WHERE `id`=?", [row.id.toString()]);
+  }
+  res.send("[1, 2, 3]");
+}