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。

1.4 KB
Raw Blame
import type { TreeNode } from "@/types/database";

export const DEFAULT_DATABASE_TREE_LABEL = "tree.defaultDatabase";

export function hasTreeNodeDatabaseContext(node: Pick<TreeNode, "database">): node is Pick<TreeNode, "database"> & {
  database: string;
} {
  return node.database != null;
}

function schemaCacheKey(...parts: string[]): string {
  return parts.map((part) => encodeURIComponent(part)).join(":");
}

export function treeNodeSchemaCachePrefix(node: TreeNode): string | null {
  if (node.type === "connection" && node.connectionId) {
    return `${schemaCacheKey(node.connectionId)}:`;
  }
  if (node.type === "database" && node.connectionId && hasTreeNodeDatabaseContext(node)) {
    return `${schemaCacheKey(node.connectionId, node.database)}:`;
  }
  if (node.type === "schema" && node.connectionId && hasTreeNodeDatabaseContext(node) && node.schema) {
    return `${schemaCacheKey(node.connectionId, node.database, node.schema)}:`;
  }
  return null;
}

export function normalizeCataloglessDatabaseNodes(nodes: TreeNode[]): TreeNode[] {
  return nodes.map((node) => {
    const normalized = node.type === "database" && node.database === "" && !node.label.trim() ? { ...node, label: DEFAULT_DATABASE_TREE_LABEL } : node;

    return normalized.children
      ? {
          ...normalized,
          children: normalizeCataloglessDatabaseNodes(normalized.children),
        }
      : normalized;
  });
}