BlueGit

timfa filemanager

Files

filemanager / server / db.js

db.js

db.js 1.8 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 CREATE TABLE IF NOT EXISTS share_tokens (
54 token TEXT PRIMARY KEY,
55 file_path TEXT NOT NULL,
56 is_dir INTEGER NOT NULL DEFAULT 0,
57 created_by TEXT NOT NULL,
58 created_at INTEGER NOT NULL,
59 expires_at INTEGER NOT NULL
60 );
61
62 CREATE INDEX IF NOT EXISTS idx_share_tokens_expires ON share_tokens(expires_at);
63 `);
64}
65
66function closeDb ()
67{
68 if (db)
69 {
70 db.close();
71 db = null;
72 }
73}
74
75module.exports = { getDb, initDb, closeDb };