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 assert from "node:assert/strict";
import { test } from "vitest";
import { SCHEMA_TREE_CACHE_TTL_MS, decodeSchemaTreeCache, encodeSchemaTreeCache } from "../../apps/desktop/src/lib/metadata/schemaTreeCache.ts";
const children = [{ id: "conn:db", label: "db", type: "database" }];
const now = Date.parse("2026-05-17T10:00:00.000Z");
test("wraps tree children with a cache timestamp", () => {
assert.deepEqual(encodeSchemaTreeCache(children, now), {
version: 3,
cachedAt: "2026-05-17T10:00:00.000Z",
children,
});
});
test("treats recent schema tree cache envelopes as fresh", () => {
const payload = encodeSchemaTreeCache(children, now);
assert.deepEqual(decodeSchemaTreeCache(payload, now + SCHEMA_TREE_CACHE_TTL_MS - 1), {
children,
isStale: false,
});
});
test("treats expired schema tree cache envelopes as stale", () => {
const payload = encodeSchemaTreeCache(children, now);
assert.deepEqual(decodeSchemaTreeCache(payload, now + SCHEMA_TREE_CACHE_TTL_MS + 1), {
children,
isStale: true,
});
});
test("keeps legacy array cache readable but stale", () => {
assert.deepEqual(decodeSchemaTreeCache(children, now), {
children,
isStale: true,
});
});
test("rejects invalid schema tree cache payloads", () => {
assert.equal(decodeSchemaTreeCache({ version: 2, cachedAt: "bad", children: "nope" }, now), null);
assert.equal(decodeSchemaTreeCache({ version: 1, cachedAt: "2026-05-17T10:00:00.000Z", children }, now), null);
});