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";
import type { ConnectionConfig } from "@/types/database";
const api = vi.hoisted(() => ({
connectDb: vi.fn(),
connectionDatabaseInfo: vi.fn(),
saveConnectionDatabaseInfo: vi.fn(),
saveConnections: vi.fn(),
saveSidebarLayout: vi.fn(),
connectionIdentifierQuote: vi.fn(),
}));
vi.mock("@/lib/backend/tauriRuntime", () => ({ isTauriRuntime: () => false }));
vi.mock("@/lib/backend/api", () => api);
// Cold module transformation is setup work, not part of the behavioral timeout.
import { useConnectionStore } from "@/stores/connectionStore";
function kingbaseConnection(): ConnectionConfig {
return {
id: "kingbase-info",
name: "Synthetic Kingbase",
db_type: "kingbase",
host: "example.test",
port: 54321,
username: "synthetic",
password: "synthetic-fixture",
database: "app",
};
}
describe("connectionStore Kingbase mode lifecycle", () => {
beforeEach(() => {
vi.resetAllMocks();
const data = new Map<string, string>();
vi.stubGlobal("localStorage", {
getItem: (key: string) => data.get(key) ?? null,
setItem: (key: string, value: string) => data.set(key, value),
removeItem: (key: string) => data.delete(key),
});
setActivePinia(createPinia());
api.connectDb.mockResolvedValue("kingbase-info");
api.saveConnectionDatabaseInfo.mockResolvedValue(undefined);
api.saveConnections.mockResolvedValue(undefined);
api.saveSidebarLayout.mockResolvedValue(undefined);
api.connectionIdentifierQuote.mockResolvedValue('"');
});
it.each(["connect", "ensureConnected"] as const)("refreshes mode before %s is ready and discards stale metadata on failure", async (method) => {
const config = { ...kingbaseConnection(), database_info: { compatibilityMode: "mysql" } };
let reject!: (error: Error) => void;
api.connectionDatabaseInfo.mockReturnValue(
new Promise((_, rejectPromise) => {
reject = rejectPromise;
}),
);
const store = useConnectionStore();
await store.addConnection(config);
const connecting = method === "connect" ? store.connect(config) : store.ensureConnected(config.id);
try {
await vi.waitFor(() => expect(api.connectionDatabaseInfo).toHaveBeenCalled());
expect(store.connectedIds.has(config.id)).toBe(false);
expect(store.getConfig(config.id)?.database_info?.compatibilityMode).toBeUndefined();
} finally {
reject(new Error("mode metadata unavailable"));
await connecting;
}
expect(store.connectedIds.has(config.id)).toBe(true);
expect(store.getConfig(config.id)?.database_info?.compatibilityMode).toBeUndefined();
});
it("refreshes and persists the reported mode", async () => {
const mode = "oracle";
const config = kingbaseConnection();
api.connectionDatabaseInfo.mockResolvedValue({ productName: "KingbaseES", compatibilityMode: mode });
const store = useConnectionStore();
await store.addConnection(config);
await store.connect(config);
expect(store.getConfig(config.id)?.database_info?.compatibilityMode).toBe(mode);
expect(api.saveConnectionDatabaseInfo).toHaveBeenCalledWith(config.id, expect.objectContaining({ compatibilityMode: mode }));
});
});