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。
TypeScript aicliclickhousedatabasedatabase-clientdatabase-managementdockerguimcpmongodbmysqlpostgresqlredisrustsql-serversqlitetaurivue
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();
});
});