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
export interface OracleTnsConnectionConfig {
  alias: string;
  tnsAdmin: string;
}

const ORACLE_TNS_JDBC_PREFIX = "jdbc:oracle:thin:@";

export function parseOracleTnsConnectionString(value?: string): OracleTnsConnectionConfig | null {
  const source = value?.trim() || "";
  if (!source.toLowerCase().startsWith(ORACLE_TNS_JDBC_PREFIX)) return null;

  const target = source.slice(ORACLE_TNS_JDBC_PREFIX.length);
  if (!target || target.startsWith("(") || target.startsWith("//") || target.includes(":")) return null;

  const [rawAlias, rawQuery = ""] = target.split("?", 2);
  let alias = "";
  try {
    alias = decodeURIComponent(rawAlias).trim();
  } catch {
    return null;
  }
  const tnsAdmin = new URLSearchParams(rawQuery).get("TNS_ADMIN")?.trim() || "";
  if (!alias) return null;
  return { alias, tnsAdmin };
}

export function buildOracleTnsConnectionString(alias: string, tnsAdmin: string): string {
  const normalizedAlias = alias.trim();
  const normalizedTnsAdmin = normalizeOracleTnsAdminPath(tnsAdmin);
  const query = new URLSearchParams({ TNS_ADMIN: normalizedTnsAdmin });
  return `${ORACLE_TNS_JDBC_PREFIX}${encodeURIComponent(normalizedAlias)}?${query.toString()}`;
}

export function normalizeOracleTnsAdminPath(value: string): string {
  const path = value.trim();
  if (!path) return "";
  if (!/(^|[\\/])tnsnames\.ora$/i.test(path)) return path;

  const parent = path.replace(/[\\/]tnsnames\.ora$/i, "");
  if (/^[A-Za-z]:$/.test(parent)) return `${parent}\\`;
  if (parent) return parent;
  return path.startsWith("\\") ? "\\" : "/";
}