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。
TypeScript aicliclickhousedatabasedatabase-clientdatabase-managementdockerguimcpmongodbmysqlpostgresqlredisrustsql-serversqlitetaurivue
/**
* Code snapshot rendering & export utilities (CodeSnap-style).
*
* Flow: selected code text -> shiki re-render (reusing the AI highlighter
* singleton) -> CodeSnap-like shell DOM (traffic lights / title / line
* numbers / background) -> PNG export either to the system clipboard
* (Tauri `writeImage`) or to a file (dialog + fs, with a browser-download
* fallback for web mode).
*
* The rendered snapshot DOM is fully self-contained: it embeds its own
* `<style>` tag so `dom-to-image-more` captures identical styling when it
* clones the node into a foreignObject.
*/
import type { AppThemeAppearance } from "@/lib/app/appTheme";
import { createAiShikiBlockCodeHighlighter, type AiCodeHighlighter } from "@/lib/ai/aiCodeHighlighter";
import { isTauriRuntime } from "@/lib/backend/tauriRuntime";
import { sqlSemanticTableNameSpans } from "@/lib/sql/semantic/model";
import { LEGACY_WEBVIEW_CLASS } from "@/lib/ui/legacyWebView";
export interface CodeSnapshotSource {
code: string;
/** Shiki language name or AI label (e.g. "sql", "python", "JSON"). */
lang: string;
/** Optional title shown in the snapshot bar next to the traffic lights. */
title?: string;
}
export interface CodeSnapshotStyleOptions {
appearance: AppThemeAppearance;
/** Render the macOS-style traffic light dots. Defaults to true. */
showTrafficLights?: boolean;
/** Render line numbers. Defaults to true. */
showLineNumbers?: boolean;
/** Padding (px) around the code area. Defaults to 16. */
padding?: number;
/** Code font size (px). Defaults to 13. */
fontSize?: number;
}
const SNAPSHOT_BACKGROUND: Record<AppThemeAppearance, string> = {
light: "#ffffff",
dark: "#0d1117",
};
const SNAPSHOT_BAR_BACKGROUND: Record<AppThemeAppearance, string> = {
light: "#f6f8fa",
dark: "#161b22",
};
const SNAPSHOT_BAR_TEXT: Record<AppThemeAppearance, string> = {
light: "#57606a",
dark: "#8b949e",
};
const SNAPSHOT_LINE_NUMBER: Record<AppThemeAppearance, string> = {
light: "#d0d7de",
dark: "#484f58",
};
const SNAPSHOT_CODE_TEXT: Record<AppThemeAppearance, string> = {
light: "#24292f",
dark: "#e1e4e8",
};
const SNAPSHOT_TABLE_NAME_COLOR: Record<AppThemeAppearance, string> = {
light: "#116329",
dark: "#7ee787",
};
const SQL_SNAPSHOT_LANGS = new Set(["sql", "mysql", "postgresql", "postgres", "tsql", "clickhouse", "sqlite"]);
const TRAFFIC_LIGHT_COLORS = ["#ff5f57", "#febc2e", "#28c840"] as const;
const MAX_EXPORT_PIXEL_RATIO = 2;
const MAX_EXPORT_CANVAS_EDGE = 16_384;
const MAX_EXPORT_CANVAS_PIXELS = 64 * 1024 * 1024;
/**
* Self-contained stylesheet embedded in every snapshot DOM. Keep it prefix
* namespaced (`dbx-code-snapshot`) so it never leaks into the app chrome.
*/
export const CODE_SNAPSHOT_CSS = `
.dbx-code-snapshot,
.dbx-code-snapshot * {
border: 0;
outline: 0;
}
.dbx-code-snapshot {
border-radius: 8px;
overflow: hidden;
font-family: "SF Mono", "Cascadia Code", "JetBrains Mono", Consolas, "Courier New", monospace;
text-align: left;
box-shadow: 0 8px 24px rgba(0, 0, 0, 0.35);
}
.dbx-code-snapshot__bar {
display: flex;
align-items: center;
gap: 8px;
padding: 10px 14px;
}
.dbx-code-snapshot__dot {
width: 12px;
height: 12px;
border-radius: 50%;
flex: none;
}
.dbx-code-snapshot__title {
margin-left: 4px;
font-size: 12px;
font-weight: 500;
overflow: hidden;
text-overflow: ellipsis;
white-space: nowrap;
}
.dbx-code-snapshot__pre {
margin: 0;
overflow: hidden;
line-height: 1.6;
tab-size: 4;
}
.dbx-code-snapshot__pre code {
font-family: inherit;
font-size: inherit;
background: transparent;
}
.dbx-code-snapshot__pre .line {
display: block;
min-height: 1.6em;
}
.dbx-code-snapshot__line-number {
display: inline-block;
min-width: 2.2em;
margin-right: 1.4em;
text-align: right;
color: var(--dbx-snapshot-line-number, #8b949e);
font-variant-numeric: tabular-nums;
user-select: none;
-webkit-user-select: none;
}
.dbx-code-snapshot__pre--numbered {
counter-reset: dbx-snapshot-line;
}
.dbx-code-snapshot__pre--numbered .line {
counter-increment: dbx-snapshot-line;
}
.dbx-code-snapshot__pre--numbered .line::before {
content: counter(dbx-snapshot-line);
display: inline-block;
min-width: 2.2em;
margin-right: 1.4em;
text-align: right;
color: var(--dbx-snapshot-line-number, #8b949e);
font-variant-numeric: tabular-nums;
user-select: none;
-webkit-user-select: none;
}
`;
let highlighterPromise: Promise<AiCodeHighlighter> | undefined;
/** Lazy singleton reusing the AI assistant's shiki highlighter instance. */
export function getCodeSnapshotHighlighter(): Promise<AiCodeHighlighter> {
highlighterPromise ??= createAiShikiBlockCodeHighlighter({
appearance: () => "dark",
}).catch((err: unknown) => {
// Reset so a transient highlighter failure can be retried on the next
// render instead of permanently poisoning the singleton.
highlighterPromise = undefined;
throw err;
});
return highlighterPromise;
}
function escapeHtml(value: string): string {
return value.replaceAll("&", "&").replaceAll("<", "<").replaceAll(">", ">").replaceAll('"', """).replaceAll("'", "'");
}
function renderEscapedSnapshotLines(value: string): string {
return `<span class="line">${escapeHtml(value).replace(/\r\n|\r|\n/g, '</span><span class="line">')}</span>`;
}
function renderSnapshotBar(title: string | undefined, appearance: AppThemeAppearance, showTrafficLights: boolean): string {
const dots = showTrafficLights ? TRAFFIC_LIGHT_COLORS.map((color) => `<span class="dbx-code-snapshot__dot" style="background:${color}"></span>`).join("") : "";
const titleHtml = title ? `<span class="dbx-code-snapshot__title" style="color:${SNAPSHOT_BAR_TEXT[appearance]}">${escapeHtml(title)}</span>` : "";
return `<div class="dbx-code-snapshot__bar" style="background:${SNAPSHOT_BAR_BACKGROUND[appearance]};color:${SNAPSHOT_BAR_TEXT[appearance]}">${dots}${titleHtml}</div>`;
}
function isSnapshotNumberedLineNode(node: Node): node is Element {
return node instanceof Element && node.classList.contains("line") && node.closest(".dbx-code-snapshot__pre--numbered") !== null;
}
function hasMaterializedLineNumber(line: Element): boolean {
return Array.from(line.children).some((child) => child.classList.contains("dbx-code-snapshot__line-number"));
}
function legacyWebViewExportFallbackEnabled(): boolean {
return typeof document !== "undefined" && document.documentElement.classList.contains(LEGACY_WEBVIEW_CLASS);
}
/**
* Keep preview rendering on CSS counters, but rewrite the cloned export DOM to
* use real line-number nodes. Older WebKit foreignObject exports can flatten
* every counter() value to "1", while the live preview still looks correct.
*/
export function materializeSnapshotCloneLineNumbers(root: ParentNode): void {
for (const block of Array.from(root.querySelectorAll<HTMLElement>(".dbx-code-snapshot__pre--numbered"))) {
block.classList.remove("dbx-code-snapshot__pre--numbered");
const lineNumberColor = block.style.getPropertyValue("--dbx-snapshot-line-number").trim() || SNAPSHOT_LINE_NUMBER.dark;
const lines = Array.from(block.querySelectorAll<HTMLElement>("code > .line"));
for (const [index, line] of lines.entries()) {
if (hasMaterializedLineNumber(line)) continue;
const lineNumber = block.ownerDocument.createElement("span");
lineNumber.className = "dbx-code-snapshot__line-number";
lineNumber.setAttribute("aria-hidden", "true");
lineNumber.textContent = String(index + 1);
lineNumber.style.cssText = ["display:inline-block", "min-width:2.2em", "margin-right:1.4em", "text-align:right", `color:${lineNumberColor}`, "font-variant-numeric:tabular-nums", "user-select:none", "-webkit-user-select:none"].join(";");
const lineContent = block.ownerDocument.createElement("span");
lineContent.className = "dbx-code-snapshot__line-content";
lineContent.style.display = "inline";
while (line.firstChild) {
lineContent.append(line.firstChild);
}
line.append(lineNumber, lineContent);
}
}
}
/**
* Give SQL table names their own color so they stand apart from field
* identifiers — shiki renders quoted table and column identifiers with the
* same string token color, while the editor marks table names semantically.
* The same metadata-free analyzer as the editor's table-name highlight maps
* table spans onto the highlighted HTML; the wrapper carries an inline color,
* so the preview and both export paths (clipboard/PNG clone of this DOM) stay
* identical.
*/
export function applySnapshotSqlTableColors(highlightedBody: string, rawCode: string, appearance: AppThemeAppearance): string {
let tableSpans: Array<{ start: number; end: number }>;
try {
tableSpans = sqlSemanticTableNameSpans(rawCode);
} catch {
return highlightedBody;
}
if (tableSpans.length === 0) return highlightedBody;
const parsed = new DOMParser().parseFromString(`<t>${highlightedBody}</t>`, "text/html");
const root = parsed.body.firstElementChild;
if (!root) return highlightedBody;
// Line starts in the raw code; shiki splits lines into .line elements whose
// text no longer contains the separators, so offsets are mapped per line.
const lineStarts: number[] = [0];
for (let index = 0; index < rawCode.length; index += 1) {
if (rawCode[index] === "\n") lineStarts.push(index + 1);
else if (rawCode[index] === "\r") lineStarts.push(index + (rawCode[index + 1] === "\n" ? 2 : 1));
}
const lineElements = Array.from(root.querySelectorAll<HTMLElement>(".line"));
const rawLines = rawCode.split(/\r\n|\r|\n/);
const color = SNAPSHOT_TABLE_NAME_COLOR[appearance];
const wrapRanges = (textNode: Text, nodeStart: number, clipEnd: number, totalLength: number) => {
const ranges: Array<[number, number]> = [];
for (const span of tableSpans) {
const start = Math.max(span.start, nodeStart);
const end = Math.min(span.end, nodeStart + totalLength, clipEnd);
if (start < end) ranges.push([start - nodeStart, end - nodeStart]);
}
ranges.sort((a, b) => b[0] - a[0]);
for (const [relativeStart, relativeEnd] of ranges) {
if (relativeEnd < totalLength) textNode.splitText(relativeEnd);
const segment = relativeStart > 0 ? textNode.splitText(relativeStart) : textNode;
const wrapper = textNode.ownerDocument!.createElement("span");
wrapper.className = "dbx-code-snapshot__table-name";
wrapper.setAttribute("data-sql-token", "table");
// setAttribute (not style.color) keeps the literal color in the DOM;
// style.color serializes engine-dependently (rgb() in WebKit/Chromium).
wrapper.setAttribute("style", `color:${color}`);
segment.parentNode?.insertBefore(wrapper, segment);
wrapper.appendChild(segment);
}
};
lineElements.forEach((lineElement, lineIndex) => {
const lineStart = lineStarts[lineIndex];
const lineEnd = lineStart + (rawLines[lineIndex]?.length ?? 0);
const walker = lineElement.ownerDocument!.createTreeWalker(lineElement, NodeFilter.SHOW_TEXT);
const textNodes: Text[] = [];
while (walker.nextNode()) textNodes.push(walker.currentNode as Text);
let position = lineStart;
for (const textNode of textNodes) {
const totalLength = textNode.length;
wrapRanges(textNode, position, lineEnd, totalLength);
// splitText keeps the leading part in place; the consumed length is the
// original node's length regardless of how the ranges split it.
position += totalLength;
}
});
return root.innerHTML;
}
/**
* Render a self-contained snapshot DOM (as an HTML string) for the given code.
* The returned string includes its own `<style>` tag and can be injected via
* `v-html`, then exported with `snapshotElementToPng`.
*/
export async function renderCodeSnapshotHtml(source: CodeSnapshotSource, options: CodeSnapshotStyleOptions): Promise<string> {
let body: string;
try {
const highlight = await getCodeSnapshotHighlighter();
body = highlight(source.code, source.lang, options.appearance);
} catch {
// Legacy WebKit can reject regular expressions generated by Shiki.
body = renderEscapedSnapshotLines(source.code);
}
if (SQL_SNAPSHOT_LANGS.has(source.lang.trim().toLowerCase())) {
body = applySnapshotSqlTableColors(body, source.code, options.appearance);
}
const appearance = options.appearance;
const showBar = options.showTrafficLights !== false || !!source.title;
const showLineNumbers = options.showLineNumbers !== false;
const padding = options.padding ?? 16;
const fontSize = options.fontSize ?? 13;
const bar = showBar ? renderSnapshotBar(source.title, appearance, options.showTrafficLights !== false) : "";
const preClass = `dbx-code-snapshot__pre${showLineNumbers ? " dbx-code-snapshot__pre--numbered" : ""}`;
const lineNumberColor = SNAPSHOT_LINE_NUMBER[appearance];
return (
`<style>${CODE_SNAPSHOT_CSS}</style>` +
`<div class="dbx-code-snapshot" data-snapshot-appearance="${appearance}" style="background:${SNAPSHOT_BACKGROUND[appearance]};font-size:${fontSize}px">` +
bar +
`<pre class="${preClass}" style="--dbx-snapshot-line-number:${lineNumberColor};color:${SNAPSHOT_CODE_TEXT[appearance]};padding:0 ${padding}px ${padding}px"><code>${body}</code></pre>` +
`</div>`
);
}
/** Convert a snapshot DOM element into a PNG data URL. */
export async function snapshotElementToPng(element: HTMLElement): Promise<string> {
const domtoimage = (await import("dom-to-image-more")).default;
// 预览区允许滚动,因此导出尺寸必须覆盖完整内容,而不是只取当前可见宽度。
const rect = typeof element.getBoundingClientRect === "function" ? element.getBoundingClientRect() : null;
let borderTop = 0;
let borderBottom = 0;
if (typeof window !== "undefined" && typeof window.getComputedStyle === "function" && element instanceof (window.Element || Object)) {
try {
const computedStyle = window.getComputedStyle(element);
borderTop = parseFloat(computedStyle.borderTopWidth) || 0;
borderBottom = parseFloat(computedStyle.borderBottomWidth) || 0;
} catch {
// Ignored for non-DOM elements in test runners
}
}
let width = Math.max(element.offsetWidth || 0, element.scrollWidth || 0, rect ? Math.ceil(rect.width) : 0);
let height = Math.max(element.offsetHeight || 0, element.scrollHeight || 0, (element.scrollHeight || 0) + Math.ceil(borderTop + borderBottom), rect ? Math.ceil(rect.height) : 0);
if (rect && typeof element.querySelector === "function") {
// If element contains table rows, ensure height fully encloses the bottom edge of the last row
const lastRow = element.querySelector("tr:last-child");
if (lastRow && typeof lastRow.getBoundingClientRect === "function") {
const rowRect = lastRow.getBoundingClientRect();
const requiredHeight = Math.ceil(rowRect.bottom - rect.top) + Math.ceil(borderBottom);
if (requiredHeight > height) {
height = requiredHeight;
}
}
}
const basePixels = width * height;
const targetScale = Math.min(MAX_EXPORT_PIXEL_RATIO, Math.max(1, typeof window === "undefined" ? 1 : window.devicePixelRatio || 1));
// Keep the output canvas within browser limits without rejecting a larger
// source layout. Wide grids can still be captured safely by rasterizing the
// full DOM at a reduced scale.
const scale = Math.min(targetScale, MAX_EXPORT_CANVAS_EDGE / width, MAX_EXPORT_CANVAS_EDGE / height, Math.sqrt(MAX_EXPORT_CANVAS_PIXELS / basePixels));
const useLegacyLineNumberFallback = legacyWebViewExportFallbackEnabled();
const isGridSnapshot = typeof element.classList?.contains === "function" && element.classList.contains("dbx-grid-snapshot");
const hasOnclone = useLegacyLineNumberFallback || isGridSnapshot;
return domtoimage.toPng(element, {
quality: 1,
width,
height,
// dom-to-image-more 使用 scale 放大实际画布;pixelRatio 不是该库支持的参数。
scale,
adjustPseudoElement: useLegacyLineNumberFallback
? (node: Node, pseudoElement: ":before" | ":after") => {
if (pseudoElement === ":before" && isSnapshotNumberedLineNode(node)) {
return false;
}
return undefined;
}
: undefined,
onclone: hasOnclone
? (clone: Node) => {
if (useLegacyLineNumberFallback && typeof (clone as ParentNode).querySelectorAll === "function") {
materializeSnapshotCloneLineNumbers(clone as ParentNode);
}
if (isGridSnapshot && clone && (clone as HTMLElement).style) {
// Prevent rigid fixed height from clipping table rows inside overflow:hidden
(clone as HTMLElement).style.height = "auto";
(clone as HTMLElement).style.minHeight = `${height}px`;
}
}
: undefined,
style: {
width: `${width}px`,
height: `${height}px`,
},
});
}
async function dataUrlToBlob(dataUrl: string): Promise<Blob> {
return await (await fetch(dataUrl)).blob();
}
/**
* Copy a PNG data URL to the system clipboard. Uses the Tauri
* clipboard-manager `writeImage` on desktop and falls back to the Web
* Clipboard API (`ClipboardItem`) for web mode.
*/
export async function copyPngDataUrlToClipboard(dataUrl: string): Promise<void> {
const blob = await dataUrlToBlob(dataUrl);
if (isTauriRuntime()) {
const { writeImage } = await import("@tauri-apps/plugin-clipboard-manager");
await writeImage(new Uint8Array(await blob.arrayBuffer()));
return;
}
if (typeof ClipboardItem !== "undefined" && navigator.clipboard?.write) {
await navigator.clipboard.write([new ClipboardItem({ "image/png": blob })]);
return;
}
throw new Error("Clipboard image write is not supported in this environment");
}
/**
* Save a PNG data URL to a file. On desktop this opens the native save
* dialog; on web it downloads the image. Returns false when the user
* cancels the native save dialog.
*/
export async function savePngDataUrlToFile(dataUrl: string, defaultName: string): Promise<boolean> {
const blob = await dataUrlToBlob(dataUrl);
if (isTauriRuntime()) {
const { save } = await import("@tauri-apps/plugin-dialog");
const { writeFile } = await import("@tauri-apps/plugin-fs");
const path = await save({
defaultPath: defaultName,
filters: [{ name: "PNG", extensions: ["png"] }],
});
if (!path) return false;
// Native write errors must reach the caller so the UI never claims the
// user-selected path was saved when the filesystem rejected it.
await writeFile(path, new Uint8Array(await blob.arrayBuffer()));
return true;
}
const url = URL.createObjectURL(blob);
try {
const a = document.createElement("a");
a.href = url;
a.download = defaultName;
a.click();
} finally {
URL.revokeObjectURL(url);
}
return true;
}