From 5cfd8d35ac937799dcf6079b3412e6f2d76b6a4f Mon Sep 17 00:00:00 2001
From: "Akshay\" (aider)" <nerdy@peppe.rs>
Date: Fri, 8 Nov 2024 22:10:47 +0000
Subject: feat: Add user registration, login, and subscription management with
 SQLite

---
 src/index.js | 21 +++++++++++++++++++++
 1 file changed, 21 insertions(+)

(limited to 'src/index.js')

diff --git a/src/index.js b/src/index.js
index cf55183..bb9eb53 100644
--- a/src/index.js
+++ b/src/index.js
@@ -2,15 +2,36 @@ const express = require("express");
 const path = require("node:path");
 const routes = require("./routes/index");
 const geddit = require("./geddit.js");
+const { Database } = require("bun:sqlite");
 
 const app = express();
 
 app.set("views", path.join(__dirname, "views"));
 app.set("view engine", "pug");
 
+app.use(express.json());
 app.use(express.static(path.join(__dirname, "public")));
 app.use("/", routes);
 
+const db = new Database("users.db");
+
+db.run(`
+  CREATE TABLE IF NOT EXISTS users (
+    id INTEGER PRIMARY KEY AUTOINCREMENT,
+    username TEXT UNIQUE,
+    password TEXT
+  )
+`);
+
+db.run(`
+  CREATE TABLE IF NOT EXISTS subscriptions (
+    id INTEGER PRIMARY KEY AUTOINCREMENT,
+    user_id INTEGER,
+    subreddit TEXT,
+    FOREIGN KEY(user_id) REFERENCES users(id)
+  )
+`);
+
 const port = process.env.READIT_PORT;
 const server = app.listen(port ? port : 3000, () => {
 	console.log(`started on ${server.address().port}`);
-- 
cgit v1.2.3