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。

3.7 KB
Raw Blame
import { describe, expect, it } from "vitest";
import { CREATE_DATABASE_CHARSET_OPTIONS, createDatabaseCollationOptionsForCharset, defaultCreateDatabaseCollationForCharset, normalizeCreateDatabaseCharset, parseCreateDatabaseCharsetMetadata, nextCreateDatabaseCollation } from "@/lib/database/createDatabaseCharsetOptions";

describe("createDatabaseCharsetOptions", () => {
  it("offers common MySQL character sets with utf8mb4 first", () => {
    expect(CREATE_DATABASE_CHARSET_OPTIONS.slice(0, 4)).toEqual(["utf8mb4", "utf8", "gbk", "latin1"]);
    expect(CREATE_DATABASE_CHARSET_OPTIONS).toEqual(expect.arrayContaining(["ascii", "big5", "gb2312", "utf16", "utf32"]));
  });

  it("normalizes typed custom values without changing their case", () => {
    expect(normalizeCreateDatabaseCharset("  utf8mb3  ")).toBe("utf8mb3");
    expect(normalizeCreateDatabaseCharset("Big5")).toBe("Big5");
  });

  it("offers common collations for the selected character set", () => {
    expect(createDatabaseCollationOptionsForCharset("utf8mb4").slice(0, 3)).toEqual(["utf8mb4_unicode_ci", "utf8mb4_general_ci", "utf8mb4_bin"]);
    expect(createDatabaseCollationOptionsForCharset("utf8mb4")).toEqual(expect.arrayContaining(["utf8mb4_bin"]));
    expect(createDatabaseCollationOptionsForCharset("utf8mb4").some((collation) => collation.includes("0900"))).toBe(false);
    expect(createDatabaseCollationOptionsForCharset("gbk")).toEqual(["gbk_chinese_ci", "gbk_bin"]);
    expect(createDatabaseCollationOptionsForCharset("utf8")).toEqual(createDatabaseCollationOptionsForCharset("utf8mb3"));
  });

  it("parses server-provided character sets and collations", () => {
    const metadata = parseCreateDatabaseCharsetMetadata(
      {
        columns: ["Charset", "Description", "Default collation", "Maxlen"],
        rows: [
          ["utf8mb4", "UTF-8 Unicode", "utf8mb4_general_ci", 4],
          ["gbk", "GBK Simplified Chinese", "gbk_chinese_ci", 2],
        ],
      },
      {
        columns: ["Collation", "Charset", "Id", "Default", "Compiled", "Sortlen"],
        rows: [
          ["utf8mb4_general_ci", "utf8mb4", 45, "Yes", "Yes", 1],
          ["utf8mb4_unicode_ci", "utf8mb4", 224, "", "Yes", 8],
          ["gbk_chinese_ci", "gbk", 28, "Yes", "Yes", 1],
        ],
      },
    );

    expect(metadata.charsets).toEqual(["utf8mb4", "gbk"]);
    expect(metadata.collationsByCharset.utf8mb4).toEqual(["utf8mb4_general_ci", "utf8mb4_unicode_ci"]);
    expect(metadata.collationsByCharset.gbk).toEqual(["gbk_chinese_ci"]);
  });

  it("keeps server-provided MySQL 8 utf8mb4 collations", () => {
    const metadata = parseCreateDatabaseCharsetMetadata(
      {
        columns: ["Charset", "Description", "Default collation", "Maxlen"],
        rows: [["utf8mb4", "UTF-8 Unicode", "utf8mb4_0900_ai_ci", 4]],
      },
      {
        columns: ["Collation", "Charset", "Id", "Default", "Compiled", "Sortlen"],
        rows: [
          ["utf8mb4_0900_ai_ci", "utf8mb4", 255, "Yes", "Yes", 0],
          ["utf8mb4_general_ci", "utf8mb4", 45, "", "Yes", 1],
          ["utf8mb4_unicode_ci", "utf8mb4", 224, "", "Yes", 8],
          ["utf8mb4_unicode_520_ci", "utf8mb4", 246, "", "Yes", 8],
          ["utf8mb4_bin", "utf8mb4", 46, "", "Yes", 1],
        ],
      },
    );

    expect(metadata.collationsByCharset.utf8mb4).toEqual(["utf8mb4_0900_ai_ci", "utf8mb4_general_ci", "utf8mb4_unicode_ci", "utf8mb4_unicode_520_ci", "utf8mb4_bin"]);
  });

  it("keeps custom collations unless the previous value was the old charset default", () => {
    expect(defaultCreateDatabaseCollationForCharset("latin1")).toBe("latin1_swedish_ci");
    expect(nextCreateDatabaseCollation("gbk", "utf8mb4", "utf8mb4_unicode_ci")).toBe("gbk_chinese_ci");
    expect(nextCreateDatabaseCollation("gbk", "utf8mb4", "custom_ci")).toBe("custom_ci");
  });
});