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。

3.0 KB
Raw Blame
import type { AppThemeAppearance } from "@/lib/app/appTheme";

export type SqlHighlighter = (content: string, appearance?: AppThemeAppearance) => string;

interface ShikiSqlHighlighterOptions {
  appearance: () => AppThemeAppearance;
  themePreset?: ShikiSqlThemePreset;
}

type ShikiSqlThemePreset = "default" | "preview";

const SHIKI_THEMES = {
  default: {
    dark: "github-dark",
    light: "github-light",
  },
  preview: {
    dark: "dark-plus",
    light: "min-light",
  },
} as const;

export type ShikiHighlighter = Awaited<ReturnType<typeof import("shiki/core").createHighlighterCore>>;
type ShikiCodeHighlighter = Pick<ShikiHighlighter, "codeToHtml">;

let highlighterPromise: Promise<ShikiHighlighter> | undefined;

export async function createShikiSqlHighlighter(options: ShikiSqlHighlighterOptions): Promise<SqlHighlighter> {
  try {
    const highlighter = await getShikiSqlHighlighter();
    return createSafeSqlHighlighter(highlighter, options);
  } catch (error) {
    console.warn("[DBX][sqlHighlighter] Failed to initialize SQL highlighter:", error);
    return escapeHtml;
  }
}

export function createSafeSqlHighlighter(highlighter: ShikiCodeHighlighter, options: ShikiSqlHighlighterOptions): SqlHighlighter {
  return (content, appearance = options.appearance()) => {
    try {
      const themes = SHIKI_THEMES[options.themePreset ?? "default"];
      return highlighter.codeToHtml(content, {
        lang: "sql",
        structure: "inline",
        theme: themes[appearance],
      });
    } catch (error) {
      console.warn("[DBX][sqlHighlighter] Failed to highlight SQL:", error);
      return escapeHtml(content);
    }
  };
}

export function escapeHtml(content: string): string {
  return content.replace(/[&<>"']/g, (char) => {
    switch (char) {
      case "&":
        return "&amp;";
      case "<":
        return "&lt;";
      case ">":
        return "&gt;";
      case '"':
        return "&quot;";
      default:
        return "&#39;";
    }
  });
}

/**
 * Lazily-initialized shared highlighter. Exported so other SQL renderers
 * (e.g. rich-text copy) reuse one Shiki instance instead of loading the SQL
 * grammar and themes a second time.
 */
export function getShikiSqlHighlighter(): Promise<ShikiHighlighter> {
  highlighterPromise ??= loadShikiSqlHighlighter();
  return highlighterPromise;
}

async function loadShikiSqlHighlighter(): Promise<ShikiHighlighter> {
  const [{ createHighlighterCore }, { createJavaScriptRegexEngine }, githubDark, githubLight, darkPlus, minLight, sql] = await Promise.all([
    import("shiki/core"),
    import("shiki/engine/javascript"),
    import("shiki/themes/github-dark.mjs"),
    import("shiki/themes/github-light.mjs"),
    import("shiki/themes/dark-plus.mjs"),
    import("shiki/themes/min-light.mjs"),
    import("shiki/langs/sql.mjs"),
  ]);

  return createHighlighterCore({
    engine: createJavaScriptRegexEngine(),
    langs: [sql.default],
    themes: [githubDark.default, githubLight.default, darkPlus.default, minLight.default],
  });
}