File size: 2,156 Bytes
88c4c60 | 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 | // Verify 3-tier driver fallback: better-sqlite3 → node:sqlite → sql.js
import fs from "node:fs";
import os from "node:os";
import path from "node:path";
import { describe, it, expect, beforeEach, afterEach, vi } from "vitest";
let tempDir;
const originalDataDir = process.env.DATA_DIR;
beforeEach(() => {
tempDir = fs.mkdtempSync(path.join(os.tmpdir(), "9router-chain-"));
process.env.DATA_DIR = tempDir;
delete global._dbAdapter;
vi.resetModules();
});
afterEach(() => {
try { global._dbAdapter?.instance?.close?.(); } catch {}
delete global._dbAdapter;
if (tempDir) fs.rmSync(tempDir, { recursive: true, force: true });
if (originalDataDir === undefined) delete process.env.DATA_DIR;
else process.env.DATA_DIR = originalDataDir;
});
describe("Driver fallback chain", () => {
it("default → picks better-sqlite3 when available", async () => {
const { getAdapter } = await import("@/lib/db/driver.js");
const db = await getAdapter();
expect(["better-sqlite3", "node:sqlite", "sql.js"]).toContain(db.driver);
});
it("falls back to node:sqlite when better-sqlite3 unavailable", async () => {
// Mock the better-sqlite3 adapter to throw
vi.doMock("@/lib/db/adapters/betterSqliteAdapter.js", () => {
throw new Error("simulated unavailable");
});
const { getAdapter } = await import("@/lib/db/driver.js");
const db = await getAdapter();
// Node 22.5+ should give node:sqlite, else sql.js
const [maj, min] = process.versions.node.split(".").map(Number);
if (maj > 22 || (maj === 22 && min >= 5)) {
expect(db.driver).toBe("node:sqlite");
} else {
expect(db.driver).toBe("sql.js");
}
});
it("falls back to sql.js when both native drivers unavailable", async () => {
vi.doMock("@/lib/db/adapters/betterSqliteAdapter.js", () => {
throw new Error("simulated unavailable");
});
vi.doMock("@/lib/db/adapters/nodeSqliteAdapter.js", () => {
throw new Error("simulated unavailable");
});
const { getAdapter } = await import("@/lib/db/driver.js");
const db = await getAdapter();
expect(db.driver).toBe("sql.js");
});
});
|