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.9 KB
Raw Blame
import { describe, expect, it } from "vitest";
import { currentStatementFrameRangeTo } from "@/lib/sql/currentStatementFrame";
import type { SqlTextRange } from "@/lib/sql/sqlStatementRanges";

function frameDocument(sql: string) {
  return {
    length: sql.length,
    sliceString: (from: number, to: number) => sql.slice(from, to),
  };
}

describe("currentStatementFrameRangeTo", () => {
  it("includes a directly adjacent trailing semicolon in frame width calculations", () => {
    const sql = "SELECT 1;";
    const range: SqlTextRange = { from: 0, to: "SELECT 1".length, sql: "SELECT 1" };
    expect(currentStatementFrameRangeTo(frameDocument(sql), range)).toBe(sql.length);
  });

  it("includes a trailing semicolon on its own line", () => {
    const sql = "SELECT 1\n;\n\nSELECT 2;";
    const range: SqlTextRange = { from: 0, to: "SELECT 1".length, sql: "SELECT 1" };
    expect(currentStatementFrameRangeTo(frameDocument(sql), range)).toBe(sql.indexOf(";") + 1);
  });

  it("does not extend the frame across a comment before a later semicolon", () => {
    const sql = "SELECT 1\n-- comment\n;";
    const range: SqlTextRange = { from: 0, to: "SELECT 1".length, sql: "SELECT 1" };
    expect(currentStatementFrameRangeTo(frameDocument(sql), range)).toBe(range.to);
  });

  it("does not extend the frame across a blank line before a later semicolon", () => {
    const sql = "SELECT 1\n\n;";
    const range: SqlTextRange = { from: 0, to: "SELECT 1".length, sql: "SELECT 1" };
    expect(currentStatementFrameRangeTo(frameDocument(sql), range)).toBe(range.to);
  });

  it("does not extend the frame when the next non-whitespace character is not a semicolon", () => {
    const sql = "SELECT 1\n\nSELECT 2";
    const range: SqlTextRange = { from: 0, to: "SELECT 1".length, sql: "SELECT 1" };
    expect(currentStatementFrameRangeTo(frameDocument(sql), range)).toBe(range.to);
  });
});