[shenyu] branch master updated: Fix json data in upgrade sql. (#4374)

[xiaoyu]

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

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


The following commit(s) were added to refs/heads/master by this push:
     new 8e6728bd3 Fix json data in upgrade sql. (#4374)
8e6728bd3 is described below

commit 8e6728bd3f6f6c0b6f1042e1503e90eaa23599a5
Author: Will <u3bre...@gmail.com>
AuthorDate: Mon Feb 13 18:37:37 2023 +0800

    Fix json data in upgrade sql. (#4374)
    
    * 修复ModifyResponsePlugin会重置ClientResponse maxInMemorySize=256K的问题。
    
    * Fixed sql problems in upgrade sql files (2.4.3-upgrade-2.5.0-mysql.sql, 
2.5.0-upgrade-2.5.1-mysql.sql) that conflict with plugin_handle id.
    
    * Delete duplicate sql statements.
    
    * Fix upgrade sql.
    
    ---------
    
    Co-authored-by: moremind <hefen...@hotmail.com>
    Co-authored-by: xiaoyu <xia...@apache.org>
    Co-authored-by: dragon-zhang <zhangzich...@apache.org>
---
 db/upgrade/2.5.0-upgrade-2.5.1-mysql.sql | 2 +-
 db/upgrade/2.5.0-upgrade-2.5.1-pg.sql    | 2 +-
 2 files changed, 2 insertions(+), 2 deletions(-)

diff --git a/db/upgrade/2.5.0-upgrade-2.5.1-mysql.sql 
b/db/upgrade/2.5.0-upgrade-2.5.1-mysql.sql
index c6e6086c1..b0ade850e 100644
--- a/db/upgrade/2.5.0-upgrade-2.5.1-mysql.sql
+++ b/db/upgrade/2.5.0-upgrade-2.5.1-mysql.sql
@@ -40,7 +40,7 @@ UPDATE plugin_handle SET sort = sort + 2 WHERE plugin_id = 
'29' AND field in ('s
 /* insert plugin for loggingPulsar */
 INSERT INTO `plugin` VALUES ('35', 'loggingPulsar', 
'{\"topic":\"shenyu-access-logging\", \"serviceUrl\": 
\"pulsar://localhost:6650\"}', 'Logging', 185, 0, '2022-06-30 21:00:00', 
'2022-06-30 21:00:00');
 -- insert loggingTencentCls plugin
-INSERT INTO `plugin` VALUES ('36', 'loggingTencentCls','{\"endpoint\": 
\"ap-guangzhou.cls.tencentcs.com\, \"topic\": \"shenyu-topic\"}', 'Logging', 
176, 0, '2022-06-30 21:00:00', '2022-06-30 21:00:00');
+INSERT INTO `plugin` VALUES ('36', 'loggingTencentCls','{\"endpoint\": 
\"ap-guangzhou.cls.tencentcs.com\", \"topic\": \"shenyu-topic\"}', 'Logging', 
176, 0, '2022-06-30 21:00:00', '2022-06-30 21:00:00');
 /* insert plugin for loggingClickHouse */
 INSERT INTO `plugin` VALUES ('38', 'loggingClickHouse', 
'{\"host\":\"127.0.0.1\",\"port\":\"8123\",\"databse\":\"shenyu-gateway\",\"username\":\"foo\",\"password\":\"bar\"}',
 'Logging', 195, 0, '2022-06-30 21:00:00', '2022-06-30 21:00:00');
 
diff --git a/db/upgrade/2.5.0-upgrade-2.5.1-pg.sql 
b/db/upgrade/2.5.0-upgrade-2.5.1-pg.sql
index 7991053a8..e2738162f 100644
--- a/db/upgrade/2.5.0-upgrade-2.5.1-pg.sql
+++ b/db/upgrade/2.5.0-upgrade-2.5.1-pg.sql
@@ -40,7 +40,7 @@ UPDATE "public"."plugin_handle" SET sort = sort + 2 WHERE 
plugin_id = '29' AND f
 /* insert plugin for loggingPulsar */
 INSERT INTO "public"."plugin" VALUES ('35', 'loggingPulsar', 
'{"topic":"shenyu-access-logging", "serviceUrl": "pulsar://localhost:6650"}', 
'Logging', 185, 0, '2022-05-25 18:08:01', '2022-05-25 18:08:01');
 -- insert loggingTencentCls plugin
-INSERT INTO "public"."plugin" VALUES ('36', 'loggingTencentCls', '{"endpoint": 
"ap-guangzhou.cls.tencentcs.com\, "topic": "shenyu-topic"}', 'Logging', 176, 0, 
'2022-06-30 21:00:00', '2022-06-30 21:00:00');
+INSERT INTO "public"."plugin" VALUES ('36', 'loggingTencentCls', '{"endpoint": 
"ap-guangzhou.cls.tencentcs.com", "topic": "shenyu-topic"}', 'Logging', 176, 0, 
'2022-06-30 21:00:00', '2022-06-30 21:00:00');
 /* insert plugin for loggingClickHouse */
 INSERT INTO "public"."plugin" VALUES ('38', 'loggingClickHouse', 
'{"host":"127.0.0.1","port":"8123","databse":"shenyu-gateway","username":"foo","password":"bar"}',
 'Logging', 195, 0, '2022-06-30 21:00:00', '2022-06-30 21:00:00');