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。

1.9 KB
Raw Blame
import { describe, expect, it } from "vitest";
import { schemaDiffRoutineObjectTypes, schemaDiffRoutineObjectTypesIntersection, supportsSchemaDiffRoutines } from "@/lib/database/databaseObjectCapabilities";

describe("Oracle-family routine comparison workflow", () => {
  it.each(["oracle", "oceanbase-oracle"] as const)("offers standalone procedures and functions for a %s pair", (databaseType) => {
    expect(supportsSchemaDiffRoutines(databaseType)).toBe(true);
    expect(schemaDiffRoutineObjectTypes(databaseType)).toEqual(["PROCEDURE", "FUNCTION"]);
    expect(schemaDiffRoutineObjectTypesIntersection(databaseType, databaseType)).toEqual(["PROCEDURE", "FUNCTION"]);
  });

  it.each(["oracle", "oceanbase-oracle"] as const)("only adds explicitly requested package kinds for %s", (databaseType) => {
    expect(schemaDiffRoutineObjectTypes(databaseType, ["PROCEDURE", "FUNCTION", "PACKAGE", "PACKAGE_BODY"])).toEqual(["PROCEDURE", "FUNCTION", "PACKAGE", "PACKAGE_BODY"]);
    expect(schemaDiffRoutineObjectTypesIntersection(databaseType, databaseType, ["PACKAGE_BODY"])).toEqual(["PACKAGE_BODY"]);
  });

  it.each([
    ["oracle", "oceanbase-oracle"],
    ["oceanbase-oracle", "oracle"],
  ] as const)("permits exact package comparison from %s to %s without broadening standalone conversion", (source, target) => {
    expect(schemaDiffRoutineObjectTypesIntersection(source, target)).toEqual([]);
    expect(schemaDiffRoutineObjectTypesIntersection(source, target, ["PROCEDURE", "FUNCTION", "PACKAGE", "PACKAGE_BODY"])).toEqual(["PACKAGE", "PACKAGE_BODY"]);
  });

  it.each(["dameng", "xugu", "mysql", "postgres"] as const)("does not inherit package comparison from the %s sidebar", (databaseType) => {
    expect(schemaDiffRoutineObjectTypes(databaseType, ["PACKAGE", "PACKAGE_BODY"])).toEqual([]);
    expect(schemaDiffRoutineObjectTypesIntersection("oracle", databaseType, ["PACKAGE", "PACKAGE_BODY"])).toEqual([]);
  });
});