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.1 KB
Raw Blame
// @vitest-environment happy-dom

import { describe, expect, it } from "vitest";
import { constrainSqlHoverLayout, sqlHoverScrollbarMetrics } from "@/lib/editor/sqlHoverLayout";

describe("constrainSqlHoverLayout", () => {
  it("caps table structure hovers and scrolls oversized DDL inside the content area", () => {
    const root = document.createElement("div");
    const content = document.createElement("div");

    constrainSqlHoverLayout(root, content);

    expect(root.dataset.sqlStructureHover).toBe("true");
    expect(root.style.width).toBe("80vw");
    expect(root.style.maxWidth).toBe("900px");
    expect(root.style.maxHeight).toBe("calc(50vh - 12px)");
    expect(root.style.overflow).toBe("hidden");
    expect(content.dataset.sqlStructureHoverContent).toBe("true");
    expect(content.style.flex).toBe("0 1 auto");
    expect(content.style.maxHeight).toBe("480px");
    expect(content.style.maxWidth).toBe("100%");
    expect(content.style.overflowX).toBe("hidden");
    expect(content.style.overflowY).toBe("auto");
    expect(content.style.overscrollBehavior).toBe("contain");
    expect(content.style.scrollbarGutter).toBe("stable");
    expect(root.querySelector('[data-sql-structure-hover-scrollbar="true"]')).not.toBeNull();
    expect(root.querySelector('[data-sql-structure-hover-scrollbar-thumb="true"]')).not.toBeNull();
  });

  it("maps content scroll position to a proportional custom scrollbar thumb", () => {
    expect(sqlHoverScrollbarMetrics(600, 1200, 300, 600)).toEqual({
      maxScroll: 600,
      maxThumbLeft: 300,
      thumbLeft: 150,
      thumbWidth: 300,
    });

    expect(sqlHoverScrollbarMetrics(600, 6000, 5400, 600)).toEqual({
      maxScroll: 5400,
      maxThumbLeft: 540,
      thumbLeft: 540,
      thumbWidth: 60,
    });
  });

  it("keeps horizontal trackpad scrolling while the native scrollbar is hidden", () => {
    const root = document.createElement("div");
    const content = document.createElement("div");
    Object.defineProperty(content, "clientWidth", { configurable: true, value: 600 });
    Object.defineProperty(content, "scrollWidth", { configurable: true, value: 1200 });
    constrainSqlHoverLayout(root, content);

    const wheelEvent = new WheelEvent("wheel", { cancelable: true, deltaX: 120 });
    content.dispatchEvent(wheelEvent);

    expect(content.scrollLeft).toBe(120);
    expect(wheelEvent.defaultPrevented).toBe(true);
  });

  it("translates Alt plus deltaY into horizontal scrolling", () => {
    const root = document.createElement("div");
    const content = document.createElement("div");
    Object.defineProperty(content, "clientWidth", { configurable: true, value: 600 });
    Object.defineProperty(content, "scrollWidth", { configurable: true, value: 1200 });
    constrainSqlHoverLayout(root, content);

    const wheelEvent = new WheelEvent("wheel", { cancelable: true, deltaY: 120 });
    Object.defineProperty(wheelEvent, "altKey", { value: true });
    content.dispatchEvent(wheelEvent);

    expect(content.scrollLeft).toBe(120);
    expect(wheelEvent.defaultPrevented).toBe(true);
  });

  it("starts the scrollbar on mount and stops responding after destroy", () => {
    const root = document.createElement("div");
    const content = document.createElement("div");
    Object.defineProperty(content, "clientWidth", { configurable: true, value: 600 });
    Object.defineProperty(content, "scrollWidth", { configurable: true, value: 2400 });
    const controller = constrainSqlHoverLayout(root, content);
    const track = root.querySelector<HTMLElement>('[data-sql-structure-hover-scrollbar="true"]')!;

    // 挂载前未跑过 update,轨道仍隐藏
    expect(track.hidden).toBe(true);
    controller.mount();
    expect(track.hidden).toBe(false);

    const before = content.scrollLeft;
    content.dispatchEvent(new WheelEvent("wheel", { cancelable: true, deltaX: 120 }));
    expect(content.scrollLeft).toBe(before + 120);

    controller.destroy();
    const afterDestroy = content.scrollLeft;
    content.dispatchEvent(new WheelEvent("wheel", { cancelable: true, deltaX: 120 }));
    expect(content.scrollLeft).toBe(afterDestroy);
  });
});