| 1 | 'use strict'; |
| 2 | |
| 3 | const path = require('path'); |
| 4 | const { Database } = require('node-sqlite3-wasm'); |
| 5 | |
| 6 | const DB_PATH = path.join(__dirname, '../filemanager.db'); |
| 7 | let db; |
| 8 | |
| 9 | function 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 | |
| 18 | function 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 | |
| 38 | function closeDb() { |
| 39 | if (db) { |
| 40 | db.close(); |
| 41 | db = null; |
| 42 | } |
| 43 | } |
| 44 | |
| 45 | module.exports = { getDb, initDb, closeDb }; |