This is an automated email from the ASF dual-hosted git repository.
panjuan 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 50ae5e7 Enable part of integration tests for PostgreSQL Proxy (#13042)
50ae5e7 is described below
commit 50ae5e769cd378ab7a71c231fd4c5b1c765b3f77
Author: 吴伟杰 <[email protected]>
AuthorDate: Thu Oct 14 18:28:25 2021 +0800
Enable part of integration tests for PostgreSQL Proxy (#13042)
* Add PostgreSQL db scenario RQL dataset
* Add PostgreSQL dbtbl_with_readwrite_splitting scenario RQL dataset
* Add PostgreSQL readwrite_splitting scenario RQL dataset
* Add PostgreSQL encrypt scenario RQL dataset
* Fix config-empty-rules.yaml for PostgreSQL
* Enable part of integration test for PostgreSQL Proxy
* Enable part of integration test for PostgreSQL Proxy
* Enable part of integration test for PostgreSQL Proxy
* Enable part of integration test for PostgreSQL Proxy
* Update it.yml for PostgreSQL Proxy Integration Test
---
.github/workflows/it.yml | 18 +++++++--
.../rql/dataset/db/postgresql/show_algorithms.xml | 27 +++++++++++++
.../dataset/db/postgresql/show_binging_rules.xml | 23 +++++++++++
.../dataset/db/postgresql/show_broadcast_rules.xml | 24 +++++++++++
.../rql/dataset/db/postgresql/show_resources.xml | 37 +++++++++++++++++
.../cases/rql/dataset/db/postgresql/show_rules.xml | 40 ++++++++++++++++++
.../rql/dataset/db/postgresql/show_table_rule.xml | 36 +++++++++++++++++
.../postgresql/show_algorithms.xml | 27 +++++++++++++
.../postgresql/show_binging_rules.xml | 23 +++++++++++
.../postgresql/show_broadcast_rules.xml | 24 +++++++++++
.../postgresql/show_readwrite_splitting_rules.xml | 37 +++++++++++++++++
.../postgresql/show_resources.xml | 47 ++++++++++++++++++++++
.../postgresql/show_rules.xml | 40 ++++++++++++++++++
.../postgresql/show_table_rule.xml | 36 +++++++++++++++++
.../dataset/encrypt/postgresql/show_algorithms.xml | 24 +++++++++++
.../encrypt/postgresql/show_binging_rules.xml | 22 ++++++++++
.../encrypt/postgresql/show_broadcast_rules.xml | 22 ++++++++++
.../encrypt/postgresql/show_encrypt_rule.xml | 28 +++++++++++++
.../encrypt/postgresql/show_encrypt_rules.xml | 29 +++++++++++++
.../dataset/encrypt/postgresql/show_resources.xml | 28 +++++++++++++
.../rql/dataset/encrypt/postgresql/show_rules.xml | 35 ++++++++++++++++
.../dataset/encrypt/postgresql/show_table_rule.xml | 35 ++++++++++++++++
.../postgresql/show_algorithms.xml | 24 +++++++++++
.../postgresql/show_binging_rules.xml | 23 +++++++++++
.../postgresql/show_broadcast_rules.xml | 24 +++++++++++
.../postgresql/show_readwrite_splitting_rules.xml | 28 +++++++++++++
.../postgresql/show_resources.xml | 30 ++++++++++++++
.../readwrite_splitting/postgresql/show_rules.xml | 38 +++++++++++++++++
.../postgresql/show_table_rule.xml | 36 +++++++++++++++++
.../postgresql/proxy/conf/config-empty-rules.yaml | 42 +++++++++----------
30 files changed, 883 insertions(+), 24 deletions(-)
diff --git a/.github/workflows/it.yml b/.github/workflows/it.yml
index 4813617..af42425 100644
--- a/.github/workflows/it.yml
+++ b/.github/workflows/it.yml
@@ -27,8 +27,8 @@ env:
MAVEN_OPTS: -Dhttp.keepAlive=false -Dmaven.wagon.http.pool=false
-Dmaven.wagon.http.retryHandler.class=standard
-Dmaven.wagon.http.retryHandler.count=3
jobs:
- MySQL:
- name: DB
+ integration-test-docker:
+ name: Integration Test in Docker
runs-on: ubuntu-latest
timeout-minutes: 60
strategy:
@@ -36,8 +36,20 @@ jobs:
matrix:
env: [ docker ]
adapter: [ proxy, jdbc ]
- database: [ MySQL ]
+ database: [ MySQL, PostgreSQL ]
scenario: [
db,tbl,dbtbl_with_readwrite_splitting,encrypt,dbtbl_with_readwrite_splitting_and_encrypt,readwrite_splitting,empty_rules
]
+ exclude:
+ - adapter: jdbc
+ database: PostgreSQL
+ - adapter: proxy
+ database: PostgreSQL
+ scenario: tbl
+ - adapter: proxy
+ database: PostgreSQL
+ scenario: dbtbl_with_readwrite_splitting_and_encrypt
+ - adapter: proxy
+ database: PostgreSQL
+ scenario: empty_rules
steps:
- name: Cache Maven Repos
uses: actions/cache@v2
diff --git
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/rql/dataset/db/postgresql/show_algorithms.xml
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/rql/dataset/db/postgresql/show_algorithms.xml
new file mode 100644
index 0000000..016a6ca
--- /dev/null
+++
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/rql/dataset/db/postgresql/show_algorithms.xml
@@ -0,0 +1,27 @@
+<!--
+ ~ 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.
+ -->
+
+<dataset>
+ <metadata>
+ <column name="name" />
+ <column name="type" />
+ <column name="props" />
+ </metadata>
+ <row values="standard_test| STANDARD_TEST| " />
+ <row values="db_inline_order_id| INLINE|
algorithm-expression=db_${order_id_sharding % 2}.t_order_federate_sharding" />
+ <row values="db_inline_item_id| INLINE|
algorithm-expression=db_${db_inline_item_id %
2}.t_order_item_federate_sharding" />
+</dataset>
diff --git
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/rql/dataset/db/postgresql/show_binging_rules.xml
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/rql/dataset/db/postgresql/show_binging_rules.xml
new file mode 100644
index 0000000..1177a82
--- /dev/null
+++
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/rql/dataset/db/postgresql/show_binging_rules.xml
@@ -0,0 +1,23 @@
+<!--
+ ~ 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.
+ -->
+
+<dataset>
+ <metadata>
+ <column name="sharding_binding_tables" />
+ </metadata>
+ <row values="t_order,t_order_item,t_order_details" />
+</dataset>
diff --git
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/rql/dataset/db/postgresql/show_broadcast_rules.xml
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/rql/dataset/db/postgresql/show_broadcast_rules.xml
new file mode 100644
index 0000000..150d531
--- /dev/null
+++
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/rql/dataset/db/postgresql/show_broadcast_rules.xml
@@ -0,0 +1,24 @@
+<!--
+ ~ 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.
+ -->
+
+<dataset>
+ <metadata>
+ <column name="sharding_broadcast_tables" />
+ </metadata>
+ <row values="t_broadcast_table" />
+ <row values="t_broadcast_table_for_ddl" />
+</dataset>
diff --git
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/rql/dataset/db/postgresql/show_resources.xml
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/rql/dataset/db/postgresql/show_resources.xml
new file mode 100644
index 0000000..1a570e6
--- /dev/null
+++
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/rql/dataset/db/postgresql/show_resources.xml
@@ -0,0 +1,37 @@
+<!--
+ ~ 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.
+ -->
+
+<dataset>
+ <metadata>
+ <column name="name" />
+ <column name="type" />
+ <column name="host" />
+ <column name="port" />
+ <column name="db" />
+ <column name="attribute" />
+ </metadata>
+ <row values="ds_0| PostgreSQL| postgresql.db.host| 5432| db_0|
{"maxLifetimeMilliseconds":1800000,"readOnly":false,"minPoolSize":2,"idleTimeoutMilliseconds":60000,"maxPoolSize":2,"connectionTimeoutMilliseconds":30000}"
/>
+ <row values="ds_1| PostgreSQL| postgresql.db.host| 5432| db_1|
{"maxLifetimeMilliseconds":1800000,"readOnly":false,"minPoolSize":2,"idleTimeoutMilliseconds":60000,"maxPoolSize":2,"connectionTimeoutMilliseconds":30000}"
/>
+ <row values="ds_2| PostgreSQL| postgresql.db.host| 5432| db_2|
{"maxLifetimeMilliseconds":1800000,"readOnly":false,"minPoolSize":2,"idleTimeoutMilliseconds":60000,"maxPoolSize":2,"connectionTimeoutMilliseconds":30000}"
/>
+ <row values="ds_3| PostgreSQL| postgresql.db.host| 5432| db_3|
{"maxLifetimeMilliseconds":1800000,"readOnly":false,"minPoolSize":2,"idleTimeoutMilliseconds":60000,"maxPoolSize":2,"connectionTimeoutMilliseconds":30000}"
/>
+ <row values="ds_4| PostgreSQL| postgresql.db.host| 5432| db_4|
{"maxLifetimeMilliseconds":1800000,"readOnly":false,"minPoolSize":2,"idleTimeoutMilliseconds":60000,"maxPoolSize":2,"connectionTimeoutMilliseconds":30000}"
/>
+ <row values="ds_5| PostgreSQL| postgresql.db.host| 5432| db_5|
{"maxLifetimeMilliseconds":1800000,"readOnly":false,"minPoolSize":2,"idleTimeoutMilliseconds":60000,"maxPoolSize":2,"connectionTimeoutMilliseconds":30000}"
/>
+ <row values="ds_6| PostgreSQL| postgresql.db.host| 5432| db_6|
{"maxLifetimeMilliseconds":1800000,"readOnly":false,"minPoolSize":2,"idleTimeoutMilliseconds":60000,"maxPoolSize":2,"connectionTimeoutMilliseconds":30000}"
/>
+ <row values="ds_7| PostgreSQL| postgresql.db.host| 5432| db_7|
{"maxLifetimeMilliseconds":1800000,"readOnly":false,"minPoolSize":2,"idleTimeoutMilliseconds":60000,"maxPoolSize":2,"connectionTimeoutMilliseconds":30000}"
/>
+ <row values="ds_8| PostgreSQL| postgresql.db.host| 5432| db_8|
{"maxLifetimeMilliseconds":1800000,"readOnly":false,"minPoolSize":2,"idleTimeoutMilliseconds":60000,"maxPoolSize":2,"connectionTimeoutMilliseconds":30000}"
/>
+ <row values="ds_9| PostgreSQL| postgresql.db.host| 5432| db_9|
{"maxLifetimeMilliseconds":1800000,"readOnly":false,"minPoolSize":2,"idleTimeoutMilliseconds":60000,"maxPoolSize":2,"connectionTimeoutMilliseconds":30000}"
/>
+</dataset>
diff --git
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/rql/dataset/db/postgresql/show_rules.xml
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/rql/dataset/db/postgresql/show_rules.xml
new file mode 100644
index 0000000..c9793bc
--- /dev/null
+++
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/rql/dataset/db/postgresql/show_rules.xml
@@ -0,0 +1,40 @@
+<!--
+ ~ 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.
+ -->
+
+<dataset>
+ <metadata>
+ <column name="table" />
+ <column name="actual_data_nodes" />
+ <column name="actual_data_sources" />
+ <column name="database_strategy_type" />
+ <column name="database_sharding_column" />
+ <column name="database_sharding_algorithm_type" />
+ <column name="database_sharding_algorithm_props" />
+ <column name="table_strategy_type" />
+ <column name="table_sharding_column" />
+ <column name="table_sharding_algorithm_type" />
+ <column name="table_sharding_algorithm_props" />
+ <column name="key_generate_column" />
+ <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_federate_sharding|
ds_${0..1}.t_order_federate_sharding| | INLINE| order_id_sharding| INLINE|
algorithm-expression=db_${order_id_sharding % 2}.t_order_federate_sharding| | |
| | | | " />
+ <row values="t_order_item_federate_sharding|
ds_${0..1}.t_order_item_federate_sharding| | INLINE| item_id| INLINE|
algorithm-expression=db_${db_inline_item_id %
2}.t_order_item_federate_sharding| | | | | | | " />
+</dataset>
diff --git
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/rql/dataset/db/postgresql/show_table_rule.xml
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/rql/dataset/db/postgresql/show_table_rule.xml
new file mode 100644
index 0000000..136a27c
--- /dev/null
+++
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/rql/dataset/db/postgresql/show_table_rule.xml
@@ -0,0 +1,36 @@
+<!--
+ ~ 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.
+ -->
+
+<dataset>
+ <metadata>
+ <column name="table" />
+ <column name="actual_data_nodes" />
+ <column name="actual_data_sources" />
+ <column name="database_strategy_type" />
+ <column name="database_sharding_column" />
+ <column name="database_sharding_algorithm_type" />
+ <column name="database_sharding_algorithm_props" />
+ <column name="table_strategy_type" />
+ <column name="table_sharding_column" />
+ <column name="table_sharding_algorithm_type" />
+ <column name="table_sharding_algorithm_props" />
+ <column name="key_generate_column" />
+ <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| | | | | | | | " />
+</dataset>
diff --git
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/rql/dataset/dbtbl_with_readwrite_splitting/postgresql/show_algorithms.xml
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/rql/dataset/dbtbl_with_readwrite_splitting/postgresql/show_algorithms.xml
new file mode 100644
index 0000000..5aa4375
--- /dev/null
+++
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/rql/dataset/dbtbl_with_readwrite_splitting/postgresql/show_algorithms.xml
@@ -0,0 +1,27 @@
+<!--
+ ~ 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.
+ -->
+
+<dataset>
+ <metadata>
+ <column name="name" />
+ <column name="type" />
+ <column name="props" />
+ </metadata>
+ <row values="standard_test| STANDARD_TEST| " />
+ <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/postgresql/show_binging_rules.xml
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/rql/dataset/dbtbl_with_readwrite_splitting/postgresql/show_binging_rules.xml
new file mode 100644
index 0000000..1177a82
--- /dev/null
+++
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/rql/dataset/dbtbl_with_readwrite_splitting/postgresql/show_binging_rules.xml
@@ -0,0 +1,23 @@
+<!--
+ ~ 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.
+ -->
+
+<dataset>
+ <metadata>
+ <column name="sharding_binding_tables" />
+ </metadata>
+ <row values="t_order,t_order_item,t_order_details" />
+</dataset>
diff --git
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/rql/dataset/dbtbl_with_readwrite_splitting/postgresql/show_broadcast_rules.xml
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/rql/dataset/dbtbl_with_readwrite_splitting/postgresql/show_broadcast_rules.xml
new file mode 100644
index 0000000..150d531
--- /dev/null
+++
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/rql/dataset/dbtbl_with_readwrite_splitting/postgresql/show_broadcast_rules.xml
@@ -0,0 +1,24 @@
+<!--
+ ~ 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.
+ -->
+
+<dataset>
+ <metadata>
+ <column name="sharding_broadcast_tables" />
+ </metadata>
+ <row values="t_broadcast_table" />
+ <row values="t_broadcast_table_for_ddl" />
+</dataset>
diff --git
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/rql/dataset/dbtbl_with_readwrite_splitting/postgresql/show_readwrite_splitting_rules.xml
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/rql/dataset/dbtbl_with_readwrite_splitting/postgresql/show_readwrite_splitting_rules.xml
new file mode 100644
index 0000000..82ffa54
--- /dev/null
+++
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/rql/dataset/dbtbl_with_readwrite_splitting/postgresql/show_readwrite_splitting_rules.xml
@@ -0,0 +1,37 @@
+<!--
+ ~ 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.
+ -->
+
+<dataset>
+ <metadata>
+ <column name="name" />
+ <column name="auto_aware_data_source_name" />
+ <column name="write_data_source_name" />
+ <column name="read_data_source_names" />
+ <column name="load_balancer_type" />
+ <column name="load_balancer_props" />
+ </metadata>
+ <row values="pr_ds_0| null| write_ds_0| read_ds_0| ROUND_ROBIN| " />
+ <row values="pr_ds_1| null| write_ds_1| read_ds_1| ROUND_ROBIN| " />
+ <row values="pr_ds_2| null| write_ds_2| read_ds_2| ROUND_ROBIN| " />
+ <row values="pr_ds_3| null| write_ds_3| read_ds_3| ROUND_ROBIN| " />
+ <row values="pr_ds_4| null| write_ds_4| read_ds_4| ROUND_ROBIN| " />
+ <row values="pr_ds_5| null| write_ds_5| read_ds_5| ROUND_ROBIN| " />
+ <row values="pr_ds_6| null| write_ds_6| read_ds_6| ROUND_ROBIN| " />
+ <row values="pr_ds_7| null| write_ds_7| read_ds_7| ROUND_ROBIN| " />
+ <row values="pr_ds_8| null| write_ds_8| read_ds_8| ROUND_ROBIN| " />
+ <row values="pr_ds_9| null| write_ds_9| read_ds_9| ROUND_ROBIN| " />
+</dataset>
diff --git
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/rql/dataset/dbtbl_with_readwrite_splitting/postgresql/show_resources.xml
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/rql/dataset/dbtbl_with_readwrite_splitting/postgresql/show_resources.xml
new file mode 100644
index 0000000..ad5ddc2
--- /dev/null
+++
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/rql/dataset/dbtbl_with_readwrite_splitting/postgresql/show_resources.xml
@@ -0,0 +1,47 @@
+<!--
+ ~ 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.
+ -->
+
+<dataset>
+ <metadata>
+ <column name="name" />
+ <column name="type" />
+ <column name="host" />
+ <column name="port" />
+ <column name="db" />
+ <column name="attribute" />
+ </metadata>
+ <row values="write_ds_0| PostgreSQL|
postgresql.dbtbl_with_readwrite_splitting.host| 5432| write_ds_0|
{"maxLifetimeMilliseconds":1800000,"readOnly":false,"minPoolSize":2,"idleTimeoutMilliseconds":60000,"maxPoolSize":2,"connectionTimeoutMilliseconds":30000}"
/>
+ <row values="write_ds_1| PostgreSQL|
postgresql.dbtbl_with_readwrite_splitting.host| 5432| write_ds_1|
{"maxLifetimeMilliseconds":1800000,"readOnly":false,"minPoolSize":2,"idleTimeoutMilliseconds":60000,"maxPoolSize":2,"connectionTimeoutMilliseconds":30000}"
/>
+ <row values="write_ds_2| PostgreSQL|
postgresql.dbtbl_with_readwrite_splitting.host| 5432| write_ds_2|
{"maxLifetimeMilliseconds":1800000,"readOnly":false,"minPoolSize":2,"idleTimeoutMilliseconds":60000,"maxPoolSize":2,"connectionTimeoutMilliseconds":30000}"
/>
+ <row values="write_ds_3| PostgreSQL|
postgresql.dbtbl_with_readwrite_splitting.host| 5432| write_ds_3|
{"maxLifetimeMilliseconds":1800000,"readOnly":false,"minPoolSize":2,"idleTimeoutMilliseconds":60000,"maxPoolSize":2,"connectionTimeoutMilliseconds":30000}"
/>
+ <row values="write_ds_4| PostgreSQL|
postgresql.dbtbl_with_readwrite_splitting.host| 5432| write_ds_4|
{"maxLifetimeMilliseconds":1800000,"readOnly":false,"minPoolSize":2,"idleTimeoutMilliseconds":60000,"maxPoolSize":2,"connectionTimeoutMilliseconds":30000}"
/>
+ <row values="write_ds_5| PostgreSQL|
postgresql.dbtbl_with_readwrite_splitting.host| 5432| write_ds_5|
{"maxLifetimeMilliseconds":1800000,"readOnly":false,"minPoolSize":2,"idleTimeoutMilliseconds":60000,"maxPoolSize":2,"connectionTimeoutMilliseconds":30000}"
/>
+ <row values="write_ds_6| PostgreSQL|
postgresql.dbtbl_with_readwrite_splitting.host| 5432| write_ds_6|
{"maxLifetimeMilliseconds":1800000,"readOnly":false,"minPoolSize":2,"idleTimeoutMilliseconds":60000,"maxPoolSize":2,"connectionTimeoutMilliseconds":30000}"
/>
+ <row values="write_ds_7| PostgreSQL|
postgresql.dbtbl_with_readwrite_splitting.host| 5432| write_ds_7|
{"maxLifetimeMilliseconds":1800000,"readOnly":false,"minPoolSize":2,"idleTimeoutMilliseconds":60000,"maxPoolSize":2,"connectionTimeoutMilliseconds":30000}"
/>
+ <row values="write_ds_8| PostgreSQL|
postgresql.dbtbl_with_readwrite_splitting.host| 5432| write_ds_8|
{"maxLifetimeMilliseconds":1800000,"readOnly":false,"minPoolSize":2,"idleTimeoutMilliseconds":60000,"maxPoolSize":2,"connectionTimeoutMilliseconds":30000}"
/>
+ <row values="write_ds_9| PostgreSQL|
postgresql.dbtbl_with_readwrite_splitting.host| 5432| write_ds_9|
{"maxLifetimeMilliseconds":1800000,"readOnly":false,"minPoolSize":2,"idleTimeoutMilliseconds":60000,"maxPoolSize":2,"connectionTimeoutMilliseconds":30000}"
/>
+ <row values="read_ds_0| PostgreSQL|
postgresql.dbtbl_with_readwrite_splitting.host| 5432| read_ds_0|
{"maxLifetimeMilliseconds":1800000,"readOnly":false,"minPoolSize":2,"idleTimeoutMilliseconds":60000,"maxPoolSize":2,"connectionTimeoutMilliseconds":30000}"
/>
+ <row values="read_ds_1| PostgreSQL|
postgresql.dbtbl_with_readwrite_splitting.host| 5432| read_ds_1|
{"maxLifetimeMilliseconds":1800000,"readOnly":false,"minPoolSize":2,"idleTimeoutMilliseconds":60000,"maxPoolSize":2,"connectionTimeoutMilliseconds":30000}"
/>
+ <row values="read_ds_2| PostgreSQL|
postgresql.dbtbl_with_readwrite_splitting.host| 5432| read_ds_2|
{"maxLifetimeMilliseconds":1800000,"readOnly":false,"minPoolSize":2,"idleTimeoutMilliseconds":60000,"maxPoolSize":2,"connectionTimeoutMilliseconds":30000}"
/>
+ <row values="read_ds_3| PostgreSQL|
postgresql.dbtbl_with_readwrite_splitting.host| 5432| read_ds_3|
{"maxLifetimeMilliseconds":1800000,"readOnly":false,"minPoolSize":2,"idleTimeoutMilliseconds":60000,"maxPoolSize":2,"connectionTimeoutMilliseconds":30000}"
/>
+ <row values="read_ds_4| PostgreSQL|
postgresql.dbtbl_with_readwrite_splitting.host| 5432| read_ds_4|
{"maxLifetimeMilliseconds":1800000,"readOnly":false,"minPoolSize":2,"idleTimeoutMilliseconds":60000,"maxPoolSize":2,"connectionTimeoutMilliseconds":30000}"
/>
+ <row values="read_ds_5| PostgreSQL|
postgresql.dbtbl_with_readwrite_splitting.host| 5432| read_ds_5|
{"maxLifetimeMilliseconds":1800000,"readOnly":false,"minPoolSize":2,"idleTimeoutMilliseconds":60000,"maxPoolSize":2,"connectionTimeoutMilliseconds":30000}"
/>
+ <row values="read_ds_6| PostgreSQL|
postgresql.dbtbl_with_readwrite_splitting.host| 5432| read_ds_6|
{"maxLifetimeMilliseconds":1800000,"readOnly":false,"minPoolSize":2,"idleTimeoutMilliseconds":60000,"maxPoolSize":2,"connectionTimeoutMilliseconds":30000}"
/>
+ <row values="read_ds_7| PostgreSQL|
postgresql.dbtbl_with_readwrite_splitting.host| 5432| read_ds_7|
{"maxLifetimeMilliseconds":1800000,"readOnly":false,"minPoolSize":2,"idleTimeoutMilliseconds":60000,"maxPoolSize":2,"connectionTimeoutMilliseconds":30000}"
/>
+ <row values="read_ds_8| PostgreSQL|
postgresql.dbtbl_with_readwrite_splitting.host| 5432| read_ds_8|
{"maxLifetimeMilliseconds":1800000,"readOnly":false,"minPoolSize":2,"idleTimeoutMilliseconds":60000,"maxPoolSize":2,"connectionTimeoutMilliseconds":30000}"
/>
+ <row values="read_ds_9| PostgreSQL|
postgresql.dbtbl_with_readwrite_splitting.host| 5432| read_ds_9|
{"maxLifetimeMilliseconds":1800000,"readOnly":false,"minPoolSize":2,"idleTimeoutMilliseconds":60000,"maxPoolSize":2,"connectionTimeoutMilliseconds":30000}"
/>
+</dataset>
diff --git
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/rql/dataset/dbtbl_with_readwrite_splitting/postgresql/show_rules.xml
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/rql/dataset/dbtbl_with_readwrite_splitting/postgresql/show_rules.xml
new file mode 100644
index 0000000..3333286
--- /dev/null
+++
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/rql/dataset/dbtbl_with_readwrite_splitting/postgresql/show_rules.xml
@@ -0,0 +1,40 @@
+<!--
+ ~ 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.
+ -->
+
+<dataset>
+ <metadata>
+ <column name="table" />
+ <column name="actual_data_nodes" />
+ <column name="actual_data_sources" />
+ <column name="database_strategy_type" />
+ <column name="database_sharding_column" />
+ <column name="database_sharding_algorithm_type" />
+ <column name="database_sharding_algorithm_props" />
+ <column name="table_strategy_type" />
+ <column name="table_sharding_column" />
+ <column name="table_sharding_algorithm_type" />
+ <column name="table_sharding_algorithm_props" />
+ <column name="key_generate_column" />
+ <column name="key_generator_type" />
+ <column name="key_generator_props" />
+ </metadata>
+ <row values="t_order| pr_ds_${0..9}.t_order_${0..9}| | STANDARD_TEST|
user_id| STANDARD_TEST| | STANDARD_TEST| order_id| STANDARD_TEST| | | | " />
+ <row values="t_order_item| pr_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| pr_ds_${0..9}.t_order_details_${0..9}| |
STANDARD_TEST| user_id| STANDARD_TEST| | STANDARD_TEST| order_id|
STANDARD_TEST| | | | " />
+ <row values="t_order_item_federate_sharding |
pr_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 |
pr_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/postgresql/show_table_rule.xml
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/rql/dataset/dbtbl_with_readwrite_splitting/postgresql/show_table_rule.xml
new file mode 100644
index 0000000..87f5245
--- /dev/null
+++
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/rql/dataset/dbtbl_with_readwrite_splitting/postgresql/show_table_rule.xml
@@ -0,0 +1,36 @@
+<!--
+ ~ 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.
+ -->
+
+<dataset>
+ <metadata>
+ <column name="table" />
+ <column name="actual_data_nodes" />
+ <column name="actual_data_sources" />
+ <column name="database_strategy_type" />
+ <column name="database_sharding_column" />
+ <column name="database_sharding_algorithm_type" />
+ <column name="database_sharding_algorithm_props" />
+ <column name="table_strategy_type" />
+ <column name="table_sharding_column" />
+ <column name="table_sharding_algorithm_type" />
+ <column name="table_sharding_algorithm_props" />
+ <column name="key_generate_column" />
+ <column name="key_generator_type" />
+ <column name="key_generator_props" />
+ </metadata>
+ <row values="t_order| pr_ds_${0..9}.t_order_${0..9}| | STANDARD_TEST|
user_id| STANDARD_TEST| | STANDARD_TEST| order_id| STANDARD_TEST| | | | " />
+</dataset>
diff --git
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/rql/dataset/encrypt/postgresql/show_algorithms.xml
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/rql/dataset/encrypt/postgresql/show_algorithms.xml
new file mode 100644
index 0000000..8af51b2
--- /dev/null
+++
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/rql/dataset/encrypt/postgresql/show_algorithms.xml
@@ -0,0 +1,24 @@
+<!--
+ ~ 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.
+ -->
+
+<dataset>
+ <metadata>
+ <column name="name" />
+ <column name="type" />
+ <column name="props" />
+ </metadata>
+</dataset>
diff --git
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/rql/dataset/encrypt/postgresql/show_binging_rules.xml
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/rql/dataset/encrypt/postgresql/show_binging_rules.xml
new file mode 100644
index 0000000..649c170
--- /dev/null
+++
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/rql/dataset/encrypt/postgresql/show_binging_rules.xml
@@ -0,0 +1,22 @@
+<!--
+ ~ 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.
+ -->
+
+<dataset>
+ <metadata>
+ <column name="sharding_binding_tables" />
+ </metadata>
+</dataset>
diff --git
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/rql/dataset/encrypt/postgresql/show_broadcast_rules.xml
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/rql/dataset/encrypt/postgresql/show_broadcast_rules.xml
new file mode 100644
index 0000000..53ecd54
--- /dev/null
+++
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/rql/dataset/encrypt/postgresql/show_broadcast_rules.xml
@@ -0,0 +1,22 @@
+<!--
+ ~ 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.
+ -->
+
+<dataset>
+ <metadata>
+ <column name="sharding_broadcast_tables" />
+ </metadata>
+</dataset>
diff --git
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/rql/dataset/encrypt/postgresql/show_encrypt_rule.xml
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/rql/dataset/encrypt/postgresql/show_encrypt_rule.xml
new file mode 100644
index 0000000..fe97e0a
--- /dev/null
+++
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/rql/dataset/encrypt/postgresql/show_encrypt_rule.xml
@@ -0,0 +1,28 @@
+<!--
+ ~ 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.
+ -->
+
+<dataset>
+ <metadata>
+ <column name="table" />
+ <column name="logic_column" />
+ <column name="cipher_column" />
+ <column name="plain_column" />
+ <column name="encryptor_type" />
+ <column name="encryptor_props" />
+ </metadata>
+ <row values="t_user| pwd| pwd_cipher| pwd_plain| AES|
aes-key-value=123456abc" />
+</dataset>
diff --git
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/rql/dataset/encrypt/postgresql/show_encrypt_rules.xml
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/rql/dataset/encrypt/postgresql/show_encrypt_rules.xml
new file mode 100644
index 0000000..b0f93c2
--- /dev/null
+++
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/rql/dataset/encrypt/postgresql/show_encrypt_rules.xml
@@ -0,0 +1,29 @@
+<!--
+ ~ 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.
+ -->
+
+<dataset>
+ <metadata>
+ <column name="table" />
+ <column name="logic_column" />
+ <column name="cipher_column" />
+ <column name="plain_column" />
+ <column name="encryptor_type" />
+ <column name="encryptor_props" />
+ </metadata>
+ <row values="t_user| pwd| pwd_cipher| pwd_plain| AES|
aes-key-value=123456abc" />
+ <row values="t_user_details| number| number_cipher| number_plain| AES|
aes-key-value=123456abc" />
+</dataset>
diff --git
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/rql/dataset/encrypt/postgresql/show_resources.xml
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/rql/dataset/encrypt/postgresql/show_resources.xml
new file mode 100644
index 0000000..8bd6492
--- /dev/null
+++
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/rql/dataset/encrypt/postgresql/show_resources.xml
@@ -0,0 +1,28 @@
+<!--
+ ~ 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.
+ -->
+
+<dataset>
+ <metadata>
+ <column name="name" />
+ <column name="type" />
+ <column name="host" />
+ <column name="port" />
+ <column name="db" />
+ <column name="attribute" />
+ </metadata>
+ <row values="encrypt| PostgreSQL| postgresql.encrypt.host| 5432| encrypt|
{"maxLifetimeMilliseconds":1800000,"readOnly":false,"minPoolSize":2,"idleTimeoutMilliseconds":60000,"maxPoolSize":2,"connectionTimeoutMilliseconds":30000}"
/>
+</dataset>
diff --git
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/rql/dataset/encrypt/postgresql/show_rules.xml
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/rql/dataset/encrypt/postgresql/show_rules.xml
new file mode 100644
index 0000000..ec887a6
--- /dev/null
+++
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/rql/dataset/encrypt/postgresql/show_rules.xml
@@ -0,0 +1,35 @@
+<!--
+ ~ 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.
+ -->
+
+<dataset>
+ <metadata>
+ <column name="table" />
+ <column name="actual_data_nodes" />
+ <column name="actual_data_sources" />
+ <column name="database_strategy_type" />
+ <column name="database_sharding_column" />
+ <column name="database_sharding_algorithm_type" />
+ <column name="database_sharding_algorithm_props" />
+ <column name="table_strategy_type" />
+ <column name="table_sharding_column" />
+ <column name="table_sharding_algorithm_type" />
+ <column name="table_sharding_algorithm_props" />
+ <column name="key_generate_column" />
+ <column name="key_generator_type" />
+ <column name="key_generator_props" />
+ </metadata>
+</dataset>
diff --git
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/rql/dataset/encrypt/postgresql/show_table_rule.xml
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/rql/dataset/encrypt/postgresql/show_table_rule.xml
new file mode 100644
index 0000000..ec887a6
--- /dev/null
+++
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/rql/dataset/encrypt/postgresql/show_table_rule.xml
@@ -0,0 +1,35 @@
+<!--
+ ~ 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.
+ -->
+
+<dataset>
+ <metadata>
+ <column name="table" />
+ <column name="actual_data_nodes" />
+ <column name="actual_data_sources" />
+ <column name="database_strategy_type" />
+ <column name="database_sharding_column" />
+ <column name="database_sharding_algorithm_type" />
+ <column name="database_sharding_algorithm_props" />
+ <column name="table_strategy_type" />
+ <column name="table_sharding_column" />
+ <column name="table_sharding_algorithm_type" />
+ <column name="table_sharding_algorithm_props" />
+ <column name="key_generate_column" />
+ <column name="key_generator_type" />
+ <column name="key_generator_props" />
+ </metadata>
+</dataset>
diff --git
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/rql/dataset/readwrite_splitting/postgresql/show_algorithms.xml
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/rql/dataset/readwrite_splitting/postgresql/show_algorithms.xml
new file mode 100644
index 0000000..8af51b2
--- /dev/null
+++
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/rql/dataset/readwrite_splitting/postgresql/show_algorithms.xml
@@ -0,0 +1,24 @@
+<!--
+ ~ 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.
+ -->
+
+<dataset>
+ <metadata>
+ <column name="name" />
+ <column name="type" />
+ <column name="props" />
+ </metadata>
+</dataset>
diff --git
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/rql/dataset/readwrite_splitting/postgresql/show_binging_rules.xml
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/rql/dataset/readwrite_splitting/postgresql/show_binging_rules.xml
new file mode 100644
index 0000000..1177a82
--- /dev/null
+++
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/rql/dataset/readwrite_splitting/postgresql/show_binging_rules.xml
@@ -0,0 +1,23 @@
+<!--
+ ~ 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.
+ -->
+
+<dataset>
+ <metadata>
+ <column name="sharding_binding_tables" />
+ </metadata>
+ <row values="t_order,t_order_item,t_order_details" />
+</dataset>
diff --git
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/rql/dataset/readwrite_splitting/postgresql/show_broadcast_rules.xml
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/rql/dataset/readwrite_splitting/postgresql/show_broadcast_rules.xml
new file mode 100644
index 0000000..150d531
--- /dev/null
+++
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/rql/dataset/readwrite_splitting/postgresql/show_broadcast_rules.xml
@@ -0,0 +1,24 @@
+<!--
+ ~ 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.
+ -->
+
+<dataset>
+ <metadata>
+ <column name="sharding_broadcast_tables" />
+ </metadata>
+ <row values="t_broadcast_table" />
+ <row values="t_broadcast_table_for_ddl" />
+</dataset>
diff --git
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/rql/dataset/readwrite_splitting/postgresql/show_readwrite_splitting_rules.xml
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/rql/dataset/readwrite_splitting/postgresql/show_readwrite_splitting_rules.xml
new file mode 100644
index 0000000..6aaf540
--- /dev/null
+++
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/rql/dataset/readwrite_splitting/postgresql/show_readwrite_splitting_rules.xml
@@ -0,0 +1,28 @@
+<!--
+ ~ 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.
+ -->
+
+<dataset>
+ <metadata>
+ <column name="name" />
+ <column name="auto_aware_data_source_name" />
+ <column name="write_data_source_name" />
+ <column name="read_data_source_names" />
+ <column name="load_balancer_type" />
+ <column name="load_balancer_props" />
+ </metadata>
+ <row values="write-read-ds| null| write_ds| read_0,read_1| null| " />
+</dataset>
diff --git
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/rql/dataset/readwrite_splitting/postgresql/show_resources.xml
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/rql/dataset/readwrite_splitting/postgresql/show_resources.xml
new file mode 100644
index 0000000..d495a01
--- /dev/null
+++
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/rql/dataset/readwrite_splitting/postgresql/show_resources.xml
@@ -0,0 +1,30 @@
+<!--
+ ~ 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.
+ -->
+
+<dataset>
+ <metadata>
+ <column name="name" />
+ <column name="type" />
+ <column name="host" />
+ <column name="port" />
+ <column name="db" />
+ <column name="attribute" />
+ </metadata>
+ <row values="write_ds| PostgreSQL| postgresql.readwrite_splitting.host|
5432| write_ds|
{"maxLifetimeMilliseconds":1800000,"readOnly":false,"minPoolSize":2,"idleTimeoutMilliseconds":60000,"maxPoolSize":2,"connectionTimeoutMilliseconds":30000}"
/>
+ <row values="read_0| PostgreSQL| postgresql.readwrite_splitting.host|
5432| read_0|
{"maxLifetimeMilliseconds":1800000,"readOnly":false,"minPoolSize":2,"idleTimeoutMilliseconds":60000,"maxPoolSize":2,"connectionTimeoutMilliseconds":30000}"
/>
+ <row values="read_1| PostgreSQL| postgresql.readwrite_splitting.host|
5432| read_1|
{"maxLifetimeMilliseconds":1800000,"readOnly":false,"minPoolSize":2,"idleTimeoutMilliseconds":60000,"maxPoolSize":2,"connectionTimeoutMilliseconds":30000}"
/>
+</dataset>
diff --git
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/rql/dataset/readwrite_splitting/postgresql/show_rules.xml
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/rql/dataset/readwrite_splitting/postgresql/show_rules.xml
new file mode 100644
index 0000000..eef1236
--- /dev/null
+++
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/rql/dataset/readwrite_splitting/postgresql/show_rules.xml
@@ -0,0 +1,38 @@
+<!--
+ ~ 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.
+ -->
+
+<dataset>
+ <metadata>
+ <column name="table" />
+ <column name="actual_data_nodes" />
+ <column name="actual_data_sources" />
+ <column name="database_strategy_type" />
+ <column name="database_sharding_column" />
+ <column name="database_sharding_algorithm_type" />
+ <column name="database_sharding_algorithm_props" />
+ <column name="table_strategy_type" />
+ <column name="table_sharding_column" />
+ <column name="table_sharding_algorithm_type" />
+ <column name="table_sharding_algorithm_props" />
+ <column name="key_generate_column" />
+ <column name="key_generator_type" />
+ <column name="key_generator_props" />
+ </metadata>
+ <row values="t_order| write-read-ds.t_order| | | | | | none| | | | | | " />
+ <row values="t_order_item| write-read-ds.t_order_item| | | | | | none| | |
| | | " />
+ <row values="t_order_details| write-read-ds.t_order_details| | | | | |
none| | | | | | " />
+</dataset>
diff --git
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/rql/dataset/readwrite_splitting/postgresql/show_table_rule.xml
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/rql/dataset/readwrite_splitting/postgresql/show_table_rule.xml
new file mode 100644
index 0000000..b24a5a7
--- /dev/null
+++
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/rql/dataset/readwrite_splitting/postgresql/show_table_rule.xml
@@ -0,0 +1,36 @@
+<!--
+ ~ 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.
+ -->
+
+<dataset>
+ <metadata>
+ <column name="table" />
+ <column name="actual_data_nodes" />
+ <column name="actual_data_sources" />
+ <column name="database_strategy_type" />
+ <column name="database_sharding_column" />
+ <column name="database_sharding_algorithm_type" />
+ <column name="database_sharding_algorithm_props" />
+ <column name="table_strategy_type" />
+ <column name="table_sharding_column" />
+ <column name="table_sharding_algorithm_type" />
+ <column name="table_sharding_algorithm_props" />
+ <column name="key_generate_column" />
+ <column name="key_generator_type" />
+ <column name="key_generator_props" />
+ </metadata>
+ <row values="t_order| write-read-ds.t_order| | | | | | none| | | | | | " />
+</dataset>
diff --git
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/docker/empty_rules/postgresql/proxy/conf/config-empty-rules.yaml
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/docker/empty_rules/postgresql/proxy/conf/config-empty-rules.yaml
index ea3e8d1..3b7c978 100644
---
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/docker/empty_rules/postgresql/proxy/conf/config-empty-rules.yaml
+++
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/docker/empty_rules/postgresql/proxy/conf/config-empty-rules.yaml
@@ -19,7 +19,7 @@ schemaName: empty_rules
dataSources:
encrypt_write_ds_0:
- url:
jdbc:mysql://mysql.empty_rules.host:3306/encrypt_write_ds_0?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url:
jdbc:postgresql://postgresql.empty_rules.host:5432/encrypt_write_ds_0?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
username: root
password: root
connectionTimeoutMilliseconds: 30000
@@ -28,7 +28,7 @@ dataSources:
maxPoolSize: 2
minPoolSize: 2
encrypt_write_ds_1:
- url:
jdbc:mysql://mysql.empty_rules.host:3306/encrypt_write_ds_1?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url:
jdbc:postgresql://postgresql.empty_rules.host:5432/encrypt_write_ds_1?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
username: root
password: root
connectionTimeoutMilliseconds: 30000
@@ -37,7 +37,7 @@ dataSources:
maxPoolSize: 2
minPoolSize: 2
encrypt_write_ds_2:
- url:
jdbc:mysql://mysql.empty_rules.host:3306/encrypt_write_ds_2?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url:
jdbc:postgresql://postgresql.empty_rules.host:5432/encrypt_write_ds_2?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
username: root
password: root
connectionTimeoutMilliseconds: 30000
@@ -46,7 +46,7 @@ dataSources:
maxPoolSize: 2
minPoolSize: 2
encrypt_write_ds_3:
- url:
jdbc:mysql://mysql.empty_rules.host:3306/encrypt_write_ds_3?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url:
jdbc:postgresql://postgresql.empty_rules.host:5432/encrypt_write_ds_3?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
username: root
password: root
connectionTimeoutMilliseconds: 30000
@@ -55,7 +55,7 @@ dataSources:
maxPoolSize: 2
minPoolSize: 2
encrypt_write_ds_4:
- url:
jdbc:mysql://mysql.empty_rules.host:3306/encrypt_write_ds_4?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url:
jdbc:postgresql://postgresql.empty_rules.host:5432/encrypt_write_ds_4?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
username: root
password: root
connectionTimeoutMilliseconds: 30000
@@ -64,7 +64,7 @@ dataSources:
maxPoolSize: 2
minPoolSize: 2
encrypt_write_ds_5:
- url:
jdbc:mysql://mysql.empty_rules.host:3306/encrypt_write_ds_5?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url:
jdbc:postgresql://postgresql.empty_rules.host:5432/encrypt_write_ds_5?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
username: root
password: root
connectionTimeoutMilliseconds: 30000
@@ -73,7 +73,7 @@ dataSources:
maxPoolSize: 2
minPoolSize: 2
encrypt_write_ds_6:
- url:
jdbc:mysql://mysql.empty_rules.host:3306/encrypt_write_ds_6?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url:
jdbc:postgresql://postgresql.empty_rules.host:5432/encrypt_write_ds_6?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
username: root
password: root
connectionTimeoutMilliseconds: 30000
@@ -82,7 +82,7 @@ dataSources:
maxPoolSize: 2
minPoolSize: 2
encrypt_write_ds_7:
- url:
jdbc:mysql://mysql.empty_rules.host:3306/encrypt_write_ds_7?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url:
jdbc:postgresql://postgresql.empty_rules.host:5432/encrypt_write_ds_7?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
username: root
password: root
connectionTimeoutMilliseconds: 30000
@@ -91,7 +91,7 @@ dataSources:
maxPoolSize: 2
minPoolSize: 2
encrypt_write_ds_8:
- url:
jdbc:mysql://mysql.empty_rules.host:3306/encrypt_write_ds_8?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url:
jdbc:postgresql://postgresql.empty_rules.host:5432/encrypt_write_ds_8?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
username: root
password: root
connectionTimeoutMilliseconds: 30000
@@ -100,7 +100,7 @@ dataSources:
maxPoolSize: 2
minPoolSize: 2
encrypt_write_ds_9:
- url:
jdbc:mysql://mysql.empty_rules.host:3306/encrypt_write_ds_9?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url:
jdbc:postgresql://postgresql.empty_rules.host:5432/encrypt_write_ds_9?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
username: root
password: root
connectionTimeoutMilliseconds: 30000
@@ -109,7 +109,7 @@ dataSources:
maxPoolSize: 2
minPoolSize: 2
encrypt_read_ds_0:
- url:
jdbc:mysql://mysql.empty_rules.host:3306/encrypt_read_ds_0?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url:
jdbc:postgresql://postgresql.empty_rules.host:5432/encrypt_read_ds_0?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
username: root
password: root
connectionTimeoutMilliseconds: 30000
@@ -118,7 +118,7 @@ dataSources:
maxPoolSize: 2
minPoolSize: 2
encrypt_read_ds_1:
- url:
jdbc:mysql://mysql.empty_rules.host:3306/encrypt_read_ds_1?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url:
jdbc:postgresql://postgresql.empty_rules.host:5432/encrypt_read_ds_1?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
username: root
password: root
connectionTimeoutMilliseconds: 30000
@@ -127,7 +127,7 @@ dataSources:
maxPoolSize: 2
minPoolSize: 2
encrypt_read_ds_2:
- url:
jdbc:mysql://mysql.empty_rules.host:3306/encrypt_read_ds_2?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url:
jdbc:postgresql://postgresql.empty_rules.host:5432/encrypt_read_ds_2?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
username: root
password: root
connectionTimeoutMilliseconds: 30000
@@ -136,7 +136,7 @@ dataSources:
maxPoolSize: 2
minPoolSize: 2
encrypt_read_ds_3:
- url:
jdbc:mysql://mysql.empty_rules.host:3306/encrypt_read_ds_3?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url:
jdbc:postgresql://postgresql.empty_rules.host:5432/encrypt_read_ds_3?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
username: root
password: root
connectionTimeoutMilliseconds: 30000
@@ -145,7 +145,7 @@ dataSources:
maxPoolSize: 2
minPoolSize: 2
encrypt_read_ds_4:
- url:
jdbc:mysql://mysql.empty_rules.host:3306/encrypt_read_ds_4?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url:
jdbc:postgresql://postgresql.empty_rules.host:5432/encrypt_read_ds_4?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
username: root
password: root
connectionTimeoutMilliseconds: 30000
@@ -154,7 +154,7 @@ dataSources:
maxPoolSize: 2
minPoolSize: 2
encrypt_read_ds_5:
- url:
jdbc:mysql://mysql.empty_rules.host:3306/encrypt_read_ds_5?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url:
jdbc:postgresql://postgresql.empty_rules.host:5432/encrypt_read_ds_5?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
username: root
password: root
connectionTimeoutMilliseconds: 30000
@@ -163,7 +163,7 @@ dataSources:
maxPoolSize: 2
minPoolSize: 2
encrypt_read_ds_6:
- url:
jdbc:mysql://mysql.empty_rules.host:3306/encrypt_read_ds_6?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url:
jdbc:postgresql://postgresql.empty_rules.host:5432/encrypt_read_ds_6?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
username: root
password: root
connectionTimeoutMilliseconds: 30000
@@ -172,7 +172,7 @@ dataSources:
maxPoolSize: 2
minPoolSize: 2
encrypt_read_ds_7:
- url:
jdbc:mysql://mysql.empty_rules.host:3306/encrypt_read_ds_7?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url:
jdbc:postgresql://postgresql.empty_rules.host:5432/encrypt_read_ds_7?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
username: root
password: root
connectionTimeoutMilliseconds: 30000
@@ -181,7 +181,7 @@ dataSources:
maxPoolSize: 2
minPoolSize: 2
encrypt_read_ds_8:
- url:
jdbc:mysql://mysql.empty_rules.host:3306/encrypt_read_ds_8?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url:
jdbc:postgresql://postgresql.empty_rules.host:5432/encrypt_read_ds_8?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
username: root
password: root
connectionTimeoutMilliseconds: 30000
@@ -190,7 +190,7 @@ dataSources:
maxPoolSize: 2
minPoolSize: 2
encrypt_read_ds_9:
- url:
jdbc:mysql://mysql.empty_rules.host:3306/encrypt_read_ds_9?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url:
jdbc:postgresql://postgresql.empty_rules.host:5432/encrypt_read_ds_9?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
username: root
password: root
connectionTimeoutMilliseconds: 30000
@@ -199,7 +199,7 @@ dataSources:
maxPoolSize: 2
minPoolSize: 2
rdl_test_0:
- url:
jdbc:mysql://mysql.empty_rules.host:3306/rdl_test_0?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url:
jdbc:postgresql://postgresql.empty_rules.host:5432/rdl_test_0?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
username: root
password: root
connectionTimeoutMilliseconds: 30000
