From 292257d627bd1dfeafd772ac6457e2f54c2b73ba Mon Sep 17 00:00:00 2001 From: Maks Jopek Date: Sun, 4 Apr 2021 01:53:24 +0200 Subject: One step closer to the end --- backend/ts/api/login.ts | 49 +++++++++++++++++++++++++++++++++++++++++++++++++ 1 file changed, 49 insertions(+) create mode 100644 backend/ts/api/login.ts (limited to 'backend/ts/api/login.ts') 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; + 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 */``); + 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]"); +} -- cgit v1.3.1