'use strict'; const path = require('path'); const { Database } = require('node-sqlite3-wasm'); const DB_PATH = path.join(__dirname, '../filemanager.db'); let db; function getDb() { if (!db) { db = new Database(DB_PATH); db.exec('PRAGMA journal_mode = WAL'); db.exec('PRAGMA foreign_keys = ON'); } return db; } function initDb() { const d = getDb(); d.exec(` CREATE TABLE IF NOT EXISTS users ( id INTEGER PRIMARY KEY AUTOINCREMENT, username TEXT UNIQUE NOT NULL, password_hash TEXT NOT NULL, is_admin INTEGER NOT NULL DEFAULT 0, permissions TEXT NOT NULL DEFAULT '{}' ); CREATE TABLE IF NOT EXISTS file_meta ( file_path TEXT PRIMARY KEY, uploader TEXT NOT NULL DEFAULT '', downloaders TEXT NOT NULL DEFAULT '[]' ); `); } function closeDb() { if (db) { db.close(); db = null; } } module.exports = { getDb, initDb, closeDb };