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 { getTableMetadataCapabilities, isStructureMetadataTabSupported } from "@/lib/table/tableMetadataCapabilities";
describe("tableMetadataCapabilities", () => {
it.each(["oracle", "oceanbase-oracle", "dameng"] as const)("keeps legacy %s JDBC facets while hiding unsupported exact facets", (type) => {
const legacy = getTableMetadataCapabilities(type);
expect(getTableMetadataCapabilities(type, { connectionType: "jdbc" })).toEqual(legacy);
expect(getTableMetadataCapabilities(type, { connectionType: type, exactIdentity: true })).toEqual(legacy);
expect(getTableMetadataCapabilities(type, { connectionType: "jdbc", exactIdentity: true })).toEqual({ ...legacy, foreignKeys: false, constraints: false, triggers: false, partitions: false });
});
it("exposes only collection indexes for MongoDB table information", () => {
expect(getTableMetadataCapabilities("mongodb")).toEqual({
columns: false,
indexes: true,
foreignKeys: false,
constraints: false,
triggers: false,
partitions: false,
ddl: false,
});
});
it("exposes only describe fields for Salesforce objects", () => {
// An SObject has no index, foreign key, trigger or DDL metadata; only the
// describe payload (fields) is real, so every other structure tab stays off
// instead of rendering permanently empty.
expect(getTableMetadataCapabilities("salesforce")).toEqual({
columns: true,
indexes: false,
foreignKeys: false,
constraints: false,
triggers: false,
partitions: false,
ddl: false,
});
});
it("exposes structured constraints only for dialects that implement list_constraints", () => {
expect(getTableMetadataCapabilities("oracle").constraints).toBe(true);
expect(getTableMetadataCapabilities("oceanbase-oracle").constraints).toBe(true);
expect(getTableMetadataCapabilities("oceanbase-mysql").constraints).toBe(false);
expect(getTableMetadataCapabilities("postgres").constraints).toBe(true);
expect(getTableMetadataCapabilities("kingbase").constraints).toBe(true);
expect(getTableMetadataCapabilities("vastbase").constraints).toBe(true);
expect(getTableMetadataCapabilities("opengauss").constraints).toBe(true);
expect(getTableMetadataCapabilities("sqlserver").constraints).toBe(true);
expect(getTableMetadataCapabilities("mysql").constraints).toBe(false);
expect(getTableMetadataCapabilities(undefined).constraints).toBe(false);
});
it("exposes partitions only for dialects with declarative partitioning metadata", () => {
expect(getTableMetadataCapabilities("postgres").partitions).toBe(true);
expect(getTableMetadataCapabilities("kingbase").partitions).toBe(true);
expect(getTableMetadataCapabilities("mysql").partitions).toBe(false);
expect(getTableMetadataCapabilities("oracle").partitions).toBe(false);
// openGauss-based engines use a different partition catalog and stay off.
expect(getTableMetadataCapabilities("opengauss").partitions).toBe(false);
expect(getTableMetadataCapabilities("vastbase").partitions).toBe(false);
expect(getTableMetadataCapabilities("gaussdb").partitions).toBe(false);
expect(getTableMetadataCapabilities(undefined).partitions).toBe(false);
});
it("shows the Partitions tab for PostgreSQL in both edit and create mode only", () => {
const postgres = getTableMetadataCapabilities("postgres");
expect(isStructureMetadataTabSupported("partitions", postgres, false)).toBe(true);
// Create mode declares `PARTITION BY` instead of reading the catalog.
expect(isStructureMetadataTabSupported("partitions", postgres, true)).toBe(true);
const mysql = getTableMetadataCapabilities("mysql");
expect(isStructureMetadataTabSupported("partitions", mysql, false)).toBe(false);
// The DDL tab has no create-mode baseline; the partitions tab does.
expect(isStructureMetadataTabSupported("ddl", postgres, true)).toBe(false);
});
});