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, ref, type App } from "vue";
import { createPinia, setActivePinia } from "pinia";
import { afterEach, beforeEach, describe, expect, it, vi } from "vitest";
import i18n from "@/i18n";
import type { ContextMenuItem } from "@/components/ui/CustomContextMenu.vue";
import type { TreeNode } from "@/types/database";

vi.mock("@/lib/backend/tauriRuntime", () => ({ isTauriRuntime: () => true }));
vi.mock("@tauri-apps/plugin-dialog", () => ({ open: vi.fn(), save: vi.fn() }));
vi.mock("@/lib/backend/api", async (importOriginal) => ({
  ...(await importOriginal<typeof import("@/lib/backend/api")>()),
  listPlugins: vi.fn().mockResolvedValue([]),
  listDatabases: vi.fn().mockResolvedValue([]),
  buildDuckDbAttachDatabaseSql: vi.fn().mockResolvedValue("ATTACH 'new.duckdb' AS new"),
  buildSqliteAttachDatabaseSql: vi.fn().mockResolvedValue("ATTACH 'new.db' AS new"),
  executeQuery: vi.fn(),
}));
import * as api from "@/lib/backend/api";
import { open, save } from "@tauri-apps/plugin-dialog";
import SidebarTreeRuntimeHost from "@/components/sidebar/SidebarTreeRuntimeHost.vue";
import TreeItem from "@/components/sidebar/TreeItem.vue";
import { useConnectionStore } from "@/stores/connectionStore";
import { createSidebarTreeRuntime, sidebarTreeRuntimeKey } from "@/lib/sidebar/sidebarTreeRuntime";

const apps: App[] = [];
const oldNode: TreeNode = { id: "conn:old", type: "database", label: "old", connectionId: "conn", database: "old" };
const newNode: TreeNode = { ...oldNode, id: "conn:new", label: "new", database: "new" };
const connection: TreeNode = { id: "conn", isExpanded: true, type: "connection", label: "Test", connectionId: "conn", children: [oldNode, newNode] };
const flatten = (items: ContextMenuItem[]): ContextMenuItem[] => items.flatMap((item) => [item, ...flatten(item.children ?? [])]);

async function mount(dbType: "sqlite" | "duckdb", tableRows = false) {
  const pinia = createPinia();
  setActivePinia(pinia);
  const store = useConnectionStore();
  store.connections = [{ id: "conn", name: "Test", db_type: dbType, driver_profile: dbType }];
  store.treeNodes = [{ ...connection, children: [oldNode, newNode].map((node) => (tableRows ? { ...node, type: "table" } : node)) }];
  store.selectedTreeNodeId = oldNode.id;
  store.selectedTreeNodeIds = [oldNode.id, connection.id];
  store.treeSelectionAnchorId = oldNode.id;
  store.connectionMultiSelectActive = true;
  vi.spyOn(store, "ensureConnected").mockResolvedValue(undefined);
  vi.spyOn(store, "updateConnection").mockResolvedValue(undefined);
  vi.spyOn(store, "ensureVisibleDatabase").mockResolvedValue(undefined);
  vi.spyOn(store, "loadDatabases").mockResolvedValue(undefined);
  const host = ref<InstanceType<typeof SidebarTreeRuntimeHost>>();
  const app = createApp(defineComponent({ setup: () => () => h("div", [h(SidebarTreeRuntimeHost, { ref: host, node: connection, depth: 0 }), ...[oldNode, newNode].map((node) => h(TreeItem, { node: tableRows ? { ...node, type: "table" } : node, depth: 1 }))]) }));
  app.use(pinia).use(i18n);
  app.provide(sidebarTreeRuntimeKey, createSidebarTreeRuntime());
  const container = document.createElement("div");
  document.body.append(container);
  app.mount(container);
  apps.push(app);
  await nextTick();
  const menu = host.value!.buildContextMenu(connection);
  const label = i18n.global.t(dbType === "duckdb" ? "contextMenu.createDuckDbFile" : "contextMenu.attachSqliteDatabase");
  const action = flatten(menu).find((item) => item.label === label)?.action;
  expect(action).toBeTypeOf("function");
  return { store, action: action!, row: (id: string) => container.querySelector<HTMLElement>(`[data-node-id="${id}"]`)! };
}

beforeEach(() => {
  vi.mocked(open).mockResolvedValue("/tmp/new.db");
  vi.mocked(save).mockResolvedValue("/tmp/new.duckdb");
  vi.mocked(api.executeQuery).mockResolvedValue({ columns: [], rows: [] } as any);
});
afterEach(() => {
  apps.splice(0).forEach((app) => app.unmount());
  document.body.innerHTML = "";
  vi.restoreAllMocks();
  vi.clearAllMocks();
});

describe.each(["sqlite", "duckdb"] as const)("%s attached database selection", (dbType) => {
  it("selects only the attached database and resets the range anchor and multi-select mode", async () => {
    const { store, action, row } = await mount(dbType);
    action();
    await vi.waitFor(() => expect(store.loadDatabases).toHaveBeenCalled());
    await nextTick();
    expect(store.selectedTreeNodeId).toBe(newNode.id);
    expect(store.selectedTreeNodeIds).toEqual([newNode.id]);
    expect(store.treeSelectionAnchorId).toBe(newNode.id);
    expect(store.connectionMultiSelectActive).toBe(false);
    expect(row(newNode.id).classList.contains("tree-item-active")).toBe(true);
    expect(row(oldNode.id).classList.contains("tree-item-active")).toBe(false);
  });

  it.each(["cancel", "failure"])("keeps the original selection on %s", async (outcome) => {
    const { store, action } = await mount(dbType);
    if (outcome === "cancel") {
      vi.mocked(open).mockResolvedValue(null);
      vi.mocked(save).mockResolvedValue(null);
    } else {
      vi.mocked(api.executeQuery).mockRejectedValueOnce(new Error("attach failed"));
    }
    action();
    await vi.waitFor(() => expect(dbType === "duckdb" ? save : open).toHaveBeenCalled());
    await new Promise((resolve) => setTimeout(resolve, 0));
    if (outcome === "failure") expect(api.executeQuery).toHaveBeenCalledOnce();
    else expect(api.executeQuery).not.toHaveBeenCalled();
    expect(store.loadDatabases).not.toHaveBeenCalled();
    expect(store.selectedTreeNodeId).toBe(oldNode.id);
    expect(store.selectedTreeNodeIds).toEqual([oldNode.id, connection.id]);
    expect(store.treeSelectionAnchorId).toBe(oldNode.id);
    expect(store.connectionMultiSelectActive).toBe(true);
  });
});

it.each(["ctrlKey", "metaKey"])("does not highlight a lead row toggled out with %s", async (modifier) => {
  const { store, row } = await mount("sqlite", true);
  store.selectedTreeNodeIds = [oldNode.id, newNode.id];
  store.selectedTreeNodeId = newNode.id;
  store.connectionMultiSelectActive = false;
  await nextTick();
  row(newNode.id).dispatchEvent(new MouseEvent("click", { bubbles: true, [modifier]: true }));
  await nextTick();
  expect(store.selectedTreeNodeId).toBe(newNode.id);
  expect(store.selectedTreeNodeIds).toEqual([oldNode.id]);
  expect(row(newNode.id).classList.contains("tree-item-active")).toBe(false);
  expect(row(oldNode.id).classList.contains("tree-item-active")).toBe(true);
});