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.9 KB
Raw Blame
import { beforeEach, describe, expect, it, vi } from "vitest";
import { loadSqlParameterHistory, MAX_SQL_PARAMETER_HISTORY, rememberSqlParameterValue } from "@/lib/sql/sqlParameterHistory";

const storage = new Map<string, string>();

beforeEach(() => {
  storage.clear();
  vi.stubGlobal("localStorage", {
    getItem: (key: string) => storage.get(key) ?? null,
    setItem: (key: string, value: string) => storage.set(key, value),
    removeItem: (key: string) => storage.delete(key),
  });
});

describe("sqlParameterHistory", () => {
  it("stores recent values by parameter name", () => {
    rememberSqlParameterValue("start_date", { kind: "string", value: "2026-01-01" });
    rememberSqlParameterValue("start_date", { kind: "string", value: "2026-01-02" });

    expect(loadSqlParameterHistory("start_date")).toEqual([
      { kind: "string", value: "2026-01-02" },
      { kind: "string", value: "2026-01-01" },
    ]);
  });

  it("deduplicates by type and value and moves the latest value to the front", () => {
    rememberSqlParameterValue("min_id", { kind: "number", value: "1" });
    rememberSqlParameterValue("min_id", { kind: "number", value: "2" });
    rememberSqlParameterValue("min_id", { kind: "number", value: "1" });

    expect(loadSqlParameterHistory("min_id")).toEqual([
      { kind: "number", value: "1" },
      { kind: "number", value: "2" },
    ]);
  });

  it("matches parameter names case-insensitively and limits history size", () => {
    for (let i = 0; i < MAX_SQL_PARAMETER_HISTORY + 2; i += 1) {
      rememberSqlParameterValue("UserId", { kind: "number", value: String(i) });
    }

    const history = loadSqlParameterHistory("userId");
    expect(history).toHaveLength(MAX_SQL_PARAMETER_HISTORY);
    expect(history[0]).toEqual({ kind: "number", value: String(MAX_SQL_PARAMETER_HISTORY + 1) });
    expect(history.at(-1)).toEqual({ kind: "number", value: "2" });
  });
});