BlueGit

timfa filemanager

Files

filemanager / server / db.js

db.js

db.js 2.5 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 watched_by TEXT NOT NULL DEFAULT '{}',
38 uploaded_at TEXT
39 );
40
41 CREATE TABLE IF NOT EXISTS auth_sessions (
42 session_id TEXT PRIMARY KEY,
43 username TEXT NOT NULL,
44 ip TEXT NOT NULL,
45 region TEXT NOT NULL,
46 fp_hash TEXT NOT NULL,
47 created_at INTEGER NOT NULL,
48 last_seen_at INTEGER NOT NULL,
49 revoked_at INTEGER
50 );
51
52 CREATE INDEX IF NOT EXISTS idx_auth_sessions_username ON auth_sessions(username);
53 CREATE INDEX IF NOT EXISTS idx_auth_sessions_last_seen ON auth_sessions(last_seen_at);
54
55 CREATE TABLE IF NOT EXISTS share_tokens (
56 token TEXT PRIMARY KEY,
57 file_path TEXT NOT NULL,
58 is_dir INTEGER NOT NULL DEFAULT 0,
59 created_by TEXT NOT NULL,
60 created_at INTEGER NOT NULL,
61 expires_at INTEGER NOT NULL
62 );
63
64 CREATE INDEX IF NOT EXISTS idx_share_tokens_expires ON share_tokens(expires_at);
65 `);
66
67 const fileMetaCols = d.prepare('PRAGMA table_info(file_meta)').all();
68 const colNames = fileMetaCols.map((col) => String(col.name || ''));
69
70 if (!colNames.includes('watched_by'))
71 {
72 d.exec("ALTER TABLE file_meta ADD COLUMN watched_by TEXT NOT NULL DEFAULT '{}'");
73 }
74
75 if (!colNames.includes('sha256'))
76 {
77 d.exec('ALTER TABLE file_meta ADD COLUMN sha256 TEXT');
78 d.exec('CREATE INDEX IF NOT EXISTS idx_file_meta_sha256 ON file_meta(sha256)');
79 } else
80 {
81 d.exec('CREATE INDEX IF NOT EXISTS idx_file_meta_sha256 ON file_meta(sha256)');
82 }
83
84 if (!colNames.includes('uploaded_at'))
85 {
86 d.exec('ALTER TABLE file_meta ADD COLUMN uploaded_at TEXT');
87 }
88}
89
90function closeDb ()
91{
92 if (db)
93 {
94 db.close();
95 db = null;
96 }
97}
98
99module.exports = { getDb, initDb, closeDb };