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.7 KB
Raw Blame
import { jsonLanguage } from "@codemirror/lang-json";
import { yamlLanguage } from "@codemirror/lang-yaml";
import { xmlLanguage } from "@codemirror/lang-xml";

export type KvValueFormat = "text" | "base64" | "json" | "yaml" | "xml" | "sql" | "properties" | "shell" | "dockerfile" | "nginx" | "kubernetes";

const DOCKERFILE_INSTRUCTIONS = new Set(["ADD", "ARG", "CMD", "COPY", "ENTRYPOINT", "ENV", "EXPOSE", "FROM", "HEALTHCHECK", "LABEL", "MAINTAINER", "ONBUILD", "RUN", "SHELL", "STOPSIGNAL", "USER", "VOLUME", "WORKDIR"]);

function syntaxError(language: { parser: { parse: (text: string) => { cursor: () => { type: { isError: boolean }; next: () => boolean } } } }, text: string): boolean {
  const cursor = language.parser.parse(text).cursor();
  do {
    if (cursor.type.isError) return true;
  } while (cursor.next());
  return false;
}

export function detectKvValueFormat(text: string, encoding: "utf8" | "base64" = "utf8"): KvValueFormat {
  if (encoding === "base64") return "base64";
  const trimmed = text.trim();
  if (!trimmed) return "text";
  if ((trimmed.startsWith("{") || trimmed.startsWith("[")) && !syntaxError(jsonLanguage, text)) return "json";
  if (trimmed.startsWith("<") && !syntaxError(xmlLanguage, text)) return "xml";
  if (/^#!\s*\/(?:usr\/bin\/env\s+)?(?:ba|z|k)?sh\b/m.test(text)) return "shell";
  if (/^(?:#\s*syntax=\S+\s*)?(?:FROM|ARG)\s+\S+/im.test(text)) return "dockerfile";
  if (/^\s*(?:events|http|server|upstream|location)\b[^{;]*\{/m.test(text)) return "nginx";
  if (/^\s*apiVersion\s*:\s*\S+/m.test(text) && /^\s*kind\s*:\s*\S+/m.test(text) && !syntaxError(yamlLanguage, text)) return "kubernetes";
  if (/^\s*(?:SELECT|INSERT|UPDATE|DELETE|CREATE|ALTER|DROP|WITH|GRANT|REVOKE)\b/im.test(text)) return "sql";
  if (/^(?:[#!].*\n)*\s*[A-Za-z0-9_.-]+\s*=\s*\S/m.test(text)) return "properties";
  if (/^(---\s*$|[A-Za-z0-9_.-]+\s*:)/m.test(text) && !syntaxError(yamlLanguage, text)) return "yaml";
  return "text";
}

export function validateKvValue(text: string, format: KvValueFormat): string | null {
  if (format === "json") {
    try {
      JSON.parse(text);
      return null;
    } catch (error) {
      return error instanceof Error ? error.message : String(error);
    }
  }
  if ((format === "yaml" || format === "kubernetes") && syntaxError(yamlLanguage, text)) return "Invalid YAML syntax";
  if (format === "xml" && syntaxError(xmlLanguage, text)) return "Invalid XML syntax";
  if (format === "base64") {
    const normalized = text.replace(/\s+/g, "");
    if (normalized && (!/^[A-Za-z0-9+/]*={0,2}$/.test(normalized) || normalized.length % 4 !== 0)) return "Invalid Base64 data";
  }
  if (format === "kubernetes" && text.trim()) {
    const documents = text
      .split(/^---\s*$/m)
      .map((document) => document.trim())
      .filter(Boolean);
    if (documents.some((document) => !/^\s*apiVersion\s*:\s*\S+/m.test(document) || !/^\s*kind\s*:\s*\S+/m.test(document))) {
      return "Each Kubernetes document must contain apiVersion and kind";
    }
  }
  if (format === "properties") {
    let continuing = false;
    const invalidLine = text.split(/\r?\n/).find((line) => {
      const trimmed = line.trim();
      if (!trimmed || trimmed.startsWith("#") || trimmed.startsWith("!")) return false;
      if (continuing) {
        continuing = trimmed.endsWith("\\");
        return false;
      }
      continuing = trimmed.endsWith("\\");
      return !/[=:]/.test(trimmed) && !continuing;
    });
    if (invalidLine) return `Invalid Properties entry: ${invalidLine}`;
    if (continuing) return "Invalid Properties entry: unfinished continuation";
  }
  if (format === "dockerfile") {
    let continuing = false;
    const invalidInstruction = text.split(/\r?\n/).find((line) => {
      const trimmed = line.trim();
      if (!trimmed || trimmed.startsWith("#")) return false;
      if (continuing) {
        continuing = trimmed.endsWith("\\");
        return false;
      }
      continuing = trimmed.endsWith("\\");
      return !DOCKERFILE_INSTRUCTIONS.has(trimmed.split(/\s+/, 1)[0].toUpperCase());
    });
    if (invalidInstruction) return `Unknown Dockerfile instruction: ${invalidInstruction.split(/\s+/, 1)[0]}`;
    if (continuing) return "Invalid Dockerfile: unfinished line continuation";
  }
  if (format === "nginx") {
    let depth = 0;
    for (const character of text.replace(/#[^\r\n]*/g, "")) {
      if (character === "{") depth++;
      if (character === "}") depth--;
      if (depth < 0) return "Invalid Nginx configuration: unexpected closing brace";
    }
    if (depth !== 0) return "Invalid Nginx configuration: unbalanced braces";
  }
  return null;
}

export function formatKvValue(text: string, format: KvValueFormat): string {
  if (format === "json") return JSON.stringify(JSON.parse(text), null, 2);
  return text;
}