import { DatabaseSync } from "node:sqlite"; import { mkdirSync } from "node:fs"; import { dirname } from "node:path"; export function openDatabase (filePath) { mkdirSync(dirname(filePath), { recursive: true }); const database = new DatabaseSync(filePath); database.exec("PRAGMA journal_mode = WAL"); database.exec("PRAGMA foreign_keys = ON"); return database; } export function withTransaction (database, fn) { database.exec("BEGIN"); try { const result = fn(); database.exec("COMMIT"); return result; } catch (error) { database.exec("ROLLBACK"); throw error; } }