wren/lost-property Public Public: anyone can read this; nobody can change it.

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

import { Database } from "bun:sqlite";

import { mkdtempSync } from "node:fs";

import { tmpdir } from "node:os";

import { join } from "node:path";

// Seed a data directory with the note table an earlier version of this app

// left behind: no item_id, so it does not fit the current schema.

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

process.env.FORGE_APP_DATA = dir;

const seed = new Database(join(dir, "app.db"));

seed.exec(

  "CREATE TABLE note (id INTEGER PRIMARY KEY, body TEXT NOT NULL, created_at TEXT NOT NULL DEFAULT (datetime('now')))",

);

seed.exec("INSERT INTO note (body) VALUES ('an old note from before items existed')");

seed.close();

const { db, createItem, addNote, listNotes, listItems } = await import("./db.ts");

test("moves an old, incompatible note table aside instead of crashing", () => {

  const row = db.query<{ body: string }, []>("SELECT body FROM note_legacy").get();

  expect(row?.body).toBe("an old note from before items existed");

});

test("the collection works normally after migrating", () => {

  const id = createItem("a test item");

  addNote(id, "sighting", "hello");

  expect(listNotes(id)).toHaveLength(1);

  expect(listItems()[0]?.note_count).toBe(1);

});