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
// @vitest-environment happy-dom
import { createApp, h, nextTick, ref, type App } from "vue";
import { createPinia, disposePinia, type Pinia } from "pinia";
import { createI18n } from "vue-i18n";
import { afterEach, beforeEach, describe, expect, it, vi } from "vitest";
import ObjectDependenciesPanel from "../ObjectDependenciesPanel.vue";
import { useConnectionStore } from "@/stores/connectionStore";
import type { ObjectDetailsSection, ObjectDependencyTarget } from "@/lib/database/objectDependencyDetails";
const backend = vi.hoisted(() => ({ executeQuery: vi.fn(), cancelQuery: vi.fn(async () => true), checkConnectionHealth: vi.fn(async () => undefined) }));
vi.mock("@/lib/backend/api", async (original) => ({ ...(await original<typeof import("@/lib/backend/api")>()), ...backend }));
const target = { connectionId: "source-connection", database: "ORCL", schema: "Original.Owner", name: "P", objectType: "PROCEDURE" as const };
const mounted: Array<{ app: App; host: HTMLElement; pinia: Pinia }> = [];
function mountPanel(initial: ObjectDetailsSection = "source", identity: ObjectDependencyTarget = target, includeSource?: boolean, withOpen = true) {
const pinia = createPinia();
const connections = useConnectionStore(pinia);
connections.connectedIds.add(target.connectionId);
const section = ref(initial),
open = ref(true);
const onOpenObject = vi.fn(),
onViewSql = vi.fn();
const app = createApp({
render: () =>
h(
ObjectDependenciesPanel,
{
target: identity,
includeSource,
section: section.value,
...(withOpen ? { open: open.value } : {}),
"onUpdate:section": (value: ObjectDetailsSection) => {
section.value = value;
},
onOpenObject,
onViewSql,
},
{ default: () => h("textarea", { "data-source-draft": "", defaultValue: "draft" }) },
),
});
app.use(pinia);
app.use(createI18n({ legacy: false, locale: "en", messages: { en: {} }, missingWarn: false, fallbackWarn: false }));
const host = document.createElement("div");
document.body.append(host);
app.mount(host);
mounted.push({ app, host, pinia });
return { host, section, open, onOpenObject, onViewSql };
}
function button(host: HTMLElement, text: string) {
return [...host.querySelectorAll("button")].find((node) => node.textContent?.trim() === text)!;
}
beforeEach(() => {
vi.clearAllMocks();
backend.executeQuery.mockResolvedValue({
columns: ["DIRECTION", "OBJECT_OWNER", "OBJECT_NAME", "OBJECT_TYPE", "REFERENCED_OWNER", "REFERENCED_NAME", "REFERENCED_TYPE", "DEPENDENCY_TYPE", "REFERENCED_LINK_NAME"],
rows: [
["DEPENDS_ON", "Original.Owner", "P", "PROCEDURE", "Other.Owner", "Mixed.Table", "TABLE", "HARD", null],
["REFERENCED_BY", "Caller", "Call.P", "FUNCTION", "Original.Owner", "P", "PROCEDURE", "HARD", null],
["DEPENDS_ON", "Original.Owner", "P", "PROCEDURE", "Remote", "T", "TABLE", "HARD", "REMOTE_DB"],
["DEPENDS_ON", "Original.Owner", "P", "PROCEDURE", "Other.Owner", "Kind", "TYPE", "HARD", null],
],
affected_rows: 0,
execution_time_ms: 1,
});
});
afterEach(() => {
for (const item of mounted.splice(0)) {
item.app.unmount();
item.host.remove();
disposePinia(item.pinia);
}
});
describe("object details shared sections", () => {
it("opens dependency sections when optional open is omitted, while an explicit close still suppresses reads", async () => {
const omitted = mountPanel("dependencies", target, undefined, false);
await vi.waitFor(() => expect(omitted.host.textContent).toContain("Mixed.Table"));
expect(omitted.host.querySelector('[data-object-section="dependencies"]')).not.toBeNull();
const closed = mountPanel();
closed.open.value = false;
closed.section.value = "dependencies";
await nextTick();
expect(closed.host.querySelector("[data-object-details]")).toBeNull();
expect(backend.executeQuery).toHaveBeenCalledOnce();
});
it("shows foreign keys and owning objects separately in table properties without mounting a source editor", async () => {
const identity: ObjectDependencyTarget = { ...target, name: "Child.Table", objectType: "TABLE" };
const { host, onOpenObject } = mountPanel("dependencies", identity, false);
await vi.waitFor(() => expect(backend.executeQuery).toHaveBeenCalledTimes(1));
expect(host.querySelector("textarea")).toBeNull();
expect(button(host, "objects.source")).toBeUndefined();
backend.executeQuery.mockResolvedValueOnce({
columns: ["DIRECTION", "CONSTRAINT_OWNER", "CONSTRAINT_NAME", "CHILD_OWNER", "CHILD_NAME", "CHILD_COLUMN", "POSITION", "PARENT_OWNER", "PARENT_NAME", "PARENT_COLUMN", "COLUMN_COUNT"],
rows: [["REFERENCES", identity.schema, "FK", identity.schema, identity.name, "Child Column", 1, "Other.Owner", "Parent.Table", "Parent Column", 1]],
affected_rows: 0,
execution_time_ms: 1,
});
button(host, "objectRelations.foreignKeys").click();
await vi.waitFor(() => expect(host.textContent).toContain("Child Column"));
expect(backend.executeQuery.mock.calls[1]![2]).toContain("ALL_CONSTRAINTS");
button(host, "Other.Owner.Parent.Table").click();
expect(onOpenObject).toHaveBeenLastCalledWith(identity, { name: "Parent.Table", schema: "Other.Owner", type: "table", nameQuoted: true, schemaQuoted: true });
backend.executeQuery.mockResolvedValueOnce({ columns: ["CHILD_OWNER", "CHILD_NAME", "CHILD_TYPE", "PARENT_OWNER", "PARENT_NAME", "PARENT_TYPE"], rows: [["Index.Owner", "Index.Name", "INDEX", identity.schema, identity.name, "TABLE"]], affected_rows: 0, execution_time_ms: 1 });
button(host, "objectRelations.ownership").click();
await vi.waitFor(() => expect(host.textContent).toContain("Index.Owner.Index.Name"));
button(host, "Index.Owner.Index.Name").click();
expect(onOpenObject).toHaveBeenLastCalledWith(identity, { name: "Index.Name", schema: "Index.Owner", type: "index", parentName: identity.name, parentSchema: identity.schema, nameQuoted: true, schemaQuoted: true, parentNameQuoted: true, parentSchemaQuoted: true });
button(host, "objectDependencies.dependencies").click();
await nextTick();
expect(backend.executeQuery).toHaveBeenCalledTimes(3);
expect(host.querySelector("textarea")).toBeNull();
});
it("preserves the source element, draft and selection while switching and refreshing dependencies", async () => {
const { host, section } = mountPanel();
expect(backend.executeQuery).not.toHaveBeenCalled();
const editor = host.querySelector<HTMLTextAreaElement>("textarea")!;
editor.value = "changed source draft";
editor.setSelectionRange(2, 8);
button(host, "objectDependencies.dependencies").click();
await vi.waitFor(() => expect(host.textContent).toContain("Mixed.Table"));
expect(section.value).toBe("dependencies");
button(host, "common.refresh").click();
await vi.waitFor(() => expect(backend.executeQuery).toHaveBeenCalledTimes(2));
button(host, "objects.source").click();
await nextTick();
expect(host.querySelector("textarea")).toBe(editor);
expect(editor.value).toBe("changed source draft");
expect([editor.selectionStart, editor.selectionEnd]).toEqual([2, 8]);
});
it("renders directions separately and forwards a captured origin with exact object identity", async () => {
const { host, section, onOpenObject, onViewSql } = mountPanel("dependencies");
await vi.waitFor(() => expect(host.textContent).toContain("Mixed.Table"));
button(host, "Mixed.Table").click();
expect(onOpenObject).toHaveBeenCalledWith(target, { name: "Mixed.Table", schema: "Other.Owner", type: "table", nameQuoted: true, schemaQuoted: true });
expect([...host.querySelectorAll("button")].some((node) => node.textContent?.trim() === "Kind")).toBe(false);
expect(host.textContent).toContain("objectDependencies.remoteObject");
expect(host.textContent).toContain("objectDependencies.unsupportedObject");
button(host, "objectDependencies.viewSql").click();
expect(onViewSql).toHaveBeenCalledWith(target, expect.stringContaining("ALL_DEPENDENCIES"));
expect(backend.executeQuery).toHaveBeenCalledTimes(1);
const tab = host.querySelector<HTMLButtonElement>('[data-object-section="dependencies"]')!;
tab.dispatchEvent(new KeyboardEvent("keydown", { key: "ArrowRight", bubbles: true }));
await nextTick();
expect(section.value).toBe("dependents");
expect(document.activeElement?.getAttribute("data-object-section")).toBe("dependents");
const visiblePanel = host.querySelector<HTMLElement>('[role="tabpanel"][aria-labelledby$="dependents-tab"]')!;
expect(visiblePanel.textContent).toContain("Call.P");
expect(visiblePanel.textContent).not.toContain("Mixed.Table");
expect(host.querySelector("textarea")).toBeNull();
});
});