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。

7.1 KB
Raw Blame
import { describe, expect, it } from "vitest";
import {
  ACCESS_AGENT_MIN_CONNECT_TIMEOUT_SECS,
  AGENT_DRIVER_MIN_CONNECT_TIMEOUT_SECS,
  connectionAttemptOriginalErrorMessage,
  connectionAttemptTimeoutMessage,
  connectionAttemptTimeoutMs,
  CONNECTION_ATTEMPT_TIMEOUT_BUFFER_MS,
  MONGO_LEGACY_FALLBACK_TIMEOUT_BUFFER_MS,
  MONGO_OIDC_BROWSER_AUTH_TIMEOUT_MS,
} from "@/lib/connection/connectionAttemptTimeout";

describe("connectionAttemptTimeout", () => {
  it("uses a 10s default for regular database connections", () => {
    expect(connectionAttemptTimeoutMs({ db_type: "mysql", connect_timeout_secs: undefined, transport_layers: [] })).toBe(12_000);
  });

  it("keeps explicit regular database timeout values", () => {
    expect(connectionAttemptTimeoutMs({ db_type: "mysql", connect_timeout_secs: 5, transport_layers: [] })).toBe(7_000);
  });

  it("uses a 30s agent startup floor", () => {
    expect(connectionAttemptTimeoutMs({ db_type: "oracle", connect_timeout_secs: 5, transport_layers: [] })).toBe(AGENT_DRIVER_MIN_CONNECT_TIMEOUT_SECS * 1000 + CONNECTION_ATTEMPT_TIMEOUT_BUFFER_MS);
  });

  it("uses the startup floor for PrestoSQL JDBC plugin connections", () => {
    expect(connectionAttemptTimeoutMs({ db_type: "prestosql", connect_timeout_secs: 5, transport_layers: [] })).toBe(AGENT_DRIVER_MIN_CONNECT_TIMEOUT_SECS * 1000 + CONNECTION_ATTEMPT_TIMEOUT_BUFFER_MS);
  });

  it("uses the startup floor for Impala agent connections", () => {
    expect(connectionAttemptTimeoutMs({ db_type: "impala", connect_timeout_secs: 5, transport_layers: [] })).toBe(AGENT_DRIVER_MIN_CONNECT_TIMEOUT_SECS * 1000 + CONNECTION_ATTEMPT_TIMEOUT_BUFFER_MS);
  });

  it("uses the startup floor for Kyuubi agent connections", () => {
    expect(connectionAttemptTimeoutMs({ db_type: "kyuubi", connect_timeout_secs: 5, transport_layers: [] })).toBe(AGENT_DRIVER_MIN_CONNECT_TIMEOUT_SECS * 1000 + CONNECTION_ATTEMPT_TIMEOUT_BUFFER_MS);
  });

  it("uses the startup floor for generic JDBC plugin connections", () => {
    expect(connectionAttemptTimeoutMs({ db_type: "jdbc", connect_timeout_secs: 5, transport_layers: [] })).toBe(AGENT_DRIVER_MIN_CONNECT_TIMEOUT_SECS * 1000 + CONNECTION_ATTEMPT_TIMEOUT_BUFFER_MS);
  });

  it("uses the startup floor for ZooKeeper agent connections", () => {
    expect(connectionAttemptTimeoutMs({ db_type: "zookeeper", connect_timeout_secs: 5, transport_layers: [] })).toBe(AGENT_DRIVER_MIN_CONNECT_TIMEOUT_SECS * 1000 + CONNECTION_ATTEMPT_TIMEOUT_BUFFER_MS);
  });

  it("uses the startup floor for Cloud Spanner agent connections", () => {
    expect(connectionAttemptTimeoutMs({ db_type: "spanner", connect_timeout_secs: 5, transport_layers: [] })).toBe(AGENT_DRIVER_MIN_CONNECT_TIMEOUT_SECS * 1000 + CONNECTION_ATTEMPT_TIMEOUT_BUFFER_MS);
  });

  it("uses a 30s Access agent startup floor", () => {
    expect(connectionAttemptTimeoutMs({ db_type: "access", connect_timeout_secs: 5, transport_layers: [] })).toBe(ACCESS_AGENT_MIN_CONNECT_TIMEOUT_SECS * 1000 + CONNECTION_ATTEMPT_TIMEOUT_BUFFER_MS);
  });

  it("respects a user configured Access timeout above the default floor", () => {
    expect(connectionAttemptTimeoutMs({ db_type: "access", connect_timeout_secs: 45, transport_layers: [] })).toBe(47_000);
  });

  it("keeps the legacy fallback buffer for regular MongoDB connections", () => {
    expect(connectionAttemptTimeoutMs({ db_type: "mongodb", connect_timeout_secs: 5, transport_layers: [] })).toBe(5_000 + CONNECTION_ATTEMPT_TIMEOUT_BUFFER_MS + MONGO_LEGACY_FALLBACK_TIMEOUT_BUFFER_MS);
  });

  it("allows the MongoDB OIDC browser flow to use its full five-minute budget", () => {
    expect(
      connectionAttemptTimeoutMs({
        db_type: "mongodb",
        connect_timeout_secs: 5,
        transport_layers: [],
        connection_string: "mongodb+srv://cluster.example.com/app?authMechanism=MONGODB-OIDC&authSource=%24external",
      }),
    ).toBe(5_000 + CONNECTION_ATTEMPT_TIMEOUT_BUFFER_MS + MONGO_OIDC_BROWSER_AUTH_TIMEOUT_MS);
  });

  it("adds HTTP tunnel setup and tunneled endpoint probe budgets", () => {
    expect(
      connectionAttemptTimeoutMs({
        db_type: "mysql",
        connect_timeout_secs: 5,
        transport_layers: [
          {
            type: "http_tunnel",
            id: "http",
            url: "https://dbx.example.com/dbx_tunnel.php",
            connect_timeout_secs: 25,
          },
        ],
      }),
    ).toBe(37_000);
  });

  it("adds SSH setup and tunneled endpoint probe budgets", () => {
    expect(
      connectionAttemptTimeoutMs({
        db_type: "postgres",
        connect_timeout_secs: 10,
        transport_layers: [
          {
            type: "ssh",
            id: "ssh",
            host: "bastion.example.com",
            port: 22,
            user: "dbx",
            connect_timeout_secs: 5,
          },
        ],
      }),
    ).toBe(27_000);
  });

  it("uses resolved shared SSH profile settings instead of reference stub defaults", () => {
    const profile = {
      type: "ssh" as const,
      id: "shared-ssh",
      name: "Slow bastion",
      host: "bastion.example.com",
      port: 22,
      user: "dbx",
      connect_timeout_secs: 40,
    };

    expect(
      connectionAttemptTimeoutMs(
        {
          db_type: "redis",
          connect_timeout_secs: 5,
          transport_layers: [
            {
              type: "ssh",
              id: "connection-hop",
              profile_id: profile.id,
              host: "",
              port: 22,
              user: "root",
              connect_timeout_secs: 5,
            },
          ],
        },
        (profileId) => (profileId === profile.id ? profile : undefined),
      ),
    ).toBe(52_000);
  });

  it("keeps disabled shared layers outside the attempt deadline", () => {
    expect(
      connectionAttemptTimeoutMs(
        {
          db_type: "redis",
          connect_timeout_secs: 5,
          transport_layers: [
            {
              type: "ssh",
              id: "connection-hop",
              profile_id: "shared-ssh",
              enabled: false,
              host: "",
              port: 22,
              user: "root",
              connect_timeout_secs: 5,
            },
          ],
        },
        () => ({
          type: "ssh",
          id: "shared-ssh",
          host: "bastion.example.com",
          port: 22,
          user: "dbx",
          connect_timeout_secs: 40,
        }),
      ),
    ).toBe(7_000);
  });

  it("ignores disabled transport layer timeouts", () => {
    expect(
      connectionAttemptTimeoutMs({
        db_type: "mysql",
        connect_timeout_secs: 5,
        transport_layers: [
          {
            type: "http_tunnel",
            id: "http",
            enabled: false,
            url: "https://dbx.example.com/dbx_tunnel.php",
            connect_timeout_secs: 60,
          },
        ],
      }),
    ).toBe(7_000);
  });

  it("adds late original database errors to timeout messages", () => {
    const timeoutMessage = connectionAttemptTimeoutMessage(7_000);

    expect(connectionAttemptOriginalErrorMessage(timeoutMessage, "MySQL connection failed: os error 10060")).toContain("MySQL connection failed: os error 10060");
  });
});