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.5 KB
Raw Blame
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);
});