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 { databaseRenameMaintenanceDatabase, supportsDatabaseRename, supportsObjectRename } from "@/lib/table/objectRenameSql";
describe("Inceptor object rename", () => {
it("exposes table rename without enabling unsupported object or database renames", () => {
expect(supportsObjectRename("transwarp", "TABLE")).toBe(true);
expect(supportsObjectRename("transwarp", "VIEW")).toBe(false);
expect(supportsObjectRename("transwarp", "PROCEDURE")).toBe(false);
expect(supportsObjectRename("transwarp", "FUNCTION")).toBe(false);
expect(supportsDatabaseRename("transwarp")).toBe(false);
});
});
describe("StarRocks object rename", () => {
it("enables table rename only", () => {
expect(supportsObjectRename("starrocks", "TABLE")).toBe(true);
for (const objectType of ["VIEW", "MATERIALIZED_VIEW", "PROCEDURE", "FUNCTION", "EVENT"] as const) {
expect(supportsObjectRename("starrocks", objectType)).toBe(false);
}
expect(supportsDatabaseRename("starrocks")).toBe(false);
});
});
describe("OceanBase Oracle object rename", () => {
it("offers table and ordinary view rename while keeping materialized views deferred", () => {
expect(supportsObjectRename("oceanbase-oracle", "TABLE")).toBe(true);
expect(supportsObjectRename("oceanbase-oracle", "VIEW")).toBe(true);
expect(supportsObjectRename("oceanbase-oracle", "MATERIALIZED_VIEW")).toBe(false);
});
});
describe("SAP HANA object rename", () => {
it("offers table rename without enabling other object renames", () => {
expect(supportsObjectRename("saphana", "TABLE")).toBe(true);
expect(supportsObjectRename("saphana", "VIEW")).toBe(false);
expect(supportsObjectRename("saphana", "PROCEDURE")).toBe(false);
expect(supportsObjectRename("saphana", "FUNCTION")).toBe(false);
});
});
describe("database rename", () => {
it("chooses a maintenance database outside the rename target", () => {
expect(databaseRenameMaintenanceDatabase("admin", "application")).toBe("admin");
expect(databaseRenameMaintenanceDatabase("application", "application")).toBe("postgres");
expect(databaseRenameMaintenanceDatabase(undefined, "application")).toBe("postgres");
expect(databaseRenameMaintenanceDatabase("postgres", "postgres")).toBe("template1");
expect(databaseRenameMaintenanceDatabase("template1", "postgres")).toBe("template1");
});
it("does not expose database rename for YashanDB", () => {
expect(supportsDatabaseRename("postgres")).toBe(true);
expect(supportsDatabaseRename("yashandb")).toBe(false);
});
});