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.5 KB
Raw Blame
import { describe, expect, it } from "vitest";
import { buildOracleTnsConnectionString, normalizeOracleTnsAdminPath, parseOracleTnsConnectionString } from "./oracleTnsConnection";

describe("Oracle TNS connection settings", () => {
  it("round-trips an alias and TNS_ADMIN directory", () => {
    const value = buildOracleTnsConnectionString("DBX_FAILOVER", "C:\\oracle network\\admin");

    expect(parseOracleTnsConnectionString(value)).toEqual({
      alias: "DBX_FAILOVER",
      tnsAdmin: "C:\\oracle network\\admin",
    });
  });

  it("normalizes a selected tnsnames.ora file to its parent directory", () => {
    expect(normalizeOracleTnsAdminPath("C:\\oracle\\network\\admin\\tnsnames.ora")).toBe("C:\\oracle\\network\\admin");
    expect(normalizeOracleTnsAdminPath("C:\\tnsnames.ora")).toBe("C:\\");
    expect(normalizeOracleTnsAdminPath("/opt/oracle/network/admin/tnsnames.ora")).toBe("/opt/oracle/network/admin");
  });

  it("does not reinterpret service, SID, or descriptor JDBC URLs as TNS aliases", () => {
    expect(parseOracleTnsConnectionString("jdbc:oracle:thin:@//db.example.com:1521/ORCLPDB1")).toBeNull();
    expect(parseOracleTnsConnectionString("jdbc:oracle:thin:@db.example.com:1521:ORCL")).toBeNull();
    expect(parseOracleTnsConnectionString("jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(HOST=db.example.com)))")).toBeNull();
  });

  it("ignores malformed encoded aliases instead of breaking connection editing", () => {
    expect(parseOracleTnsConnectionString("jdbc:oracle:thin:@DBX%ZZ?TNS_ADMIN=%2Fopt%2Foracle")).toBeNull();
  });
});