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。
TypeScript aicliclickhousedatabasedatabase-clientdatabase-managementdockerguimcpmongodbmysqlpostgresqlredisrustsql-serversqlitetaurivue
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"]);
});