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。

2.5 KB
Raw Blame
import { analyzeSelectStructureForDisplay, resolveMetadataColumnName } from "@/lib/sql/sqlAnalysis";
import { canInsertTableRows } from "@/lib/table/tableEditing";
import type { QueryMetadataPatch } from "@/stores/queryStore";
import type { QueryResult, DatabaseType } from "@/types/database";
import type { DataGridExtractRequest, DataGridExtractorOptions } from "@/lib/dataGrid/dataGridCopyExtractor";

/** A display source label is insufficient to authorize an INSERT target. */
export function batchResultInsertRequest(result: QueryResult, metadata: QueryMetadataPatch | undefined, databaseType: DatabaseType | undefined, identifierQuote: string | undefined, options: DataGridExtractorOptions): DataGridExtractRequest | undefined {
  if (result.execution_error || result.server_message || !result.sourceStatement || !databaseType || result.large_value_cells?.length) return undefined;
  const structure = analyzeSelectStructureForDisplay(result.sourceStatement);
  if (!structure || structure.multiSource || structure.distinct || structure.groupByColumns !== undefined || structure.hasHavingClause || structure.hasWindowClause) return undefined;
  if (!structure.selectStar && structure.columns.some((column) => !column.sourceName)) return undefined;
  const analysis = metadata?.queryAnalysis;
  const tableMeta = metadata?.tableMeta;
  const tableColumnNames = tableMeta?.columns?.map((item) => item.name);
  const mapping = metadata?.querySourceColumns ?? (structure.selectStar && tableColumnNames?.length ? result.columns.map((column) => resolveMetadataColumnName(databaseType, column, undefined, tableColumnNames)) : undefined);
  if (!tableMeta || !mapping || analysis?.multiSource || analysis?.allowInsert === false || !canInsertTableRows(databaseType) || tableMeta.tableType?.toUpperCase().includes("VIEW")) return undefined;
  const hidden = new Set(result.hidden_column_indexes ?? []);
  const indexes = result.columns.map((_, index) => index).filter((index) => !hidden.has(index));
  if (!indexes.length || indexes.some((index) => !mapping[index])) return undefined;
  return {
    version: 1,
    extractor: "sql-inserts",
    databaseType,
    identifierQuote,
    tableMeta,
    columns: indexes.map((index, ordinal) => ({ displayName: result.columns[index], sourceName: mapping[index], sourceIndex: ordinal })),
    selectedColumnIndexes: indexes.map((_, index) => index),
    rows: result.rows.map((row) => indexes.map((index) => row[index])),
    selectionKind: "rows",
    options,
  };
}