From bd6f2159931b5877922efed11f7ea9c54b172379 Mon Sep 17 00:00:00 2001
From: JP Appel <jeanpierre.appel01@gmail.com>
Date: Tue, 15 Oct 2024 23:56:50 -0400
Subject: Add authentication middleware

---
 db/db.go | 46 ++++++++++++++++++++++++++++++++++++++++++++++
 1 file changed, 46 insertions(+)
 create mode 100644 db/db.go

(limited to 'db/db.go')

diff --git a/db/db.go b/db/db.go
new file mode 100644
index 0000000..8213903
--- /dev/null
+++ b/db/db.go
@@ -0,0 +1,46 @@
+package db
+
+import (
+	"database/sql"
+	"log/slog"
+	"os"
+
+	_ "github.com/mattn/go-sqlite3"
+)
+
+var Logger *slog.Logger
+
+// Create a new database connection
+func New() *sql.DB {
+	conn, err := sql.Open("sqlite3", "./foo.db")
+	if err != nil {
+		Logger.Error("Failed to create database connection")
+		panic(err)
+	}
+
+    if err = InitTables(conn); err != nil {
+        panic(err)
+    }
+
+	return conn
+}
+
+func InitTables(conn *sql.DB) error {
+	_, err := conn.Exec(`
+    CREATE TABLE IF NOT EXISTS users (
+        id INTEGER PRIMARY KEY AUTOINCREMENT,
+        username TEXT UNIQUE NOT NULL,
+        salt BLOB NOT NULL,
+        saltedHash BLOB NOT NULL
+    )
+    `)
+
+	if err != nil {
+		return err
+	}
+	return nil
+}
+
+func init() {
+	Logger = slog.New(slog.NewTextHandler(os.Stdout, nil))
+}
-- 
cgit v1.2.3