import { describe, it, expect, beforeEach, afterEach, mock } from "bun:test"; import { Kysely, ParseJSONResultsPlugin, sql } from "kysely"; import { BunSqliteDialect } from "kysely-bun-sqlite"; import { Database } from "bun:sqlite"; import { tmpdir } from "node:os"; import { join } from "node:path"; import { unlinkSync, existsSync } from "node:fs"; import { randomUUID } from "node:crypto"; // Mock the cloudflare:workers module BEFORE importing D1EventPlugin const mockQueueSend = mock(() => Promise.resolve()); mock.module("cloudflare:workers", () => ({ env: { DATASOURCES_EVENT_QUEUE: { send: mockQueueSend, }, }, })); // Dynamic import to ensure mock is applied first const { D1EventPlugin } = await import("../kysely-events.js"); interface TestDatabase { test_items: { $id: string; name: string; value: number | null; }; } describe("D1EventPlugin", () => { let dbPath: string; let db: Kysely; beforeEach(async () => { dbPath = join(tmpdir(), `test-kysely-events-${randomUUID()}.db`); db = new Kysely({ dialect: new BunSqliteDialect({ database: new Database(dbPath, { create: true }), }), plugins: [new ParseJSONResultsPlugin(), new D1EventPlugin((): Kysely => db)], log: process.env.FLIPPABLE_ENV !== "production" ? ["query", "error"] : ["error"], }); // Create test table await sql` CREATE TABLE test_items ( "$id" TEXT PRIMARY KEY, name TEXT NOT NULL, value INTEGER ) `.execute(db); // Reset mock before each test mockQueueSend.mockClear(); }); afterEach(async () => { await db.destroy(); if (existsSync(dbPath)) { unlinkSync(dbPath); } }); describe("INSERT operations", () => { it("should send event when inserting a single row", async () => { await db .insertInto("test_items") .values({ $id: "item-1", name: "Test Item", value: 42, }) .execute(); expect(mockQueueSend).toHaveBeenCalledTimes(1); expect(mockQueueSend).toHaveBeenCalledWith({ table: "test_items", rowId: "item-1", operation: "INSERT", row: { $id: "item-1", name: "Test Item", value: 42 }, }); }); it("should send events when inserting multiple rows", async () => { await db .insertInto("test_items") .values([ { $id: "item-1", name: "First", value: 1 }, { $id: "item-2", name: "Second", value: 2 }, { $id: "item-3", name: "Third", value: 3 }, ]) .execute(); expect(mockQueueSend).toHaveBeenCalledTimes(3); expect(mockQueueSend).toHaveBeenNthCalledWith(1, { table: "test_items", rowId: "item-1", operation: "INSERT", row: { $id: "item-1", name: "First", value: 1 }, }); expect(mockQueueSend).toHaveBeenNthCalledWith(2, { table: "test_items", rowId: "item-2", operation: "INSERT", row: { $id: "item-2", name: "Second", value: 2 }, }); expect(mockQueueSend).toHaveBeenNthCalledWith(3, { table: "test_items", rowId: "item-3", operation: "INSERT", row: { $id: "item-3", name: "Third", value: 3 }, }); }); it("should handle INSERT with RETURNING clause", async () => { const result = await db .insertInto("test_items") .values({ $id: "item-1", name: "Test Item", value: 42, }) .returning("$id") .execute(); // Should still send the event using fallback extraction expect(mockQueueSend).toHaveBeenCalledTimes(1); expect(mockQueueSend).toHaveBeenCalledWith({ table: "test_items", rowId: "item-1", operation: "INSERT", row: { $id: "item-1", name: "Test Item", value: 42 }, }); }); }); describe("UPDATE operations", () => { beforeEach(async () => { // Insert test data await db .insertInto("test_items") .values([ { $id: "item-1", name: "First", value: 1 }, { $id: "item-2", name: "Second", value: 2 }, ]) .execute(); mockQueueSend.mockClear(); }); it("should send event when updating a single row", async () => { await db .updateTable("test_items") .set({ name: "Updated", value: 100 }) .where("$id", "=", "item-1") .execute(); expect(mockQueueSend).toHaveBeenCalledTimes(1); expect(mockQueueSend).toHaveBeenCalledWith({ table: "test_items", rowId: "item-1", operation: "UPDATE", row: { $id: "item-1", name: "Updated", value: 100 }, }); }); it("should send events when updating multiple rows with IN clause", async () => { await db .updateTable("test_items") .set({ value: 999 }) .where("$id", "in", ["item-1", "item-2"]) .execute(); expect(mockQueueSend).toHaveBeenCalledTimes(2); // Check both events were sent (order may vary) const calls = mockQueueSend.mock.calls as unknown as Array< [{ rowId: string; operation: string; table: string }] >; const rowIds = calls.map((call) => call[0].rowId); expect(rowIds).toContain("item-1"); expect(rowIds).toContain("item-2"); // Verify operation type for (const call of calls) { expect(call[0].operation).toBe("UPDATE"); expect(call[0].table).toBe("test_items"); } }); }); describe("DELETE operations", () => { beforeEach(async () => { // Insert test data await db .insertInto("test_items") .values([ { $id: "item-1", name: "First", value: 1 }, { $id: "item-2", name: "Second", value: 2 }, { $id: "item-3", name: "Third", value: 3 }, ]) .execute(); mockQueueSend.mockClear(); }); it("should send event when deleting a single row", async () => { await db.deleteFrom("test_items").where("$id", "=", "item-1").execute(); expect(mockQueueSend).toHaveBeenCalledTimes(1); expect(mockQueueSend).toHaveBeenCalledWith({ table: "test_items", rowId: "item-1", operation: "DELETE", row: null, }); }); it("should send events when deleting multiple rows with IN clause", async () => { await db.deleteFrom("test_items").where("$id", "in", ["item-1", "item-3"]).execute(); expect(mockQueueSend).toHaveBeenCalledTimes(2); const calls = mockQueueSend.mock.calls as unknown as Array< [{ rowId: string; operation: string; row: unknown }] >; const rowIds = calls.map((call) => call[0].rowId); expect(rowIds).toContain("item-1"); expect(rowIds).toContain("item-3"); // Verify all are DELETE operations with null rows for (const call of calls) { expect(call[0].operation).toBe("DELETE"); expect(call[0].row).toBeNull(); } }); it("should handle DELETE with RETURNING clause", async () => { const result = await db.deleteFrom("test_items").where("$id", "=", "item-2").returning("$id").execute(); expect(mockQueueSend).toHaveBeenCalledTimes(1); expect(mockQueueSend).toHaveBeenCalledWith({ table: "test_items", rowId: "item-2", operation: "DELETE", row: null, }); }); }); describe("SELECT operations", () => { beforeEach(async () => { await db.insertInto("test_items").values({ $id: "item-1", name: "Test", value: 1 }).execute(); mockQueueSend.mockClear(); }); it("should NOT send events for SELECT queries", async () => { await db.selectFrom("test_items").selectAll().execute(); // Only the INSERT from beforeEach should have triggered send, which we cleared expect(mockQueueSend).not.toHaveBeenCalled(); }); }); describe("error handling", () => { it("should not break query if event sending fails", async () => { // Make send throw an error mockQueueSend.mockImplementationOnce(() => { throw new Error("Queue error"); }); // Query should still succeed const result = await db .insertInto("test_items") .values({ $id: "item-1", name: "Test", value: 1 }) .execute(); // Verify the row was inserted const row = await db .selectFrom("test_items") .selectAll() .where("$id", "=", "item-1") .executeTakeFirst(); expect(row).toBeDefined(); expect(row?.name).toBe("Test"); }); }); describe("complex WHERE clauses", () => { beforeEach(async () => { await db .insertInto("test_items") .values([ { $id: "item-1", name: "First", value: 1 }, { $id: "item-2", name: "Second", value: 2 }, ]) .execute(); mockQueueSend.mockClear(); }); it("should extract ID from AND clause", async () => { await db .updateTable("test_items") .set({ value: 100 }) .where("$id", "=", "item-1") .where("name", "=", "First") .execute(); expect(mockQueueSend).toHaveBeenCalledTimes(1); const calls1 = mockQueueSend.mock.calls as unknown as Array<[{ rowId: string }]>; expect(calls1[0][0].rowId).toBe("item-1"); }); it("should extract IDs from OR clause", async () => { await db .updateTable("test_items") .set({ value: 100 }) .where((eb) => eb.or([eb("$id", "=", "item-1"), eb("$id", "=", "item-2")])) .execute(); expect(mockQueueSend).toHaveBeenCalledTimes(2); const calls = mockQueueSend.mock.calls as unknown as Array<[{ rowId: string }]>; const rowIds = calls.map((call) => call[0].rowId); expect(rowIds).toContain("item-1"); expect(rowIds).toContain("item-2"); }); }); });