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.5 KB
Raw Blame
import { describe, expect, it } from "vitest";
import { constraintsForConstraintsTab, isForeignKeyConstraint } from "@/lib/table/constraintPresentation";
import type { ConstraintInfo } from "@/types/database";

function constraint(name: string, constraint_type: string): ConstraintInfo {
  return {
    name,
    constraint_type,
    definition: "",
    columns: [],
    ref_schema: null,
    ref_table: null,
    ref_columns: [],
    match_type: null,
    on_update: null,
    on_delete: null,
    deferrable: false,
    initially_deferred: false,
    enabled: true,
    valid: true,
  };
}

const pk = constraint("t_pkey", "PRIMARY KEY");
const fk = constraint("t_parent_fk", "FOREIGN KEY");
const unique = constraint("t_code_key", "UNIQUE");
const check = constraint("t_qty_check", "CHECK");
const all = [pk, fk, unique, check];

describe("isForeignKeyConstraint", () => {
  it("normalizes case and whitespace and accepts the bare F contype letter", () => {
    expect(isForeignKeyConstraint(constraint("a", "FOREIGN KEY"))).toBe(true);
    expect(isForeignKeyConstraint(constraint("a", "foreign key"))).toBe(true);
    expect(isForeignKeyConstraint(constraint("a", "  Foreign Key  "))).toBe(true);
    expect(isForeignKeyConstraint(constraint("a", "F"))).toBe(true);
    expect(isForeignKeyConstraint(constraint("a", "f"))).toBe(true);
  });

  it("rejects non-foreign-key constraint types", () => {
    expect(isForeignKeyConstraint(pk)).toBe(false);
    expect(isForeignKeyConstraint(unique)).toBe(false);
    expect(isForeignKeyConstraint(check)).toBe(false);
    expect(isForeignKeyConstraint(constraint("a", "EXCLUDE"))).toBe(false);
  });
});

describe("constraintsForConstraintsTab", () => {
  it("drops foreign keys when a dedicated Foreign Keys tab is shown", () => {
    expect(constraintsForConstraintsTab(all, true)).toEqual([pk, unique, check]);
  });

  it("normalizes foreign-key spellings before filtering", () => {
    const variants = [constraint("a", "foreign key"), constraint("b", "  Foreign Key  "), constraint("c", "F"), constraint("d", "PRIMARY KEY")];
    expect(constraintsForConstraintsTab(variants, true)).toEqual([variants[3]]);
  });

  it("keeps foreign keys when there is no dedicated Foreign Keys tab", () => {
    expect(constraintsForConstraintsTab(all, false)).toEqual(all);
  });

  it("keeps non-foreign-key constraints in order and handles an empty list", () => {
    expect(constraintsForConstraintsTab([fk], true)).toEqual([]);
    expect(constraintsForConstraintsTab([], true)).toEqual([]);
  });
});