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.3 KB
Raw Blame
import { describe, expect, it } from "vitest";
import { buildInceptorCreateOptions, emptyTablePhysicalOptions, hasTablePhysicalOptions, pruneTablePhysicalOptions, restoreTablePhysicalOptions } from "@/lib/table/tablePhysicalOptions";

const columns = [
  { id: "first", name: "id" },
  { id: "second", name: "day" },
  { id: "third", name: "label" },
];

describe("table physical options", () => {
  it("restores a saved draft without sharing its column selections", () => {
    const saved = { physicalOptions: { partitionColumnIds: ["second"], distributionColumnIds: ["first"], bucketCount: "2", storageFormat: "ORC", transactional: true } };
    const restored = restoreTablePhysicalOptions(saved);
    expect(restored).toMatchObject({ partitionColumnIds: ["second"], distributionColumnIds: ["first"], bucketCount: "2", storageFormat: "ORC", transactional: true });
    expect(restored.partitionColumnIds).not.toBe(saved.physicalOptions.partitionColumnIds);
    expect(restored.distributionColumnIds).not.toBe(saved.physicalOptions.distributionColumnIds);
    expect(restoreTablePhysicalOptions({})).toEqual(emptyTablePhysicalOptions());
    expect(hasTablePhysicalOptions(restored)).toBe(true);
    expect(hasTablePhysicalOptions(emptyTablePhysicalOptions())).toBe(false);
  });

  it("uses the current column name after a selected column is renamed", () => {
    const draft = { ...emptyTablePhysicalOptions(), partitionColumnIds: ["second"], distributionColumnIds: ["first"], bucketCount: "2", storageFormat: "ORC", transactional: true };
    const renamed = columns.map((column) => (column.id === "second" ? { ...column, name: "event_day" } : column));
    expect(buildInceptorCreateOptions(draft, renamed)).toEqual({
      partitionColumns: ["event_day"],
      bucketColumns: ["id"],
      bucketCount: 2,
      storageFormat: "ORC",
      transactional: true,
    });
    expect(pruneTablePhysicalOptions(draft, new Set(["first", "third"]))).toMatchObject({ partitionColumnIds: [], distributionColumnIds: ["first"] });
  });

  it("keeps an invalid bucket count in the SQL builder's validation path", () => {
    const draft = { ...emptyTablePhysicalOptions(), distributionColumnIds: ["first"], bucketCount: "1.5" };
    expect(buildInceptorCreateOptions(draft, columns).bucketCount).toBe(0);
  });
});