diff options
| author | LarsVomMars | 2020-10-07 23:42:34 +0200 |
|---|---|---|
| committer | LarsVomMars | 2020-10-10 13:17:58 +0200 |
| commit | 4e9154b12ea3ddd9da32d2a4d1ebc30f13678c59 (patch) | |
| tree | e77488cc313fc3707b688305080eb27bc2ac73e0 | |
| parent | 0e57580efcce8e8f11d5e9643700e706a193f920 (diff) | |
User profile boilerplate
| -rw-r--r-- | app.js | 2 | ||||
| -rw-r--r-- | db.js | 11 | ||||
| -rw-r--r-- | profile.txt | 1 | ||||
| -rw-r--r-- | profile/index.js | 34 | ||||
| -rw-r--r-- | profile/public/index.html | 34 | ||||
| -rw-r--r-- | profile/public/script.js | 0 | ||||
| -rw-r--r-- | profile/public/style.css | 0 | ||||
| -rw-r--r-- | tables.sql | 29 |
8 files changed, 111 insertions, 0 deletions
@@ -6,6 +6,7 @@ const { auth, checkUser } = require("./auth"); const mottovote = require("./mottovote"); const quotes = require("./quotes"); const poll = require("./poll"); +const profile = require("./profile"); const app = express(); @@ -30,6 +31,7 @@ app.use("/", express.static(__dirname + "/overview/public")); app.use("/mottovote", checkUser, mottovote); app.use("/quotes", checkUser, quotes); app.use("/poll", checkUser, poll); +app.use("/profile", checkUser, profile); app.use("/auth", auth); app.listen(process.env.PORT || 5005, () => console.log("Server started on http://localhost:5005")); @@ -40,6 +40,7 @@ class DB { "INSERT INTO class (name) VALUES ('TGM13.1'), ('TGM13.2'), ('TGTM13.1'), ('TGI13.1'), ('TGI13.2'), ('teacher')", ); + // User polls fs.readFile(__dirname + "/poll.txt", "utf8", (err, data) => { if (err) throw err; @@ -56,6 +57,7 @@ class DB { }); }); + // Motto votes fs.readFile(__dirname + "/mottos.txt", "utf8", (err, data) => { if (err) throw err; @@ -66,6 +68,15 @@ class DB { }); }); + fs.readFile(__dirname + "/profile.txt", "utf8", (err, data) => { + if (err) throw err; + + const questions = data.split("\n"); + questions.forEach((question) => { + if (question) this.query("INSERT INTO profile_questions (question) VALUE (?)", [question]); + }); + }); + const classes = data.split("--"); const userPasswords = {}; console.log("Generating users"); diff --git a/profile.txt b/profile.txt new file mode 100644 index 0000000..dd79092 --- /dev/null +++ b/profile.txt @@ -0,0 +1 @@ +Alter?
\ No newline at end of file diff --git a/profile/index.js b/profile/index.js new file mode 100644 index 0000000..4bfc1f7 --- /dev/null +++ b/profile/index.js @@ -0,0 +1,34 @@ +const express = require("express"); +const db = require("../db"); +const app = express.Router(); + +app.use("/", express.static(__dirname + "/public/")); + +// Basic API +app.get("/api/user", async (req, res) => {}); + +app.get("/api/questions", async (req, res) => { + const questions = await db.query("SELECT id, question FROM profile_questions"); + const answers = await db.query("SELECT answer, question_id FROM profile_answers WHERE user_id = ?", [req.session.uid]); + + for (const answer of answers) { + const qid = questions.findIndex((question) => question.id === answer.question_id); + if (qid !== undefined) questions[qid].answer = answer.answer; + } + res.json(questions); +}); + +app.post("/api/add", async (req, res) => {}); + +app.put("/api/update", async (req, res) => {}); + +// Comments API +app.get("/api/comments/:uid", async (req, res) => {}); + +app.post("/api/comment", async (req, res) => {}); + +app.put("/api/comment", async (req, res) => {}); + +app.delete("/api/comment", async (req, res) => {}); + +module.exports = app;
\ No newline at end of file diff --git a/profile/public/index.html b/profile/public/index.html new file mode 100644 index 0000000..30f9de8 --- /dev/null +++ b/profile/public/index.html @@ -0,0 +1,34 @@ +<!DOCTYPE html> +<html lang="de"> + +<head> + <meta charset="UTF-8"> + <meta name="viewport" content="width=device-width, initial-scale=1.0"> + <link rel="stylesheet" href="https://unpkg.com/purecss@2.0.3/build/pure-min.css" + integrity="sha384-cg6SkqEOCV1NbJoCu11+bm0NvBRc8IYLRGXkmNrqUBfTjmMYwNKPWBTIKyw9mHNJ" crossorigin="anonymous" /> + <link rel="stylesheet" href="style.css" type="text/css" media="all" /> + <title>Steckbrief</title> +</head> + +<body> + <div class="pure-menu pure-menu-horizontal"> + <a href="/" class="pure-menu-item pure-menu-link">Home</a> + <a href="/auth/api/logout" class="pure-menu-item pure-menu-link">Logout</a> + </div> + <main> + <!-- TODO: JS switch method/action --> + <form class="pure-form pure-form-stacked" action="api/add" method="post"> + <fieldset> + <legend>Steckbrief</legend> + + <!-- TODO: Insert stuff lel --> + + <!-- TODO: Consider autosave --> + <button type="submit" class="pure-button pure-button-primary">Wohooo</button> + </fieldset> + </form> + </main> + <script src="js/script.js"></script> +</body> + +</html>
\ No newline at end of file diff --git a/profile/public/script.js b/profile/public/script.js new file mode 100644 index 0000000..e69de29 --- /dev/null +++ b/profile/public/script.js diff --git a/profile/public/style.css b/profile/public/style.css new file mode 100644 index 0000000..e69de29 --- /dev/null +++ b/profile/public/style.css @@ -4,6 +4,9 @@ -- DROP TABLE IF EXISTS quotes; -- DROP TABLE IF EXISTS ranking_questions; -- DROP TABLE IF EXISTS ranking_answers; +-- DROP TABLE IF EXISTS profile_comments; +-- DROP TABLE IF EXISTS profile_answers; +-- DROP TABLE IF EXISTS profile_questions; -- DROP TABLE IF EXISTS users; -- DROP TABLE IF EXISTS types; -- DROP TABLE IF EXISTS class; @@ -84,3 +87,29 @@ CREATE TABLE IF NOT EXISTS motto_votes( CONSTRAINT `fk_voted_user` FOREIGN KEY (user_id) REFERENCES users (id), CONSTRAINT `fk_voted_vote` FOREIGN KEY (motto_id) REFERENCES mottos (id) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; + +CREATE TABLE IF NOT EXISTS profile_questions( + id INTEGER PRIMARY KEY AUTO_INCREMENT, + question VARCHAR(255) NOT NULL UNIQUE +) ENGINE=InnoDB DEFAULT CHARSET=utf8; + +CREATE TABLE IF NOT EXISTS profile_answers( + id INTEGER PRIMARY KEY AUTO_INCREMENT, + question_id INTEGER NOT NULL, + user_id INTEGER NOT NULL, + answer TEXT NULL, -- Consider VARCHAR + + UNIQUE KEY uk_answer (question_id, user_id), + CONSTRAINT `fk_profile_user` FOREIGN KEY (user_id) REFERENCES users (id), + CONSTRAINT `fk_profile_question` FOREIGN KEY (question_id) REFERENCES profile_questions (id) +) ENGINE=InnoDB DEFAULT CHARSET=utf8; + +CREATE TABLE IF NOT EXISTS profile_comments( + id INTEGER PRIMARY KEY AUTO_INCREMENT, + profile_id INTEGER NOT NULL, -- User's profile + user_id INTEGER NOT NULL, -- User who commented + comment TEXT NOT NULL, + + CONSTRAINT `fk_user_profile` FOREIGN KEY (profile_id) REFERENCES users (id), + CONSTRAINT `fk_user_commenter` FOREIGN KEY (user_id) REFERENCES users (id) +) ENGINE=InnoDB DEFAULT CHARSET=utf8;
\ No newline at end of file |