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.2 KB
Raw Blame
export type MetadataScopeValue = string | number | boolean | null | undefined;

export interface MetadataScopeInput {
  kind: string;
  connectionId?: string | null;
  database?: string | null;
  schema?: string | null;
  nodeKind?: string | null;
  tableName?: string | null;
  tableType?: string | null;
  objectTypes?: readonly (string | null | undefined)[] | null;
  searchFilter?: string | null;
  limit?: number | null;
  offset?: number | null;
  sidebarDisplayMode?: string | null;
  driverProfile?: string | null;
  extra?: Record<string, MetadataScopeValue | readonly MetadataScopeValue[]> | null;
}

function normalizeString(value: string | null | undefined): string | undefined {
  if (value == null) return undefined;
  return value;
}

function normalizeSearchFilter(value: string | null | undefined): string | undefined {
  const normalized = value?.trim();
  return normalized ? normalized : undefined;
}

function normalizeNumber(value: number | null | undefined): number | undefined {
  return typeof value === "number" && Number.isFinite(value) ? value : undefined;
}

function normalizeObjectTypes(values: readonly (string | null | undefined)[] | null | undefined): string[] | undefined {
  if (!values?.length) return undefined;
  const normalized = values
    .filter((value): value is string => typeof value === "string" && value.trim().length > 0)
    .map((value) => value.trim().toUpperCase().replace(/\s+/g, "_"))
    .sort();
  return normalized.length > 0 ? [...new Set(normalized)] : undefined;
}

function stableEntries(record: Record<string, unknown>): [string, unknown][] {
  return Object.entries(record)
    .filter(([, value]) => value !== undefined)
    .sort(([left], [right]) => left.localeCompare(right));
}

function normalizeExtra(extra: MetadataScopeInput["extra"]): Record<string, unknown> | undefined {
  if (!extra) return undefined;
  const entries = stableEntries(extra)
    .map(([key, value]) => {
      if (Array.isArray(value)) {
        return [key, value.filter((item) => item !== undefined)] as const;
      }
      return [key, value] as const;
    })
    .filter(([, value]) => {
      if (Array.isArray(value)) return value.length > 0;
      return value !== undefined;
    });
  return entries.length > 0 ? Object.fromEntries(entries) : undefined;
}

export function metadataScopeParts(input: MetadataScopeInput): Record<string, unknown> {
  return {
    kind: input.kind,
    connectionId: normalizeString(input.connectionId),
    database: normalizeString(input.database),
    schema: normalizeString(input.schema),
    nodeKind: normalizeString(input.nodeKind),
    tableName: normalizeString(input.tableName),
    tableType: normalizeString(input.tableType),
    objectTypes: normalizeObjectTypes(input.objectTypes),
    searchFilter: normalizeSearchFilter(input.searchFilter),
    limit: normalizeNumber(input.limit),
    offset: normalizeNumber(input.offset),
    sidebarDisplayMode: normalizeString(input.sidebarDisplayMode),
    driverProfile: normalizeString(input.driverProfile),
    extra: normalizeExtra(input.extra),
  };
}

export function metadataScopeKey(input: MetadataScopeInput): string {
  return JSON.stringify(stableEntries(metadataScopeParts(input)));
}