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。

3.5 KB
Raw Blame
import { strict as assert } from "node:assert";
import { beforeEach, test } from "vitest";
import { forgetDataGridConditionHistory, loadDataGridConditionHistory, rememberDataGridConditionHistory } from "../../apps/desktop/src/lib/dataGrid/dataGridConditionHistory.ts";

class MemoryStorage {
  private values = new Map<string, string>();

  getItem(key: string) {
    return this.values.get(key) ?? null;
  }

  setItem(key: string, value: string) {
    this.values.set(key, value);
  }

  removeItem(key: string) {
    this.values.delete(key);
  }
}

beforeEach(() => {
  Object.defineProperty(globalThis, "localStorage", {
    value: new MemoryStorage(),
    configurable: true,
  });
});

test("remembers table-scoped WHERE history with newest entries first", () => {
  const scope = { connectionId: "c1", database: "app", schema: "public", tableName: "users" };

  rememberDataGridConditionHistory("where", scope, "status = 'active'");
  rememberDataGridConditionHistory("where", scope, "created_at > '2026-01-01'");
  rememberDataGridConditionHistory("where", scope, "status = 'active'");

  assert.deepEqual(loadDataGridConditionHistory("where", scope), ["status = 'active'", "created_at > '2026-01-01'"]);
});

test("keeps WHERE and ORDER BY histories separate", () => {
  const scope = { connectionId: "c1", database: "app", schema: "public", tableName: "users" };

  rememberDataGridConditionHistory("where", scope, "status = 'active'");
  rememberDataGridConditionHistory("orderBy", scope, "created_at DESC");

  assert.deepEqual(loadDataGridConditionHistory("where", scope), ["status = 'active'"]);
  assert.deepEqual(loadDataGridConditionHistory("orderBy", scope), ["created_at DESC"]);
});

test.each(["where", "orderBy"] as const)("keeps the newest 20 %s history entries", (kind) => {
  const scope = { connectionId: "c1", database: "app", schema: "public", tableName: "users" };

  for (let index = 1; index <= 21; index += 1) {
    rememberDataGridConditionHistory(kind, scope, `condition ${index}`);
  }

  assert.deepEqual(
    loadDataGridConditionHistory(kind, scope),
    Array.from({ length: 20 }, (_, index) => `condition ${21 - index}`),
  );
});

test("filters history by partial input and isolates different tables", () => {
  const users = { connectionId: "c1", database: "app", schema: "public", tableName: "users" };
  const orders = { connectionId: "c1", database: "app", schema: "public", tableName: "orders" };

  rememberDataGridConditionHistory("where", users, "status = 'active'");
  rememberDataGridConditionHistory("where", users, "email LIKE '%@example.com'");
  rememberDataGridConditionHistory("where", orders, "status = 'paid'");

  assert.deepEqual(loadDataGridConditionHistory("where", users, "email"), ["email LIKE '%@example.com'"]);
  assert.deepEqual(loadDataGridConditionHistory("where", orders), ["status = 'paid'"]);
});

test("forgets a single condition without clearing other scoped history", () => {
  const scope = { connectionId: "c1", database: "app", schema: "public", tableName: "users" };

  rememberDataGridConditionHistory("where", scope, "status = 'active'");
  rememberDataGridConditionHistory("where", scope, "email LIKE '%@example.com'");
  rememberDataGridConditionHistory("orderBy", scope, "created_at DESC");

  assert.deepEqual(forgetDataGridConditionHistory("where", scope, "status = 'active'"), ["email LIKE '%@example.com'"]);
  assert.deepEqual(loadDataGridConditionHistory("where", scope), ["email LIKE '%@example.com'"]);
  assert.deepEqual(loadDataGridConditionHistory("orderBy", scope), ["created_at DESC"]);
});