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.4 KB
Raw Blame
import { describe, expect, it } from "vitest";
import { uniqueConstraintColumns } from "@/lib/table/uniqueConstraintColumns";

describe("uniqueConstraintColumns", () => {
  it("keeps columns of full single-column unique indexes and primary keys", () => {
    expect(
      uniqueConstraintColumns([
        { columns: ["id"], is_unique: true, filter: null },
        { columns: ["code"], is_unique: true, filter: null },
      ]),
    ).toEqual(new Set(["id", "code"]));
  });

  it("ignores non-unique indexes", () => {
    expect(uniqueConstraintColumns([{ columns: ["code"], is_unique: false, filter: null }]).size).toBe(0);
  });

  it("ignores composite unique indexes", () => {
    expect(uniqueConstraintColumns([{ columns: ["tenant_id", "code"], is_unique: true, filter: null }]).size).toBe(0);
  });

  it("ignores partial unique indexes", () => {
    expect(uniqueConstraintColumns([{ columns: ["code"], is_unique: true, filter: "(deleted_at IS NULL)" }]).size).toBe(0);
  });

  it("ignores expression keys", () => {
    expect(uniqueConstraintColumns([{ columns: ["lower(code)"], is_unique: true, filter: null, key_is_expression: [true] }]).size).toBe(0);
  });

  it("tolerates missing index metadata", () => {
    expect(uniqueConstraintColumns(undefined).size).toBe(0);
    expect(uniqueConstraintColumns(null).size).toBe(0);
    expect(uniqueConstraintColumns([]).size).toBe(0);
  });
});