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。
TypeScript aicliclickhousedatabasedatabase-clientdatabase-managementdockerguimcpmongodbmysqlpostgresqlredisrustsql-serversqlitetaurivue
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);
});
});