Skip to content

armgit / dbx

Public Imported from GitHub
0

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。

3.7 KB
Raw Blame
import type { CompletionAssistantCandidate, DatabaseType, TreeNode, TreeNodeType } from "@/types/database";

const PACKAGE_MEMBER_GROUP_MARKER = ":members:";

export function packageMemberGroupOwnerId(node: TreeNode): string | null {
  if (node.parentType !== "package" || (node.type !== "group-procedures" && node.type !== "group-functions")) return null;
  const markerIndex = node.id.lastIndexOf(PACKAGE_MEMBER_GROUP_MARKER);
  if (markerIndex <= 0) return null;
  return node.id.slice(0, markerIndex);
}

export function markPackageNodesExpandable(nodes: TreeNode[]): TreeNode[] {
  return nodes.map((node) => (node.type === "package" ? { ...node, children: node.children ?? [] } : node));
}

function packageMemberGroup(packageNode: TreeNode, type: "procedure" | "function", children: TreeNode[]): TreeNode {
  const isProcedureGroup = type === "procedure";
  const groupType: TreeNodeType = isProcedureGroup ? "group-procedures" : "group-functions";
  return {
    id: `${packageNode.id}:members:${type}s`,
    label: isProcedureGroup ? "tree.procedures" : "tree.functions",
    type: groupType,
    objectName: packageNode.objectName || packageNode.label,
    parentName: packageNode.objectName || packageNode.label,
    parentSchema: packageNode.schema,
    parentType: "package",
    connectionId: packageNode.connectionId,
    database: packageNode.database,
    schema: packageNode.schema,
    objectCount: children.length,
    isExpanded: false,
    children,
  };
}

function packageMemberNode(packageNode: TreeNode, kind: "procedure" | "function", name: string, signature: string, routineId?: string | null): TreeNode {
  return {
    id: routineId ? `${packageNode.id}:member:${JSON.stringify([kind, routineId])}` : `${packageNode.id}:member:${kind}:${name}:${signature}`,
    label: signature ? `${name}(${signature})` : name,
    type: kind,
    objectName: name,
    signature: signature || undefined,
    parentName: packageNode.objectName || packageNode.label,
    parentSchema: packageNode.schema,
    parentType: "package",
    valid: packageNode.valid,
    connectionId: packageNode.connectionId,
    database: packageNode.database,
    schema: packageNode.schema,
    isExpanded: false,
    children: undefined,
  };
}

export function buildPackageMemberNodes(packageNode: TreeNode, candidates: readonly CompletionAssistantCandidate[], databaseType?: DatabaseType): TreeNode[] {
  const seen = new Set<string>();
  const members: TreeNode[] = [];
  const procedures: TreeNode[] = [];
  const functions: TreeNode[] = [];

  for (const candidate of candidates) {
    if (candidate.kind !== "procedure" && candidate.kind !== "function") continue;
    const name = databaseType === "oracle" || databaseType === "oceanbase-oracle" ? candidate.name : candidate.name.trim();
    if (!name.trim()) continue;
    const signature = candidate.signature?.trim() || "";
    const key = JSON.stringify([candidate.kind, name, candidate.routine_id ?? signature]);
    if (seen.has(key)) continue;
    seen.add(key);
    const member = packageMemberNode(packageNode, candidate.kind, name, signature, candidate.routine_id);
    members.push(member);
    if (candidate.kind === "procedure") procedures.push(member);
    else functions.push(member);
  }

  // Xugu presents package specifications and bodies as one logical package.
  // Keep the richer member folders scoped to Xugu so Oracle and other package
  // providers retain their existing flat member tree.
  if (databaseType !== "xugu") return members;

  const groups: TreeNode[] = [];
  if (procedures.length > 0) groups.push(packageMemberGroup(packageNode, "procedure", procedures));
  if (functions.length > 0) groups.push(packageMemberGroup(packageNode, "function", functions));
  return groups;
}