apps/glyph Public The code is public; the app answers only to 1 person who can change it and the crew.

import { expect, test } from "bun:test";

import { mkdtempSync } from "node:fs";

import { tmpdir } from "node:os";

import { join } from "node:path";

import { check, migrate, migrations, openDb } from "./db.ts";

test("migrations apply once, in order, and the file checks out", () => {

  const dir = mkdtempSync(join(tmpdir(), "app-db-"));

  const db = openDb(dir);

  expect(check(db).version).toBe(migrations.length);

  // Opening again finds nothing to do — a migration that has run is history.

  expect(migrate(db)).toBe(migrations.length);

  expect(() => openDb(dir)).not.toThrow();

  expect(check(db)).toEqual({ version: migrations.length, integrity: "ok" });

  expect(

    db.query<{ journal_mode: string }, []>("PRAGMA journal_mode").get()

      ?.journal_mode,

  ).toBe("wal");

  expect(

    db.query<{ foreign_keys: number }, []>("PRAGMA foreign_keys").get()

      ?.foreign_keys,

  ).toBe(1);

});