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.5 KB
Raw Blame
import { createPinia, setActivePinia } from "pinia";
import { beforeEach, describe, expect, it, vi } from "vitest";

const mocks = vi.hoisted(() => ({
  analyzeEditableQueryEditability: vi.fn(),
  beginManualTransaction: vi.fn(),
  closeClientConnectionSession: vi.fn(),
  closeQuerySession: vi.fn(),
  executeInManualTransaction: vi.fn(),
  executeMulti: vi.fn(),
  getConnectionConfig: vi.fn(),
  prepareQueryPaginationExecutionPlan: vi.fn(),
  saveOpenTabsState: vi.fn(),
}));

vi.mock("@/lib/backend/api", () => ({
  analyzeEditableQueryEditability: mocks.analyzeEditableQueryEditability,
  beginManualTransaction: mocks.beginManualTransaction,
  closeClientConnectionSession: mocks.closeClientConnectionSession,
  closeQuerySession: mocks.closeQuerySession,
  executeInManualTransaction: mocks.executeInManualTransaction,
  executeMulti: mocks.executeMulti,
  prepareQueryPaginationExecutionPlan: mocks.prepareQueryPaginationExecutionPlan,
  saveOpenTabsState: mocks.saveOpenTabsState,
}));

vi.mock("@/stores/connectionStore", () => ({
  useConnectionStore: () => ({
    ensureConnected: vi.fn().mockResolvedValue(undefined),
    getConfig: mocks.getConnectionConfig,
    recordConnectionLostError: vi.fn(),
  }),
}));

// The in-memory editor settings are mutated per test so a fresh tab reflects the
// configured default transaction mode. Missing key falls back to auto-commit.
const editorSettings: Record<string, unknown> = {
  autoCalculateTotalRows: false,
  continueOnErrorOnBatch: false,
  pageSize: 100,
  queryResultMaxRowsEnabled: false,
  queryResultMaxRows: 1000,
  openTabsRestoreMode: "all",
  confirmUnsavedSqlClose: false,
};

vi.mock("@/stores/settingsStore", () => ({
  useSettingsStore: () => ({ editorSettings }),
}));

describe("queryStore default transaction mode", () => {
  beforeEach(() => {
    vi.clearAllMocks();
    setActivePinia(createPinia());
    mocks.getConnectionConfig.mockReturnValue({
      id: "oracle-1",
      name: "Oracle",
      db_type: "oracle",
      database: "ORCL",
      query_timeout_secs: 30,
    });
    mocks.prepareQueryPaginationExecutionPlan.mockImplementation(async (options) => ({
      sqlToExecute: options.sql,
      pageSql: undefined,
      pageLimit: undefined,
      pageOffset: undefined,
      countSql: undefined,
      useAgentResultSession: false,
    }));
    mocks.analyzeEditableQueryEditability.mockResolvedValue({ editable: false, reason: "not-select" });
    mocks.saveOpenTabsState.mockResolvedValue(undefined);
    delete editorSettings.defaultTransactionMode;
  });

  it("creates a query tab in manual transaction mode when configured", async () => {
    editorSettings.defaultTransactionMode = "manual";

    const { useQueryStore } = await import("@/stores/queryStore");
    const store = useQueryStore();
    const tabId = store.createTab("oracle-1", "ORCL", "Query", "query", "APP");

    const tab = store.tabs.find((item) => item.id === tabId)!;
    expect(tab.autoCommit).toBe(false);
  });

  it("creates a Dameng query tab in manual transaction mode when configured", async () => {
    editorSettings.defaultTransactionMode = "manual";
    mocks.getConnectionConfig.mockReturnValue({
      id: "dameng-1",
      name: "Dameng",
      db_type: "dameng",
      database: "DM",
    });

    const { useQueryStore } = await import("@/stores/queryStore");
    const store = useQueryStore();
    const tabId = store.createTab("dameng-1", "DM", "Query", "query", "PUBLIC");

    expect(store.tabs.find((item) => item.id === tabId)!.autoCommit).toBe(false);
  });

  it("creates a GaussDB query tab in manual transaction mode when configured", async () => {
    editorSettings.defaultTransactionMode = "manual";
    mocks.getConnectionConfig.mockReturnValue({
      id: "gaussdb-1",
      name: "GaussDB",
      db_type: "gaussdb",
      database: "postgres",
    });

    const { useQueryStore } = await import("@/stores/queryStore");
    const store = useQueryStore();
    const tabId = store.createTab("gaussdb-1", "postgres", "Query", "query", "public");

    expect(store.tabs.find((item) => item.id === tabId)!.autoCommit).toBe(false);
  });

  it("creates a query tab in auto-commit mode by default", async () => {
    const { useQueryStore } = await import("@/stores/queryStore");
    const store = useQueryStore();
    const tabId = store.createTab("oracle-1", "ORCL", "Query", "query", "APP");

    const tab = store.tabs.find((item) => item.id === tabId)!;
    expect(tab.autoCommit).toBe(true);
  });

  it("creates a query tab in auto-commit mode when explicitly set to auto", async () => {
    editorSettings.defaultTransactionMode = "auto";

    const { useQueryStore } = await import("@/stores/queryStore");
    const store = useQueryStore();
    const tabId = store.createTab("oracle-1", "ORCL", "Query", "query", "APP");

    const tab = store.tabs.find((item) => item.id === tabId)!;
    expect(tab.autoCommit).toBe(true);
  });

  it("applies the manual default when an unbound file tab binds to a transactional connection", async () => {
    editorSettings.defaultTransactionMode = "manual";
    mocks.getConnectionConfig.mockImplementation((connectionId: string) => (connectionId === "mysql-1" ? { id: "mysql-1", name: "MySQL", db_type: "mysql", database: "app" } : undefined));

    const { useQueryStore } = await import("@/stores/queryStore");
    const store = useQueryStore();
    // Externally opened SQL files and saved-SQL tabs start unbound
    // (connectionId ""), so their initial mode falls back to auto-commit.
    const tabId = store.createTab("", "", "Query", "query");
    expect(store.tabs.find((item) => item.id === tabId)!.autoCommit).toBe(true);

    store.updateConnection(tabId, "mysql-1", "app");

    expect(store.tabs.find((item) => item.id === tabId)!.autoCommit).toBe(false);
  });

  it("keeps the manual default when switching between transactional connections", async () => {
    editorSettings.defaultTransactionMode = "manual";
    mocks.getConnectionConfig.mockImplementation((connectionId: string) => (connectionId === "mysql-1" ? { id: "mysql-1", name: "MySQL", db_type: "mysql", database: "app" } : { id: "oracle-1", name: "Oracle", db_type: "oracle", database: "ORCL" }));

    const { useQueryStore } = await import("@/stores/queryStore");
    const store = useQueryStore();
    const tabId = store.createTab("oracle-1", "ORCL", "Query", "query", "APP");
    expect(store.tabs.find((item) => item.id === tabId)!.autoCommit).toBe(false);

    store.updateConnection(tabId, "mysql-1", "app");

    expect(store.tabs.find((item) => item.id === tabId)!.autoCommit).toBe(false);
  });
});