import { describe, expect, it, vi } from "vitest"; import { openSqliteDatabase } from "./sqliteAdapter"; describe("sqliteAdapter", () => {  it("opens a database and runs basic statements", () => {    const db = openSqliteDatabase(":memory:");    db.exec("CREATE TABLE sample (id INTEGER PRIMARY KEY AUTOINCREMENT, value TEXT NOT NULL);");     const insertResult = db.prepare("INSERT INTO sample (value) VALUES (?);").run("hello") as {      changes?: number;      lastInsertRowid?: number;    };    expect(insertResult.changes).toBe(1);     const row = db.prepare("SELECT value FROM sample WHERE id = ?;").get(1) as      | { value?: string }      | undefined;    expect(row?.value).toBe("hello");     const rows = db.prepare("SELECT value FROM sample ORDER BY id ASC;").all() as Array<{      value?: string;    }>;    expect(rows.map((entry) => entry.value)).toEqual(["hello"]);     db.close();  });   it("throws a helpful error when node:sqlite is unavailable", () => {    const missingModuleError = new Error("No such built-in module: node:sqlite");    (missingModuleError as NodeJS.ErrnoException).code = "ERR_UNKNOWN_BUILTIN_MODULE";    const requireFn = vi.fn((specifier: string) => {      if (specifier === "node:sqlite") {        throw missingModuleError;      }      throw new Error(`Unexpected module request: ${specifier}`);    });     expect(() => openSqliteDatabase(":memory:", requireFn as never, false)).toThrow(      "node:sqlite is unavailable",    );  });});