summaryrefslogtreecommitdiff
path: root/src/lib/db.ts
blob: d1b870fdbb1bac43fb66b8d683cafa39305f88fc (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
import sqlite from "better-sqlite3";
// import path from "path";

const dbPath = "mydatabase.db";

export const db = sqlite(dbPath);

// Create the tables if they do not exist
db.exec(`CREATE TABLE IF NOT EXISTS user (
    id TEXT NOT NULL PRIMARY KEY,
    username TEXT NOT NULL UNIQUE,
    password TEXT NOT NULL
)`);

db.exec(`CREATE TABLE IF NOT EXISTS session (
    id TEXT NOT NULL PRIMARY KEY,
    expires_at INTEGER NOT NULL,
    user_id TEXT NOT NULL,
    FOREIGN KEY (user_id) REFERENCES user(id)
)`);

// Export the DatabaseUser interface
export interface DatabaseUser {
  id: string;
  username: string;
  password: string;
}