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.2 KB
Raw Blame
import { describe, expect, it } from "vitest";
import { encodeSpreadsheetTsvCell } from "@/lib/common/spreadsheetTsv";

describe("encodeSpreadsheetTsvCell", () => {
  it("preserves legal decimal and at-sign text while guarding formulas", () => {
    expect(encodeSpreadsheetTsvCell(undefined)).toBe("");
    expect(encodeSpreadsheetTsvCell("-123.45")).toBe("-123.45");
    expect(encodeSpreadsheetTsvCell("-1234567890123456")).toBe("'-1234567890123456");
    expect(encodeSpreadsheetTsvCell("@")).toBe("@");
    expect(encodeSpreadsheetTsvCell("@ASCII")).toBe("'@ASCII");
    expect(encodeSpreadsheetTsvCell("@冯十二")).toBe("@冯十二");
    expect(encodeSpreadsheetTsvCell("=1+1")).toBe("'=1+1");
  });

  it.each([
    ["", ""],
    ["-123456789012345", "-123456789012345"],
    ["  +1", "'  +1"],
    ["-1e3", "'-1e3"],
    ["\t=1", `"'\t=1"`],
    ["\r=1", `"'\r=1"`],
    ["  @", "  @"],
  ])("preserves the formula guard boundary for %j", (input, expected) => {
    expect(encodeSpreadsheetTsvCell(input)).toBe(expected);
  });

  it("guards before TSV quoting and doubles embedded quotes", () => {
    expect(encodeSpreadsheetTsvCell('=a\t"b')).toBe(`"'=a\t""b"`);
    expect(encodeSpreadsheetTsvCell("x\r\ny")).toBe('"x\r\ny"');
  });
});