Function openDatabase

src/utils/sqlite.ts:8–21

(filePath: string)

const connections = new Map<string, Database.Database>();

export function openDatabase(filePath: string): Database.Database {
  if (connections.has(filePath)) {
    return connections.get(filePath)!;
  }
  const dir = path.dirname(filePath);
  fs.mkdirSync(dir, { recursive: true });
  const db = new Database(filePath);
  db.pragma('journal_mode = WAL');
  db.pragma('foreign_keys = ON');
  db.pragma('synchronous = NORMAL');
  db.pragma('busy_timeout = 5000');
  connections.set(filePath, db);
  return db;
}

export function closeAll(): void {
  for (const db of connections.values()) {