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。

4.4 KB
Raw Blame
import { describe, expect, it } from "vitest";
import {
  databaseConnectionFormKind,
  databaseDefaultPort,
  databaseManifestEntry,
  databaseProductCapabilities,
  databaseRuntimeMode,
  databaseTransferSupportLevel,
  supportsDatabaseCompareMode,
  supportsDatabaseFeature,
  usesAgentCursorForQuery,
  usesAgentCursorForTableData,
} from "@/lib/database/databaseDriverManifest";

describe("databaseDriverManifest", () => {
  it("advertises implemented Xugu capabilities without enabling unsupported features", () => {
    expect(databaseProductCapabilities("xugu")).toEqual({
      queryExecution: true,
      metadataBrowse: true,
      objectBrowser: true,
      objectSource: true,
      schemaSearch: true,
      diagram: true,
      tableDataEdit: true,
      tableStructureEdit: true,
      tableImport: true,
      dataTransfer: true,
      sqlFileExecution: true,
      databaseCreate: false,
      fieldLineage: true,
      sqlExplain: true,
      userAdmin: true,
      driverManagement: true,
    });
    for (const capability of ["objectSource", "tableDataEdit", "userAdmin", "sqlExplain"] as const) {
      expect(supportsDatabaseFeature("xugu", capability), capability).toBe(true);
    }
  });

  it("uses result cursors for agent, external, and native DuckDB queries", () => {
    expect(databaseRuntimeMode("gaussdb")).toBe("native");
    expect(databaseRuntimeMode("meilisearch")).toBe("native");
    expect(databaseRuntimeMode("dynamodb")).toBe("native");
    expect(usesAgentCursorForQuery("gaussdb")).toBe(false);
    expect(usesAgentCursorForQuery("meilisearch")).toBe(false);
    expect(usesAgentCursorForQuery("dynamodb")).toBe(false);
    expect(usesAgentCursorForQuery("mysql")).toBe(false);
    expect(usesAgentCursorForQuery("duckdb")).toBe(true);
    expect(usesAgentCursorForQuery("cassandra")).toBe(true);
    expect(usesAgentCursorForQuery("jdbc")).toBe(true);
    expect(usesAgentCursorForQuery("prestosql")).toBe(true);
    expect(usesAgentCursorForQuery("sqlserver")).toBe(false);
    expect(usesAgentCursorForQuery("sqlserver", "sqlserver-legacy")).toBe(true);
    expect(usesAgentCursorForQuery("sqlserver", " SQLSERVER-LEGACY ")).toBe(true);
  });

  it("limits table-data agent cursors to Cassandra and SQL Server legacy", () => {
    expect(usesAgentCursorForTableData("cassandra")).toBe(true);
    expect(usesAgentCursorForTableData("sqlserver", "sqlserver-legacy")).toBe(true);
    expect(usesAgentCursorForTableData("sqlserver")).toBe(false);
    expect(usesAgentCursorForTableData("jdbc")).toBe(false);
    expect(usesAgentCursorForTableData("prestosql")).toBe(false);
  });

  it("exposes connection defaults from the shared manifest", () => {
    expect(databaseDefaultPort("mysql")).toBe(3306);
    expect(databaseManifestEntry("h2")).toMatchObject({
      dbType: "h2",
      runtimeMode: "agent",
      agentKey: "h2",
      skipTcpProbe: true,
      localFile: true,
    });
  });

  it("exposes transfer compatibility evidence from the shared manifest", () => {
    expect(databaseTransferSupportLevel("mysql")).toBe("verified");
    expect(databaseTransferSupportLevel("kingbase")).toBe("family-compatible");
    expect(databaseTransferSupportLevel("db2")).toBe("best-effort");
    expect(databaseTransferSupportLevel("gbase")).toBeUndefined();
  });

  it("exposes schema and data comparison support from the shared manifest", () => {
    expect(supportsDatabaseCompareMode("mysql", "schema")).toBe(true);
    expect(supportsDatabaseCompareMode("kingbase", "data")).toBe(true);
    expect(supportsDatabaseCompareMode("mongodb", "data")).toBe(false);
    expect(supportsDatabaseCompareMode("redis", "schema")).toBe(false);
  });

  it("offers only the supported NebulaGraph 3.x profile", () => {
    expect(databaseManifestEntry("nebula")?.driverProfiles).toEqual([{ profile: "nebula-v3", agentKey: "nebula", label: "NebulaGraph 3.x", storeVisible: false }]);
  });

  it("routes only specialized connection forms explicitly", () => {
    expect(databaseConnectionFormKind("mysql")).toBe("standard");
    expect(databaseConnectionFormKind("jdbc")).toBe("jdbc");
    expect(databaseConnectionFormKind("mq")).toBe("mq");
    expect(databaseConnectionFormKind("mqtt")).toBe("mqtt");
    expect(databaseConnectionFormKind("nacos")).toBe("nacos");
  });

  it("advertises tableDataEdit capability for InterSystems IRIS / Caché (#11808)", () => {
    expect(supportsDatabaseFeature("iris", "tableDataEdit")).toBe(true);
  });
});