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。

4.1 KB
Raw Blame
import type { ConnectionConfig, DatabaseType } from "@/types/database";
import { filterDatabaseNamesForVisiblePicker, filterVisibleDatabaseNames, visibleDatabasePatternsAreEnabled } from "@/lib/database/visibleDatabases";

const DRAFT_VISIBLE_DATABASES_PREFIX = "__visible_draft_";

// Turso and Cloudflare D1 target one fixed SQLite-compatible `main` namespace;
// non-database services expose their own root objects rather than database namespaces.
const UNSUPPORTED_VISIBLE_DATABASE_TYPES = new Set<DatabaseType>(["turso", "cloudflare-d1", "dynamodb", "elasticsearch", "easysearch", "meilisearch", "solr", "couchdb", "qdrant", "milvus", "weaviate", "chromadb", "etcd", "zookeeper", "mq", "nacos", "consul", "plugin", "salesforce"]);

type VisibleDatabaseConnectionFields = Pick<
  ConnectionConfig,
  "db_type" | "driver_profile" | "host" | "port" | "username" | "database" | "connection_string" | "url_params" | "redis_connection_mode" | "redis_sentinel_master" | "redis_sentinel_nodes" | "redis_cluster_nodes" | "etcd_endpoints" | "jdbc_driver_class"
>;

type VisibleObjectFilterConnectionFields = VisibleDatabaseConnectionFields & Pick<ConnectionConfig, "visible_databases" | "visible_schemas">;

export function buildDraftVisibleDatabasesConnectionId(seed: string): string {
  return `${DRAFT_VISIBLE_DATABASES_PREFIX}${seed}`;
}

export function connectionCanChooseVisibleDatabases(connection: Pick<ConnectionConfig, "db_type"> | undefined): boolean {
  return !!connection?.db_type && !UNSUPPORTED_VISIBLE_DATABASE_TYPES.has(connection.db_type);
}

export function initialVisibleDatabaseSelection(databaseNames: string[], visibleDatabases: string[] | undefined, connection?: Pick<ConnectionConfig, "db_type" | "driver_profile" | "visible_databases" | "visible_database_patterns">): string[] {
  const patterns = connection?.visible_database_patterns;
  // 通配符与显式名单取并集,和侧栏筛选保持一致;全匹配通配符会让"显示全部"的选择器
  // 重新打开时仍勾选所有库(含系统库),而不是看起来又退回默认视图。
  if (Array.isArray(visibleDatabases) || visibleDatabasePatternsAreEnabled(patterns)) {
    return filterVisibleDatabaseNames(databaseNames, visibleDatabases, patterns);
  }
  return filterDatabaseNamesForVisiblePicker(databaseNames, connection);
}

export function appendVisibleDatabaseSelection(visibleDatabases: string[] | undefined, databaseName: string): string[] | undefined {
  if (!Array.isArray(visibleDatabases)) return undefined;
  const name = databaseName.trim();
  if (!name || visibleDatabases.includes(name)) return visibleDatabases;
  return [...visibleDatabases, name];
}

export function visibleDatabaseSelectionIsStale(previous: VisibleDatabaseConnectionFields, current: VisibleDatabaseConnectionFields): boolean {
  return visibleDatabaseFingerprint(previous) !== visibleDatabaseFingerprint(current);
}

export function visibleObjectFiltersNeedReset(previous: VisibleObjectFilterConnectionFields, current: VisibleObjectFilterConnectionFields): boolean {
  const hasVisibleDatabaseFilter = Array.isArray(current.visible_databases);
  const hasVisibleSchemaFilter = !!current.visible_schemas && Object.keys(current.visible_schemas).length > 0;
  return (hasVisibleDatabaseFilter || hasVisibleSchemaFilter) && visibleDatabaseSelectionIsStale(previous, current);
}

function visibleDatabaseFingerprint(connection: VisibleDatabaseConnectionFields): string {
  return JSON.stringify({
    db_type: connection.db_type,
    driver_profile: connection.driver_profile || "",
    host: connection.host || "",
    port: Number(connection.port) || 0,
    username: connection.username || "",
    database: connection.database || "",
    connection_string: connection.connection_string || "",
    url_params: connection.url_params || "",
    redis_connection_mode: connection.redis_connection_mode || "",
    redis_sentinel_master: connection.redis_sentinel_master || "",
    redis_sentinel_nodes: connection.redis_sentinel_nodes || "",
    redis_cluster_nodes: connection.redis_cluster_nodes || "",
    etcd_endpoints: connection.etcd_endpoints || "",
    jdbc_driver_class: connection.jdbc_driver_class || "",
  });
}