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。

969 B
Raw Blame
import { describe, expect, it } from "vitest";
import { buildSqlCompletionItems } from "@/lib/sql/sqlCompletion";

describe("SQL Server T-SQL keyword completion", () => {
  function labelsFor(prefix: string): string[] {
    return buildSqlCompletionItems(prefix, prefix.length, {
      databaseType: "sqlserver",
      tables: [],
      columnsByTable: new Map(),
    }).map((item) => item.label);
  }

  it("offers DECLARE ahead of DECIMAL for the decl prefix (issue #9319)", () => {
    const labels = labelsFor("decl");

    expect(labels).toContain("DECLARE");
    expect(labels).toContain("DECIMAL");
    expect(labels.indexOf("DECLARE")).toBeLessThan(labels.indexOf("DECIMAL"));
  });

  it.each(["declare", "exec", "print", "raiserror", "waitfor", "throw", "isnull", "getdate", "newid", "scope_identity", "error_message"])("offers %s for a SQL Server batch", (keyword) => {
    expect(labelsFor(keyword.slice(0, -1))).toContain(keyword.toUpperCase());
  });
});