Skip to content

armgit / dbx

Public Imported from GitHub
0

25 MB lightweight cross-platform database client for 100+ databases, including MySQL, PostgreSQL, SQLite, Redis, MongoDB, DuckDB, SQL Server, and Dameng. Built-in AI, MCP Server, CLI, desktop and Docker. | 轻量级跨平台数据库管理工具,支持 MySQL、PostgreSQL、SQLite、Redis、MongoDB、达梦等 100+ 数据库,提供桌面端、Docker、CLI、内置 AI 助手和 MCP。

3.4 KB
Raw Blame
import { afterEach, describe, expect, it, vi } from "vitest";
import type { TransferProgress, TransferRequest } from "@/lib/backend/http";
import { startTransfer } from "@/lib/backend/http";

function request(): TransferRequest {
  return {
    transferId: "transfer-1",
    sourceConnectionId: "source",
    sourceDatabase: "app",
    sourceSchema: "public",
    targetConnectionId: "target",
    targetDatabase: "warehouse",
    targetSchema: "reporting",
    tables: ["orders", "users"],
    createTable: true,
    content: "structureAndData",
    objects: [],
    mode: "append",
    targetTableNameCase: "preserve",
    quoteTargetColumnNames: true,
    ownershipPolicy: "preserve",
    batchSize: 1000,
    dropTargetBeforeCreate: false,
    dropTargetConfirmed: false,
  };
}

function doneProgress(): TransferProgress {
  return {
    transferId: "transfer-1",
    table: "users",
    tableIndex: 2,
    totalTables: 2,
    rowsTransferred: 3,
    totalRows: 3,
    status: "done",
    error: null,
    terminal: true,
  };
}

describe("web data-transfer submission", () => {
  afterEach(() => vi.unstubAllGlobals());

  it("acknowledges an accepted task once before tracking its progress", async () => {
    const fetchMock = vi.fn().mockResolvedValue({ ok: true });
    vi.stubGlobal("fetch", fetchMock);
    let source: FakeEventSource | undefined;
    class FakeEventSource {
      onmessage: ((event: { data: string }) => void) | null = null;
      onerror: (() => void) | null = null;
      close = vi.fn();

      constructor(readonly url: string) {
        source = this;
      }
    }
    vi.stubGlobal("EventSource", FakeEventSource);
    const onStarted = vi.fn();
    const onProgress = vi.fn();

    const pending = startTransfer(request(), onProgress, onStarted);
    await vi.waitFor(() => expect(onStarted).toHaveBeenCalledTimes(1));

    expect(JSON.parse(String(fetchMock.mock.calls[0]?.[1]?.body))).toEqual({ request: request() });
    expect(source?.url).toBe("/api/transfer/progress/transfer-1");
    source?.onmessage?.({ data: JSON.stringify(doneProgress()) });
    await expect(pending).resolves.toBeUndefined();
    expect(onStarted).toHaveBeenCalledTimes(1);
    expect(onProgress).toHaveBeenCalledWith(doneProgress());
  });

  it("sends a transfer timeout outside the core request payload", async () => {
    const fetchMock = vi.fn().mockResolvedValue({ ok: true });
    vi.stubGlobal("fetch", fetchMock);
    class FakeEventSource {
      onmessage: ((event: { data: string }) => void) | null = null;
      onerror: (() => void) | null = null;
      close = vi.fn();
    }
    vi.stubGlobal("EventSource", FakeEventSource);
    const transferRequest = { ...request(), operationTimeoutSecs: 600 };

    void startTransfer(transferRequest, vi.fn());
    await vi.waitFor(() => expect(fetchMock).toHaveBeenCalledTimes(1));

    const body = JSON.parse(String(fetchMock.mock.calls[0]?.[1]?.body));
    expect(body.operationTimeoutSecs).toBe(600);
    expect(body.request.operationTimeoutSecs).toBeUndefined();
  });

  it("suppresses acknowledgement when task creation fails", async () => {
    vi.stubGlobal(
      "fetch",
      vi.fn().mockResolvedValue({
        ok: false,
        text: vi.fn().mockResolvedValue('{"message":"rejected"}'),
      }),
    );
    const onStarted = vi.fn();

    await expect(startTransfer(request(), vi.fn(), onStarted)).rejects.toThrow();
    expect(onStarted).not.toHaveBeenCalled();
  });
});