BlueGit

timfa filemanager

Files

filemanager / server / db.js

db.js

fixes and updates
timfa Tim Falken · pushed by timfa · 6 months ago
0ae63c84 History
db.js 1.4 KiB Download Raw
1'use strict';
2
3const path = require('path');
4const { Database } = require('node-sqlite3-wasm');
5
6const DB_PATH = path.join(__dirname, '../filemanager.db');
7let db;
8
9function getDb ()
10{
11 if (!db)
12 {
13 db = new Database(DB_PATH);
14 db.exec('PRAGMA journal_mode = WAL');
15 db.exec('PRAGMA foreign_keys = ON');
16 }
17 return db;
18}
19
20function initDb ()
21{
22 const d = getDb();
23
24 d.exec(`
25 CREATE TABLE IF NOT EXISTS users (
26 id INTEGER PRIMARY KEY AUTOINCREMENT,
27 username TEXT UNIQUE NOT NULL,
28 password_hash TEXT NOT NULL,
29 is_admin INTEGER NOT NULL DEFAULT 0,
30 permissions TEXT NOT NULL DEFAULT '{}'
31 );
32
33 CREATE TABLE IF NOT EXISTS file_meta (
34 file_path TEXT PRIMARY KEY,
35 uploader TEXT NOT NULL DEFAULT '',
36 downloaders TEXT NOT NULL DEFAULT '[]'
37 );
38
39 CREATE TABLE IF NOT EXISTS auth_sessions (
40 session_id TEXT PRIMARY KEY,
41 username TEXT NOT NULL,
42 ip TEXT NOT NULL,
43 region TEXT NOT NULL,
44 fp_hash TEXT NOT NULL,
45 created_at INTEGER NOT NULL,
46 last_seen_at INTEGER NOT NULL,
47 revoked_at INTEGER
48 );
49
50 CREATE INDEX IF NOT EXISTS idx_auth_sessions_username ON auth_sessions(username);
51 CREATE INDEX IF NOT EXISTS idx_auth_sessions_last_seen ON auth_sessions(last_seen_at);
52 `);
53}
54
55function closeDb ()
56{
57 if (db)
58 {
59 db.close();
60 db = null;
61 }
62}
63
64module.exports = { getDb, initDb, closeDb };