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 { 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);
});
});