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.6 KB
Raw Blame
import type { BooleanSchemaDiffCompareOptionKey, SchemaDiffCompareOptions, SchemaDiffOptionItem } from "@/types/schemaDiff";

export const POSTGRES_SCHEMA_DIFF_OPTIONS: SchemaDiffOptionItem[] = [
  {
    id: "tables",
    labelKey: "schemaDiff.options.tables",
    defaultChecked: true,
    children: [
      { id: "primaryKeys", labelKey: "schemaDiff.options.primaryKeys", defaultChecked: true },
      { id: "foreignKeys", labelKey: "schemaDiff.options.foreignKeys", defaultChecked: true },
      { id: "uniqueKeys", labelKey: "schemaDiff.options.uniqueKeys", defaultChecked: true },
      { id: "checks", labelKey: "schemaDiff.options.checks", defaultChecked: true },
      { id: "exclusions", labelKey: "schemaDiff.options.exclusions", defaultChecked: true },
    ],
  },
  { id: "views", labelKey: "schemaDiff.options.views", defaultChecked: true },
  { id: "functions", labelKey: "schemaDiff.options.functions", defaultChecked: true },
  { id: "indexes", labelKey: "schemaDiff.options.indexes", defaultChecked: true },
  { id: "sequences", labelKey: "schemaDiff.options.sequences", defaultChecked: true },
  { id: "triggers", labelKey: "schemaDiff.options.triggers", defaultChecked: true },
  { id: "rules", labelKey: "schemaDiff.options.rules", defaultChecked: true },
  { id: "owners", labelKey: "schemaDiff.options.owners", defaultChecked: true },
  { id: "cascadeDelete", labelKey: "schemaDiff.options.cascadeDelete", defaultChecked: false },
  { id: "sequenceLastValues", labelKey: "schemaDiff.options.sequenceLastValues", defaultChecked: true },
  { id: "compareColumnOrder", labelKey: "schemaDiff.options.compareColumnOrder", defaultChecked: false },
  { id: "ignoreTableNameCase", labelKey: "schemaDiff.options.ignoreTableNameCase", defaultChecked: false },
  { id: "ignoreColumnNameCase", labelKey: "schemaDiff.options.ignoreColumnNameCase", defaultChecked: false },
  { id: "refreshMetadata", labelKey: "schemaDiff.options.refreshMetadata", defaultChecked: true },
  { id: "detectRenames", labelKey: "schemaDiff.options.detectRenames", defaultChecked: false },
  { id: "detectTableRenames", labelKey: "schemaDiff.options.detectTableRenames", defaultChecked: false },
  { id: "enableRollback", labelKey: "schemaDiff.options.enableRollback", defaultChecked: false },
];

export const MYSQL_SCHEMA_DIFF_OPTIONS: SchemaDiffOptionItem[] = [...POSTGRES_SCHEMA_DIFF_OPTIONS, { id: "compareCharset", labelKey: "schemaDiff.options.compareCharset", defaultChecked: true }];

export const SCHEMA_DIFF_OPTIONS_BY_DB_TYPE: Record<string, SchemaDiffOptionItem[]> = {
  postgres: POSTGRES_SCHEMA_DIFF_OPTIONS,
  opengauss: POSTGRES_SCHEMA_DIFF_OPTIONS,
  mysql: MYSQL_SCHEMA_DIFF_OPTIONS,
  goldendb: MYSQL_SCHEMA_DIFF_OPTIONS,
  // sqlserver: [...] 后续扩展
};

export function getSchemaDiffOptionsForDbType(dbType: string): SchemaDiffOptionItem[] {
  return SCHEMA_DIFF_OPTIONS_BY_DB_TYPE[dbType] ?? POSTGRES_SCHEMA_DIFF_OPTIONS;
}

export function getOptionIdsFromTree(items: SchemaDiffOptionItem[]): BooleanSchemaDiffCompareOptionKey[] {
  const ids: BooleanSchemaDiffCompareOptionKey[] = [];
  for (const item of items) {
    ids.push(item.id);
    if (item.children) {
      ids.push(...getOptionIdsFromTree(item.children));
    }
  }
  return ids;
}

export function buildDefaultOptionsFromTree(items: SchemaDiffOptionItem[]): SchemaDiffCompareOptions {
  const options = {} as SchemaDiffCompareOptions;
  for (const item of items) {
    options[item.id] = item.defaultChecked as never;
    if (item.children) {
      const childDefaults = buildDefaultOptionsFromTree(item.children);
      Object.assign(options, childDefaults);
    }
  }
  return options;
}