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。

4.5 KB
Raw Blame
// @vitest-environment happy-dom

import { beforeEach, describe, expect, it, vi } from "vitest";

const CONFIG_KEY = "dbx-data-compare-configs";

function snapshot(overrides: Record<string, unknown> = {}) {
  return {
    sourceConnectionId: "src",
    sourceDatabase: "app",
    sourceSchema: "public",
    selectedSourceTables: ["users", "orders"],
    targetConnectionId: "dst",
    targetDatabase: "app_copy",
    targetSchema: "public",
    targetTable: "users",
    detailPreviewLimit: "100",
    keyColumnsByTable: { users: ["user_id"] },
    ...overrides,
  };
}

describe("useDataCompareConfig", () => {
  beforeEach(() => {
    localStorage.clear();
    vi.resetModules();
  });

  it("creates a config and persists the whole selection", async () => {
    const { useDataCompareConfig } = await import("../useDataCompareConfig");
    const state = useDataCompareConfig();

    const created = state.createConfig("Nightly", snapshot());

    expect(state.activeConfigId.value).toBe(created.id);
    expect(state.activeConfig.value?.name).toBe("Nightly");
    const stored = JSON.parse(localStorage.getItem(CONFIG_KEY) ?? "[]") as Array<Record<string, unknown>>;
    expect(stored).toHaveLength(1);
    expect(stored[0]!.selectedSourceTables).toEqual(["users", "orders"]);
    expect(stored[0]!.keyColumnsByTable).toEqual({ users: ["user_id"] });
  });

  it("keeps config names unique instead of silently overwriting", async () => {
    const { useDataCompareConfig } = await import("../useDataCompareConfig");
    const state = useDataCompareConfig();

    state.createConfig("Same", snapshot());
    state.createConfig("Same", snapshot());

    expect(state.configs.value.map((config) => config.name)).toEqual(["Same (1)", "Same"]);
    state.renameConfig(state.configs.value[1]!.id, "Same (1)");
    expect(state.configs.value.map((config) => config.name)).toEqual(["Same (1)", "Same (1) (1)"]);
  });

  it("drops the active selection when the active config is deleted", async () => {
    const { useDataCompareConfig } = await import("../useDataCompareConfig");
    const state = useDataCompareConfig();
    const created = state.createConfig("One", snapshot());

    state.deleteConfig(created.id);

    expect(state.configs.value).toHaveLength(0);
    expect(state.activeConfigId.value).toBe("");
    expect(state.activeConfig.value).toBeNull();
  });

  it("duplicates a config under a new id without sharing mutable arrays", async () => {
    const { useDataCompareConfig } = await import("../useDataCompareConfig");
    const state = useDataCompareConfig();
    const created = state.createConfig("Base", snapshot());

    const copy = state.duplicateConfig(created.id);

    expect(copy?.id).not.toBe(created.id);
    expect(copy?.name).toBe("Base (1)");
    expect(state.activeConfigId.value).toBe(copy?.id);
    copy!.selectedSourceTables.push("logs");
    expect(created.selectedSourceTables).toEqual(["users", "orders"]);
  });

  it("updates a config in place and bumps updatedAt", async () => {
    const { useDataCompareConfig } = await import("../useDataCompareConfig");
    const state = useDataCompareConfig();
    const created = state.createConfig("One", snapshot());
    created.updatedAt = 1;

    state.updateConfig(created.id, { selectedSourceTables: ["logs"], keyColumnsByTable: {} });

    const updated = state.configs.value.find((config) => config.id === created.id);
    expect(updated?.selectedSourceTables).toEqual(["logs"]);
    expect(updated?.keyColumnsByTable).toEqual({});
    expect(updated?.updatedAt).toBeGreaterThan(1);
  });

  it("sanitizes stored configs and preserves an explicitly cleared match-column list", async () => {
    localStorage.setItem(CONFIG_KEY, JSON.stringify([{ name: "Valid", id: "a", selectedSourceTables: ["t", 5], keyColumnsByTable: { t: [], u: "bad" } }, { id: "no-name", name: "" }, "not-an-object"]));

    const { useDataCompareConfig } = await import("../useDataCompareConfig");
    const state = useDataCompareConfig();

    expect(state.configs.value).toHaveLength(1);
    expect(state.configs.value[0]!.selectedSourceTables).toEqual(["t"]);
    expect(state.configs.value[0]!.keyColumnsByTable).toEqual({ t: [] });
    expect(state.configs.value[0]!.detailPreviewLimit).toBe("");
  });

  it("recovers from unreadable stored JSON", async () => {
    localStorage.setItem(CONFIG_KEY, "{not json");

    const { useDataCompareConfig } = await import("../useDataCompareConfig");
    const state = useDataCompareConfig();

    expect(state.configs.value).toEqual([]);
    expect(state.activeConfig.value).toBeNull();
  });
});