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.1 KB
Raw Blame
import { strict as assert } from "node:assert";
import { test } from "vitest";
import * as langSql from "@codemirror/lang-sql";
import { sqlSemanticTableNameSpansForSyntaxTree } from "../../apps/desktop/src/lib/editor/codemirrorSqlSemanticHighlight.ts";
import { expandToSqlStatementWindow } from "../../apps/desktop/src/lib/sql/insertValueHints.ts";

test.each([
  ["string", `'${"x".repeat(40 * 1024)} FROM fake'`],
  ["block comment", `/* ${"x".repeat(40 * 1024)} FROM fake */`],
])("preserves %s context when the highlight window starts inside it", (_name, suppressedSql) => {
  const sql = `SELECT ${suppressedSql} AS payload;\nSELECT * FROM real_table;`;
  const realTable = sql.indexOf("real_table");
  const window = expandToSqlStatementWindow(sql, realTable, realTable + "real_table".length);
  const tree = langSql.StandardSQL.language.parser.parse(sql);

  assert.ok(window.from > sql.indexOf(suppressedSql));
  assert.deepEqual(
    sqlSemanticTableNameSpansForSyntaxTree(sql, window, tree).map((span) => sql.slice(span.start, span.end)),
    ["real_table"],
  );
});