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.2 KB
Raw Blame
import { describe, expect, it } from "vitest";
import { buildSqlCompletionItems } from "@/lib/sql/sqlCompletion";

describe("MySQL keyword completion", () => {
  function labelsFor(prefix: string, databaseType: "mysql" | "postgres" = "mysql"): string[] {
    return buildSqlCompletionItems(prefix, prefix.length, {
      databaseType,
      tables: [],
      columnsByTable: new Map(),
    }).map((item) => item.label);
  }

  // Regression for #13008: `SHOW BINARY LOGS` and `SHOW BINLOG EVENTS` had no
  // candidates at all, because neither phrase existed in MYSQL_SQL_KEYWORDS.
  it.each([
    ["logs", "BINARY LOGS"],
    ["binlog", "BINLOG EVENTS"],
    ["events", "BINLOG EVENTS"],
  ])("offers %s as the %s phrase", (prefix, phrase) => {
    expect(labelsFor(prefix)).toContain(phrase);
  });

  it("offers the REGEXP and RLIKE pattern operators", () => {
    expect(labelsFor("regexp")[0]).toBe("REGEXP");
    expect(labelsFor("rlike")).toContain("RLIKE");
  });

  it("keeps the MySQL-only phrases out of other dialects", () => {
    expect(labelsFor("binlog", "postgres")).not.toContain("BINLOG EVENTS");
    expect(labelsFor("logs", "postgres")).not.toContain("BINARY LOGS");
    expect(labelsFor("rlike", "postgres")).not.toContain("RLIKE");
  });
});