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 { describe, expect, it } from "vitest";
import { orderSidebarConnectionUtilitiesForDisplay, sortSidebarTreeChildrenForParent } from "@/lib/sidebar/sidebarNodeOrdering";
import type { TreeNode } from "@/types/database";
describe("Oracle sidebar ordering", () => {
it("projects an already-loaded grouped connection without changing schema order, nested objects, or the live tree", () => {
const children: TreeNode[] = [
{ id: "links", type: "oracle-db-links", label: "links" },
{ id: "z", type: "schema", label: "Z", children: [{ id: "table", type: "table", label: "table" }] },
{ id: "a", type: "schema", label: "A" },
{ id: "users", type: "user-admin", label: "users" },
{ id: "jobs", type: "database-job-admin", label: "jobs" },
{ id: "sql", type: "saved-sql-root", label: "sql" },
];
const nodes: TreeNode[] = [{ id: "folder", type: "connection-group", label: "folder", children: [{ id: "c1", type: "connection", label: "c1", children }] }];
const result = orderSidebarConnectionUtilitiesForDisplay(nodes);
expect(result[0].children![0].children!.map((node) => node.id)).toEqual(["sql", "z", "a", "links", "jobs", "users"]);
expect(children.map((node) => node.id)).toEqual(["links", "z", "a", "users", "jobs", "sql"]);
expect(result[0].children![0].children![1]).toBe(children[1]);
expect(orderSidebarConnectionUtilitiesForDisplay(result)).toBe(result);
});
it("keeps schemas sorted before the three connection tools after cache normalization", () => {
const children: TreeNode[] = [
{ id: "users", type: "user-admin", label: "users" },
{ id: "jobs", type: "database-job-admin", label: "jobs" },
{ id: "z", type: "schema", label: "ZEBRA" },
{ id: "links", type: "oracle-db-links", label: "links" },
{ id: "a", type: "schema", label: "ALPHA" },
];
const result = sortSidebarTreeChildrenForParent({ type: "connection" }, children, "oracle");
expect(result.map((node) => node.id)).toEqual(["a", "z", "links", "jobs", "users"]);
expect(sortSidebarTreeChildrenForParent({ type: "connection" }, result, "oracle")).toEqual(result);
});
it("sorts schema nodes alphabetically and places database links at the bottom", () => {
const children: TreeNode[] = [
{ id: "c1:__oracle_db_links", label: "tree.databaseLinks", type: "oracle-db-links", connectionId: "c1" },
{ id: "c1:ZEBRA:ZEBRA", label: "ZEBRA", type: "schema", connectionId: "c1", database: "ZEBRA", schema: "ZEBRA" },
{ id: "c1:ALPHA:ALPHA", label: "ALPHA", type: "schema", connectionId: "c1", database: "ALPHA", schema: "ALPHA" },
];
const result = sortSidebarTreeChildrenForParent({ type: "connection" }, children, "oracle");
expect(result.map((node) => node.id)).toEqual(["c1:ALPHA:ALPHA", "c1:ZEBRA:ZEBRA", "c1:__oracle_db_links"]);
});
it("places saved queries at the top, schemas in the middle, and database links at the bottom", () => {
const children: TreeNode[] = [
{ id: "c1:__oracle_db_links", label: "tree.databaseLinks", type: "oracle-db-links", connectionId: "c1" },
{ id: "c1:MY_SCHEMA:MY_SCHEMA", label: "MY_SCHEMA", type: "schema", connectionId: "c1", database: "MY_SCHEMA", schema: "MY_SCHEMA" },
{ id: "c1:__queries", label: "tree.queries", type: "saved-sql-root", connectionId: "c1" },
];
const result = sortSidebarTreeChildrenForParent({ type: "connection" }, children, "oracle");
expect(result.map((node) => node.id)).toEqual(["c1:__queries", "c1:MY_SCHEMA:MY_SCHEMA", "c1:__oracle_db_links"]);
});
});