如何用python解析oracle jdbc ezconnect

1 回答

• 1

  我已经阅读了有关EZCONNECT语法的oracle文档，并编写了正则表达式来解析它 . 第二个字符串是标准jdbc模式的简短版本，因此我将这些正则表达式字符串统一在一个类中以解析每个变体 .

  所以这里是jdbc连接字符串解析器：

  # -*- coding: utf-8 -*-
  
  import re
  
  
  class JDBCParserError(Exception):
      pass
  
  
  class JDBCParser:
      """
      Класс для распарсивания jdbc-строк.
      """
  
      # ezonnect patterns
      jdbc_ezconnect = re.compile("^jdbc:oracle:thin:"
                                  "((?P<username>[a-zA-Z0-9]{1,})"
                                  "([\/](?P<password>[a-zA-Z0-9]{1,})){0,1}){0,1}"
                                  "@"
                                  "(?P<ezdb_name>((\/\/){0,1}"
                                  "(?P<hostname>[a-zA-Z0-9\.\-]{1,})"
                                  "(\:(?P<port>\d+)){0,1})"
                                  "(\/(?P<service_name>[a-zA-Z\.\-0-9]{1,}"
                                  "(\:(?P<server_type>[a-zA-Z]{1,})){0,1}){0,1}"
                                  "(\/(?P<instance_name>[a-zA-Z0-9]{1,})){0,1}){0,1})$")
  
      # jdbc standard pattern - host:port:sid
      jdbc_classic = re.compile("^jdbc:oracle:thin:"
                                "((?P<username>[a-zA-Z0-9]{1,})"
                                "([\/](?P<password>[a-zA-Z0-9]{1,})){0,1}){0,1}"
                                "@"
                                "(?P<connection_string>("
                                "(?P<hostname>[a-zA-Z0-9\.\-]+)"
                                "(\:(?P<port>\d+)))"
                                "(\:(?P<service_name>[a-zA-Z0-9]+)))$")
  
      username = None
      password = None
      ezdb_name = None
      hostname = None
      port = None
      service_name = None
      instance_name = None
  
      connection_string = None
  
      def __init__(self, jdbc_string):
          ezconnect_match = self.jdbc_ezconnect.search(jdbc_string)
          classic_match = self.jdbc_classic.search(jdbc_string)
  
          if ezconnect_match or classic_match:
              if ezconnect_match:
                  self.username = ezconnect_match.group('username')
                  self.password = ezconnect_match.group('password')
                  self.ezdb_name = ezconnect_match.group('ezdb_name')
                  self.hostname = ezconnect_match.group('hostname')
                  self.port = ezconnect_match.group('port')
                  self.service_name = ezconnect_match.group('service_name')
                  self.instance_name = ezconnect_match.group('instance_name')
              if classic_match:
                  self.username = classic_match.group('username')
                  self.password = classic_match.group('password')
                  self.connection_string = classic_match.group('connection_string')
                  self.hostname = classic_match.group('hostname')
                  self.port = classic_match.group('port')
                  self.service_name = classic_match.group('service_name')
          else:
              raise JDBCParserError("JDBC string not recognized")
  

  回复于 2024-04-20T04:48:53+08:00