You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by yx...@apache.org on 2022/05/05 13:28:53 UTC
[shardingsphere] branch master updated: Rename ITStandardShardingAlgorithmFixture (#17348)

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

yx9o 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 01af864c821 Rename ITStandardShardingAlgorithmFixture (#17348)
01af864c821 is described below

commit 01af864c821621ea5e48864e77c4cedcc378b1a1
Author: Liang Zhang <zh...@apache.org>
AuthorDate: Thu May 5 21:28:39 2022 +0800

    Rename ITStandardShardingAlgorithmFixture (#17348)
---
 ...Algorithm.java => ITStandardShardingAlgorithmFixture.java} | 11 ++---------
 .../org.apache.shardingsphere.sharding.spi.ShardingAlgorithm  |  2 +-
 .../test/resources/cases/rql/dataset/db/show_algorithms.xml   |  2 +-
 .../src/test/resources/cases/rql/dataset/db/show_rules.xml    |  6 +++---
 .../test/resources/cases/rql/dataset/db/show_table_rule.xml   |  2 +-
 .../dbtbl_with_readwrite_splitting/show_algorithms.xml        |  2 +-
 .../rql/dataset/dbtbl_with_readwrite_splitting/show_rules.xml |  6 +++---
 .../dbtbl_with_readwrite_splitting/show_table_rule.xml        |  2 +-
 .../show_algorithms.xml                                       |  2 +-
 .../dbtbl_with_readwrite_splitting_and_encrypt/show_rules.xml |  6 +++---
 .../show_table_rule.xml                                       |  2 +-
 .../test/resources/cases/rql/dataset/tbl/show_algorithms.xml  |  2 +-
 .../src/test/resources/cases/rql/dataset/tbl/show_rules.xml   |  6 +++---
 .../test/resources/cases/rql/dataset/tbl/show_table_rule.xml  |  2 +-
 .../resources/env/scenario/db/proxy/conf/mysql/config-db.yaml |  2 +-
 .../env/scenario/db/proxy/conf/postgresql/config-db.yaml      |  2 +-
 .../src/test/resources/env/scenario/db/rules.yaml             |  2 +-
 .../conf/mysql/config-dbtbl-with-readwrite-splitting.yaml     |  2 +-
 .../postgresql/config-dbtbl-with-readwrite-splitting.yaml     |  2 +-
 .../env/scenario/dbtbl_with_readwrite_splitting/rules.yaml    |  2 +-
 .../config-dbtbl-with-readwrite-splitting-and-encrypt.yaml    |  2 +-
 .../config-dbtbl-with-readwrite-splitting-and-encrypt.yaml    |  2 +-
 .../dbtbl_with_readwrite_splitting_and_encrypt/rules.yaml     |  2 +-
 .../env/scenario/tbl/proxy/conf/mysql/config-tbl.yaml         |  2 +-
 .../env/scenario/tbl/proxy/conf/postgresql/config-tbl.yaml    |  2 +-
 .../src/test/resources/env/scenario/tbl/rules.yaml            |  2 +-
 26 files changed, 35 insertions(+), 42 deletions(-)

diff --git a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-fixture/src/test/java/org/apache/shardingsphere/test/integration/fixture/StandardModuloAlgorithm.java b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-fixture/src/test/java/org/apache/shardingsphere/test/integration/fixture/ITStandardShardingAlgorithmFixture.java
similarity index 91%
rename from shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-fixture/src/test/java/org/apache/shardingsphere/test/integration/fixture/StandardModuloAlgorithm.java
rename to shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-fixture/src/test/java/org/apache/shardingsphere/test/integration/fixture/ITStandardShardingAlgorithmFixture.java
index e1e88e4cdae..cc5fbb5c049 100644
--- a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-fixture/src/test/java/org/apache/shardingsphere/test/integration/fixture/StandardModuloAlgorithm.java
+++ b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-fixture/src/test/java/org/apache/shardingsphere/test/integration/fixture/ITStandardShardingAlgorithmFixture.java
@@ -17,8 +17,6 @@
 
 package org.apache.shardingsphere.test.integration.fixture;
 
-import lombok.Getter;
-import lombok.Setter;
 import org.apache.shardingsphere.sharding.api.sharding.standard.PreciseShardingValue;
 import org.apache.shardingsphere.sharding.api.sharding.standard.RangeShardingValue;
 import org.apache.shardingsphere.sharding.api.sharding.standard.StandardShardingAlgorithm;
@@ -26,13 +24,8 @@ import org.apache.shardingsphere.sharding.api.sharding.standard.StandardSharding
 import java.math.BigInteger;
 import java.util.Collection;
 import java.util.LinkedHashSet;
-import java.util.Properties;
 
-public final class StandardModuloAlgorithm implements StandardShardingAlgorithm<Integer> {
-    
-    @Getter
-    @Setter
-    private Properties props;
+public final class ITStandardShardingAlgorithmFixture implements StandardShardingAlgorithm<Integer> {
     
     @Override
     public String doSharding(final Collection<String> availableTargetNames, final PreciseShardingValue<Integer> shardingValue) {
@@ -66,6 +59,6 @@ public final class StandardModuloAlgorithm implements StandardShardingAlgorithm<
     
     @Override
     public String getType() {
-        return "STANDARD_TEST";
+        return "IT.STANDARD.FIXTURE";
     }
 }
diff --git a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-fixture/src/test/resources/META-INF/services/org.apache.shardingsphere.sharding.spi.ShardingAlgorithm b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-fixture/src/test/resources/META-INF/services/org.apache.shardingsphere.sharding.spi.ShardingAlgorithm
index 34e2957ebdc..3cdaaeaa8b5 100644
--- a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-fixture/src/test/resources/META-INF/services/org.apache.shardingsphere.sharding.spi.ShardingAlgorithm
+++ b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-fixture/src/test/resources/META-INF/services/org.apache.shardingsphere.sharding.spi.ShardingAlgorithm
@@ -15,4 +15,4 @@
 # limitations under the License.
 #
  
-org.apache.shardingsphere.test.integration.fixture.StandardModuloAlgorithm
+org.apache.shardingsphere.test.integration.fixture.ITStandardShardingAlgorithmFixture
diff --git a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/rql/dataset/db/show_algorithms.xml b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/rql/dataset/db/show_algorithms.xml
index 51bcdec237c..4cc39b3cf7c 100644
--- a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/rql/dataset/db/show_algorithms.xml
+++ b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/rql/dataset/db/show_algorithms.xml
@@ -21,7 +21,7 @@
         <column name="type" />
         <column name="props" />
     </metadata>
-    <row values="standard_test| STANDARD_TEST| " />
+    <row values="standard_test| IT.STANDARD.FIXTURE| " />
     <row values="db_inline_order_id| INLINE| algorithm-expression=ds_${order_id_sharding % 2}" />
     <row values="db_inline_item_id| INLINE| algorithm-expression=ds_${db_inline_item_id % 2}" />
 </dataset>
diff --git a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/rql/dataset/db/show_rules.xml b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/rql/dataset/db/show_rules.xml
index 61697732b4a..1630efea627 100644
--- a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/rql/dataset/db/show_rules.xml
+++ b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/rql/dataset/db/show_rules.xml
@@ -32,9 +32,9 @@
         <column name="key_generator_type" />
         <column name="key_generator_props" />
     </metadata>
-    <row values="t_order| ds_${0..9}.t_order| | STANDARD_TEST| user_id| STANDARD_TEST| | | | | | | | " />
-    <row values="t_order_item| ds_${0..9}.t_order_item| | STANDARD_TEST| user_id| STANDARD_TEST| | | | | | item_id| CONSTANT| " />
-    <row values="t_order_details| ds_${0..9}.t_order_details| | STANDARD_TEST| user_id| STANDARD_TEST| | | | | | | " />
+    <row values="t_order| ds_${0..9}.t_order| | IT.STANDARD.FIXTURE| user_id| IT.STANDARD.FIXTURE| | | | | | | | " />
+    <row values="t_order_item| ds_${0..9}.t_order_item| | IT.STANDARD.FIXTURE| user_id| IT.STANDARD.FIXTURE| | | | | | item_id| CONSTANT| " />
+    <row values="t_order_details| ds_${0..9}.t_order_details| | IT.STANDARD.FIXTURE| user_id| IT.STANDARD.FIXTURE| | | | | | | " />
     <row values="t_order_federate_sharding| ds_${0..1}.t_order_federate_sharding| | INLINE| order_id_sharding| INLINE| algorithm-expression=ds_${order_id_sharding % 2}| | | | | | | " />
     <row values="t_order_item_federate_sharding| ds_${0..1}.t_order_item_federate_sharding| | INLINE| item_id| INLINE| algorithm-expression=ds_${db_inline_item_id % 2}| | | | | | | " />
 </dataset>
diff --git a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/rql/dataset/db/show_table_rule.xml b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/rql/dataset/db/show_table_rule.xml
index 136a27cc50a..70c88a7f818 100644
--- a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/rql/dataset/db/show_table_rule.xml
+++ b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/rql/dataset/db/show_table_rule.xml
@@ -32,5 +32,5 @@
         <column name="key_generator_type" />
         <column name="key_generator_props" />
     </metadata>
-    <row values="t_order| ds_${0..9}.t_order| | STANDARD_TEST| user_id| STANDARD_TEST| | | | | | | | " />
+    <row values="t_order| ds_${0..9}.t_order| | IT.STANDARD.FIXTURE| user_id| IT.STANDARD.FIXTURE| | | | | | | | " />
 </dataset>
diff --git a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/rql/dataset/dbtbl_with_readwrite_splitting/show_algorithms.xml b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/rql/dataset/dbtbl_with_readwrite_splitting/show_algorithms.xml
index 5aa43753778..628a25f28ea 100644
--- a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/rql/dataset/dbtbl_with_readwrite_splitting/show_algorithms.xml
+++ b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/rql/dataset/dbtbl_with_readwrite_splitting/show_algorithms.xml
@@ -21,7 +21,7 @@
         <column name="type" />
         <column name="props" />
     </metadata>
-    <row values="standard_test| STANDARD_TEST| " />
+    <row values="standard_test| IT.STANDARD.FIXTURE| " />
     <row values="table_inline_item_id| INLINE| algorithm-expression=t_order_item_federate_sharding_${item_id % 2}" />
     <row values="table_inline_order_id| INLINE| algorithm-expression=t_order_federate_sharding_${order_id_sharding % 2}" />
 </dataset>
diff --git a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/rql/dataset/dbtbl_with_readwrite_splitting/show_rules.xml b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/rql/dataset/dbtbl_with_readwrite_splitting/show_rules.xml
index f058c1f53f5..31ac2194b06 100644
--- a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/rql/dataset/dbtbl_with_readwrite_splitting/show_rules.xml
+++ b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/rql/dataset/dbtbl_with_readwrite_splitting/show_rules.xml
@@ -32,9 +32,9 @@
         <column name="key_generator_type" />
         <column name="key_generator_props" />
     </metadata>
-    <row values="t_order| readwrite_ds_${0..9}.t_order_${0..9}| | STANDARD_TEST| user_id| STANDARD_TEST| | STANDARD_TEST| order_id| STANDARD_TEST| | | | " />
-    <row values="t_order_item| readwrite_ds_${0..9}.t_order_item_${0..9}| | STANDARD_TEST| user_id| STANDARD_TEST| | STANDARD_TEST| order_id| STANDARD_TEST| | item_id| CONSTANT| " />
-    <row values="t_order_details| readwrite_ds_${0..9}.t_order_details_${0..9}| | STANDARD_TEST| user_id| STANDARD_TEST| | STANDARD_TEST| order_id| STANDARD_TEST| | | | " />
+    <row values="t_order| readwrite_ds_${0..9}.t_order_${0..9}| | IT.STANDARD.FIXTURE| user_id| IT.STANDARD.FIXTURE| | IT.STANDARD.FIXTURE| order_id| IT.STANDARD.FIXTURE| | | | " />
+    <row values="t_order_item| readwrite_ds_${0..9}.t_order_item_${0..9}| | IT.STANDARD.FIXTURE| user_id| IT.STANDARD.FIXTURE| | IT.STANDARD.FIXTURE| order_id| IT.STANDARD.FIXTURE| | item_id| CONSTANT| " />
+    <row values="t_order_details| readwrite_ds_${0..9}.t_order_details_${0..9}| | IT.STANDARD.FIXTURE| user_id| IT.STANDARD.FIXTURE| | IT.STANDARD.FIXTURE| order_id| IT.STANDARD.FIXTURE| | | | " />
     <row values="t_order_item_federate_sharding | readwrite_ds_1.t_order_item_federate_sharding_${0..1}| | | | | | INLINE| item_id| INLINE| algorithm-expression=t_order_item_federate_sharding_${item_id % 2}| | | " />
     <row values="t_order_federate_sharding | readwrite_ds_1.t_order_federate_sharding_${0..1}| | | | | | INLINE| order_id_sharding| INLINE| algorithm-expression=t_order_federate_sharding_${order_id_sharding % 2}| | | " />
 </dataset>
diff --git a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/rql/dataset/dbtbl_with_readwrite_splitting/show_table_rule.xml b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/rql/dataset/dbtbl_with_readwrite_splitting/show_table_rule.xml
index 919603af226..29171f0b2b0 100644
--- a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/rql/dataset/dbtbl_with_readwrite_splitting/show_table_rule.xml
+++ b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/rql/dataset/dbtbl_with_readwrite_splitting/show_table_rule.xml
@@ -32,5 +32,5 @@
         <column name="key_generator_type" />
         <column name="key_generator_props" />
     </metadata>
-    <row values="t_order| readwrite_ds_${0..9}.t_order_${0..9}| | STANDARD_TEST| user_id| STANDARD_TEST| | STANDARD_TEST| order_id| STANDARD_TEST| | | | " />
+    <row values="t_order| readwrite_ds_${0..9}.t_order_${0..9}| | IT.STANDARD.FIXTURE| user_id| IT.STANDARD.FIXTURE| | IT.STANDARD.FIXTURE| order_id| IT.STANDARD.FIXTURE| | | | " />
 </dataset>
diff --git a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/rql/dataset/dbtbl_with_readwrite_splitting_and_encrypt/show_algorithms.xml b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/rql/dataset/dbtbl_with_readwrite_splitting_and_encrypt/show_algorithms.xml
index 65b1d55b997..7ef36617b0d 100644
--- a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/rql/dataset/dbtbl_with_readwrite_splitting_and_encrypt/show_algorithms.xml
+++ b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/rql/dataset/dbtbl_with_readwrite_splitting_and_encrypt/show_algorithms.xml
@@ -21,7 +21,7 @@
         <column name="type" />
         <column name="props" />
     </metadata>
-    <row values="standard_test| STANDARD_TEST| " />
+    <row values="standard_test| IT.STANDARD.FIXTURE| " />
     <row values="table_inline_item_id| INLINE| algorithm-expression=t_order_item_federate_sharding_${item_id % 2}" />
     <row values="table_inline_order_id| INLINE| algorithm-expression=t_order_federate_sharding_${order_id_sharding % 2}" />
     <row values="table_inline_user_id| INLINE| algorithm-expression=t_user_encrypt_federate_sharding_${user_id % 2},allow-range-query-with-inline-sharding=true" />
diff --git a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/rql/dataset/dbtbl_with_readwrite_splitting_and_encrypt/show_rules.xml b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/rql/dataset/dbtbl_with_readwrite_splitting_and_encrypt/show_rules.xml
index 854e6b746e4..ee6c974169e 100644
--- a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/rql/dataset/dbtbl_with_readwrite_splitting_and_encrypt/show_rules.xml
+++ b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/rql/dataset/dbtbl_with_readwrite_splitting_and_encrypt/show_rules.xml
@@ -32,9 +32,9 @@
         <column name="key_generator_type" />
         <column name="key_generator_props" />
     </metadata>
-    <row values="t_user_item| readwrite_ds_${0..9}.t_user_item_${0..9}| | STANDARD_TEST| user_id| STANDARD_TEST| | STANDARD_TEST| item_id| STANDARD_TEST| | item_id| CONSTANT| " />
-    <row values="t_user| readwrite_ds_${0..9}.t_user_${0..9}| | STANDARD_TEST| address_id| STANDARD_TEST| | STANDARD_TEST| user_id| STANDARD_TEST| | user_id| CONSTANT| " />
-    <row values="t_user_details| readwrite_ds_${0..9}.t_user_details_${0..9}| | STANDARD_TEST| address_id| STANDARD_TEST| | STANDARD_TEST| user_id| STANDARD_TEST| | | | " />
+    <row values="t_user_item| readwrite_ds_${0..9}.t_user_item_${0..9}| | IT.STANDARD.FIXTURE| user_id| IT.STANDARD.FIXTURE| | IT.STANDARD.FIXTURE| item_id| IT.STANDARD.FIXTURE| | item_id| CONSTANT| " />
+    <row values="t_user| readwrite_ds_${0..9}.t_user_${0..9}| | IT.STANDARD.FIXTURE| address_id| IT.STANDARD.FIXTURE| | IT.STANDARD.FIXTURE| user_id| IT.STANDARD.FIXTURE| | user_id| CONSTANT| " />
+    <row values="t_user_details| readwrite_ds_${0..9}.t_user_details_${0..9}| | IT.STANDARD.FIXTURE| address_id| IT.STANDARD.FIXTURE| | IT.STANDARD.FIXTURE| user_id| IT.STANDARD.FIXTURE| | | | " />
     <row values="t_order_item_federate_sharding| readwrite_ds_1.t_order_item_federate_sharding_${0..1}| | | | | | INLINE| item_id| INLINE| algorithm-expression=t_order_item_federate_sharding_${item_id % 2}| | | " />
     <row values="t_order_federate_sharding| readwrite_ds_1.t_order_federate_sharding_${0..1}| | | | | | INLINE| order_id_sharding| INLINE| algorithm-expression=t_order_federate_sharding_${order_id_sharding % 2}| | | " />
     <row values="t_user_encrypt_federate_sharding| readwrite_ds_1.t_user_encrypt_federate_sharding_${0..1}| | | | | | INLINE| user_id| INLINE| algorithm-expression=t_user_encrypt_federate_sharding_${user_id % 2},allow-range-query-with-inline-sharding=true| | | " />
diff --git a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/rql/dataset/dbtbl_with_readwrite_splitting_and_encrypt/show_table_rule.xml b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/rql/dataset/dbtbl_with_readwrite_splitting_and_encrypt/show_table_rule.xml
index e608721b455..49ae6ada640 100644
--- a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/rql/dataset/dbtbl_with_readwrite_splitting_and_encrypt/show_table_rule.xml
+++ b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/rql/dataset/dbtbl_with_readwrite_splitting_and_encrypt/show_table_rule.xml
@@ -32,5 +32,5 @@
         <column name="key_generator_type" />
         <column name="key_generator_props" />
     </metadata>
-    <row values="t_user| readwrite_ds_${0..9}.t_user_${0..9}| | STANDARD_TEST| address_id| STANDARD_TEST| | STANDARD_TEST| user_id| STANDARD_TEST| | user_id| CONSTANT| " />
+    <row values="t_user| readwrite_ds_${0..9}.t_user_${0..9}| | IT.STANDARD.FIXTURE| address_id| IT.STANDARD.FIXTURE| | IT.STANDARD.FIXTURE| user_id| IT.STANDARD.FIXTURE| | user_id| CONSTANT| " />
 </dataset>
diff --git a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/rql/dataset/tbl/show_algorithms.xml b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/rql/dataset/tbl/show_algorithms.xml
index b7fae55b606..1c4bf2066a4 100644
--- a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/rql/dataset/tbl/show_algorithms.xml
+++ b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/rql/dataset/tbl/show_algorithms.xml
@@ -21,7 +21,7 @@
         <column name="type" />
         <column name="props" />
     </metadata>
-    <row values="standard_test| STANDARD_TEST| " />
+    <row values="standard_test| IT.STANDARD.FIXTURE| " />
     <row values="table_inline_item_id| INLINE| algorithm-expression=t_order_item_federate_sharding_${item_id % 2}" />
     <row values="table_inline_order_id| INLINE| algorithm-expression=t_order_federate_sharding_${order_id_sharding % 2},allow-range-query-with-inline-sharding=true" />
 </dataset>
diff --git a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/rql/dataset/tbl/show_rules.xml b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/rql/dataset/tbl/show_rules.xml
index dc55cc11717..7b5821da912 100644
--- a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/rql/dataset/tbl/show_rules.xml
+++ b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/rql/dataset/tbl/show_rules.xml
@@ -32,9 +32,9 @@
         <column name="key_generator_type" />
         <column name="key_generator_props" />
     </metadata>
-    <row values="t_order| tbl.t_order_${0..9}| | | | | | STANDARD_TEST| order_id| STANDARD_TEST| | | | " />
-    <row values="t_order_item| tbl.t_order_item_${0..9}| | | | | | STANDARD_TEST| order_id| STANDARD_TEST| | item_id| CONSTANT| " />
-    <row values="t_order_details| tbl.t_order_details_${0..9}| | | | | | STANDARD_TEST| order_id| STANDARD_TEST| | | | " />
+    <row values="t_order| tbl.t_order_${0..9}| | | | | | IT.STANDARD.FIXTURE| order_id| IT.STANDARD.FIXTURE| | | | " />
+    <row values="t_order_item| tbl.t_order_item_${0..9}| | | | | | IT.STANDARD.FIXTURE| order_id| IT.STANDARD.FIXTURE| | item_id| CONSTANT| " />
+    <row values="t_order_details| tbl.t_order_details_${0..9}| | | | | | IT.STANDARD.FIXTURE| order_id| IT.STANDARD.FIXTURE| | | | " />
     <row values="t_order_federate_sharding| tbl.t_order_federate_sharding_${0..1}| | | | | | INLINE| order_id_sharding| INLINE| algorithm-expression=t_order_federate_sharding_${order_id_sharding % 2},allow-range-query-with-inline-sharding=true| | | " />
     <row values="t_order_item_federate_sharding | tbl.t_order_item_federate_sharding_${0..1}| | | | | | INLINE| item_id| INLINE| algorithm-expression=t_order_item_federate_sharding_${item_id % 2}| | | " />
 </dataset>
diff --git a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/rql/dataset/tbl/show_table_rule.xml b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/rql/dataset/tbl/show_table_rule.xml
index 16202abbb12..1cfa115fb77 100644
--- a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/rql/dataset/tbl/show_table_rule.xml
+++ b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/rql/dataset/tbl/show_table_rule.xml
@@ -32,5 +32,5 @@
         <column name="key_generator_type" />
         <column name="key_generator_props" />
     </metadata>
-    <row values="t_order| tbl.t_order_${0..9}| | | | | | STANDARD_TEST| order_id| STANDARD_TEST| | | | " />
+    <row values="t_order| tbl.t_order_${0..9}| | | | | | IT.STANDARD.FIXTURE| order_id| IT.STANDARD.FIXTURE| | | | " />
 </dataset>
diff --git a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/db/proxy/conf/mysql/config-db.yaml b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/db/proxy/conf/mysql/config-db.yaml
index d12b7e42078..474999b09e5 100644
--- a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/db/proxy/conf/mysql/config-db.yaml
+++ b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/db/proxy/conf/mysql/config-db.yaml
@@ -152,7 +152,7 @@ rules:
     - t_broadcast_table_for_ddl
   shardingAlgorithms:
     standard_test:
-      type: STANDARD_TEST
+      type: IT.STANDARD.FIXTURE
     db_inline_order_id:
       type: INLINE
       props:
diff --git a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/db/proxy/conf/postgresql/config-db.yaml b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/db/proxy/conf/postgresql/config-db.yaml
index 75a67da7507..984163f8968 100644
--- a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/db/proxy/conf/postgresql/config-db.yaml
+++ b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/db/proxy/conf/postgresql/config-db.yaml
@@ -152,7 +152,7 @@ rules:
     - t_broadcast_table_for_ddl
   shardingAlgorithms:
     standard_test:
-      type: STANDARD_TEST
+      type: IT.STANDARD.FIXTURE
     db_inline_order_id:
       type: INLINE
       props:
diff --git a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/db/rules.yaml b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/db/rules.yaml
index ff2d3d223a4..caeebc56736 100644
--- a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/db/rules.yaml
+++ b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/db/rules.yaml
@@ -60,7 +60,7 @@ rules:
 
   shardingAlgorithms:
     standard_test:
-      type: STANDARD_TEST
+      type: IT.STANDARD.FIXTURE
     db_inline_order_id:
       type: INLINE
       props:
diff --git a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting/proxy/conf/mysql/config-dbtbl-with-readwrite-splitting.yaml b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting/proxy/conf/mysql/config-dbtbl-with-readwrite-splitting.yaml
index a9ee3f1c7d2..71dc57c7d5d 100644
--- a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting/proxy/conf/mysql/config-dbtbl-with-readwrite-splitting.yaml
+++ b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting/proxy/conf/mysql/config-dbtbl-with-readwrite-splitting.yaml
@@ -254,7 +254,7 @@ rules:
     - t_broadcast_table_for_ddl
   shardingAlgorithms:
     standard_test:
-      type: STANDARD_TEST
+      type: IT.STANDARD.FIXTURE
     table_inline_item_id:
       type: INLINE
       props:
diff --git a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting/proxy/conf/postgresql/config-dbtbl-with-readwrite-splitting.yaml b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting/proxy/conf/postgresql/config-dbtbl-with-readwrite-splitting.yaml
index 01dda10aac0..7518d22f97d 100644
--- a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting/proxy/conf/postgresql/config-dbtbl-with-readwrite-splitting.yaml
+++ b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting/proxy/conf/postgresql/config-dbtbl-with-readwrite-splitting.yaml
@@ -254,7 +254,7 @@ rules:
     - t_broadcast_table_for_ddl
   shardingAlgorithms:
     standard_test:
-      type: STANDARD_TEST
+      type: IT.STANDARD.FIXTURE
     table_inline_item_id:
       type: INLINE
       props:
diff --git a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting/rules.yaml b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting/rules.yaml
index 29223ce456c..3b49484c558 100644
--- a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting/rules.yaml
+++ b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting/rules.yaml
@@ -71,7 +71,7 @@ rules:
   
   shardingAlgorithms:
     standard_test:
-      type: STANDARD_TEST
+      type: IT.STANDARD.FIXTURE
     table_inline_item_id:
       type: INLINE
       props:
diff --git a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting_and_encrypt/proxy/conf/mysql/config-dbtbl-with-readwrite-splitting-and-encrypt.yaml b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting_and_encrypt/proxy/conf/mysql/config-dbtbl-with-readwrite-splitting-and-encrypt.yaml
index 2d08ecc72db..39ced82017a 100644
--- a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting_and_encrypt/proxy/conf/mysql/config-dbtbl-with-readwrite-splitting-and-encrypt.yaml
+++ b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting_and_encrypt/proxy/conf/mysql/config-dbtbl-with-readwrite-splitting-and-encrypt.yaml
@@ -261,7 +261,7 @@ rules:
 
   shardingAlgorithms:
     standard_test:
-      type: STANDARD_TEST
+      type: IT.STANDARD.FIXTURE
     table_inline_item_id:
       type: INLINE
       props:
diff --git a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting_and_encrypt/proxy/conf/postgresql/config-dbtbl-with-readwrite-splitting-and-encrypt.yaml b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting_and_encrypt/proxy/conf/postgresql/config-dbtbl-with-readwrite-splitting-and-encrypt.yaml
index df6dacd9445..016e66d774b 100644
--- a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting_and_encrypt/proxy/conf/postgresql/config-dbtbl-with-readwrite-splitting-and-encrypt.yaml
+++ b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting_and_encrypt/proxy/conf/postgresql/config-dbtbl-with-readwrite-splitting-and-encrypt.yaml
@@ -261,7 +261,7 @@ rules:
 
   shardingAlgorithms:
     standard_test:
-      type: STANDARD_TEST
+      type: IT.STANDARD.FIXTURE
     table_inline_item_id:
       type: INLINE
       props:
diff --git a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting_and_encrypt/rules.yaml b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting_and_encrypt/rules.yaml
index aa5c2bac730..3fc8e1d8055 100644
--- a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting_and_encrypt/rules.yaml
+++ b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting_and_encrypt/rules.yaml
@@ -77,7 +77,7 @@ rules:
 
   shardingAlgorithms:
     standard_test:
-      type: STANDARD_TEST
+      type: IT.STANDARD.FIXTURE
     table_inline_item_id:
       type: INLINE
       props:
diff --git a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/tbl/proxy/conf/mysql/config-tbl.yaml b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/tbl/proxy/conf/mysql/config-tbl.yaml
index 3a357d40506..38f7ec569ab 100644
--- a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/tbl/proxy/conf/mysql/config-tbl.yaml
+++ b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/tbl/proxy/conf/mysql/config-tbl.yaml
@@ -72,7 +72,7 @@ rules:
 
   shardingAlgorithms:
     standard_test:
-      type: STANDARD_TEST
+      type: IT.STANDARD.FIXTURE
     table_inline_item_id:
       type: INLINE
       props:
diff --git a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/tbl/proxy/conf/postgresql/config-tbl.yaml b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/tbl/proxy/conf/postgresql/config-tbl.yaml
index 0718cc4b973..72055ce7b2e 100644
--- a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/tbl/proxy/conf/postgresql/config-tbl.yaml
+++ b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/tbl/proxy/conf/postgresql/config-tbl.yaml
@@ -72,7 +72,7 @@ rules:
 
   shardingAlgorithms:
     standard_test:
-      type: STANDARD_TEST
+      type: IT.STANDARD.FIXTURE
     table_inline_item_id:
       type: INLINE
       props:
diff --git a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/tbl/rules.yaml b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/tbl/rules.yaml
index d9ab8a51f7c..4efdfb4d0c4 100644
--- a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/tbl/rules.yaml
+++ b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/tbl/rules.yaml
@@ -59,7 +59,7 @@ rules:
   
   shardingAlgorithms:
     standard_test:
-      type: STANDARD_TEST
+      type: IT.STANDARD.FIXTURE
     table_inline_item_id:
       type: INLINE
       props: