1 files changed, 24 insertions, 7 deletions

diff --git a/db.js b/db.js
index 49caabd..31cf795 100644
--- a/db.js
+++ b/db.js
@@ -37,7 +37,7 @@ class DB {
 
             await this.query("INSERT INTO types (name) VALUES ('pupil'), ('teacher')");
             await this.query(
-                "INSERT INTO class (name) VALUES ('TGM13.1'), ('TGM13.2'), ('TGTM13.1'), ('TGI13.1'), ('TGI13.2'), ('teacher')"
+                "INSERT INTO class (name) VALUES ('TGM13.1'), ('TGM13.2'), ('TGTM13.1'), ('TGI13.1'), ('TGI13.2'), ('teacher')",
             );
 
             // User polls
@@ -49,7 +49,10 @@ class DB {
                     const questions = part.split("\n");
                     questions.forEach((question) => {
                         if (question.length > 0)
-                            this.query("INSERT INTO ranking_questions (question, type_id) VALUE (?,?)", [question, i+1]);
+                            this.query("INSERT INTO ranking_questions (question, type_id) VALUE (?,?)", [
+                                question,
+                                i + 1,
+                            ]);
                     });
                 });
             });
@@ -61,8 +64,16 @@ class DB {
                 const mottos = data.split("\n");
                 mottos.forEach(async (motto) => {
                     const [name, desc] = motto.split(" - ");
-                    if (motto)
-                        await this.query("INSERT INTO mottos (name, description) VALUES (?, ?)", [name, desc]);
+                    if (motto) await this.query("INSERT INTO mottos (name, description) VALUES (?, ?)", [name, desc]);
+                });
+            });
+
+            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]);
                 });
             });
 
@@ -97,7 +108,15 @@ class DB {
                         userPasswords[classIndex].push({ username, pwd });
                         await this.query(
                             "INSERT INTO users (username, name, middlename, surname, password, class_id, type_id) VALUE (?,?,?,?,?,?,?)",
-                            [username, names[0].replace("\r", ""), middlename, surname, password, classIndex + 1, 2]
+                            [
+                                username,
+                                names[0].replace("\r", ""),
+                                middlename,
+                                surname,
+                                password,
+                                classIndex + 1,
+                                classIndex + 1 === 6 ? 2 : 1,
+                            ],
                         );
                     }
                 }
@@ -113,8 +132,6 @@ class DB {
         const conn = await this.connect();
         try {
             return await conn.query(query, params);
-        } catch (e) {
-            throw e;
         } finally {
             conn.release();
         }