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.7 KB
Raw Blame
import { formatError } from "@/lib/backend/errorUtils";

export interface MysqlExplainCompatibilityHint {
  fallbackSql?: string;
  supportsJson: boolean;
}

const INVALID_EXPLAIN_OPTION_RE = /invalid\s+explain\s+option/i;
const VALID_EXPLAIN_OPTIONS_RE = /valid\s+options\s+are\s*:\s*\[([^\]]+)\]/i;
const EXPLAIN_FORMAT_PREFIX_RE = /^EXPLAIN\s+FORMAT\s*=\s*[A-Z_]+\s+/i;
const UNSUPPORTED_JSON_EXPLAIN_FORMAT_RE = /\bexplain\s+format\s+(['"`]?)json\1\s+is\s+not\s+supported\s+now\b/i;

export function mysqlExplainCompatibilityHint(error: unknown, explainSql: string): MysqlExplainCompatibilityHint | undefined {
  const message = formatError(error);
  if (UNSUPPORTED_JSON_EXPLAIN_FORMAT_RE.test(message)) return { supportsJson: false };
  if (!INVALID_EXPLAIN_OPTION_RE.test(message)) return undefined;

  const optionsMatch = message.match(VALID_EXPLAIN_OPTIONS_RE);
  if (!optionsMatch) return undefined;

  const validFormats = new Set(
    optionsMatch[1]
      .split(",")
      .map((format) =>
        format
          .trim()
          .replace(/^['"`]|['"`]$/g, "")
          .toUpperCase(),
      )
      .filter(Boolean),
  );
  const formatPrefixMatch = explainSql.match(EXPLAIN_FORMAT_PREFIX_RE);
  if (!formatPrefixMatch) return { supportsJson: validFormats.has("JSON") };

  // MySQL-compatible warehouses often expose TEXT as their tabular EXPLAIN format instead of TRADITIONAL.
  const fallbackPrefix = validFormats.has("TEXT") ? "EXPLAIN FORMAT=TEXT " : "EXPLAIN ";
  const fallbackSql = explainSql.replace(EXPLAIN_FORMAT_PREFIX_RE, fallbackPrefix);
  return {
    fallbackSql: fallbackSql === explainSql ? undefined : fallbackSql,
    supportsJson: validFormats.has("JSON"),
  };
}