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 { test } from "vitest";
import { autoMapImportColumns, normalizeImportColumnName } from "../../apps/desktop/src/lib/table/tableImport.ts";
test("normalizes import column names for matching", () => {
assert.equal(normalizeImportColumnName(" User ID "), "user id");
assert.equal(normalizeImportColumnName("user_id"), "user id");
assert.equal(normalizeImportColumnName("USER-ID"), "user id");
});
test("auto maps source columns to matching target columns and skips unknown columns", () => {
const mapping = autoMapImportColumns(["id", "Name", "created-at", "ignored"], ["user_id", "name", "created_at"]);
assert.deepEqual(mapping, {
id: "",
Name: "name",
"created-at": "created_at",
ignored: "",
});
});