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。

3.0 KB
Raw Blame
import { describe, expect, it, vi } from "vitest";
import { installRegisteredManagedJdbcDriver, managedJdbcDriverDefinition, managedJdbcDriverRows } from "@/lib/database/managedJdbcDrivers";
import { PHOENIX_MANAGED_MAVEN_COORDINATES } from "@/lib/database/phoenixBuiltinDriver";
import { PRESTOSQL_JDBC_DRIVER_COORDINATE } from "@/lib/database/prestoSqlBuiltinDriver";
import type { JdbcDriverInfo, JdbcMavenBundleInfo, JdbcPluginStatus } from "@/types/database";

function pluginStatus(): JdbcPluginStatus {
  return {
    installed: true,
    version: "1.0.0",
    protocol_version: 1,
    compatible: true,
    latest_version: null,
    latest_protocol_version: null,
    update_available: false,
    path: "/plugins/jdbc",
  };
}

describe("managedJdbcDrivers", () => {
  it("registers Phoenix and PrestoSQL through the same row model", () => {
    expect(managedJdbcDriverDefinition("phoenix")?.bundles.map(({ coordinate }) => coordinate)).toEqual(PHOENIX_MANAGED_MAVEN_COORDINATES);
    expect(managedJdbcDriverDefinition("prestosql")?.bundles.map(({ coordinate }) => coordinate)).toEqual([PRESTOSQL_JDBC_DRIVER_COORDINATE]);
    expect(managedJdbcDriverRows([], pluginStatus()).map(({ db_type }) => db_type)).toEqual(["prestosql", "phoenix"]);
  });

  it("marks both managed drivers installed when the offline payload contains every bundle", () => {
    const coordinates = [PRESTOSQL_JDBC_DRIVER_COORDINATE, ...PHOENIX_MANAGED_MAVEN_COORDINATES];
    const bundles = coordinates.map((coordinate): JdbcMavenBundleInfo => ({
      id: coordinate.replace(/[^A-Za-z0-9.-]/g, "_"),
      coordinate,
      scope: "runtime",
      repositories: ["https://repo.maven.apache.org/maven2/"],
      installed_at: "2026-08-14T00:00:00Z",
      path: `/plugins/jdbc/drivers/maven/${coordinate}`,
      artifacts: [],
    }));

    expect(managedJdbcDriverRows(bundles, pluginStatus()).map(({ db_type, installed }) => ({ db_type, installed }))).toEqual([
      { db_type: "prestosql", installed: true },
      { db_type: "phoenix", installed: true },
    ]);
  });

  it("installs PrestoSQL through the generic Maven resolver", async () => {
    const installed: JdbcMavenBundleInfo = {
      id: "io.prestosql_presto-jdbc_350",
      coordinate: PRESTOSQL_JDBC_DRIVER_COORDINATE,
      scope: "runtime",
      repositories: ["https://repo.maven.apache.org/maven2/"],
      installed_at: "2026-08-06T00:00:00Z",
      path: "/drivers/presto",
      artifacts: [],
    };
    const installJdbcDriverFromMaven = vi.fn(async () => [] as JdbcDriverInfo[]);
    const result = await installRegisteredManagedJdbcDriver("prestosql", [], pluginStatus(), {
      installJdbcPlugin: vi.fn(async () => pluginStatus()),
      installJdbcDriverFromMaven,
      listJdbcMavenBundles: vi.fn(async () => [installed]),
      deleteJdbcMavenBundle: vi.fn(async () => [] as JdbcDriverInfo[]),
    });

    expect(installJdbcDriverFromMaven).toHaveBeenCalledWith(PRESTOSQL_JDBC_DRIVER_COORDINATE, ["https://repo.maven.apache.org/maven2/"]);
    expect(result?.bundles).toEqual([installed]);
  });
});