add dashboard view, invites

1 files changed, 35 insertions, 0 deletions

diff --git a/src/db.js b/src/db.js
index 24bba3d..747168a 100644
--- a/src/db.js
+++ b/src/db.js
@@ -3,6 +3,18 @@ const db = new Database("readit.db", {
         strict: true,
 });
 
+function runMigration(name, migrationFn) {
+        const exists = db
+                .query("SELECT * FROM migrations WHERE name = $name")
+                .get({ name });
+
+        if (!exists) {
+                migrationFn();
+                db.query("INSERT INTO migrations (name) VALUES ($name)").run({ name });
+        }
+}
+
+// users table
 db.query(`
   CREATE TABLE IF NOT EXISTS users (
     id INTEGER PRIMARY KEY AUTOINCREMENT,
@@ -11,6 +23,7 @@ db.query(`
   )
 `).run();
 
+// subs table
 db.query(`
   CREATE TABLE IF NOT EXISTS subscriptions (
     id INTEGER PRIMARY KEY AUTOINCREMENT,
@@ -21,4 +34,26 @@ db.query(`
   )
 `).run();
 
+// migrations table
+db.query(`
+  CREATE TABLE IF NOT EXISTS migrations (
+    id INTEGER PRIMARY KEY AUTOINCREMENT,
+    name TEXT UNIQUE
+  )
+`).run();
+
+runMigration("add-isAdmin-column", () => {
+        db.query(`
+    ALTER TABLE users
+    ADD COLUMN isAdmin INTEGER DEFAULT 0
+  `).run();
+
+        // first user is admin
+        db.query(`
+    UPDATE users
+    SET isAdmin = 1
+    WHERE id = (SELECT MIN(id) FROM users)
+  `).run();
+});
+
 module.exports = { db };