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。

6.5 KB
Raw Blame
import { describe, expect, it } from "vitest";
import type { ConnectionConfig } from "@/types/database";
import { connectionConfigFingerprint, databaseInfoCopyText, databaseInfoRows, isTauriCommandUnavailable, normalizeConnectionTestResult, supportsConnectionDatabaseInfo } from "@/lib/connection/connectionDatabaseInfo";

function config(overrides: Partial<ConnectionConfig> = {}): ConnectionConfig {
  return {
    id: "connection-1",
    name: "Local H2",
    db_type: "h2",
    driver_label: "H2",
    host: "127.0.0.1",
    port: 9092,
    username: "sa",
    password: "secret",
    ...overrides,
  };
}

describe("connectionDatabaseInfo", () => {
  it.each(["pg", "oracle", "mysql", "sqlserver", "future_mode"])("preserves %s compatibility metadata across connection testing and persistence", (mode) => {
    const original = config({ db_type: "kingbase" });
    const result = normalizeConnectionTestResult({ message: "ok", databaseInfo: { compatibilityMode: ` ${mode} `, productVersion: "V009R001" } }, original);
    expect(result.databaseInfo?.compatibilityMode).toBe(mode);
    const stored = JSON.parse(JSON.stringify({ ...original, database_info: result.databaseInfo })) as ConnectionConfig;
    expect(stored.database_info?.compatibilityMode).toBe(mode);
    expect(connectionConfigFingerprint(stored)).toBe(connectionConfigFingerprint(original));
  });

  it("hides database information for connections without database metadata", () => {
    for (const dbType of ["dynamodb", "elasticsearch", "easysearch", "meilisearch", "solr", "qdrant", "weaviate", "chromadb", "etcd", "zookeeper", "nacos", "consul", "mq", "mqtt", "victoriametrics"] as const) {
      expect(supportsConnectionDatabaseInfo(dbType)).toBe(false);
    }
    for (const dbType of ["mysql", "redis", "mongodb", "milvus", "turso", "cloudflare-d1", "plugin"] as const) {
      expect(supportsConnectionDatabaseInfo(dbType)).toBe(true);
    }
  });

  it("normalizes structured and legacy responses with a configured product fallback", () => {
    expect(normalizeConnectionTestResult("Connection successful", config())).toEqual({
      message: "Connection successful",
      databaseInfo: { productName: "H2" },
    });
    expect(normalizeConnectionTestResult("Connection successful", config({ database: "app" })).databaseInfo).toMatchObject({
      productName: "H2",
      currentDatabase: "app",
    });
    expect(
      normalizeConnectionTestResult(
        {
          message: "Connection successful",
          databaseInfo: {
            productName: "  H2  ",
            productVersion: " 2.2.224 ",
            currentDatabase: " testdb ",
            serverCharset: " utf8mb4 ",
            driverName: " ",
            unquotedIdentifierCase: "UPPER",
          },
        },
        config(),
      ).databaseInfo,
    ).toEqual({
      productName: "H2",
      productVersion: "2.2.224",
      currentDatabase: "testdb",
      serverComment: undefined,
      serverCharset: "utf8mb4",
      serverCollation: undefined,
      unquotedIdentifierCase: "upper",
      quotedIdentifierCase: undefined,
      driverName: undefined,
      driverVersion: undefined,
      jdbcVersion: undefined,
    });
  });

  it("fingerprints connection-affecting config without depending on object key order", () => {
    const original = config({ transport_layers: [{ id: "ssh", type: "ssh", host: "jump", port: 22, user: "root", password: "hop-secret" }] });
    const reordered = Object.fromEntries(Object.entries(original).reverse()) as unknown as ConnectionConfig;
    expect(connectionConfigFingerprint(reordered)).toBe(connectionConfigFingerprint(original));
    expect(connectionConfigFingerprint({ ...original, password: "changed" })).not.toBe(connectionConfigFingerprint(original));
    expect(connectionConfigFingerprint({ ...original, name: "Renamed" })).not.toBe(connectionConfigFingerprint(original));
    expect(connectionConfigFingerprint({ ...original, transport_layers: [{ ...original.transport_layers![0], host: "other-jump" }] })).not.toBe(connectionConfigFingerprint(original));
    expect(connectionConfigFingerprint(original, "")).not.toBe(connectionConfigFingerprint(original, original.name));
    expect(connectionConfigFingerprint({ ...original, database_info: { productName: "MySQL", productVersion: "8.4.0" } })).toBe(connectionConfigFingerprint(original));
    expect(connectionConfigFingerprint({ ...original, note: "Production reporting" })).toBe(connectionConfigFingerprint(original));
    expect(connectionConfigFingerprint({ ...original, default_schema: "archive" })).toBe(connectionConfigFingerprint(original));
    expect(connectionConfigFingerprint({ ...original, sidebar_auto_load_all_tables: true })).toBe(connectionConfigFingerprint(original));
    expect(connectionConfigFingerprint({ ...original, show_database_links: false })).toBe(connectionConfigFingerprint(original));
    expect(connectionConfigFingerprint({ ...original, show_native_jobs: false, show_user_admin: true })).toBe(connectionConfigFingerprint(original));
    expect(connectionConfigFingerprint({ ...original, jdbc_dialect: "oceanbase-oracle" })).toBe(connectionConfigFingerprint(original));
  });

  it("formats only database metadata for rows and copied text", () => {
    const info = normalizeConnectionTestResult(
      {
        message: "ok",
        databaseInfo: { productName: "H2", currentDatabase: "app", driverName: "H2 JDBC Driver", jdbcVersion: "4.2" },
      },
      config(),
    ).databaseInfo!;
    const copy = databaseInfoCopyText(
      info,
      (field) => field,
      (value) => value,
    );

    expect(databaseInfoRows(info).map((row) => row.key)).toEqual(["productName", "currentDatabase", "driverName", "jdbcVersion"]);
    expect(copy).toContain("productName: H2");
    expect(copy).toContain("currentDatabase: app");
    expect(copy).not.toContain("127.0.0.1");
    expect(copy).not.toContain("secret");
    expect(copy).not.toContain("connection_string");
  });

  it("recognizes only explicit missing-command errors for Tauri fallback", () => {
    expect(isTauriCommandUnavailable("Command test_connection_with_info not found", "test_connection_with_info")).toBe(true);
    expect(isTauriCommandUnavailable("unknown command 'test_connection_with_info'", "test_connection_with_info")).toBe(true);
    expect(isTauriCommandUnavailable("Authentication failed", "test_connection_with_info")).toBe(false);
    expect(isTauriCommandUnavailable("Command test_connection not found", "test_connection_with_info")).toBe(false);
    expect(isTauriCommandUnavailable("Database not found while invoking command test_connection_with_info", "test_connection_with_info")).toBe(false);
  });
});