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.6 KB
Raw Blame
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);
  });
});