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。

2.5 KB
Raw Blame
import { describe, expect, it } from "vitest";
import { parseSqlServerHostPort } from "../sqlServerHostPort";

describe("parseSqlServerHostPort", () => {
  it("parses comma-separated port", () => {
    expect(parseSqlServerHostPort("gg.test.com,9005")).toEqual({
      host: "gg.test.com",
      port: 9005,
      portExplicit: true,
    });
  });

  it("parses comma-separated port with whitespace", () => {
    expect(parseSqlServerHostPort(" 192.168.1.100, 14333 ")).toEqual({
      host: "192.168.1.100",
      port: 14333,
      portExplicit: true,
    });
  });

  it("strips tcp: prefix and extracts comma-separated port", () => {
    expect(parseSqlServerHostPort("tcp:gg.test.com,9005")).toEqual({
      host: "gg.test.com",
      port: 9005,
      portExplicit: true,
    });
  });

  it("strips tcp: prefix without port", () => {
    expect(parseSqlServerHostPort("tcp:gg.test.com", 1433)).toEqual({
      host: "gg.test.com",
      port: 1433,
      portExplicit: false,
    });
  });

  it("parses colon-separated port", () => {
    expect(parseSqlServerHostPort("gg.test.com:9005")).toEqual({
      host: "gg.test.com",
      port: 9005,
      portExplicit: true,
    });
  });

  it("parses named instance with comma port", () => {
    expect(parseSqlServerHostPort("192.168.1.10\\SQL2022,14333")).toEqual({
      host: "192.168.1.10\\SQL2022",
      port: 14333,
      portExplicit: true,
    });
  });

  it("parses named instance with tcp prefix", () => {
    expect(parseSqlServerHostPort("tcp:192.168.1.10\\SQL2022", 1433)).toEqual({
      host: "192.168.1.10\\SQL2022",
      port: 1433,
      portExplicit: false,
    });
  });

  it("parses bracketed IPv6 with comma or colon port", () => {
    expect(parseSqlServerHostPort("[::1],9005")).toEqual({
      host: "[::1]",
      port: 9005,
      portExplicit: true,
    });
    expect(parseSqlServerHostPort("[::1]:9005")).toEqual({
      host: "[::1]",
      port: 9005,
      portExplicit: true,
    });
  });

  it("keeps regular host without port", () => {
    expect(parseSqlServerHostPort("localhost", 1433)).toEqual({
      host: "localhost",
      port: 1433,
      portExplicit: false,
    });
    expect(parseSqlServerHostPort("", 1433)).toEqual({
      host: "",
      port: 1433,
      portExplicit: false,
    });
  });

  it.each(["[::1],70000", "[::1]:oops", "[::1]:0", "[::1]unexpected", "server:1e3", "server,0x599"])("preserves invalid endpoint text instead of selecting a different port: %s", (host) => {
    expect(parseSqlServerHostPort(host, 1433)).toEqual({ host, port: 1433, portExplicit: false });
  });
});