refactor: Replace db.run with db.query and update database name

1 files changed, 7 insertions, 3 deletions

diff --git a/src/index.js b/src/index.js
index ae9d87b..cc7e2e6 100644
--- a/src/index.js
+++ b/src/index.js
@@ -13,9 +13,9 @@ app.use(express.json());
 app.use(express.static(path.join(__dirname, "public")));
 app.use("/", routes);
 
-const db = new Database("users.db");
+const db = new Database("readit.db");
 
-db.run(`
+const createUsers = db.query(`
   CREATE TABLE IF NOT EXISTS users (
     id INTEGER PRIMARY KEY AUTOINCREMENT,
     username TEXT UNIQUE,
@@ -23,7 +23,9 @@ db.run(`
   )
 `);
 
-db.run(`
+createUsers.run();
+
+const createSubs = db.query(`
   CREATE TABLE IF NOT EXISTS subscriptions (
     id INTEGER PRIMARY KEY AUTOINCREMENT,
     user_id INTEGER,
@@ -33,6 +35,8 @@ db.run(`
   )
 `);
 
+createSubs.run();
+
 module.exports = { db };
 
 const port = process.env.READIT_PORT;