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。

4.4 KB
Raw Blame
import { DEFAULT_SQL_INSERT_DIALECT, DEFAULT_SQL_INSERT_MODE, type SqlInsertDialect, type SqlInsertMode } from "./sqlInsertMode";

export interface DatabaseExportSavedOptions {
  includeStructure: boolean;
  includeData: boolean;
  insertDialect: SqlInsertDialect;
  insertMode: SqlInsertMode;
  includeObjects: boolean;
  includeCreateDatabase: boolean;
  dropTableIfExists: boolean;
  omitAutoIncrement: boolean;
  preserveOriginalLanguage: boolean;
  splitSqlOutput: boolean;
  splitSqlPartMaxMb: number;
}

export const MIN_SPLIT_SQL_PART_MB = 1;
export const MAX_SPLIT_SQL_PART_MB = 4096;

export const DEFAULT_DATABASE_EXPORT_OPTIONS: DatabaseExportSavedOptions = {
  includeStructure: true,
  includeData: true,
  insertDialect: DEFAULT_SQL_INSERT_DIALECT,
  insertMode: DEFAULT_SQL_INSERT_MODE,
  includeObjects: true,
  includeCreateDatabase: false,
  dropTableIfExists: false,
  omitAutoIncrement: false,
  preserveOriginalLanguage: false,
  splitSqlOutput: false,
  splitSqlPartMaxMb: 100,
};

export const DATABASE_EXPORT_OPTIONS_STORAGE_KEY = "dbx-database-export-last-options-v1";

export function loadSavedDatabaseExportOptions(storage?: Pick<Storage, "getItem">): DatabaseExportSavedOptions {
  try {
    const store = storage ?? (typeof localStorage !== "undefined" ? localStorage : undefined);
    if (!store) return { ...DEFAULT_DATABASE_EXPORT_OPTIONS };

    const raw = store.getItem(DATABASE_EXPORT_OPTIONS_STORAGE_KEY);
    if (!raw) return { ...DEFAULT_DATABASE_EXPORT_OPTIONS };

    const parsed = JSON.parse(raw);
    if (!parsed || typeof parsed !== "object") return { ...DEFAULT_DATABASE_EXPORT_OPTIONS };

    return {
      includeStructure: typeof parsed.includeStructure === "boolean" ? parsed.includeStructure : DEFAULT_DATABASE_EXPORT_OPTIONS.includeStructure,
      includeData: typeof parsed.includeData === "boolean" ? parsed.includeData : DEFAULT_DATABASE_EXPORT_OPTIONS.includeData,
      insertDialect: parsed.insertDialect === "standard" ? "standard" : DEFAULT_DATABASE_EXPORT_OPTIONS.insertDialect,
      insertMode: parsed.insertMode === "single" ? "single" : DEFAULT_DATABASE_EXPORT_OPTIONS.insertMode,
      includeObjects: typeof parsed.includeObjects === "boolean" ? parsed.includeObjects : DEFAULT_DATABASE_EXPORT_OPTIONS.includeObjects,
      includeCreateDatabase: typeof parsed.includeCreateDatabase === "boolean" ? parsed.includeCreateDatabase : DEFAULT_DATABASE_EXPORT_OPTIONS.includeCreateDatabase,
      dropTableIfExists: typeof parsed.dropTableIfExists === "boolean" ? parsed.dropTableIfExists : DEFAULT_DATABASE_EXPORT_OPTIONS.dropTableIfExists,
      omitAutoIncrement: typeof parsed.omitAutoIncrement === "boolean" ? parsed.omitAutoIncrement : DEFAULT_DATABASE_EXPORT_OPTIONS.omitAutoIncrement,
      preserveOriginalLanguage: typeof parsed.preserveOriginalLanguage === "boolean" ? parsed.preserveOriginalLanguage : DEFAULT_DATABASE_EXPORT_OPTIONS.preserveOriginalLanguage,
      splitSqlOutput: typeof parsed.splitSqlOutput === "boolean" ? parsed.splitSqlOutput : DEFAULT_DATABASE_EXPORT_OPTIONS.splitSqlOutput,
      splitSqlPartMaxMb: typeof parsed.splitSqlPartMaxMb === "number" && Number.isFinite(parsed.splitSqlPartMaxMb) ? Math.min(MAX_SPLIT_SQL_PART_MB, Math.max(MIN_SPLIT_SQL_PART_MB, Math.round(parsed.splitSqlPartMaxMb))) : DEFAULT_DATABASE_EXPORT_OPTIONS.splitSqlPartMaxMb,
    };
  } catch {
    return { ...DEFAULT_DATABASE_EXPORT_OPTIONS };
  }
}

export function saveDatabaseExportOptions(options: Partial<DatabaseExportSavedOptions>, storage?: Pick<Storage, "setItem" | "getItem">): void {
  try {
    const store = storage ?? (typeof localStorage !== "undefined" ? localStorage : undefined);
    if (!store) return;

    const current = loadSavedDatabaseExportOptions(store);
    const updated: DatabaseExportSavedOptions = {
      ...current,
      ...options,
    };
    store.setItem(DATABASE_EXPORT_OPTIONS_STORAGE_KEY, JSON.stringify(updated));
  } catch {
    // Ignore storage write failures (quota exceeded, private browsing, etc.)
  }
}

export function sortDatabaseTableNames(names: string[]): string[] {
  // Pin the collation so the order does not shift with the OS locale.
  return [...names].sort((a, b) => a.localeCompare(b, "en", { sensitivity: "base" }));
}

/** Use the selected table as the suggested filename when exporting one table. */
export function databaseExportFileStem(database: string, selectedTables: readonly string[]): string {
  return selectedTables.length === 1 ? selectedTables[0]! : database;
}