import { Database } from "bun:sqlite";

import { resolveDbPath } from "@/utils/env";

import { runMigrations } from "./migrations";

export const openDb = (pathOverride?: string): Database => {
  const dbPath = resolveDbPath(pathOverride);
  const db = new Database(dbPath, { create: true });
  db.run("PRAGMA journal_mode = WAL;");
  db.run("PRAGMA synchronous = NORMAL;");
  db.run("PRAGMA foreign_keys = ON;");
  runMigrations(db);
  return db;
};

export const closeDb = (db: Database): void => {
  db.close();
};