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 { describe, expect, it } from "vitest";
import { DEFAULT_QUERY_RESULT_EXPORT_FILE_NAME_SOURCE, normalizeQueryResultExportFileNameSource, queryResultExportBaseName, sanitizeExportBaseName } from "@/lib/export/saveTextFile";
describe("queryResultExportBaseName", () => {
it("prefers the result label derived from the SQL's nearby comment by default (#9894)", () => {
expect(queryResultExportBaseName("检查结果", "query 5")).toBe("检查结果");
expect(queryResultExportBaseName("检查结果", "query 5", "result-label")).toBe("检查结果");
});
it("prefers the tab title when configured to prefer tab title (#12092)", () => {
expect(queryResultExportBaseName("orders", "sales_report.sql", "tab-title")).toBe("sales_report.sql");
expect(sanitizeExportBaseName(queryResultExportBaseName("orders", "sales_report.sql", "tab-title")!)).toBe("sales_report");
});
it("falls back to the result label in tab-title mode when tab title is missing (#12092)", () => {
expect(queryResultExportBaseName("orders", undefined, "tab-title")).toBe("orders");
expect(queryResultExportBaseName("orders", "", "tab-title")).toBe("orders");
expect(queryResultExportBaseName("orders", " ", "tab-title")).toBe("orders");
});
it("falls back to the tab title when the result carries no label in result-label mode", () => {
expect(queryResultExportBaseName(undefined, "query 5")).toBe("query 5");
expect(queryResultExportBaseName("", "query 5")).toBe("query 5");
expect(queryResultExportBaseName(" ", "query 5")).toBe("query 5");
});
it("keeps the schema-qualified label so exported files stay identifiable", () => {
expect(queryResultExportBaseName("dbx.orders", "本地MySQL8.4@dbx")).toBe("dbx.orders");
});
it("returns undefined when neither source provides a name", () => {
expect(queryResultExportBaseName(undefined, undefined)).toBeUndefined();
expect(queryResultExportBaseName("", "")).toBeUndefined();
expect(queryResultExportBaseName(undefined, undefined, "tab-title")).toBeUndefined();
expect(queryResultExportBaseName("", "", "tab-title")).toBeUndefined();
});
it("keeps the sanitized base name free of path separators", () => {
expect(sanitizeExportBaseName(queryResultExportBaseName("检查结果/2026", "query 5")!)).toBe("检查结果_2026");
});
});
describe("normalizeQueryResultExportFileNameSource", () => {
it("accepts valid export filename source values", () => {
expect(normalizeQueryResultExportFileNameSource("result-label")).toBe("result-label");
expect(normalizeQueryResultExportFileNameSource("tab-title")).toBe("tab-title");
});
it("falls back to default on invalid or missing values", () => {
expect(normalizeQueryResultExportFileNameSource(undefined)).toBe(DEFAULT_QUERY_RESULT_EXPORT_FILE_NAME_SOURCE);
expect(normalizeQueryResultExportFileNameSource("invalid")).toBe(DEFAULT_QUERY_RESULT_EXPORT_FILE_NAME_SOURCE);
expect(normalizeQueryResultExportFileNameSource(123)).toBe(DEFAULT_QUERY_RESULT_EXPORT_FILE_NAME_SOURCE);
});
});