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。

6.4 KB
Raw Blame
// @vitest-environment happy-dom
import { createApp, defineComponent, h, nextTick, reactive } from "vue";
import { createPinia, setActivePinia } from "pinia";
import { createI18n } from "vue-i18n";
import { afterEach, describe, expect, it, vi } from "vitest";
import type { QueryResult, QueryTab } from "@/types/database";

vi.mock("@/components/editor/QueryEditor.vue", () => ({ default: { render: () => null } }));
vi.mock("@/components/transfer/QueryResultTransferDialog.vue", () => ({ __esModule: true, default: { render: () => null } }));
vi.mock("@/components/grid/DataGrid.vue", () => ({ default: { render: () => h("div", { "data-test": "data-grid" }) } }));

import ContentArea from "../ContentArea.vue";
import { useConnectionStore } from "@/stores/connectionStore";
import { useQueryStore } from "@/stores/queryStore";

const cleanups: Array<() => void> = [];
afterEach(() => {
  cleanups.splice(0).forEach((cleanup) => cleanup());
  document.body.replaceChildren();
  window.localStorage?.clear();
});

async function mountContentAreaWithRuns(options: { results: QueryResult[]; resultRuns?: NonNullable<QueryTab["resultRuns"]>; activeResultRunId?: string }) {
  const pinia = createPinia();
  setActivePinia(pinia);
  const connection = { id: "mysql-1", name: "MySQL", db_type: "mysql" as const, host: "localhost", port: 3306, username: "root", password: "" };
  useConnectionStore().connections = [connection];
  const tab = reactive<QueryTab>({
    id: "query-tab-1",
    title: "Query 1",
    connectionId: connection.id,
    database: "app",
    mode: "query",
    sql: "SELECT 1",
    isExecuting: false,
    results: options.results,
    result: options.results[0],
    activeResultIndex: 0,
    resultRuns: options.resultRuns,
    activeResultRunId: options.activeResultRunId,
  });
  useQueryStore().tabs.push(tab);

  const state = reactive({ view: "result" as "result" | "messages" });
  const host = document.createElement("div");
  document.body.appendChild(host);
  const app = createApp(
    defineComponent({
      setup: () => () =>
        h(ContentArea, {
          activeTab: tab,
          activeConnection: connection,
          activeOutputView: state.view,
          executableSql: "",
          formatSqlRequest: null,
          compressSqlRequest: null,
          selectedSql: "",
          cursorPos: 0,
          resultOnly: true,
          blockDangerousRedisCommands: false,
          "onUpdate:activeOutputView": (_tabId: string, view: string) => {
            state.view = view as typeof state.view;
          },
        }),
    }),
  );
  app.use(pinia);
  app.use(
    createI18n({
      legacy: false,
      locale: "en",
      messages: {
        en: {
          tabs: {
            resultN: "Result {n}",
            runN: "Run {n}",
            resultRuns: "Result runs",
            resultSets: "Result sets",
            allResults: "All results ({count})",
            removeRun: "Remove run {n}",
          },
        },
      },
      missingWarn: false,
      fallbackWarn: false,
    }),
  );
  app.mount(host);
  cleanups.push(() => app.unmount());
  await nextTick();
  await nextTick();
  return { host, state, tab };
}

describe("ContentArea result run tabs layout and middle-click close", () => {
  const singleResult: QueryResult = {
    columns: ["id"],
    rows: [[1]],
    affected_rows: 1,
    execution_time_ms: 5,
  };
  const secondResult: QueryResult = {
    columns: ["name"],
    rows: [["Alice"]],
    affected_rows: 1,
    execution_time_ms: 3,
  };

  it("hides ResultSetNavigator when resultRuns exist and active run has a single result set", async () => {
    const { host } = await mountContentAreaWithRuns({
      results: [singleResult],
      resultRuns: [
        { id: "run-1", title: "Run 1", sequence: 1, sql: "SELECT 1", createdAt: 1, result: singleResult, results: [singleResult] },
        { id: "run-2", title: "Run 2", sequence: 2, sql: "SELECT 2", createdAt: 2, result: singleResult, results: [singleResult] },
      ],
      activeResultRunId: "run-1",
    });

    const runTabsRegion = host.querySelector("[data-result-run-tabs-region]");
    expect(runTabsRegion).not.toBeNull();
    const runTabs = host.querySelectorAll("[data-result-run-tab]");
    expect(runTabs.length).toBe(2);

    // ResultSetNavigator is hidden because visibleResultItems.length <= 1
    const resultSetRegion = host.querySelector("[data-result-set-tabs-region]");
    expect(resultSetRegion).toBeNull();
  });

  it("shows ResultSetNavigator when resultRuns exist and active run has multiple result sets", async () => {
    const { host } = await mountContentAreaWithRuns({
      results: [singleResult, secondResult],
      resultRuns: [
        { id: "run-1", title: "Run 1", sequence: 1, sql: "SELECT 1; SELECT 2;", createdAt: 1, result: singleResult, results: [singleResult, secondResult] },
        { id: "run-2", title: "Run 2", sequence: 2, sql: "SELECT 3", createdAt: 2, result: singleResult, results: [singleResult] },
      ],
      activeResultRunId: "run-1",
    });

    const runTabsRegion = host.querySelector("[data-result-run-tabs-region]");
    expect(runTabsRegion).not.toBeNull();

    // ResultSetNavigator is shown because visibleResultItems.length > 1
    const resultSetRegion = host.querySelector("[data-result-set-tabs-region]");
    expect(resultSetRegion).not.toBeNull();
    expect(resultSetRegion?.classList.contains("shrink-0")).toBe(true);
    expect(resultSetRegion?.classList.contains("max-w-[50%]")).toBe(true);
  });

  it("closes result run on middle click on the result run tab", async () => {
    const { host } = await mountContentAreaWithRuns({
      results: [singleResult],
      resultRuns: [
        { id: "run-1", title: "Run 1", sequence: 1, sql: "SELECT 1", createdAt: 1, result: singleResult, results: [singleResult] },
        { id: "run-2", title: "Run 2", sequence: 2, sql: "SELECT 2", createdAt: 2, result: singleResult, results: [singleResult] },
      ],
      activeResultRunId: "run-1",
    });

    const queryStore = useQueryStore();
    const removeSpy = vi.spyOn(queryStore, "removeResultRun").mockResolvedValue(true);

    const runTabs = host.querySelectorAll<HTMLButtonElement>("[data-result-run-tab]");
    expect(runTabs.length).toBe(2);

    // Middle click on run-2 (button: 1)
    const middleClickEvent = new MouseEvent("mousedown", { button: 1, bubbles: true, cancelable: true });
    runTabs[1]!.dispatchEvent(middleClickEvent);
    await nextTick();

    expect(removeSpy).toHaveBeenCalledWith("query-tab-1", "run-2");
  });
});