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.8 KB
Raw Blame
import { strict as assert } from "node:assert";
import { test } from "vitest";
import { filterObjectBrowserTableColumns } from "../../apps/desktop/src/lib/table/objectBrowserTableInfo.ts";

const columns = [
  { name: "business_id", data_type: "varchar(64)", comment: "业务ID" },
  { name: "created_at", data_type: "TIMESTAMP", comment: "Created time" },
  { name: "status", data_type: "INT", comment: null },
  { name: "note", data_type: "TEXT" },
  { name: "empty_note", data_type: "TEXT", comment: "" },
];

test("filters table-info columns by case-insensitive name and trimmed type text", () => {
  assert.deepEqual(
    filterObjectBrowserTableColumns(columns, "BUSINESS").map((column) => column.name),
    ["business_id"],
  );
  assert.deepEqual(
    filterObjectBrowserTableColumns(columns, "  timestamp  ").map((column) => column.name),
    ["created_at"],
  );
});

test("filters table-info columns by partial localized and case-insensitive comments", () => {
  assert.deepEqual(
    filterObjectBrowserTableColumns(columns, "业务").map((column) => column.name),
    ["business_id"],
  );
  assert.deepEqual(
    filterObjectBrowserTableColumns(columns, "CREATED TIME").map((column) => column.name),
    ["created_at"],
  );
});

test("handles missing, null, and empty comments without changing no-match behavior", () => {
  assert.deepEqual(filterObjectBrowserTableColumns(columns, "not present"), []);
});

test("returns every column for empty searches and preserves match order", () => {
  assert.deepEqual(
    filterObjectBrowserTableColumns(columns, "   ").map((column) => column.name),
    columns.map((column) => column.name),
  );
  assert.deepEqual(
    filterObjectBrowserTableColumns(columns, "text").map((column) => column.name),
    ["note", "empty_note"],
  );
});