From 6f0b965f3a1a14a959c1cde7fa2a31fb7beaf03f Mon Sep 17 00:00:00 2001
From: LarsVomMars
Date: Fri, 2 Oct 2020 13:37:10 +0200
Subject: Move to js initValues

---
 db.js      |  8 +++++++-
 tables.sql | 16 ++++------------
 2 files changed, 11 insertions(+), 13 deletions(-)

diff --git a/db.js b/db.js
index 27fa9e7..f3b3b18 100644
--- a/db.js
+++ b/db.js
@@ -12,7 +12,7 @@ class DB {
             database: process.env.DBName,
         });
         this.init();
-        this.query("SELECT * FROM users").then((res) => {
+        this.query("SELECT * FROM users LIMIT 1").then((res) => {
             if (res.length === 0) this.initValues();
         });
     }
@@ -37,6 +37,12 @@ class DB {
     initValues() {
         fs.readFile(__dirname + "/names.csv", "utf8", async (err, data) => {
             if (err) throw err;
+
+            await this.query("INSERT INTO types (name) VALUES ('teacher'), ('puipl')");
+            await this.query(
+                "INSERT INTO class (name) VALUES ('TGM13.1'), ('TGM13.2'), (TGTM13.1), (TGI13.1), (TGI13.2)"
+            );
+
             const classes = data.split("--");
             const userPasswords = {};
             console.log("Generating users");
diff --git a/tables.sql b/tables.sql
index e629f7a..8948860 100644
--- a/tables.sql
+++ b/tables.sql
@@ -9,10 +9,10 @@ CREATE TABLE IF NOT EXISTS theme(
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
 
 -- TODO: Remove dropping
-DROP TABLE IF EXISTS quotes;
-DROP TABLE IF EXISTS users;
-DROP TABLE IF EXISTS types;
-DROP TABLE IF EXISTS class;
+-- DROP TABLE IF EXISTS quotes;
+-- DROP TABLE IF EXISTS users;
+-- DROP TABLE IF EXISTS types;
+-- DROP TABLE IF EXISTS class;
 
 CREATE TABLE IF NOT EXISTS types(
     id INTEGER PRIMARY KEY AUTO_INCREMENT,
@@ -49,11 +49,3 @@ CREATE TABLE IF NOT EXISTS quotes(
     CONSTRAINT `fk_user_quote1` FOREIGN KEY (user_id) REFERENCES users (id),
     CONSTRAINT `fk_user_quote2` FOREIGN KEY (author_id) REFERENCES users (id)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-
-INSERT INTO types VALUES (1, "teacher"), (2, "pupil");
-INSERT INTO class VALUES
-    (1, "TGM13.1"),
-    (2, "TGM13.2"),
-    (3, "TGTM13.1"),
-    (4, "TGI13.1"),
-    (5, "TGI13.2");
-- 
cgit v1.2.3