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.5 KB
Raw Blame
import type { ManualExportMode } from "@/lib/export/manualExportQueue";

export type XlsxHeaderMode = "name" | "comment" | "name-comment" | "name-comment-rows";

export interface XlsxExportOptions {
  headerMode: XlsxHeaderMode;
  autoFilter: boolean;
  executionMode?: ManualExportMode;
}

export function hasXlsxHeaderComments(comments: readonly (string | null | undefined)[] | undefined): boolean {
  return comments?.some((comment) => !!comment?.trim()) ?? false;
}

/** True when the header mode renders comments on a separate second row. */
export function xlsxHeaderUsesCommentRows(mode: XlsxHeaderMode): boolean {
  return mode === "name-comment-rows";
}

export function buildXlsxHeaderOverrides(columns: readonly string[], comments: readonly (string | null | undefined)[] | undefined, mode: XlsxHeaderMode): (string | null)[] | undefined {
  if (mode === "name") return undefined;
  if (mode === "name-comment-rows") {
    // The comments render as their own header row, so they travel as plain
    // comment data (paired with the headerCommentRows flag) instead of
    // overriding the header text.
    const overrides = columns.map((_, index) => comments?.[index]?.trim() || null);
    return overrides.some((header) => header !== null) ? overrides : undefined;
  }

  const overrides = columns.map((column, index) => {
    const comment = comments?.[index]?.trim();
    if (!comment) return null;
    return mode === "comment" ? comment : `${column} (${comment})`;
  });

  return overrides.some((header) => header !== null) ? overrides : undefined;
}