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, nextTick, type App } from "vue";
import { afterEach, describe, expect, it, vi } from "vitest";
vi.mock("vue-i18n", () => ({
useI18n: () => ({
t: (key: string, params?: Record<string, unknown>) => (params ? `${key}:${JSON.stringify(params)}` : key),
}),
}));
import TablePartitionsPanel from "@/components/structure/TablePartitionsPanel.vue";
import type { PgTablePartitioning } from "@/types/database";
const mountedApps: App[] = [];
async function mount(props: Record<string, unknown>) {
const root = document.createElement("div");
document.body.append(root);
const app = createApp(TablePartitionsPanel, props);
mountedApps.push(app);
app.mount(root);
for (let i = 0; i < 10; i += 1) {
await nextTick();
await Promise.resolve();
}
return root;
}
const partitioned: PgTablePartitioning = {
isPartitioned: true,
isPartition: false,
strategy: "range",
keyDefinition: "RANGE (sold_on)",
keyColumns: ["sold_on"],
defaultPartition: "sales_default",
partitions: [
{
schema: "public",
name: "sales_2024",
isLeaf: true,
bound: { kind: "range", from: ["'2024-01-01'"], to: ["'2025-01-01'"] },
rowEstimate: 366,
totalBytes: 1048576,
children: [],
},
{
schema: "public",
name: "sales_nested",
strategy: "list",
isLeaf: false,
bound: { kind: "range", from: ["'2025-01-01'"], to: ["'2026-01-01'"] },
children: [{ schema: "public", name: "sales_nested_cn", isLeaf: true, bound: { kind: "list", values: ["'cn'"] }, children: [] }],
},
],
};
afterEach(() => {
for (const app of mountedApps.splice(0)) app.unmount();
document.body.innerHTML = "";
});
describe("TablePartitionsPanel", () => {
it("renders the strategy, key, default partition and flattened rows", async () => {
const root = await mount({ partitioning: partitioned, loading: false, error: "" });
const text = root.textContent ?? "";
expect(text).toContain("structureEditor.partitionKindRange");
expect(text).toContain("RANGE (sold_on)");
expect(text).toContain("structureEditor.partitionsDefault");
expect(text).toContain("sales_default");
expect(text).toContain("sales_2024");
expect(text).toContain("FROM ('2024-01-01') TO ('2025-01-01')");
// Nested child appears with its own bound, and the parent shows its strategy.
expect(text).toContain("sales_nested_cn");
expect(text).toContain("IN ('cn')");
expect(text).toContain("structureEditor.partitionKindList");
// The size/count estimates moved out of the row body into its hover hint.
expect(text).not.toContain("structureEditor.partitionsRowEstimate");
const hinted = Array.from(root.querySelectorAll("[title]")).find((element) => element.getAttribute("title")?.includes("structureEditor.partitionsRowEstimate"));
expect(hinted?.getAttribute("title")).toContain("structureEditor.partitionsSize");
});
it("indents sub-partitions and labels them, with no guide lines at all", async () => {
const root = await mount({ partitioning: partitioned, loading: false, error: "" });
const text = root.textContent ?? "";
expect(text).not.toContain("├─");
expect(text).not.toContain("└─");
expect(root.querySelectorAll("[data-partition-guide]")).toHaveLength(0);
// One indent spacer per row: 0 for top-level rows, 16px for a sub-partition.
const indents = Array.from(root.querySelectorAll<HTMLElement>("[data-partition-depth]"));
expect(indents.map((cell) => cell.dataset.partitionDepth)).toEqual(["0", "0", "1"]);
expect(indents.map((cell) => cell.style.width)).toEqual(["0px", "0px", "16px"]);
expect(text).toContain("structureEditor.partitionSubPartitionBadge");
});
it("folds and unfolds sub-partitions from the parent toggle", async () => {
const root = await mount({ partitioning: partitioned, loading: false, error: "" });
expect(root.textContent ?? "").toContain("sales_nested_cn");
expect(root.textContent ?? "").toContain("structureEditor.partitionChildCount");
const collapse = root.querySelector('button[title="structureEditor.partitionCollapse"]');
expect(collapse).not.toBeNull();
collapse!.dispatchEvent(new MouseEvent("click", { bubbles: true }));
for (let i = 0; i < 5; i += 1) await nextTick();
expect(root.textContent ?? "").not.toContain("sales_nested_cn");
// The parent stays visible with its fold marker flipped to expand.
expect(root.textContent ?? "").toContain("sales_nested");
expect(root.querySelector('button[title="structureEditor.partitionExpand"]')).not.toBeNull();
});
it("ignores the fold while searching so a matching child is never hidden", async () => {
const root = await mount({ partitioning: partitioned, loading: false, error: "", searchQuery: "sales" });
expect(root.textContent ?? "").toContain("sales_nested_cn");
const collapse = root.querySelector('button[title="structureEditor.partitionCollapse"]');
expect(collapse).not.toBeNull();
collapse!.dispatchEvent(new MouseEvent("click", { bubbles: true }));
for (let i = 0; i < 5; i += 1) await nextTick();
// The fold is recorded, but an active search keeps every match visible.
expect(root.querySelector('button[title="structureEditor.partitionExpand"]')).not.toBeNull();
expect(root.textContent ?? "").toContain("sales_nested_cn");
});
it("filters rows by the search query", async () => {
const root = await mount({ partitioning: partitioned, loading: false, error: "", searchQuery: "2024" });
const text = root.textContent ?? "";
expect(text).toContain("sales_2024");
expect(text).not.toContain("sales_nested_cn");
});
it("shows the empty state for a non-partitioned table", async () => {
const root = await mount({
partitioning: { isPartitioned: false, isPartition: false, keyColumns: [], partitions: [] },
loading: false,
error: "",
});
expect(root.textContent ?? "").toContain("structureEditor.partitionsEmpty");
});
it("shows the error instead of the empty state", async () => {
const root = await mount({ partitioning: null, loading: false, error: "permission denied" });
expect(root.textContent ?? "").toContain("permission denied");
expect(root.textContent ?? "").not.toContain("structureEditor.partitionsEmpty");
});
});