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。

2.7 KB
Raw Blame
import { createPinia, setActivePinia } from "pinia";
import { beforeEach, expect, it, vi } from "vitest";
import type { QueryMessage, QueryResult } from "@/types/database";

const mocks = vi.hoisted(() => ({ executeMulti: vi.fn(), subscribe: vi.fn(), cleanup: vi.fn() }));
vi.mock("@/lib/backend/tauriRuntime", () => ({ isTauriRuntime: () => true }));
vi.mock("@/lib/backend/api", () => ({
  executeMulti: mocks.executeMulti,
  subscribeQueryMessages: mocks.subscribe,
  closeClientConnectionSession: vi.fn().mockResolvedValue(undefined),
  closeQuerySession: vi.fn().mockResolvedValue(undefined),
  saveOpenTabsState: vi.fn().mockResolvedValue(undefined),
  prepareQueryPaginationExecutionPlan: vi.fn(async (options) => ({ sqlToExecute: options.sql, useAgentResultSession: false })),
}));
vi.mock("@/stores/connectionStore", () => ({
  useConnectionStore: () => ({
    ensureConnected: vi.fn().mockResolvedValue(undefined),
    getConfig: () => ({ id: "pg", name: "PostgreSQL", db_type: "postgres", database: "app", query_timeout_secs: 30 }),
    lookupLocalCompletionTables: () => [],
    recordConnectionLostError: vi.fn(),
  }),
}));
vi.mock("@/stores/settingsStore", () => ({ useSettingsStore: () => ({ editorSettings: { pageSize: 100, autoCalculateTotalRows: false } }) }));

beforeEach(() => {
  vi.clearAllMocks();
  setActivePinia(createPinia());
  mocks.subscribe.mockResolvedValue(mocks.cleanup);
});

const notice: QueryMessage = { severity: "NOTICE", message: "running output" };

it.each([false, true])("retains streamed output and cleans up listeners (failed=%s)", async (failed) => {
  let resolve!: (results: QueryResult[]) => void;
  let reject!: (error: Error) => void;
  mocks.executeMulti.mockReturnValue(
    new Promise<QueryResult[]>((resolveQuery, rejectQuery) => {
      resolve = resolveQuery;
      reject = rejectQuery;
    }),
  );
  const { useQueryStore } = await import("../queryStore");
  const store = useQueryStore();
  const tabId = store.createTab("pg", "app", "Query");
  const run = store.executeTabSql(tabId, "DO $$ BEGIN RAISE NOTICE 'running output'; END $$");
  await vi.waitFor(() => expect(mocks.executeMulti).toHaveBeenCalled());
  const listener = mocks.subscribe.mock.calls[0][1];
  listener([notice, notice]);
  expect(store.tabs[0].liveQueryMessages).toEqual([notice, notice]);
  if (failed) reject(new Error("Query canceled"));
  else resolve([{ columns: [], rows: [], affected_rows: 0, execution_time_ms: 1, messages: [notice, notice] }]);
  await run;
  expect(store.tabs[0].result?.messages).toEqual([notice, notice]);
  expect(store.tabs[0].liveQueryMessages).toBeUndefined();
  expect(mocks.cleanup).toHaveBeenCalledOnce();
  listener([{ ...notice, message: "late output" }]);
  expect(store.tabs[0].result?.messages).toEqual([notice, notice]);
});