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。

2.8 KB
Raw Blame
import assert from "node:assert/strict";
import { test } from "vitest";
import { canConfigureVisibleSchemasForTreeNode, isSchemaAware, supportsClearableQuerySchema, supportsConnectionQueryActions, supportsDatabaseCreation, usesTreeSchemaMode } from "../../apps/desktop/src/lib/database/databaseCapabilities.ts";

test("TDengine uses database/catalog tree nodes without a schema layer", () => {
  assert.equal(isSchemaAware("tdengine"), false);
  assert.equal(usesTreeSchemaMode("tdengine"), false);
});

test("IoTDB keeps schema-qualified paths without showing a duplicate schema node", () => {
  assert.equal(isSchemaAware("iotdb"), true);
  assert.equal(usesTreeSchemaMode("iotdb"), false);
});

test("GoldenDB and Vastbase expose database creation", () => {
  assert.equal(supportsDatabaseCreation("goldendb"), true);
  assert.equal(supportsDatabaseCreation("vastbase"), true);
});

test("Vastbase keeps PostgreSQL-like schema filtering on database nodes", () => {
  assert.equal(isSchemaAware("vastbase"), true);
  assert.equal(usesTreeSchemaMode("vastbase"), true);
  assert.equal(canConfigureVisibleSchemasForTreeNode("vastbase", "database", "vastbase"), true);
  assert.equal(canConfigureVisibleSchemasForTreeNode("vastbase", "connection"), false);
});

test("visible schema menu capability preserves adjacent database families", () => {
  assert.equal(canConfigureVisibleSchemasForTreeNode("oracle", "connection"), true);
  assert.equal(canConfigureVisibleSchemasForTreeNode("dameng", "connection"), true);
  assert.equal(canConfigureVisibleSchemasForTreeNode("oceanbase-oracle", "connection"), false);
  assert.equal(canConfigureVisibleSchemasForTreeNode("postgres", "database", "app"), true);
  assert.equal(canConfigureVisibleSchemasForTreeNode("sqlserver", "database", "app"), true);
  assert.equal(canConfigureVisibleSchemasForTreeNode("mysql", "database", "app"), false);
});

test("only explicitly supported query schemas can be cleared from query tabs", () => {
  assert.equal(supportsClearableQuerySchema("oracle"), true);
  assert.equal(supportsClearableQuerySchema("dameng"), true);
  assert.equal(supportsClearableQuerySchema("gaussdb"), true);
  assert.equal(supportsClearableQuerySchema("oceanbase-oracle"), true);
  assert.equal(supportsClearableQuerySchema("mysql"), false);
  assert.equal(supportsClearableQuerySchema("postgres"), false);
  assert.equal(supportsClearableQuerySchema("opengauss"), false);
  assert.equal(supportsClearableQuerySchema("sqlserver"), false);
  assert.equal(supportsClearableQuerySchema("jdbc"), false);
});

test("non-SQL connection menus do not expose SQL-style query actions", () => {
  assert.equal(supportsConnectionQueryActions("nacos"), false);
  assert.equal(supportsConnectionQueryActions("hbase"), false);
  assert.equal(supportsConnectionQueryActions("mysql"), true);
  assert.equal(supportsConnectionQueryActions("redis"), true);
});