You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by zh...@apache.org on 2020/08/03 09:16:14 UTC

[shardingsphere] branch master updated: Add more test cases for infra module (#6596)

This is an automated email from the ASF dual-hosted git repository.

zhangyonglun pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/shardingsphere.git


The following commit(s) were added to refs/heads/master by this push:
     new 77b2809  Add more test cases for infra module (#6596)
77b2809 is described below

commit 77b28096b8e96b989c240e86521c281439c16b50
Author: Liang Zhang <te...@163.com>
AuthorDate: Mon Aug 3 17:16:03 2020 +0800

    Add more test cases for infra module (#6596)
    
    * Add logback-test.xml for shardingsphere-infra-common module
    
    * Add ShardingSphereAlgorithmFactoryTest
    
    * Add MySQLDataSourceMetaDataTest
    
    * Add MySQLDatabaseTypeTest
    
    * Add test case for getTrunkDatabaseTypeName
---
 .../database/type/dialect/MySQLDatabaseType.java   |  2 +-
 .../ShardingSphereAlgorithmFactoryTest.java        | 57 ++++++++++++++++++++++
 .../infra/config/fixture/WithInitAlgorithm.java}   | 33 ++++++-------
 .../config/fixture/WithoutInitAlgorithm.java}      | 31 +++++-------
 ...est.java => MariaDBDataSourceMetaDataTest.java} | 17 ++-----
 .../dialect/MySQLDataSourceMetaDataTest.java       | 14 +++---
 .../infra/database/type/DatabaseTypesTest.java     | 12 +++++
 .../type/dialect/MySQLDatabaseTypeTest.java}       | 30 ++++++------
 ....infra.config.algorithm.ShardingSphereAlgorithm |  4 +-
 .../src/test/resources/logback-test.xml            | 34 +++++++++++++
 ...hardingsphere.sharding.spi.KeyGenerateAlgorithm |  1 -
 11 files changed, 159 insertions(+), 76 deletions(-)

diff --git a/shardingsphere-infra/shardingsphere-infra-common/src/main/java/org/apache/shardingsphere/infra/database/type/dialect/MySQLDatabaseType.java b/shardingsphere-infra/shardingsphere-infra-common/src/main/java/org/apache/shardingsphere/infra/database/type/dialect/MySQLDatabaseType.java
index a65c96b..95bf20b 100644
--- a/shardingsphere-infra/shardingsphere-infra-common/src/main/java/org/apache/shardingsphere/infra/database/type/dialect/MySQLDatabaseType.java
+++ b/shardingsphere-infra/shardingsphere-infra-common/src/main/java/org/apache/shardingsphere/infra/database/type/dialect/MySQLDatabaseType.java
@@ -35,7 +35,7 @@ public final class MySQLDatabaseType implements DatabaseType {
     
     @Override
     public Collection<String> getJdbcUrlPrefixes() {
-        return Arrays.asList(String.format("jdbc:%s:", getName().toLowerCase()), "jdbc:mysqlx:");
+        return Arrays.asList("jdbc:mysql:", "jdbc:mysqlx:");
     }
     
     @Override
diff --git a/shardingsphere-infra/shardingsphere-infra-common/src/test/java/org/apache/shardingsphere/infra/config/algorithm/ShardingSphereAlgorithmFactoryTest.java b/shardingsphere-infra/shardingsphere-infra-common/src/test/java/org/apache/shardingsphere/infra/config/algorithm/ShardingSphereAlgorithmFactoryTest.java
new file mode 100644
index 0000000..29d7007
--- /dev/null
+++ b/shardingsphere-infra/shardingsphere-infra-common/src/test/java/org/apache/shardingsphere/infra/config/algorithm/ShardingSphereAlgorithmFactoryTest.java
@@ -0,0 +1,57 @@
+/*
+ * 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.config.algorithm;
+
+import org.apache.shardingsphere.infra.config.fixture.WithInitAlgorithm;
+import org.apache.shardingsphere.infra.config.fixture.WithoutInitAlgorithm;
+import org.apache.shardingsphere.infra.spi.ShardingSphereServiceLoader;
+import org.junit.BeforeClass;
+import org.junit.Test;
+
+import java.util.Properties;
+
+import static org.hamcrest.CoreMatchers.instanceOf;
+import static org.hamcrest.CoreMatchers.is;
+import static org.junit.Assert.assertThat;
+
+public final class ShardingSphereAlgorithmFactoryTest {
+    
+    @BeforeClass
+    public static void setUp() {
+        ShardingSphereServiceLoader.register(ShardingSphereAlgorithm.class);
+    }
+    
+    @Test
+    public void assertCreateAlgorithmWithoutInit() {
+        Properties props = new Properties();
+        props.setProperty("key", "value");
+        ShardingSphereAlgorithm actual = ShardingSphereAlgorithmFactory.createAlgorithm(new ShardingSphereAlgorithmConfiguration("WITHOUT_INIT", props), ShardingSphereAlgorithm.class);
+        assertThat(actual, instanceOf(WithoutInitAlgorithm.class));
+        assertThat(actual.getProps().getProperty("key"), is("value"));
+    }
+    
+    @Test
+    public void assertCreateAlgorithmWithInit() {
+        Properties props = new Properties();
+        props.setProperty("key", "value");
+        ShardingSphereAlgorithm actual = ShardingSphereAlgorithmFactory.createAlgorithm(new ShardingSphereAlgorithmConfiguration("WITH_INIT", props), ShardingSphereAlgorithm.class);
+        assertThat(actual, instanceOf(WithInitAlgorithm.class));
+        assertThat(actual.getProps().getProperty("key"), is("value"));
+        assertThat(((WithInitAlgorithm) actual).getTestValue(), is("value"));
+    }
+}
diff --git a/shardingsphere-infra/shardingsphere-infra-common/src/main/java/org/apache/shardingsphere/infra/database/type/dialect/MySQLDatabaseType.java b/shardingsphere-infra/shardingsphere-infra-common/src/test/java/org/apache/shardingsphere/infra/config/fixture/WithInitAlgorithm.java
similarity index 53%
copy from shardingsphere-infra/shardingsphere-infra-common/src/main/java/org/apache/shardingsphere/infra/database/type/dialect/MySQLDatabaseType.java
copy to shardingsphere-infra/shardingsphere-infra-common/src/test/java/org/apache/shardingsphere/infra/config/fixture/WithInitAlgorithm.java
index a65c96b..46711ea 100644
--- a/shardingsphere-infra/shardingsphere-infra-common/src/main/java/org/apache/shardingsphere/infra/database/type/dialect/MySQLDatabaseType.java
+++ b/shardingsphere-infra/shardingsphere-infra-common/src/test/java/org/apache/shardingsphere/infra/config/fixture/WithInitAlgorithm.java
@@ -15,31 +15,30 @@
  * limitations under the License.
  */
 
-package org.apache.shardingsphere.infra.database.type.dialect;
+package org.apache.shardingsphere.infra.config.fixture;
 
-import org.apache.shardingsphere.infra.database.metadata.dialect.MySQLDataSourceMetaData;
-import org.apache.shardingsphere.infra.database.type.DatabaseType;
+import lombok.Getter;
+import lombok.Setter;
+import org.apache.shardingsphere.infra.config.algorithm.ShardingSphereAlgorithm;
+import org.apache.shardingsphere.infra.config.algorithm.ShardingSphereAlgorithmPostProcessor;
 
-import java.util.Arrays;
-import java.util.Collection;
+import java.util.Properties;
 
-/**
- * Database type of MySQL.
- */
-public final class MySQLDatabaseType implements DatabaseType {
+@Getter
+@Setter
+public class WithInitAlgorithm implements ShardingSphereAlgorithm, ShardingSphereAlgorithmPostProcessor {
     
-    @Override
-    public String getName() {
-        return "MySQL";
-    }
+    private Properties props;
+    
+    private String testValue;
     
     @Override
-    public Collection<String> getJdbcUrlPrefixes() {
-        return Arrays.asList(String.format("jdbc:%s:", getName().toLowerCase()), "jdbc:mysqlx:");
+    public void init() {
+        testValue = props.getProperty("key");
     }
     
     @Override
-    public MySQLDataSourceMetaData getDataSourceMetaData(final String url, final String username) {
-        return new MySQLDataSourceMetaData(url);
+    public String getType() {
+        return "WITH_INIT";
     }
 }
diff --git a/shardingsphere-infra/shardingsphere-infra-common/src/main/java/org/apache/shardingsphere/infra/database/type/dialect/MySQLDatabaseType.java b/shardingsphere-infra/shardingsphere-infra-common/src/test/java/org/apache/shardingsphere/infra/config/fixture/WithoutInitAlgorithm.java
similarity index 52%
copy from shardingsphere-infra/shardingsphere-infra-common/src/main/java/org/apache/shardingsphere/infra/database/type/dialect/MySQLDatabaseType.java
copy to shardingsphere-infra/shardingsphere-infra-common/src/test/java/org/apache/shardingsphere/infra/config/fixture/WithoutInitAlgorithm.java
index a65c96b..e90d8c5 100644
--- a/shardingsphere-infra/shardingsphere-infra-common/src/main/java/org/apache/shardingsphere/infra/database/type/dialect/MySQLDatabaseType.java
+++ b/shardingsphere-infra/shardingsphere-infra-common/src/test/java/org/apache/shardingsphere/infra/config/fixture/WithoutInitAlgorithm.java
@@ -15,31 +15,22 @@
  * limitations under the License.
  */
 
-package org.apache.shardingsphere.infra.database.type.dialect;
+package org.apache.shardingsphere.infra.config.fixture;
 
-import org.apache.shardingsphere.infra.database.metadata.dialect.MySQLDataSourceMetaData;
-import org.apache.shardingsphere.infra.database.type.DatabaseType;
+import lombok.Getter;
+import lombok.Setter;
+import org.apache.shardingsphere.infra.config.algorithm.ShardingSphereAlgorithm;
 
-import java.util.Arrays;
-import java.util.Collection;
+import java.util.Properties;
 
-/**
- * Database type of MySQL.
- */
-public final class MySQLDatabaseType implements DatabaseType {
-    
-    @Override
-    public String getName() {
-        return "MySQL";
-    }
+@Getter
+@Setter
+public class WithoutInitAlgorithm implements ShardingSphereAlgorithm {
     
-    @Override
-    public Collection<String> getJdbcUrlPrefixes() {
-        return Arrays.asList(String.format("jdbc:%s:", getName().toLowerCase()), "jdbc:mysqlx:");
-    }
+    private Properties props;
     
     @Override
-    public MySQLDataSourceMetaData getDataSourceMetaData(final String url, final String username) {
-        return new MySQLDataSourceMetaData(url);
+    public String getType() {
+        return "WITHOUT_INIT";
     }
 }
diff --git a/shardingsphere-infra/shardingsphere-infra-common/src/test/java/org/apache/shardingsphere/infra/database/metadata/dialect/MySQLDataSourceMetaDataTest.java b/shardingsphere-infra/shardingsphere-infra-common/src/test/java/org/apache/shardingsphere/infra/database/metadata/dialect/MariaDBDataSourceMetaDataTest.java
similarity index 67%
copy from shardingsphere-infra/shardingsphere-infra-common/src/test/java/org/apache/shardingsphere/infra/database/metadata/dialect/MySQLDataSourceMetaDataTest.java
copy to shardingsphere-infra/shardingsphere-infra-common/src/test/java/org/apache/shardingsphere/infra/database/metadata/dialect/MariaDBDataSourceMetaDataTest.java
index a5ac967..29c66c4 100644
--- a/shardingsphere-infra/shardingsphere-infra-common/src/test/java/org/apache/shardingsphere/infra/database/metadata/dialect/MySQLDataSourceMetaDataTest.java
+++ b/shardingsphere-infra/shardingsphere-infra-common/src/test/java/org/apache/shardingsphere/infra/database/metadata/dialect/MariaDBDataSourceMetaDataTest.java
@@ -24,20 +24,11 @@ import static org.hamcrest.CoreMatchers.is;
 import static org.junit.Assert.assertNull;
 import static org.junit.Assert.assertThat;
 
-public final class MySQLDataSourceMetaDataTest {
+public final class MariaDBDataSourceMetaDataTest {
     
     @Test
     public void assertNewConstructorWithPort() {
-        MySQLDataSourceMetaData actual = new MySQLDataSourceMetaData("jdbc:mysql://127.0.0.1:9999/ds_0?serverTimezone=UTC&useSSL=false");
-        assertThat(actual.getHostName(), is("127.0.0.1"));
-        assertThat(actual.getPort(), is(9999));
-        assertThat(actual.getCatalog(), is("ds_0"));
-        assertNull(actual.getSchema());
-    }
-    
-    @Test
-    public void assertFailoverUrl() {
-        MySQLDataSourceMetaData actual = new MySQLDataSourceMetaData("jdbc:mysql://127.0.0.1:9999,127.0.0.1:3306,127.0.0.1:3307/ds_0?serverTimezone=UTC&useSSL=false");
+        MariaDBDataSourceMetaData actual = new MariaDBDataSourceMetaData("jdbc:mariadb://127.0.0.1:9999/ds_0?serverTimezone=UTC&useSSL=false");
         assertThat(actual.getHostName(), is("127.0.0.1"));
         assertThat(actual.getPort(), is(9999));
         assertThat(actual.getCatalog(), is("ds_0"));
@@ -46,7 +37,7 @@ public final class MySQLDataSourceMetaDataTest {
     
     @Test
     public void assertNewConstructorWithDefaultPort() {
-        MySQLDataSourceMetaData actual = new MySQLDataSourceMetaData("jdbc:mysql:loadbalance://127.0.0.1/ds_0?serverTimezone=UTC&useSSL=false");
+        MariaDBDataSourceMetaData actual = new MariaDBDataSourceMetaData("jdbc:mariadb:replication://127.0.0.1/ds_0?serverTimezone=UTC&useSSL=false");
         assertThat(actual.getHostName(), is("127.0.0.1"));
         assertThat(actual.getPort(), is(3306));
         assertNull(actual.getSchema());
@@ -54,6 +45,6 @@ public final class MySQLDataSourceMetaDataTest {
     
     @Test(expected = UnrecognizedDatabaseURLException.class)
     public void assertNewConstructorFailure() {
-        new MySQLDataSourceMetaData("jdbc:mysql:xxxxxxxx");
+        new MariaDBDataSourceMetaData("jdbc:mariadb:xxxxxxxx");
     }
 }
diff --git a/shardingsphere-infra/shardingsphere-infra-common/src/test/java/org/apache/shardingsphere/infra/database/metadata/dialect/MySQLDataSourceMetaDataTest.java b/shardingsphere-infra/shardingsphere-infra-common/src/test/java/org/apache/shardingsphere/infra/database/metadata/dialect/MySQLDataSourceMetaDataTest.java
index a5ac967..a3656a7 100644
--- a/shardingsphere-infra/shardingsphere-infra-common/src/test/java/org/apache/shardingsphere/infra/database/metadata/dialect/MySQLDataSourceMetaDataTest.java
+++ b/shardingsphere-infra/shardingsphere-infra-common/src/test/java/org/apache/shardingsphere/infra/database/metadata/dialect/MySQLDataSourceMetaDataTest.java
@@ -36,19 +36,19 @@ public final class MySQLDataSourceMetaDataTest {
     }
     
     @Test
-    public void assertFailoverUrl() {
-        MySQLDataSourceMetaData actual = new MySQLDataSourceMetaData("jdbc:mysql://127.0.0.1:9999,127.0.0.1:3306,127.0.0.1:3307/ds_0?serverTimezone=UTC&useSSL=false");
+    public void assertNewConstructorWithDefaultPort() {
+        MySQLDataSourceMetaData actual = new MySQLDataSourceMetaData("jdbc:mysql:loadbalance://127.0.0.1/ds_0?serverTimezone=UTC&useSSL=false");
         assertThat(actual.getHostName(), is("127.0.0.1"));
-        assertThat(actual.getPort(), is(9999));
-        assertThat(actual.getCatalog(), is("ds_0"));
+        assertThat(actual.getPort(), is(3306));
         assertNull(actual.getSchema());
     }
     
     @Test
-    public void assertNewConstructorWithDefaultPort() {
-        MySQLDataSourceMetaData actual = new MySQLDataSourceMetaData("jdbc:mysql:loadbalance://127.0.0.1/ds_0?serverTimezone=UTC&useSSL=false");
+    public void assertMultipleDatabases() {
+        MySQLDataSourceMetaData actual = new MySQLDataSourceMetaData("jdbc:mysql://127.0.0.1:9999,127.0.0.1:3306,127.0.0.1:3307/ds_0?serverTimezone=UTC&useSSL=false");
         assertThat(actual.getHostName(), is("127.0.0.1"));
-        assertThat(actual.getPort(), is(3306));
+        assertThat(actual.getPort(), is(9999));
+        assertThat(actual.getCatalog(), is("ds_0"));
         assertNull(actual.getSchema());
     }
     
diff --git a/shardingsphere-infra/shardingsphere-infra-common/src/test/java/org/apache/shardingsphere/infra/database/type/DatabaseTypesTest.java b/shardingsphere-infra/shardingsphere-infra-common/src/test/java/org/apache/shardingsphere/infra/database/type/DatabaseTypesTest.java
index 3f9761d..3c4e1b0 100644
--- a/shardingsphere-infra/shardingsphere-infra-common/src/test/java/org/apache/shardingsphere/infra/database/type/DatabaseTypesTest.java
+++ b/shardingsphere-infra/shardingsphere-infra-common/src/test/java/org/apache/shardingsphere/infra/database/type/DatabaseTypesTest.java
@@ -17,6 +17,8 @@
 
 package org.apache.shardingsphere.infra.database.type;
 
+import org.apache.shardingsphere.infra.database.type.dialect.MariaDBDatabaseType;
+import org.apache.shardingsphere.infra.database.type.dialect.MySQLDatabaseType;
 import org.apache.shardingsphere.infra.exception.ShardingSphereException;
 import org.junit.Test;
 
@@ -26,6 +28,16 @@ import static org.junit.Assert.assertThat;
 public final class DatabaseTypesTest {
     
     @Test
+    public void assertGetTrunkDatabaseTypeNameWithMasterDatabaseType() {
+        assertThat(DatabaseTypes.getTrunkDatabaseTypeName(new MySQLDatabaseType()), is("MySQL"));
+    }
+    
+    @Test
+    public void assertGetTrunkDatabaseTypeNameWithBranchDatabaseType() {
+        assertThat(DatabaseTypes.getTrunkDatabaseTypeName(new MariaDBDatabaseType()), is("MySQL"));
+    }
+    
+    @Test
     public void assertGetActualDatabaseType() {
         assertThat(DatabaseTypes.getActualDatabaseType("MySQL").getName(), is("MySQL"));
     }
diff --git a/shardingsphere-infra/shardingsphere-infra-common/src/main/java/org/apache/shardingsphere/infra/database/type/dialect/MySQLDatabaseType.java b/shardingsphere-infra/shardingsphere-infra-common/src/test/java/org/apache/shardingsphere/infra/database/type/dialect/MySQLDatabaseTypeTest.java
similarity index 59%
copy from shardingsphere-infra/shardingsphere-infra-common/src/main/java/org/apache/shardingsphere/infra/database/type/dialect/MySQLDatabaseType.java
copy to shardingsphere-infra/shardingsphere-infra-common/src/test/java/org/apache/shardingsphere/infra/database/type/dialect/MySQLDatabaseTypeTest.java
index a65c96b..c5be68e 100644
--- a/shardingsphere-infra/shardingsphere-infra-common/src/main/java/org/apache/shardingsphere/infra/database/type/dialect/MySQLDatabaseType.java
+++ b/shardingsphere-infra/shardingsphere-infra-common/src/test/java/org/apache/shardingsphere/infra/database/type/dialect/MySQLDatabaseTypeTest.java
@@ -18,28 +18,28 @@
 package org.apache.shardingsphere.infra.database.type.dialect;
 
 import org.apache.shardingsphere.infra.database.metadata.dialect.MySQLDataSourceMetaData;
-import org.apache.shardingsphere.infra.database.type.DatabaseType;
+import org.junit.Test;
 
 import java.util.Arrays;
-import java.util.Collection;
 
-/**
- * Database type of MySQL.
- */
-public final class MySQLDatabaseType implements DatabaseType {
+import static org.hamcrest.CoreMatchers.instanceOf;
+import static org.hamcrest.CoreMatchers.is;
+import static org.junit.Assert.assertThat;
+
+public final class MySQLDatabaseTypeTest {
     
-    @Override
-    public String getName() {
-        return "MySQL";
+    @Test
+    public void assertGetName() {
+        assertThat(new MySQLDatabaseType().getName(), is("MySQL"));
     }
     
-    @Override
-    public Collection<String> getJdbcUrlPrefixes() {
-        return Arrays.asList(String.format("jdbc:%s:", getName().toLowerCase()), "jdbc:mysqlx:");
+    @Test
+    public void assertGetJdbcUrlPrefixes() {
+        assertThat(new MySQLDatabaseType().getJdbcUrlPrefixes(), is(Arrays.asList("jdbc:mysql:", "jdbc:mysqlx:")));
     }
     
-    @Override
-    public MySQLDataSourceMetaData getDataSourceMetaData(final String url, final String username) {
-        return new MySQLDataSourceMetaData(url);
+    @Test
+    public void assertGetDataSourceMetaData() {
+        assertThat(new MySQLDatabaseType().getDataSourceMetaData("jdbc:mysql://127.0.0.1/ds", "root"), instanceOf(MySQLDataSourceMetaData.class));
     }
 }
diff --git a/shardingsphere-integration-test/shardingsphere-test-fixture/src/test/resources/META-INF/services/org.apache.shardingsphere.sharding.spi.KeyGenerateAlgorithm b/shardingsphere-infra/shardingsphere-infra-common/src/test/resources/META-INF/services/org.apache.shardingsphere.infra.config.algorithm.ShardingSphereAlgorithm
similarity index 85%
copy from shardingsphere-integration-test/shardingsphere-test-fixture/src/test/resources/META-INF/services/org.apache.shardingsphere.sharding.spi.KeyGenerateAlgorithm
copy to shardingsphere-infra/shardingsphere-infra-common/src/test/resources/META-INF/services/org.apache.shardingsphere.infra.config.algorithm.ShardingSphereAlgorithm
index 1e46ced..bbc8c86 100644
--- a/shardingsphere-integration-test/shardingsphere-test-fixture/src/test/resources/META-INF/services/org.apache.shardingsphere.sharding.spi.KeyGenerateAlgorithm
+++ b/shardingsphere-infra/shardingsphere-infra-common/src/test/resources/META-INF/services/org.apache.shardingsphere.infra.config.algorithm.ShardingSphereAlgorithm
@@ -15,5 +15,5 @@
 # limitations under the License.
 #
 
-org.apache.shardingsphere.dbtest.fixture.ConstantKeyGenerateAlgorithm
-
+org.apache.shardingsphere.infra.config.fixture.WithInitAlgorithm
+org.apache.shardingsphere.infra.config.fixture.WithoutInitAlgorithm
diff --git a/shardingsphere-infra/shardingsphere-infra-common/src/test/resources/logback-test.xml b/shardingsphere-infra/shardingsphere-infra-common/src/test/resources/logback-test.xml
new file mode 100644
index 0000000..6d1bbb7
--- /dev/null
+++ b/shardingsphere-infra/shardingsphere-infra-common/src/test/resources/logback-test.xml
@@ -0,0 +1,34 @@
+<?xml version="1.0"?>
+<!--
+  ~ 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.
+  -->
+
+<configuration>
+    <appender name="console" class="ch.qos.logback.core.ConsoleAppender">
+        <encoder>
+            <pattern>[%-5level] %d{HH:mm:ss.SSS} [%thread] %logger{36} - %msg%n</pattern>
+        </encoder>
+    </appender>
+    <logger name="org.apache.shardingsphere" level="info" additivity="false">
+        <appender-ref ref="console"/>
+    </logger>
+    <logger name="com.zaxxer.hikari.HikariConfig" level="warn" />
+    
+    <root>
+        <level value="error" />
+        <appender-ref ref="console" />
+    </root>
+</configuration> 
diff --git a/shardingsphere-integration-test/shardingsphere-test-fixture/src/test/resources/META-INF/services/org.apache.shardingsphere.sharding.spi.KeyGenerateAlgorithm b/shardingsphere-integration-test/shardingsphere-test-fixture/src/test/resources/META-INF/services/org.apache.shardingsphere.sharding.spi.KeyGenerateAlgorithm
index 1e46ced..2b32ce5 100644
--- a/shardingsphere-integration-test/shardingsphere-test-fixture/src/test/resources/META-INF/services/org.apache.shardingsphere.sharding.spi.KeyGenerateAlgorithm
+++ b/shardingsphere-integration-test/shardingsphere-test-fixture/src/test/resources/META-INF/services/org.apache.shardingsphere.sharding.spi.KeyGenerateAlgorithm
@@ -16,4 +16,3 @@
 #
 
 org.apache.shardingsphere.dbtest.fixture.ConstantKeyGenerateAlgorithm
-