/*
 * Licensed to the Apache Software Foundation (ASF) under one or more
 * contributor license agreements.  See the NOTICE file distributed with
 * this work for additional information regarding copyright ownership.
 * The ASF licenses this file to You under the Apache License, Version 2.0
 * (the "License"); you may not use this file except in compliance with
 * the License.  You may obtain a copy of the License at
 *
 *     http://www.apache.org/licenses/LICENSE-2.0
 *
 * Unless required by applicable law or agreed to in writing, software
 * distributed under the License is distributed on an "AS IS" BASIS,
 * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
 * See the License for the specific language governing permissions and
 * limitations under the License.
 */

package org.apache.shardingsphere.infra.database.metadata.dialect;

import com.google.common.base.Strings;
import lombok.Getter;
import org.apache.shardingsphere.infra.database.metadata.DataSourceMetaData;
import org.apache.shardingsphere.infra.database.metadata.UnrecognizedDatabaseURLException;

import java.util.regex.Matcher;
import java.util.regex.Pattern;

/**
 * Data source meta data for Oracle.
 */
@Getter
public final class OracleDataSourceMetaData implements DataSourceMetaData {
    
    private static final int DEFAULT_PORT = 1521;
    
    private String hostName;
    
    private int port;
    
    private String catalog;
    
    private String schema;
    
    private final Pattern thinUrlPattern = Pattern.compile("jdbc:oracle:(thin|oci|kprb):@(//)?([\\w\\-\\.]+):?([0-9]*)[:/]([\\w\\-]+)", Pattern.CASE_INSENSITIVE);
    
    private final Pattern connectDescriptorUrlPattern = Pattern.compile("jdbc:oracle:(thin|oci|kprb):@[(\\w\\s=)]+HOST\\s*=\\s*(\\d+(\\."
            + "((2(5[0-5]|[0-4]\\d))|[0-1]?\\d{1,2})){3}).*PORT\\s*=\\s*(\\d+).*SERVICE_NAME\\s*=\\s*(\\w+)\\)");
    
    public OracleDataSourceMetaData(final String url, final String username) {
        Matcher matcher = thinUrlPattern.matcher(url);
        if (!matcher.find()) {
            matchWithConnectDescriptorPattern(url, username);
            return;
        }
        hostName = matcher.group(3);
        port = Strings.isNullOrEmpty(matcher.group(4)) ? DEFAULT_PORT : Integer.parseInt(matcher.group(4));
        catalog = matcher.group(5);
        schema = username;
    }
    
    private void matchWithConnectDescriptorPattern(final String url, final String username) {
        Matcher matcher = connectDescriptorUrlPattern.matcher(url);
        if (!matcher.find()) {
            throw new UnrecognizedDatabaseURLException(url, connectDescriptorUrlPattern.pattern());
        }
        hostName = matcher.group(2);
        port = Integer.parseInt(matcher.group(7));
        catalog = matcher.group(8);
        schema = username;
    }
}

@@ -1356,24 +1356,30 @@
     private 
+final 
 String hostN
@@ -1400,16 +1400,22 @@
 private 
+final 
 int port
@@ -1429,24 +1429,30 @@
     private 
+final 
 String catal
@@ -1472,16 +1472,22 @@
 private 
+final 
 String s
@@ -2101,29 +2101,30 @@
        match
-WithC
+er = c
 onnectDescri
@@ -2131,50 +2131,170 @@
 ptor
+Url
 Pattern
-(url, username);%0A            return
+.matcher(url);%0A            if (!matcher.find()) %7B%0A                throw new UnrecognizedDatabaseURLException(url, connectDescriptorUrlPattern.pattern())
 ;%0A  
@@ -2291,34 +2291,42 @@
 ern());%0A        
+ 
-%7D%0A
+   %7D%0A    
         hostName
@@ -2342,17 +2342,17 @@
 r.group(
-3
+2
 );%0A     
@@ -2358,71 +2358,18 @@
     
+ 
+   
 port =
- Strings.isNullOrEmpty(matcher.group(4)) ? DEFAULT_PORT :
  Int
@@ -2400,13 +2400,17 @@
 oup(
-4
+7
 ));%0A
+    
     
@@ -2437,17 +2437,17 @@
 r.group(
-5
+8
 );%0A     
@@ -2441,32 +2441,36 @@
 oup(8);%0A        
+    
 schema = usernam
@@ -2480,369 +2480,142 @@
     
-%7D%0A
     
-%0A
     
-private void matchWithConnectDescriptorPattern(final String url, final String username) %7B%0A        Matcher matcher = connectDescriptorUrlPattern.matcher(url);%0A        if (!matcher.find()) %7B%0A            throw new UnrecognizedDatabaseURLException(url, connectDescriptorUrlPattern.pattern());%0A        %7D%0A        hostName = matcher.group(2);%0A        port =
+return;%0A        %7D%0A        hostName = matcher.group(3);%0A        port = Strings.isNullOrEmpty(matcher.group(4)) ? DEFAULT_PORT :
  Int
@@ -2634,33 +2634,33 @@
 t(matcher.group(
-7
+4
 ));%0A        cata
@@ -2671,33 +2671,33 @@
 = matcher.group(
-8
+5
 );%0A        schem

change variable to final