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
import type { EditableStructureColumn, TranswarpCreateTableOptions } from "@/lib/table/tableStructureEditorSql";

export interface TablePhysicalOptionsDraft {
  partitionColumnIds: string[];
  distributionColumnIds: string[];
  bucketCount: string;
  storageFormat: string;
  transactional: boolean;
}

export interface TablePhysicalOptionsConfig {
  partitionColumnsLabel: string;
  distributionColumnsLabel: string;
  bucketCountLabel: string;
  storageFormatLabel: string;
  transactionalLabel?: string;
  maxBuckets: number;
  storageFormats: readonly string[];
}

export const INCEPTOR_PHYSICAL_OPTIONS: TablePhysicalOptionsConfig = {
  partitionColumnsLabel: "structureEditor.transwarpPartitionColumns",
  distributionColumnsLabel: "structureEditor.transwarpBucketColumns",
  bucketCountLabel: "structureEditor.transwarpBucketCount",
  storageFormatLabel: "structureEditor.transwarpStorageFormat",
  transactionalLabel: "structureEditor.transwarpTransactional",
  maxBuckets: 4096,
  storageFormats: ["ORC", "PARQUET", "TEXTFILE"],
};

export function emptyTablePhysicalOptions(): TablePhysicalOptionsDraft {
  return { partitionColumnIds: [], distributionColumnIds: [], bucketCount: "", storageFormat: "", transactional: false };
}

export function hasTablePhysicalOptions(draft: TablePhysicalOptionsDraft): boolean {
  return draft.partitionColumnIds.length > 0 || draft.distributionColumnIds.length > 0 || !!draft.bucketCount.trim() || !!draft.storageFormat || draft.transactional;
}

export function pruneTablePhysicalOptions(draft: TablePhysicalOptionsDraft, availableColumnIds: ReadonlySet<string>): TablePhysicalOptionsDraft {
  const partitionColumnIds = draft.partitionColumnIds.filter((id) => availableColumnIds.has(id));
  const distributionColumnIds = draft.distributionColumnIds.filter((id) => availableColumnIds.has(id));
  if (partitionColumnIds.length === draft.partitionColumnIds.length && distributionColumnIds.length === draft.distributionColumnIds.length) return draft;
  return { ...draft, partitionColumnIds, distributionColumnIds };
}

export function restoreTablePhysicalOptions(saved: { physicalOptions?: TablePhysicalOptionsDraft }): TablePhysicalOptionsDraft {
  if (!saved.physicalOptions) return emptyTablePhysicalOptions();
  return {
    partitionColumnIds: [...saved.physicalOptions.partitionColumnIds],
    distributionColumnIds: [...saved.physicalOptions.distributionColumnIds],
    bucketCount: saved.physicalOptions.bucketCount,
    storageFormat: saved.physicalOptions.storageFormat,
    transactional: saved.physicalOptions.transactional,
  };
}

export function buildInceptorCreateOptions(draft: TablePhysicalOptionsDraft, columns: readonly Pick<EditableStructureColumn, "id" | "name">[]): TranswarpCreateTableOptions {
  const names = (ids: readonly string[]) => ids.map((id) => columns.find((column) => column.id === id)?.name ?? id);
  const count = draft.bucketCount.trim();
  const parsedCount = Number(count);
  return {
    partitionColumns: names(draft.partitionColumnIds),
    bucketColumns: names(draft.distributionColumnIds),
    bucketCount: count ? (Number.isSafeInteger(parsedCount) && parsedCount > 0 && parsedCount <= 4096 ? parsedCount : 0) : undefined,
    storageFormat: draft.storageFormat || undefined,
    transactional: draft.transactional,
  };
}