aboutsummaryrefslogtreecommitdiff
path: root/db.js
diff options
context:
space:
mode:
Diffstat (limited to 'db.js')
-rw-r--r--db.js19
1 files changed, 19 insertions, 0 deletions
diff --git a/db.js b/db.js
index d33f8bc..b16364a 100644
--- a/db.js
+++ b/db.js
@@ -40,6 +40,11 @@ class DB {
"INSERT INTO class (name) VALUES ('TGM13.1'), ('TGM13.2'), ('TGTM13.1'), ('TGI13.1'), ('TGI13.2'), ('teacher')",
);
+
+ const types = ["number", "file", "date", "text", "color"];
+ await this.query("INSERT INTO profile_input_types (type) VALUES (?), (?), (?), (?), (?)", types);
+
+ // User polls
fs.readFile(__dirname + "/poll.txt", "utf8", (err, data) => {
if (err) throw err;
@@ -56,6 +61,7 @@ class DB {
});
});
+ // Motto votes
fs.readFile(__dirname + "/mottos.txt", "utf8", (err, data) => {
if (err) throw err;
@@ -66,6 +72,19 @@ class DB {
});
});
+ // User profile
+ fs.readFile(__dirname + "/profile.txt", "utf8", (err, data) => {
+ if (err) throw err;
+
+ const questions = data.split("\n");
+ questions.forEach((question) => {
+ if (question) {
+ const [q, type] = question.split(" - ");
+ this.query("INSERT INTO profile_questions (question, question_type) VALUE (?, ?)", [q, types.indexOf(type) + 1]);
+ }
+ });
+ });
+
const classes = data.split("--");
const userPasswords = {};
console.log("Generating users");