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.1 KB
Raw Blame
import type { SavedSqlFile, SavedSqlFolder } from "@/types/database";
import type { SavedSqlExecutionTarget } from "@/lib/savedSql/savedSqlExecutionTarget";

export interface SavedSqlBatchTargetSelection {
  connectionId: string;
  database: string;
  catalog?: string;
}

export interface SavedSqlBatchReassignment {
  target: SavedSqlExecutionTarget;
  folderId?: string;
}

function normalizedCatalog(catalog: string | null | undefined): string | undefined {
  return catalog || undefined;
}

export function savedSqlBatchReassignment(file: SavedSqlFile, folder: SavedSqlFolder | undefined, selection: SavedSqlBatchTargetSelection): SavedSqlBatchReassignment {
  const catalog = normalizedCatalog(selection.catalog);
  const keepsNamespace = file.connectionId === selection.connectionId && normalizedCatalog(file.catalog) === catalog && file.database === selection.database;
  return {
    target: {
      connectionId: selection.connectionId,
      database: selection.database,
      catalog,
      schema: keepsNamespace ? file.schema : undefined,
    },
    folderId: folder?.id === file.folderId ? file.folderId : undefined,
  };
}