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, MongoCollectionKind, TreeNode } from "@/types/database";
function installLocalStorage() {
const data = new Map<string, string>();
vi.stubGlobal("localStorage", {
getItem: vi.fn((key: string) => data.get(key) ?? null),
setItem: vi.fn((key: string, value: string) => data.set(key, value)),
removeItem: vi.fn((key: string) => data.delete(key)),
});
}
function mongoConnection(): ConnectionConfig {
return {
id: "mongo-1",
name: "MongoDB",
db_type: "mongodb",
host: "127.0.0.1",
port: 27017,
username: "",
password: "",
database: "app",
} as ConnectionConfig;
}
function findNode(nodes: TreeNode[], id: string): TreeNode | undefined {
for (const node of nodes) {
if (node.id === id) return node;
const child = node.children && findNode(node.children, id);
if (child) return child;
}
return undefined;
}
async function setup(kind: MongoCollectionKind) {
const api = {
listIndexes: vi.fn().mockResolvedValue([{ name: "email_1", columns: ["email"], is_primary: false, is_unique: false }]),
};
vi.doMock("@/lib/backend/tauriRuntime", () => ({ isTauriRuntime: () => false }));
vi.doMock("@/lib/backend/api", () => api);
const { useConnectionStore } = await import("@/stores/connectionStore");
const store = useConnectionStore();
const config = mongoConnection();
const collectionId = `${config.id}:app:reports`;
store.connections = [config];
store.connectedIds.add(config.id);
store.treeNodes = [
{
id: config.id,
label: config.name,
type: "connection",
connectionId: config.id,
isExpanded: true,
children: [
{
id: collectionId,
label: "reports",
type: "mongo-collection",
connectionId: config.id,
database: "app",
meta: { collectionKind: kind },
isExpanded: false,
children: [],
},
],
},
];
return { api, config, store, collectionId };
}
describe("connectionStore MongoDB collection groups", () => {
beforeEach(() => {
vi.resetModules();
vi.unstubAllGlobals();
installLocalStorage();
setActivePinia(createPinia());
});
it("does not expose an Indexes group or issue listIndexes for a view", async () => {
const { api, config, store, collectionId } = await setup("view");
await store.loadTableGroups(config.id, "app", "reports", undefined, collectionId);
const collection = findNode(store.treeNodes, collectionId)!;
expect(collection.children?.some((node) => node.type === "group-indexes")).toBe(false);
// A stale tree node from an earlier metadata load must also remain safe.
const indexGroup: TreeNode = {
id: `${collectionId}:__indexes`,
label: "tree.indexes",
type: "group-indexes",
connectionId: config.id,
database: "app",
tableName: "reports",
meta: { collectionKind: "view" },
isExpanded: false,
children: [],
};
collection.children = [indexGroup];
await store.loadIndexes(config.id, "app", "reports", undefined, indexGroup.id);
expect(api.listIndexes).not.toHaveBeenCalled();
expect(findNode(store.treeNodes, indexGroup.id)).toMatchObject({ children: [], isExpanded: true });
});
it("keeps the Indexes group available for ordinary collections", async () => {
const { api, config, store, collectionId } = await setup("collection");
await store.loadTableGroups(config.id, "app", "reports", undefined, collectionId);
const indexGroup = findNode(store.treeNodes, `${collectionId}:__indexes`)!;
expect(indexGroup.type).toBe("group-indexes");
await store.loadIndexes(config.id, "app", "reports", undefined, indexGroup.id);
expect(api.listIndexes).toHaveBeenCalledOnce();
expect(indexGroup.children?.[0]).toMatchObject({ type: "index", label: "email_1 (email)" });
});
});