You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by ji...@apache.org on 2021/09/30 15:42:23 UTC
[shardingsphere] branch master updated: Modify the Encrypt document
in RQL Syntax. (#12864)
This is an automated email from the ASF dual-hosted git repository.
jianglongtao 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 7a0f6cb Modify the Encrypt document in RQL Syntax. (#12864)
7a0f6cb is described below
commit 7a0f6cba4e08b459a22199f4878a98fb21392684
Author: yx9o <ya...@163.com>
AuthorDate: Thu Sep 30 23:41:11 2021 +0800
Modify the Encrypt document in RQL Syntax. (#12864)
---
.../dist-sql/syntax/rql/rql-encrypt-rule.cn.md | 56 +++++++++++-----------
.../dist-sql/syntax/rql/rql-encrypt-rule.en.md | 56 +++++++++++-----------
.../syntax/rql/rql-readwrite-splitting-rule.cn.md | 30 ++++++------
.../syntax/rql/rql-readwrite-splitting-rule.en.md | 30 ++++++------
4 files changed, 86 insertions(+), 86 deletions(-)
diff --git a/docs/document/content/features/dist-sql/syntax/rql/rql-encrypt-rule.cn.md b/docs/document/content/features/dist-sql/syntax/rql/rql-encrypt-rule.cn.md
index e93fd88..358921d 100644
--- a/docs/document/content/features/dist-sql/syntax/rql/rql-encrypt-rule.cn.md
+++ b/docs/document/content/features/dist-sql/syntax/rql/rql-encrypt-rule.cn.md
@@ -14,48 +14,48 @@ SHOW ENCRYPT TABLE RULE tableName [from schemaName]
## 说明
-| 列 | 说明 |
-| -------------- | ---------- |
-| table | 逻辑表名 |
-| logicColumn | 逻辑列名 |
-| cipherColumn | 密文列名 |
-| plainColumn | 明文列名 |
-| encryptorType | 加密算法类型 |
-| encryptorProps | 加密算法参数 |
+| 列 | 说明 |
+| --------------- | ---------- |
+| table | 逻辑表名 |
+| logic_column | 逻辑列名 |
+| cipher_column | 密文列名 |
+| plain_column | 明文列名 |
+| encryptor_type | 加密算法类型 |
+| encryptor_props | 加密算法参数 |
## 示例
*显示加密规则*
```sql
mysql> show encrypt rules from encrypt_db;
-+-----------+-------------+--------------+-------------+---------------+-------------------------+
-| table | logicColumn | cipherColumn | plainColumn | encryptorType | encryptorProps |
-+-----------+-------------+--------------+-------------+---------------+-------------------------+
-| t_encrypt | order_id | order_cipher | NULL | MD5 | |
-| t_encrypt | user_id | user_cipher | user_plain | AES | aes-key-value=123456abc |
-| t_order | item_id | order_cipher | NULL | MD5 | |
-| t_order | order_id | user_cipher | user_plain | AES | aes-key-value=123456abc |
-+-----------+-------------+--------------+-------------+---------------+-------------------------+
++-----------+--------------+---------------+--------------+----------------+-------------------------+
+| table | logic_column | cipher_column | plain_column | encryptor_type | encryptor_props |
++-----------+--------------+---------------+--------------+----------------+-------------------------+
+| t_encrypt | order_id | order_cipher | NULL | MD5 | |
+| t_encrypt | user_id | user_cipher | user_plain | AES | aes-key-value=123456abc |
+| t_order | item_id | order_cipher | NULL | MD5 | |
+| t_order | order_id | user_cipher | user_plain | AES | aes-key-value=123456abc |
++-----------+--------------+---------------+--------------+----------------+-------------------------+
4 rows in set (0.01 sec)
```
*显示加密表规则表名*
```sql
mysql> show encrypt table rule t_encrypt;
-+-----------+-------------+--------------+-------------+---------------+-------------------------+
-| table | logicColumn | cipherColumn | plainColumn | encryptorType | encryptorProps |
-+-----------+-------------+--------------+-------------+---------------+-------------------------+
-| t_encrypt | order_id | order_cipher | NULL | MD5 | |
-| t_encrypt | user_id | user_cipher | user_plain | AES | aes-key-value=123456abc |
-+-----------+-------------+--------------+-------------+---------------+-------------------------+
++-----------+--------------+---------------+--------------+----------------+-------------------------+
+| table | logic_column | cipher_column | plain_column | encryptor_type | encryptor_props |
++-----------+--------------+---------------+--------------+----------------+-------------------------+
+| t_encrypt | order_id | order_cipher | NULL | MD5 | |
+| t_encrypt | user_id | user_cipher | user_plain | AES | aes-key-value=123456abc |
++-----------+--------------+---------------+--------------+----------------+-------------------------+
2 rows in set (0.00 sec)
mysql> show encrypt table rule t_encrypt from encrypt_db;
-+-----------+-------------+--------------+-------------+---------------+-------------------------+
-| table | logicColumn | cipherColumn | plainColumn | encryptorType | encryptorProps |
-+-----------+-------------+--------------+-------------+---------------+-------------------------+
-| t_encrypt | order_id | order_cipher | NULL | MD5 | |
-| t_encrypt | user_id | user_cipher | user_plain | AES | aes-key-value=123456abc |
-+-----------+-------------+--------------+-------------+---------------+-------------------------+
++-----------+--------------+---------------+--------------+----------------+-------------------------+
+| table | logic_column | cipher_column | plain_column | encryptor_type | encryptor_props |
++-----------+--------------+---------------+--------------+----------------+-------------------------+
+| t_encrypt | order_id | order_cipher | NULL | MD5 | |
+| t_encrypt | user_id | user_cipher | user_plain | AES | aes-key-value=123456abc |
++-----------+--------------+---------------+--------------+----------------+-------------------------+
2 rows in set (0.00 sec)
```
diff --git a/docs/document/content/features/dist-sql/syntax/rql/rql-encrypt-rule.en.md b/docs/document/content/features/dist-sql/syntax/rql/rql-encrypt-rule.en.md
index ca8822c..7bde398 100644
--- a/docs/document/content/features/dist-sql/syntax/rql/rql-encrypt-rule.en.md
+++ b/docs/document/content/features/dist-sql/syntax/rql/rql-encrypt-rule.en.md
@@ -14,48 +14,48 @@ SHOW ENCRYPT TABLE RULE tableName [from schemaName]
## Description
-| Column | Description |
-| -------------- | ------------------------------- |
-| table | Logical table name |
-| logicColumn | Logical column name |
-| cipherColumn | Ciphertext column name |
-| plainColumn | Plaintext column name |
-| encryptorType | Encryption algorithm type |
-| encryptorProps | Encryption algorithm parameter |
+| Column | Description |
+| --------------- | ------------------------------- |
+| table | Logical table name |
+| logic_column | Logical column name |
+| cipher_column | Ciphertext column name |
+| plain_column | Plaintext column name |
+| encryptor_type | Encryption algorithm type |
+| encryptor_props | Encryption algorithm parameter |
## Example
*Show Encrypt Rules*
```sql
mysql> show encrypt rules from encrypt_db;
-+-----------+-------------+--------------+-------------+---------------+-------------------------+
-| table | logicColumn | cipherColumn | plainColumn | encryptorType | encryptorProps |
-+-----------+-------------+--------------+-------------+---------------+-------------------------+
-| t_encrypt | order_id | order_cipher | NULL | MD5 | |
-| t_encrypt | user_id | user_cipher | user_plain | AES | aes-key-value=123456abc |
-| t_order | item_id | order_cipher | NULL | MD5 | |
-| t_order | order_id | user_cipher | user_plain | AES | aes-key-value=123456abc |
-+-----------+-------------+--------------+-------------+---------------+-------------------------+
++-----------+--------------+---------------+--------------+----------------+-------------------------+
+| table | logic_column | cipher_column | plain_column | encryptor_type | encryptor_props |
++-----------+--------------+---------------+--------------+----------------+-------------------------+
+| t_encrypt | order_id | order_cipher | NULL | MD5 | |
+| t_encrypt | user_id | user_cipher | user_plain | AES | aes-key-value=123456abc |
+| t_order | item_id | order_cipher | NULL | MD5 | |
+| t_order | order_id | user_cipher | user_plain | AES | aes-key-value=123456abc |
++-----------+--------------+---------------+--------------+----------------+-------------------------+
4 rows in set (0.01 sec)
```
*Show Encrypt Table Rule Table Name*
```sql
mysql> show encrypt table rule t_encrypt;
-+-----------+-------------+--------------+-------------+---------------+-------------------------+
-| table | logicColumn | cipherColumn | plainColumn | encryptorType | encryptorProps |
-+-----------+-------------+--------------+-------------+---------------+-------------------------+
-| t_encrypt | order_id | order_cipher | NULL | MD5 | |
-| t_encrypt | user_id | user_cipher | user_plain | AES | aes-key-value=123456abc |
-+-----------+-------------+--------------+-------------+---------------+-------------------------+
++-----------+--------------+---------------+--------------+----------------+-------------------------+
+| table | logic_column | cipher_column | plain_column | encryptor_type | encryptor_props |
++-----------+--------------+---------------+--------------+----------------+-------------------------+
+| t_encrypt | order_id | order_cipher | NULL | MD5 | |
+| t_encrypt | user_id | user_cipher | user_plain | AES | aes-key-value=123456abc |
++-----------+--------------+---------------+--------------+----------------+-------------------------+
2 rows in set (0.00 sec)
mysql> show encrypt table rule t_encrypt from encrypt_db;
-+-----------+-------------+--------------+-------------+---------------+-------------------------+
-| table | logicColumn | cipherColumn | plainColumn | encryptorType | encryptorProps |
-+-----------+-------------+--------------+-------------+---------------+-------------------------+
-| t_encrypt | order_id | order_cipher | NULL | MD5 | |
-| t_encrypt | user_id | user_cipher | user_plain | AES | aes-key-value=123456abc |
-+-----------+-------------+--------------+-------------+---------------+-------------------------+
++-----------+--------------+---------------+--------------+----------------+-------------------------+
+| table | logic_column | cipher_column | plain_column | encryptor_type | encryptor_props |
++-----------+--------------+---------------+--------------+----------------+-------------------------+
+| t_encrypt | order_id | order_cipher | NULL | MD5 | |
+| t_encrypt | user_id | user_cipher | user_plain | AES | aes-key-value=123456abc |
++-----------+--------------+---------------+--------------+----------------+-------------------------+
2 rows in set (0.00 sec)
```
diff --git a/docs/document/content/features/dist-sql/syntax/rql/rql-readwrite-splitting-rule.cn.md b/docs/document/content/features/dist-sql/syntax/rql/rql-readwrite-splitting-rule.cn.md
index b2b6375..b085ac2 100644
--- a/docs/document/content/features/dist-sql/syntax/rql/rql-readwrite-splitting-rule.cn.md
+++ b/docs/document/content/features/dist-sql/syntax/rql/rql-readwrite-splitting-rule.cn.md
@@ -25,32 +25,32 @@ SHOW READWRITE_SPLITTING RULES [FROM schemaName]
*静态读写分离规则*
```sql
mysql> show readwrite_splitting rules;
-+------------+-------------------------+---------------------+--------------------------+------------------+------------------------+
-| name | auto_aware_data_source_name | write_data_source_name | read_data_source_names | load_balancer_type | load_balancer_props |
-+------------+-------------------------+---------------------+--------------------------+------------------+------------------------+
-| ms_group_0 | NULL | ds_primary | ds_slave_0, ds_slave_1 | random | |
-+------------+-------------------------+---------------------+--------------------------+------------------+------------------------+
++------------+-----------------------------+------------------------+------------------------+--------------------+---------------------+
+| name | auto_aware_data_source_name | write_data_source_name | read_data_source_names | load_balancer_type | load_balancer_props |
++------------+-----------------------------+------------------------+------------------------+--------------------+---------------------+
+| ms_group_0 | NULL | ds_primary | ds_slave_0, ds_slave_1 | random | |
++------------+-----------------------------+------------------------+------------------------+--------------------+---------------------+
1 row in set (0.00 sec)
```
*动态读写分离规则*
```sql
mysql> show readwrite_splitting rules from readwrite_splitting_db;
-+-------+-------------------------+---------------------+---------------------+------------------+------------------------+
-| name | auto_aware_data_source_name | write_data_source_name | read_data_source_names | load_balancer_type | load_balancer_props |
-+-------+-------------------------+---------------------+---------------------+------------------+------------------------+
-| pr_ds | ms_group_0 | NULL | | random | read_weight=2:1} |
-+-------+-------------------------+---------------------+---------------------+------------------+------------------------+
++-------+-----------------------------+------------------------+------------------------+--------------------+---------------------+
+| name | auto_aware_data_source_name | write_data_source_name | read_data_source_names | load_balancer_type | load_balancer_props |
++-------+-----------------------------+------------------------+------------------------+--------------------+---------------------+
+| pr_ds | ms_group_0 | NULL | | random | read_weight=2:1 |
++-------+-----------------------------+------------------------+------------------------+--------------------+---------------------+
1 row in set (0.01 sec)
```
*静态读写分离规则和动态读写分离规则*
```sql
mysql> show readwrite_splitting rules from readwrite_splitting_db;
-+-------+-------------------------+---------------------+------------------------+------------------+------------------------+
-| name | auto_aware_data_source_name | write_data_source_name | read_data_source_names | load_balancer_type | load_balancer_props |
-+-------+-------------------------+---------------------+------------------------+------------------+------------------------+
-| pr_ds | ms_group_0 | write_ds | read_ds_0, read_ds_1 | random | read_weight=2:1 |
-+-------+-------------------------+---------------------+------------------------+------------------+------------------------+
++-------+-----------------------------+------------------------+------------------------+--------------------+---------------------+
+| name | auto_aware_data_source_name | write_data_source_name | read_data_source_names | load_balancer_type | load_balancer_props |
++-------+-----------------------------+------------------------+------------------------+--------------------+---------------------+
+| pr_ds | ms_group_0 | write_ds | read_ds_0, read_ds_1 | random | read_weight=2:1 |
++-------+-----------------------------+------------------------+------------------------+--------------------+---------------------+
1 row in set (0.00 sec)
```
diff --git a/docs/document/content/features/dist-sql/syntax/rql/rql-readwrite-splitting-rule.en.md b/docs/document/content/features/dist-sql/syntax/rql/rql-readwrite-splitting-rule.en.md
index 0c58ed4..7e996fd 100644
--- a/docs/document/content/features/dist-sql/syntax/rql/rql-readwrite-splitting-rule.en.md
+++ b/docs/document/content/features/dist-sql/syntax/rql/rql-readwrite-splitting-rule.en.md
@@ -25,32 +25,32 @@ SHOW READWRITE_SPLITTING RULES [FROM schemaName]
*Static Readwrite Splitting Rules*
```sql
mysql> show readwrite_splitting rules;
-+------------+-------------------------+---------------------+--------------------------+------------------+------------------------+
-| name | auto_aware_data_source_name | write_data_source_name | read_data_source_names | load_balancer_type | load_balancer_props |
-+------------+-------------------------+---------------------+--------------------------+------------------+------------------------+
-| ms_group_0 | NULL | ds_primary | ds_slave_0, ds_slave_1 | random | |
-+------------+-------------------------+---------------------+--------------------------+------------------+------------------------+
++------------+-----------------------------+------------------------+------------------------+--------------------+---------------------+
+| name | auto_aware_data_source_name | write_data_source_name | read_data_source_names | load_balancer_type | load_balancer_props |
++------------+-----------------------------+------------------------+------------------------+--------------------+---------------------+
+| ms_group_0 | NULL | ds_primary | ds_slave_0, ds_slave_1 | random | |
++------------+-----------------------------+------------------------+------------------------+--------------------+---------------------+
1 row in set (0.00 sec)
```
*Dynamic Readwrite Splitting Rules*
```sql
mysql> show readwrite_splitting rules from readwrite_splitting_db;
-+-------+-------------------------+---------------------+---------------------+------------------+------------------------+
-| name | auto_aware_data_source_name | write_data_source_name | read_data_source_names | load_balancer_type | load_balancer_props |
-+-------+-------------------------+---------------------+---------------------+------------------+------------------------+
-| pr_ds | ms_group_0 | NULL | | random | read_weight=2:1} |
-+-------+-------------------------+---------------------+---------------------+------------------+------------------------+
++-------+-----------------------------+------------------------+------------------------+--------------------+---------------------+
+| name | auto_aware_data_source_name | write_data_source_name | read_data_source_names | load_balancer_type | load_balancer_props |
++-------+-----------------------------+------------------------+------------------------+--------------------+---------------------+
+| pr_ds | ms_group_0 | NULL | | random | read_weight=2:1 |
++-------+-----------------------------+------------------------+------------------------+--------------------+---------------------+
1 row in set (0.01 sec)
```
*Static Readwrite Splitting Rules And Dynamic Readwrite Splitting Rules*
```sql
mysql> show readwrite_splitting rules from readwrite_splitting_db;
-+-------+-------------------------+---------------------+------------------------+------------------+------------------------+
-| name | auto_aware_data_source_name | write_data_source_name | read_data_source_names | load_balancer_type | load_balancer_props |
-+-------+-------------------------+---------------------+------------------------+------------------+------------------------+
-| pr_ds | ms_group_0 | write_ds | read_ds_0, read_ds_1 | random | read_weight=2:1 |
-+-------+-------------------------+---------------------+------------------------+------------------+------------------------+
++-------+-----------------------------+------------------------+------------------------+--------------------+---------------------+
+| name | auto_aware_data_source_name | write_data_source_name | read_data_source_names | load_balancer_type | load_balancer_props |
++-------+-----------------------------+------------------------+------------------------+--------------------+---------------------+
+| pr_ds | ms_group_0 | write_ds | read_ds_0, read_ds_1 | random | read_weight=2:1 |
++-------+-----------------------------+------------------------+------------------------+--------------------+---------------------+
1 row in set (0.00 sec)
```