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/incubator-shenyu.git
The following commit(s) were added to refs/heads/master by this push:
new c6cd8cc3a [type:feat] Signature plugin add upgrade sql (#3671)
c6cd8cc3a is described below
commit c6cd8cc3a3053155ba8a08909808057b66f50136
Author: yunlongn <[email protected]>
AuthorDate: Wed Jul 6 22:05:30 2022 +0800
[type:feat] Signature plugin add upgrade sql (#3671)
* [ISSUE #3628] Signature plugin extension
* [ISSUE #3628] Signature plugin extension
* [ISSUE #3628] Signature plugin extension
* [ISSUE #3628] Signature plugin extension
* [type:feat] Signature plugin add upgrade sql
---
db/upgrade/2.4.3-upgrade-2.5.0-mysql.sql | 7 +++++++
db/upgrade/2.4.3-upgrade-2.5.0-pg.sql | 7 +++++++
2 files changed, 14 insertions(+)
diff --git a/db/upgrade/2.4.3-upgrade-2.5.0-mysql.sql
b/db/upgrade/2.4.3-upgrade-2.5.0-mysql.sql
index 0d44d71df..bb6a15d4c 100644
--- a/db/upgrade/2.4.3-upgrade-2.5.0-mysql.sql
+++ b/db/upgrade/2.4.3-upgrade-2.5.0-mysql.sql
@@ -96,3 +96,10 @@ INSERT INTO `plugin_handle` VALUES ('1529402613204172902',
'50', 'sampleRate', '
INSERT INTO `plugin_handle` VALUES ('1529402613204172903', '50',
'maxResponseBody', 'maxResponseBody', 1, 3, 5,
'{\"required\":\"0\",\"defaultValue\":524288}', '2022-07-04 22:00:00',
'2022-07-04 22:00:00');
INSERT INTO `plugin_handle` VALUES ('1529402613204172904', '50',
'maxRequestBody', 'maxRequestBody', 1, 3, 6,
'{\"required\":\"0\",\"defaultValue\":524288}', '2022-07-04 22:00:00',
'2022-07-04 22:00:00');
INSERT INTO `plugin_handle` VALUES ('1529402613204172905', '50',
'compressAlg', 'compressAlg', 3, 3, 7,
'{\"required\":\"0\",\"defaultValue\":\"none\"}', '2022-07-04 22:00:00',
'2022-07-04 22:00:00');
+
+-- insert plugin_handle data for sign
+INSERT INTO `plugin_handle` VALUES ('1529402613204172884', '1',
'signRequestBody', 'signRequestBody', 3, 2, 9,
'{"required":"0","defaultValue":"false","placeholder":"signRequestBody","rule":""}',
'2022-06-29 10:08:02', '2022-06-29 10:08:02');
+
+-- insert shenyu_dict data for sign
+INSERT IGNORE INTO shenyu_dict (`id`, `type`, `dict_code`, `dict_name`,
`dict_value`, `desc`, `sort`, `enabled`) VALUES ('1529402613195784247',
'signRequestBody', 'SIGN_REQUEST_BODY', 'close', 'false', 'close', 1, 1);
+INSERT IGNORE INTO shenyu_dict (`id`, `type`, `dict_code`, `dict_name`,
`dict_value`, `desc`, `sort`, `enabled`) VALUES ('1529402613195784248',
'signRequestBody', 'SIGN_REQUEST_BODY', 'open', 'true', 'open', 0, 1);
\ No newline at end of file
diff --git a/db/upgrade/2.4.3-upgrade-2.5.0-pg.sql
b/db/upgrade/2.4.3-upgrade-2.5.0-pg.sql
index 8f6c68cef..1dda62edc 100644
--- a/db/upgrade/2.4.3-upgrade-2.5.0-pg.sql
+++ b/db/upgrade/2.4.3-upgrade-2.5.0-pg.sql
@@ -108,3 +108,10 @@ INSERT INTO "public"."plugin_handle" VALUES
('1529403902783524954', '50', 'maxRe
INSERT INTO "public"."plugin_handle" VALUES ('1529403902783524955', '50',
'compressAlg', 'compressAlg', 3, 3, 7,
'{"required":"0","defaultValue":"none"}', '2022-07-04 22:00:00', '2022-07-04
22:00:00');
INSERT INTO "public"."plugin_handle" VALUES ('1529403902783524956', '50',
'topic', 'topic', 2, 1, 1,
'{"required":"0","defaultValue":"","placeholder":"optional"}', '2022-07-04
22:00:00', '2022-07-04 22:00:00');
INSERT INTO "public"."plugin_handle" VALUES ('1529403902783524957', '50',
'sampleRate', 'sampleRate', 2, 1, 2,
'{"required":"0","defaultValue":"","placeholder":"optional,0,0.01~1"}',
'2022-07-04 22:00:00', '2022-07-04 22:00:00');
+
+-- insert plugin_handle data for sign
+INSERT INTO "public"."plugin_handle" VALUES ('1529402613204172884', '1',
'signRequestBody', 'signRequestBody', 3, 2, 9,
'{"required":"0","defaultValue":"false","placeholder":"signRequestBody","rule":""}',
'2022-06-29 10:08:02', '2022-06-29 10:08:02');
+
+-- insert shenyu_dict data for sign
+INSERT INTO shenyu_dict ("id", "type", "dict_code", "dict_name", "dict_value",
"desc", "sort", "enabled") VALUES ('1529402613195784247', 'signRequestBody',
'SIGN_REQUEST_BODY', 'close', 'false', 'close', 1, 1);
+INSERT INTO shenyu_dict ("id", "type", "dict_code", "dict_name", "dict_value",
"desc", "sort", "enabled") VALUES ('1529402613195784248', 'signRequestBody',
'SIGN_REQUEST_BODY', 'open', 'true', 'open', 0, 1);
\ No newline at end of file
