BlueGit

timfa filemanager

Files

filemanager / server / db.js

db.js

import project
timfa Tim Falken · pushed by timfa · 6 months ago
d3c0b911 History
db.js 969 B 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 if (!db) {
11 db = new Database(DB_PATH);
12 db.exec('PRAGMA journal_mode = WAL');
13 db.exec('PRAGMA foreign_keys = ON');
14 }
15 return db;
16}
17
18function initDb() {
19 const d = getDb();
20
21 d.exec(`
22 CREATE TABLE IF NOT EXISTS users (
23 id INTEGER PRIMARY KEY AUTOINCREMENT,
24 username TEXT UNIQUE NOT NULL,
25 password_hash TEXT NOT NULL,
26 is_admin INTEGER NOT NULL DEFAULT 0,
27 permissions TEXT NOT NULL DEFAULT '{}'
28 );
29
30 CREATE TABLE IF NOT EXISTS file_meta (
31 file_path TEXT PRIMARY KEY,
32 uploader TEXT NOT NULL DEFAULT '',
33 downloaders TEXT NOT NULL DEFAULT '[]'
34 );
35 `);
36}
37
38function closeDb() {
39 if (db) {
40 db.close();
41 db = null;
42 }
43}
44
45module.exports = { getDb, initDb, closeDb };