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 ce3719d4d6 [type:fix]fix 2.6.1 to 2.7.0 upgrade.sql (#5933)
ce3719d4d6 is described below
commit ce3719d4d68cb51df0704a154fb1da8b2a1778ed
Author: xcsnx <[email protected]>
AuthorDate: Mon Feb 17 14:48:41 2025 +0800
[type:fix]fix 2.6.1 to 2.7.0 upgrade.sql (#5933)
* fix
* fix
* fix upgrade.sql
---------
Co-authored-by: ‘xcsnx’ <‘[email protected]’>
---
db/upgrade/2.6.1-upgrade-2.7.0-og.sql | 100 ++++++++++++++---------------
db/upgrade/2.6.1-upgrade-2.7.0-oracle.sql | 101 +++++++++++++++---------------
db/upgrade/2.6.1-upgrade-2.7.0-pg.sql | 98 ++++++++++++++---------------
3 files changed, 144 insertions(+), 155 deletions(-)
diff --git a/db/upgrade/2.6.1-upgrade-2.7.0-og.sql
b/db/upgrade/2.6.1-upgrade-2.7.0-og.sql
index 1f27167d0b..bfe46e9df6 100644
--- a/db/upgrade/2.6.1-upgrade-2.7.0-og.sql
+++ b/db/upgrade/2.6.1-upgrade-2.7.0-og.sql
@@ -145,50 +145,6 @@ COMMENT ON COLUMN
"public"."namespace_plugin_rel"."date_created" IS 'Creation ti
COMMENT ON COLUMN "public"."namespace_plugin_rel"."date_updated" IS 'Update
time';
-INSERT INTO "public"."namespace_plugin_rel" VALUES
('1801816010882822145','649330b6-c2d7-4edc-be8e-8a54df9eb385','1', NULL, 20, 0,
'2022-05-25 18:02:53.000', '2022-05-25 18:02:53.000');
-INSERT INTO "public"."namespace_plugin_rel" VALUES
('1801816010882822146','649330b6-c2d7-4edc-be8e-8a54df9eb385','10', NULL, 140,
0, '2022-05-25 18:02:53.000', '2022-05-25 18:02:53.000');
-INSERT INTO "public"."namespace_plugin_rel" VALUES
('1801816010882822147','649330b6-c2d7-4edc-be8e-8a54df9eb385','11',
'{"protocol":"zookeeper","register":"127.0.0.1:2181","threadpool":"shared"}',
310, 0, '2022-05-25 18:02:53.000', '2022-05-25 18:02:53.000');
-INSERT INTO "public"."namespace_plugin_rel" VALUES
('1801816010882822148','649330b6-c2d7-4edc-be8e-8a54df9eb385','12', NULL, 310,
0, '2022-05-25 18:02:53.000', '2022-05-25 18:02:53.000');
-INSERT INTO "public"."namespace_plugin_rel" VALUES
('1801816010882822149','649330b6-c2d7-4edc-be8e-8a54df9eb385','13',
'{"multiSelectorHandle":"1","multiRuleHandle":"0","threadpool":"shared"}', 310,
0, '2022-05-25 18:02:53.000', '2022-05-25 18:02:53.000');
-INSERT INTO "public"."namespace_plugin_rel" VALUES
('1801816010882822150','649330b6-c2d7-4edc-be8e-8a54df9eb385','14', NULL, 80,
1, '2022-05-25 18:02:53.000', '2022-05-25 18:02:53.000');
-INSERT INTO "public"."namespace_plugin_rel" VALUES
('1801816010882822151','649330b6-c2d7-4edc-be8e-8a54df9eb385','15',
'{"multiSelectorHandle":"1","multiRuleHandle":"0","threadpool":"shared"}', 310,
0, '2022-05-25 18:02:53.000', '2022-05-25 18:02:53.000');
-INSERT INTO "public"."namespace_plugin_rel" VALUES
('1801816010882822152','649330b6-c2d7-4edc-be8e-8a54df9eb385','16', NULL, 110,
0, '2022-05-25 18:02:53.000', '2022-05-25 18:02:53.000');
-INSERT INTO "public"."namespace_plugin_rel" VALUES
('1801816010882822153','649330b6-c2d7-4edc-be8e-8a54df9eb385','17',
'{"registerProtocol":"direct","registerAddress":"127.0.0.1:2181","corethreads":0,"threads":2147483647,"queues":0,"threadpool":"shared"}',
310, 0, '2022-05-25 18:02:53.000', '2022-05-25 18:02:53.000');
-INSERT INTO "public"."namespace_plugin_rel" VALUES
('1801816010882822154','649330b6-c2d7-4edc-be8e-8a54df9eb385','18', NULL, 160,
0, '2022-05-25 18:02:53.000', '2022-05-25 18:02:53.000');
-INSERT INTO "public"."namespace_plugin_rel" VALUES
('1801816010882822155','649330b6-c2d7-4edc-be8e-8a54df9eb385','19',
'{"secretKey":"key"}', 30, 0, '2022-05-25 18:02:53.000', '2022-05-25
18:02:53.000');
-INSERT INTO "public"."namespace_plugin_rel" VALUES
('1801816010882822156','649330b6-c2d7-4edc-be8e-8a54df9eb385','2',
'{"model":"black"}', 50, 0, '2022-05-25 18:02:53.000', '2022-05-25
18:02:53.000');
-INSERT INTO "public"."namespace_plugin_rel" VALUES
('1801816010882822157','649330b6-c2d7-4edc-be8e-8a54df9eb385','20', NULL, 120,
0, '2022-05-25 18:02:53.000', '2022-05-25 18:02:53.000');
-INSERT INTO "public"."namespace_plugin_rel" VALUES
('1801816010882822158','649330b6-c2d7-4edc-be8e-8a54df9eb385','21', NULL, 40,
0, '2022-05-25 18:02:53.000', '2022-05-25 18:02:53.000');
-INSERT INTO "public"."namespace_plugin_rel" VALUES
('1801816010882822159','649330b6-c2d7-4edc-be8e-8a54df9eb385','22', NULL, 70,
0, '2022-05-25 18:02:53.000', '2022-05-25 18:02:53.000');
-INSERT INTO "public"."namespace_plugin_rel" VALUES
('1801816010882822160','649330b6-c2d7-4edc-be8e-8a54df9eb385','23', NULL, 220,
0, '2022-05-25 18:02:53.000', '2022-05-25 18:02:53.000');
-INSERT INTO "public"."namespace_plugin_rel" VALUES
('1801816010882822161','649330b6-c2d7-4edc-be8e-8a54df9eb385','24', NULL, 100,
1, '2022-05-25 18:02:53.000', '2022-05-25 18:02:53.000');
-INSERT INTO "public"."namespace_plugin_rel" VALUES
('1801816010882822162','649330b6-c2d7-4edc-be8e-8a54df9eb385','25', NULL, 410,
1, '2022-05-25 18:02:53.000', '2022-05-25 18:02:53.000');
-INSERT INTO "public"."namespace_plugin_rel" VALUES
('1801816010882822163','649330b6-c2d7-4edc-be8e-8a54df9eb385','26',
'{"multiSelectorHandle":"1"}', 200, 1, '2022-05-25 18:02:53.000', '2022-05-25
18:02:53.000');
-INSERT INTO "public"."namespace_plugin_rel" VALUES
('1801816010882822164','649330b6-c2d7-4edc-be8e-8a54df9eb385','27', NULL, 125,
1, '2022-05-25 18:02:53.000', '2022-05-25 18:02:53.000');
-INSERT INTO "public"."namespace_plugin_rel" VALUES
('1801816010882822165','649330b6-c2d7-4edc-be8e-8a54df9eb385','28', '{"port":
9500,"bossGroupThreadCount": 1,"maxPayloadSize":
65536,"workerGroupThreadCount": 12,"userName": "shenyu","password":
"shenyu","isEncryptPassword": false,"encryptMode": "","leakDetectorLevel":
"DISABLED"}', 125, 0, '2022-05-25 18:02:53.000', '2022-05-25 18:02:53.000');
-INSERT INTO "public"."namespace_plugin_rel" VALUES
('1801816010882822166','649330b6-c2d7-4edc-be8e-8a54df9eb385','29',
'{"topic":"shenyu-access-logging", "namesrvAddr":
"localhost:9876","producerGroup":"shenyu-plugin-logging-rocketmq"}', 170, 0,
'2022-05-25 18:02:53.000', '2022-05-25 18:02:53.000');
-INSERT INTO "public"."namespace_plugin_rel" VALUES
('1801816010882822167','649330b6-c2d7-4edc-be8e-8a54df9eb385','3', NULL, 90, 0,
'2022-05-25 18:02:53.000', '2022-05-25 18:02:53.000');
-INSERT INTO "public"."namespace_plugin_rel" VALUES
('1801816010882822168','649330b6-c2d7-4edc-be8e-8a54df9eb385','30',
'{"cacheType":"memory"}', 10, 0, '2022-05-25 18:02:53.000', '2022-05-25
18:02:53.000');
-INSERT INTO "public"."namespace_plugin_rel" VALUES
('1801816010882822169','649330b6-c2d7-4edc-be8e-8a54df9eb385','31', NULL, 1, 0,
'2022-06-16 14:40:35.000', '2022-06-16 14:40:55.000');
-INSERT INTO "public"."namespace_plugin_rel" VALUES
('1801816010882822170','649330b6-c2d7-4edc-be8e-8a54df9eb385','32',
'{"host":"localhost", "port": "9200"}', 190, 0, '2022-06-19 22:00:00.000',
'2022-06-19 22:00:00.000');
-INSERT INTO "public"."namespace_plugin_rel" VALUES
('1801816010882822171','649330b6-c2d7-4edc-be8e-8a54df9eb385','33',
'{"host":"localhost", "port": "9092"}', 180, 0, '2022-07-04 22:00:00.000',
'2022-07-02 22:00:00.000');
-INSERT INTO "public"."namespace_plugin_rel" VALUES
('1801816010882822172','649330b6-c2d7-4edc-be8e-8a54df9eb385','34',
'{"projectName": "shenyu", "logStoreName": "shenyu-logstore", "topic":
"shenyu-topic"}', 175, 0, '2022-06-30 21:00:00.000', '2022-06-30 21:00:00.000');
-INSERT INTO "public"."namespace_plugin_rel" VALUES
('1801816010882822173','649330b6-c2d7-4edc-be8e-8a54df9eb385','35',
'{"topic":"shenyu-access-logging", "serviceUrl": "pulsar://localhost:6650"}',
185, 0, '2022-06-30 21:00:00.000', '2022-06-30 21:00:00.000');
-INSERT INTO "public"."namespace_plugin_rel" VALUES
('1801816010882822174','649330b6-c2d7-4edc-be8e-8a54df9eb385','36',
'{"endpoint": "ap-guangzhou.cls.tencentcs.com", "topic": "shenyu-topic"}', 176,
0, '2022-06-30 21:00:00.000', '2022-06-30 21:00:00.000');
-INSERT INTO "public"."namespace_plugin_rel" VALUES
('1801816010882822175','649330b6-c2d7-4edc-be8e-8a54df9eb385','38',
'{"host":"127.0.0.1","port":"8123","databse":"shenyu-gateway","username":"foo","password":"bar"}',
195, 0, '2022-06-30 21:00:00.000', '2022-06-30 21:00:00.000');
-INSERT INTO "public"."namespace_plugin_rel" VALUES
('1801816010882822176','649330b6-c2d7-4edc-be8e-8a54df9eb385','39',
'{"endpoint":"http://localhost:8000"}', 40, 0, '2022-09-11 12:00:00.000',
'2022-09-11 12:00:00.000');
-INSERT INTO "public"."namespace_plugin_rel" VALUES
('1801816010882822177','649330b6-c2d7-4edc-be8e-8a54df9eb385','4',
'{"master":"mymaster","mode":"standalone","url":"192.168.1.1:6379","password":"abc"}',
60, 0, '2022-05-25 18:02:53.000', '2022-05-25 18:02:53.000');
-INSERT INTO "public"."namespace_plugin_rel" VALUES
('1801816010882822178','649330b6-c2d7-4edc-be8e-8a54df9eb385','40', NULL, 150,
0, '2022-07-24 19:00:00.000', '2022-07-24 19:00:00.000');
-INSERT INTO "public"."namespace_plugin_rel" VALUES
('1801816010882822179','649330b6-c2d7-4edc-be8e-8a54df9eb385','42', NULL, 320,
1, '2023-05-30 18:02:53.000', '2022-05-30 18:02:53.000');
-INSERT INTO "public"."namespace_plugin_rel" VALUES
('1801816010882822180','649330b6-c2d7-4edc-be8e-8a54df9eb385','43',
'{"totalSizeInBytes":"104857600","maxBlockMs":"0","ioThreadCount":"1","batchSizeThresholdInBytes":"524288","batchCountThreshold":"4096","lingerMs":"2000","retries":"100","baseRetryBackoffMs":"100","maxRetryBackoffMs":"100","enableLocalTest":"true","setGiveUpExtraLongSingleLog":"false"}',
177, 0, '2023-07-05 14:03:53.686', '2023-07-06 12:42:07.234');
-INSERT INTO "public"."namespace_plugin_rel" VALUES
('1801816010882822181','649330b6-c2d7-4edc-be8e-8a54df9eb385','44',
'{"defaultHandleJson":"{\"authorization\":\"test:test123\"}"}', 150, 0,
'2022-07-24 19:00:00.000', '2022-07-24 19:00:00.000');
-INSERT INTO "public"."namespace_plugin_rel" VALUES
('1801816010882822182','649330b6-c2d7-4edc-be8e-8a54df9eb385','45',
'{"host":"127.0.0.1","port":5672,"password":"admin","username":"admin","exchangeName":"exchange.logging.plugin","queueName":"queue.logging.plugin","routingKey":"topic.logging","virtualHost":"/","exchangeType":"direct","durable":"true","exclusive":"false","autoDelete":"false"}',
171, 0, '2023-11-06 15:49:56.454', '2023-11-10 10:40:58.447');
-INSERT INTO "public"."namespace_plugin_rel" VALUES
('1801816010882822183','649330b6-c2d7-4edc-be8e-8a54df9eb385','5',
'{"multiSelectorHandle":"1","multiRuleHandle":"0"}', 200, 1, '2022-05-25
18:02:53.000', '2022-05-25 18:02:53.000');
-INSERT INTO "public"."namespace_plugin_rel" VALUES
('1801816010882822184','649330b6-c2d7-4edc-be8e-8a54df9eb385','6',
'{"register":"zookeeper://localhost:2181","multiSelectorHandle":"1","threadpool":"shared","corethreads":0,"threads":2147483647,"queues":0}',
310, 0, '2022-05-25 18:02:53.000', '2022-05-25 18:02:53.000');
-INSERT INTO "public"."namespace_plugin_rel" VALUES
('1801816010882822185','649330b6-c2d7-4edc-be8e-8a54df9eb385','8',
'{"enabled":false,"registerType":"eureka","serverLists":"http://localhost:8761/eureka","props":{}}',
200, 0, '2022-05-25 18:02:53.000', '2022-05-25 18:02:53.000');
-INSERT INTO "public"."namespace_plugin_rel" VALUES
('1801816010882822186','649330b6-c2d7-4edc-be8e-8a54df9eb385','9', NULL, 130,
0, '2022-05-25 18:02:53.000', '2022-05-25 18:02:53.000');
-
-
INSERT INTO "public"."resource" VALUES ('1792749362445840479',
'1357956838021890048', 'SHENYU.MENU.SYSTEM.MANAGMENT.NAMESPACEPLUGIN',
'namespacePlugin', '/config/namespacePlugin', 'namespacePlugin', 1, 2, 'build',
0, 0, '', 1, '2024-06-25 18:02:53.000', '2024-06-25 18:02:53.000');
INSERT INTO "public"."resource" VALUES ('1792749362445840480',
'1792749362445840479', 'SHENYU.BUTTON.SYSTEM.LIST', '', '', '', 2, 0, '', 1, 0,
'system:namespacePlugin:list', 1, '2024-06-25 18:02:53.000', '2024-06-25
18:02:53.000');
INSERT INTO "public"."resource" VALUES ('1792749362445840481',
'1792749362445840479', 'SHENYU.BUTTON.SYSTEM.DELETE', '', '', '', 2, 1, '', 1,
0, 'system:namespacePlugin:delete', 1, '2024-06-25 18:02:53.000', '2024-06-25
18:02:53.000');
@@ -236,21 +192,21 @@ COMMENT ON COLUMN
"public"."proxy_selector"."namespace_id" IS 'namespaceId';
ALTER TABLE "public"."alert_receiver" ADD COLUMN namespace_id VARCHAR(50) NOT
NULL;
COMMENT ON COLUMN "public"."alert_receiver"."namespace_id" IS 'namespaceId';
-UPDATE "public"."selector" SET namespace_id =
'649330b6-c2d7-4edc-be8e-8a54df9eb385' WHERE namespace_id IS NULL;
+UPDATE "public"."selector" SET namespace_id =
'649330b6-c2d7-4edc-be8e-8a54df9eb385' WHERE namespace_id IS NULL OR
LENGTH(namespace_id) = 0;
-UPDATE "public"."rule" SET namespace_id =
'649330b6-c2d7-4edc-be8e-8a54df9eb385' WHERE namespace_id IS NULL;
+UPDATE "public"."rule" SET namespace_id =
'649330b6-c2d7-4edc-be8e-8a54df9eb385' WHERE namespace_id IS NULL OR
LENGTH(namespace_id) = 0;
-UPDATE "public"."meta_data" SET namespace_id =
'649330b6-c2d7-4edc-be8e-8a54df9eb385' WHERE namespace_id IS NULL;
+UPDATE "public"."meta_data" SET namespace_id =
'649330b6-c2d7-4edc-be8e-8a54df9eb385' WHERE namespace_id IS NULL OR
LENGTH(namespace_id) = 0;
-UPDATE "public"."app_auth" SET namespace_id =
'649330b6-c2d7-4edc-be8e-8a54df9eb385' WHERE namespace_id IS NULL;
+UPDATE "public"."app_auth" SET namespace_id =
'649330b6-c2d7-4edc-be8e-8a54df9eb385' WHERE namespace_id IS NULL OR
LENGTH(namespace_id) = 0;
-UPDATE "public"."discovery" SET namespace_id =
'649330b6-c2d7-4edc-be8e-8a54df9eb385' WHERE namespace_id IS NULL;
+UPDATE "public"."discovery" SET namespace_id =
'649330b6-c2d7-4edc-be8e-8a54df9eb385' WHERE namespace_id IS NULL OR
LENGTH(namespace_id) = 0;
-UPDATE "public"."discovery_upstream" SET namespace_id =
'649330b6-c2d7-4edc-be8e-8a54df9eb385' WHERE namespace_id IS NULL;
+UPDATE "public"."discovery_upstream" SET namespace_id =
'649330b6-c2d7-4edc-be8e-8a54df9eb385' WHERE namespace_id IS NULL OR
LENGTH(namespace_id) = 0;
-UPDATE "public"."proxy_selector" SET namespace_id =
'649330b6-c2d7-4edc-be8e-8a54df9eb385' WHERE namespace_id IS NULL;
+UPDATE "public"."proxy_selector" SET namespace_id =
'649330b6-c2d7-4edc-be8e-8a54df9eb385' WHERE namespace_id IS NULL OR
LENGTH(namespace_id) = 0;
-UPDATE "public"."alert_receiver" SET namespace_id =
'649330b6-c2d7-4edc-be8e-8a54df9eb385' WHERE namespace_id IS NULL;
+UPDATE "public"."alert_receiver" SET namespace_id =
'649330b6-c2d7-4edc-be8e-8a54df9eb385' WHERE namespace_id IS NULL OR
LENGTH(namespace_id) = 0;
-- ----------------------------
-- Table structure for scale
@@ -338,3 +294,43 @@ COMMENT ON COLUMN "public"."namespace_user_rel"."user_id"
IS 'user_id';
COMMENT ON COLUMN "public"."namespace_user_rel"."date_created" IS 'create
time';
COMMENT ON COLUMN "public"."namespace_user_rel"."date_updated" IS 'update
time';
+INSERT INTO "public"."namespace_plugin_rel" (
+ id,
+ namespace_id,
+ plugin_id,
+ config,
+ sort,
+ enabled,
+ date_created,
+ date_updated
+)
+SELECT
+ CONCAT(EXTRACT(EPOCH FROM clock_timestamp()) * 1000::BIGINT,
LPAD((RANDOM() * 1000000)::BIGINT::TEXT, 6, '0')),
+ '649330b6-c2d7-4edc-be8e-8a54df9eb385',
+ id,
+ config,
+ sort,
+ enabled,
+ date_created,
+ date_updated
+FROM "public"."plugin";
+
+
+INSERT INTO "public"."namespace_user_rel" (
+ id,
+ namespace_id,
+ user_id,
+ date_created,
+ date_updated
+)
+SELECT
+ CONCAT(
+ FLOOR(EXTRACT(EPOCH FROM NOW()) * 1000),
+ LPAD(CAST(FLOOR(RANDOM() * 1000000) AS TEXT), 6, '0')
+ ),
+ '649330b6-c2d7-4edc-be8e-8a54df9eb385',
+ id,
+ date_created,
+ date_updated
+FROM dashboard_user;
+
diff --git a/db/upgrade/2.6.1-upgrade-2.7.0-oracle.sql
b/db/upgrade/2.6.1-upgrade-2.7.0-oracle.sql
index 03bf078847..a7dad8eaaa 100755
--- a/db/upgrade/2.6.1-upgrade-2.7.0-oracle.sql
+++ b/db/upgrade/2.6.1-upgrade-2.7.0-oracle.sql
@@ -182,50 +182,6 @@ COMMENT ON COLUMN namespace_plugin_rel.enabled IS 'Whether
the plugin is enabled
COMMENT ON COLUMN namespace_plugin_rel.date_created IS 'Creation time';
COMMENT ON COLUMN namespace_plugin_rel.date_updated IS 'Update time';
-INSERT /*+ IGNORE_ROW_ON_DUPKEY_INDEX (namespace_plugin_rel(id)) */ INTO
namespace_plugin_rel (id,namespace_id,plugin_id, config, sort, enabled) VALUES
('1801816010882822145','649330b6-c2d7-4edc-be8e-8a54df9eb385','1', NULL, 20, 0);
-INSERT /*+ IGNORE_ROW_ON_DUPKEY_INDEX (namespace_plugin_rel(id)) */ INTO
namespace_plugin_rel (id,namespace_id,plugin_id, config, sort, enabled) VALUES
('1801816010882822146','649330b6-c2d7-4edc-be8e-8a54df9eb385','10', NULL, 140,
0);
-INSERT /*+ IGNORE_ROW_ON_DUPKEY_INDEX (namespace_plugin_rel(id)) */ INTO
namespace_plugin_rel (id,namespace_id,plugin_id, config, sort, enabled) VALUES
('1801816010882822147','649330b6-c2d7-4edc-be8e-8a54df9eb385','11',
'{"protocol":"zookeeper","register":"127.0.0.1:2181","threadpool":"shared"}',
310, 0);
-INSERT /*+ IGNORE_ROW_ON_DUPKEY_INDEX (namespace_plugin_rel(id)) */ INTO
namespace_plugin_rel (id,namespace_id,plugin_id, config, sort, enabled) VALUES
('1801816010882822148','649330b6-c2d7-4edc-be8e-8a54df9eb385','12', NULL, 310,
0);
-INSERT /*+ IGNORE_ROW_ON_DUPKEY_INDEX (namespace_plugin_rel(id)) */ INTO
namespace_plugin_rel (id,namespace_id,plugin_id, config, sort, enabled) VALUES
('1801816010882822149','649330b6-c2d7-4edc-be8e-8a54df9eb385','13',
'{"multiSelectorHandle":"1","multiRuleHandle":"0","threadpool":"shared"}', 310,
0);
-INSERT /*+ IGNORE_ROW_ON_DUPKEY_INDEX (namespace_plugin_rel(id)) */ INTO
namespace_plugin_rel (id,namespace_id,plugin_id, config, sort, enabled) VALUES
('1801816010882822150','649330b6-c2d7-4edc-be8e-8a54df9eb385','14', NULL, 80,
1);
-INSERT /*+ IGNORE_ROW_ON_DUPKEY_INDEX (namespace_plugin_rel(id)) */ INTO
namespace_plugin_rel (id,namespace_id,plugin_id, config, sort, enabled) VALUES
('1801816010882822151','649330b6-c2d7-4edc-be8e-8a54df9eb385','15',
'{"multiSelectorHandle":"1","multiRuleHandle":"0","threadpool":"shared"}', 310,
0);
-INSERT /*+ IGNORE_ROW_ON_DUPKEY_INDEX (namespace_plugin_rel(id)) */ INTO
namespace_plugin_rel (id,namespace_id,plugin_id, config, sort, enabled) VALUES
('1801816010882822152','649330b6-c2d7-4edc-be8e-8a54df9eb385','16', NULL, 110,
0);
-INSERT /*+ IGNORE_ROW_ON_DUPKEY_INDEX (namespace_plugin_rel(id)) */ INTO
namespace_plugin_rel (id,namespace_id,plugin_id, config, sort, enabled) VALUES
('1801816010882822153','649330b6-c2d7-4edc-be8e-8a54df9eb385','17',
'{"registerProtocol":"direct","registerAddress":"127.0.0.1:2181","corethreads":0,"threads":2147483647,"queues":0,"threadpool":"shared"}',
310, 0);
-INSERT /*+ IGNORE_ROW_ON_DUPKEY_INDEX (namespace_plugin_rel(id)) */ INTO
namespace_plugin_rel (id,namespace_id,plugin_id, config, sort, enabled) VALUES
('1801816010882822154','649330b6-c2d7-4edc-be8e-8a54df9eb385','18', NULL, 160,
0);
-INSERT /*+ IGNORE_ROW_ON_DUPKEY_INDEX (namespace_plugin_rel(id)) */ INTO
namespace_plugin_rel (id,namespace_id,plugin_id, config, sort, enabled) VALUES
('1801816010882822155','649330b6-c2d7-4edc-be8e-8a54df9eb385','19',
'{"secretKey":"key"}', 30, 0);
-INSERT /*+ IGNORE_ROW_ON_DUPKEY_INDEX (namespace_plugin_rel(id)) */ INTO
namespace_plugin_rel (id,namespace_id,plugin_id, config, sort, enabled) VALUES
('1801816010882822156','649330b6-c2d7-4edc-be8e-8a54df9eb385','2',
'{"model":"black"}', 50, 0);
-INSERT /*+ IGNORE_ROW_ON_DUPKEY_INDEX (namespace_plugin_rel(id)) */ INTO
namespace_plugin_rel (id,namespace_id,plugin_id, config, sort, enabled) VALUES
('1801816010882822157','649330b6-c2d7-4edc-be8e-8a54df9eb385','20', NULL, 120,
0);
-INSERT /*+ IGNORE_ROW_ON_DUPKEY_INDEX (namespace_plugin_rel(id)) */ INTO
namespace_plugin_rel (id,namespace_id,plugin_id, config, sort, enabled) VALUES
('1801816010882822158','649330b6-c2d7-4edc-be8e-8a54df9eb385','21', NULL, 40,
0);
-INSERT /*+ IGNORE_ROW_ON_DUPKEY_INDEX (namespace_plugin_rel(id)) */ INTO
namespace_plugin_rel (id,namespace_id,plugin_id, config, sort, enabled) VALUES
('1801816010882822159','649330b6-c2d7-4edc-be8e-8a54df9eb385','22', NULL, 70,
0);
-INSERT /*+ IGNORE_ROW_ON_DUPKEY_INDEX (namespace_plugin_rel(id)) */ INTO
namespace_plugin_rel (id,namespace_id,plugin_id, config, sort, enabled) VALUES
('1801816010882822160','649330b6-c2d7-4edc-be8e-8a54df9eb385','23', NULL, 220,
0);
-INSERT /*+ IGNORE_ROW_ON_DUPKEY_INDEX (namespace_plugin_rel(id)) */ INTO
namespace_plugin_rel (id,namespace_id,plugin_id, config, sort, enabled) VALUES
('1801816010882822161','649330b6-c2d7-4edc-be8e-8a54df9eb385','24', NULL, 100,
1);
-INSERT /*+ IGNORE_ROW_ON_DUPKEY_INDEX (namespace_plugin_rel(id)) */ INTO
namespace_plugin_rel (id,namespace_id,plugin_id, config, sort, enabled) VALUES
('1801816010882822162','649330b6-c2d7-4edc-be8e-8a54df9eb385','25', NULL, 410,
1);
-INSERT /*+ IGNORE_ROW_ON_DUPKEY_INDEX (namespace_plugin_rel(id)) */ INTO
namespace_plugin_rel (id,namespace_id,plugin_id, config, sort, enabled) VALUES
('1801816010882822163','649330b6-c2d7-4edc-be8e-8a54df9eb385','26',
'{"multiSelectorHandle":"1"}', 200, 1);
-INSERT /*+ IGNORE_ROW_ON_DUPKEY_INDEX (namespace_plugin_rel(id)) */ INTO
namespace_plugin_rel (id,namespace_id,plugin_id, config, sort, enabled) VALUES
('1801816010882822164','649330b6-c2d7-4edc-be8e-8a54df9eb385','27', NULL, 125,
1);
-INSERT /*+ IGNORE_ROW_ON_DUPKEY_INDEX (namespace_plugin_rel(id)) */ INTO
namespace_plugin_rel (id,namespace_id,plugin_id, config, sort, enabled) VALUES
('1801816010882822165','649330b6-c2d7-4edc-be8e-8a54df9eb385','28', '{"port":
9500,"bossGroupThreadCount": 1,"maxPayloadSize":
65536,"workerGroupThreadCount": 12,"userName": "shenyu","password":
"shenyu","isEncryptPassword": false,"encryptMode": "","leakDetectorLevel":
"DISABLED"}', 125, 0);
-INSERT /*+ IGNORE_ROW_ON_DUPKEY_INDEX (namespace_plugin_rel(id)) */ INTO
namespace_plugin_rel (id,namespace_id,plugin_id, config, sort, enabled) VALUES
('1801816010882822166','649330b6-c2d7-4edc-be8e-8a54df9eb385','29',
'{"topic":"shenyu-access-logging", "namesrvAddr":
"localhost:9876","producerGroup":"shenyu-plugin-logging-rocketmq"}', 170, 0);
-INSERT /*+ IGNORE_ROW_ON_DUPKEY_INDEX (namespace_plugin_rel(id)) */ INTO
namespace_plugin_rel (id,namespace_id,plugin_id, config, sort, enabled) VALUES
('1801816010882822167','649330b6-c2d7-4edc-be8e-8a54df9eb385','3', NULL, 90, 0);
-INSERT /*+ IGNORE_ROW_ON_DUPKEY_INDEX (namespace_plugin_rel(id)) */ INTO
namespace_plugin_rel (id,namespace_id,plugin_id, config, sort, enabled) VALUES
('1801816010882822168','649330b6-c2d7-4edc-be8e-8a54df9eb385','30',
'{"cacheType":"memory"}', 10, 0);
-INSERT /*+ IGNORE_ROW_ON_DUPKEY_INDEX (namespace_plugin_rel(id)) */ INTO
namespace_plugin_rel (id,namespace_id,plugin_id, config, sort, enabled) VALUES
('1801816010882822169','649330b6-c2d7-4edc-be8e-8a54df9eb385','31', NULL, 1, 0);
-INSERT /*+ IGNORE_ROW_ON_DUPKEY_INDEX (namespace_plugin_rel(id)) */ INTO
namespace_plugin_rel (id,namespace_id,plugin_id, config, sort, enabled) VALUES
('1801816010882822170','649330b6-c2d7-4edc-be8e-8a54df9eb385','32',
'{"host":"localhost", "port": "9200"}', 190, 0);
-INSERT /*+ IGNORE_ROW_ON_DUPKEY_INDEX (namespace_plugin_rel(id)) */ INTO
namespace_plugin_rel (id,namespace_id,plugin_id, config, sort, enabled) VALUES
('1801816010882822171','649330b6-c2d7-4edc-be8e-8a54df9eb385','33',
'{"host":"localhost", "port": "9092"}', 180, 0);
-INSERT /*+ IGNORE_ROW_ON_DUPKEY_INDEX (namespace_plugin_rel(id)) */ INTO
namespace_plugin_rel (id,namespace_id,plugin_id, config, sort, enabled) VALUES
('1801816010882822172','649330b6-c2d7-4edc-be8e-8a54df9eb385','34',
'{"projectName": "shenyu", "logStoreName": "shenyu-logstore", "topic":
"shenyu-topic"}', 175, 0);
-INSERT /*+ IGNORE_ROW_ON_DUPKEY_INDEX (namespace_plugin_rel(id)) */ INTO
namespace_plugin_rel (id,namespace_id,plugin_id, config, sort, enabled) VALUES
('1801816010882822173','649330b6-c2d7-4edc-be8e-8a54df9eb385','35',
'{"topic":"shenyu-access-logging", "serviceUrl": "pulsar://localhost:6650"}',
185, 0);
-INSERT /*+ IGNORE_ROW_ON_DUPKEY_INDEX (namespace_plugin_rel(id)) */ INTO
namespace_plugin_rel (id,namespace_id,plugin_id, config, sort, enabled) VALUES
('1801816010882822174','649330b6-c2d7-4edc-be8e-8a54df9eb385','36',
'{"endpoint": "ap-guangzhou.cls.tencentcs.com", "topic": "shenyu-topic"}', 176,
0);
-INSERT /*+ IGNORE_ROW_ON_DUPKEY_INDEX (namespace_plugin_rel(id)) */ INTO
namespace_plugin_rel (id,namespace_id,plugin_id, config, sort, enabled) VALUES
('1801816010882822175','649330b6-c2d7-4edc-be8e-8a54df9eb385','38',
'{"host":"127.0.0.1","port":"8123","databse":"shenyu-gateway","username":"foo","password":"bar"}',
195, 0);
-INSERT /*+ IGNORE_ROW_ON_DUPKEY_INDEX (namespace_plugin_rel(id)) */ INTO
namespace_plugin_rel (id,namespace_id,plugin_id, config, sort, enabled) VALUES
('1801816010882822176','649330b6-c2d7-4edc-be8e-8a54df9eb385','39',
'{"endpoint":"http://localhost:8000"}', 40, 0);
-INSERT /*+ IGNORE_ROW_ON_DUPKEY_INDEX (namespace_plugin_rel(id)) */ INTO
namespace_plugin_rel (id,namespace_id,plugin_id, config, sort, enabled) VALUES
('1801816010882822177','649330b6-c2d7-4edc-be8e-8a54df9eb385','4',
'{"master":"mymaster","mode":"standalone","url":"192.168.1.1:6379","password":"abc"}',
60, 0);
-INSERT /*+ IGNORE_ROW_ON_DUPKEY_INDEX (namespace_plugin_rel(id)) */ INTO
namespace_plugin_rel (id,namespace_id,plugin_id, config, sort, enabled) VALUES
('1801816010882822178','649330b6-c2d7-4edc-be8e-8a54df9eb385','40', NULL, 150,
0);
-INSERT /*+ IGNORE_ROW_ON_DUPKEY_INDEX (namespace_plugin_rel(id)) */ INTO
namespace_plugin_rel (id,namespace_id,plugin_id, config, sort, enabled) VALUES
('1801816010882822179','649330b6-c2d7-4edc-be8e-8a54df9eb385','42', NULL, 320,
1);
-INSERT /*+ IGNORE_ROW_ON_DUPKEY_INDEX (namespace_plugin_rel(id)) */ INTO
namespace_plugin_rel (id,namespace_id,plugin_id, config, sort, enabled) VALUES
('1801816010882822180','649330b6-c2d7-4edc-be8e-8a54df9eb385','43',
'{"totalSizeInBytes":"104857600","maxBlockMs":"0","ioThreadCount":"1","batchSizeThresholdInBytes":"524288","batchCountThreshold":"4096","lingerMs":"2000","retries":"100","baseRetryBackoffMs":"100","maxRetryBackoffMs":"100","enableLocalTest":"true","setGiveUpExtraLongSingl
[...]
-INSERT /*+ IGNORE_ROW_ON_DUPKEY_INDEX (namespace_plugin_rel(id)) */ INTO
namespace_plugin_rel (id,namespace_id,plugin_id, config, sort, enabled) VALUES
('1801816010882822181','649330b6-c2d7-4edc-be8e-8a54df9eb385','44',
'{"defaultHandleJson":"{\"authorization\":\"test:test123\"}"}', 150, 0);
-INSERT /*+ IGNORE_ROW_ON_DUPKEY_INDEX (namespace_plugin_rel(id)) */ INTO
namespace_plugin_rel (id,namespace_id,plugin_id, config, sort, enabled) VALUES
('1801816010882822182','649330b6-c2d7-4edc-be8e-8a54df9eb385','45',
'{"host":"127.0.0.1","port":5672,"password":"admin","username":"admin","exchangeName":"exchange.logging.plugin","queueName":"queue.logging.plugin","routingKey":"topic.logging","virtualHost":"/","exchangeType":"direct","durable":"true","exclusive":"false","autoDelete":"fal
[...]
-INSERT /*+ IGNORE_ROW_ON_DUPKEY_INDEX (namespace_plugin_rel(id)) */ INTO
namespace_plugin_rel (id,namespace_id,plugin_id, config, sort, enabled) VALUES
('1801816010882822183','649330b6-c2d7-4edc-be8e-8a54df9eb385','5',
'{"multiSelectorHandle":"1","multiRuleHandle":"0"}', 200, 1);
-INSERT /*+ IGNORE_ROW_ON_DUPKEY_INDEX (namespace_plugin_rel(id)) */ INTO
namespace_plugin_rel (id,namespace_id,plugin_id, config, sort, enabled) VALUES
('1801816010882822184','649330b6-c2d7-4edc-be8e-8a54df9eb385','6',
'{"register":"zookeeper://localhost:2181","multiSelectorHandle":"1","threadpool":"shared","corethreads":0,"threads":2147483647,"queues":0}',
310, 0);
-INSERT /*+ IGNORE_ROW_ON_DUPKEY_INDEX (namespace_plugin_rel(id)) */ INTO
namespace_plugin_rel (id,namespace_id,plugin_id, config, sort, enabled) VALUES
('1801816010882822185','649330b6-c2d7-4edc-be8e-8a54df9eb385','8',
'{"enabled":false,"registerType":"eureka","serverLists":"http://localhost:8761/eureka","props":{}}',
200, 0);
-INSERT /*+ IGNORE_ROW_ON_DUPKEY_INDEX (namespace_plugin_rel(id)) */ INTO
namespace_plugin_rel (id,namespace_id,plugin_id, config, sort, enabled) VALUES
('1801816010882822186','649330b6-c2d7-4edc-be8e-8a54df9eb385','9', NULL, 130,
0);
-
-
INSERT /*+ IGNORE_ROW_ON_DUPKEY_INDEX("resource" (id)) */ INTO "resource"
(id, parent_id, title, name, url, component, resource_type, sort, icon,
is_leaf, is_route, perms, status)VALUES ('1792749362445840479',
'1357956838021890048', 'SHENYU.MENU.SYSTEM.MANAGMENT.NAMESPACEPLUGIN',
'namespacePlugin', '/config/namespacePlugin', 'namespacePlugin', 1, 2, 'build',
0, 0, '', 1);
INSERT /*+ IGNORE_ROW_ON_DUPKEY_INDEX("resource" (id)) */ INTO "resource"
(id, parent_id, title, name, url, component, resource_type, sort, icon,
is_leaf, is_route, perms, status)VALUES ('1792749362445840480',
'1792749362445840479', 'SHENYU.BUTTON.SYSTEM.LIST', '', '', '', 2, 0, '', 1, 0,
'system:namespacePlugin:list', 1);
@@ -287,21 +243,21 @@ COMMENT ON COLUMN proxy_selector.namespace_id IS
'namespaceId';
ALTER TABLE alert_receiver ADD namespace_id VARCHAR2(50) NOT NULL;
COMMENT ON COLUMN alert_receiver.namespace_id IS 'namespaceId';
-UPDATE selector SET namespace_id = '649330b6-c2d7-4edc-be8e-8a54df9eb385'
WHERE namespace_id IS NULL;
+UPDATE selector SET namespace_id = '649330b6-c2d7-4edc-be8e-8a54df9eb385'
WHERE namespace_id IS NULL OR LENGTH(namespace_id) = 0;
-UPDATE rule SET namespace_id = '649330b6-c2d7-4edc-be8e-8a54df9eb385' WHERE
namespace_id IS NULL;
+UPDATE rule SET namespace_id = '649330b6-c2d7-4edc-be8e-8a54df9eb385' WHERE
namespace_id IS NULL OR LENGTH(namespace_id) = 0;
-UPDATE meta_data SET namespace_id = '649330b6-c2d7-4edc-be8e-8a54df9eb385'
WHERE namespace_id IS NULL;
+UPDATE meta_data SET namespace_id = '649330b6-c2d7-4edc-be8e-8a54df9eb385'
WHERE namespace_id IS NULL OR LENGTH(namespace_id) = 0;
-UPDATE app_auth SET namespace_id = '649330b6-c2d7-4edc-be8e-8a54df9eb385'
WHERE namespace_id IS NULL;
+UPDATE app_auth SET namespace_id = '649330b6-c2d7-4edc-be8e-8a54df9eb385'
WHERE namespace_id IS NULL OR LENGTH(namespace_id) = 0;
-UPDATE discovery SET namespace_id = '649330b6-c2d7-4edc-be8e-8a54df9eb385'
WHERE namespace_id IS NULL;
+UPDATE discovery SET namespace_id = '649330b6-c2d7-4edc-be8e-8a54df9eb385'
WHERE namespace_id IS NULL OR LENGTH(namespace_id) = 0;
-UPDATE discovery_upstream SET namespace_id =
'649330b6-c2d7-4edc-be8e-8a54df9eb385' WHERE namespace_id IS NULL;
+UPDATE discovery_upstream SET namespace_id =
'649330b6-c2d7-4edc-be8e-8a54df9eb385' WHERE namespace_id IS NULL OR
LENGTH(namespace_id) = 0;
-UPDATE proxy_selector SET namespace_id =
'649330b6-c2d7-4edc-be8e-8a54df9eb385' WHERE namespace_id IS NULL;
+UPDATE proxy_selector SET namespace_id =
'649330b6-c2d7-4edc-be8e-8a54df9eb385' WHERE namespace_id IS NULL OR
LENGTH(namespace_id) = 0;
-UPDATE alert_receiver SET namespace_id =
'649330b6-c2d7-4edc-be8e-8a54df9eb385' WHERE namespace_id IS NULL;
+UPDATE alert_receiver SET namespace_id =
'649330b6-c2d7-4edc-be8e-8a54df9eb385' WHERE namespace_id IS NULL OR
LENGTH(namespace_id) = 0;
-- ----------------------------
-- Table structure for scale
@@ -418,3 +374,44 @@ comment on column NAMESPACE_USER_REL.date_created
comment on column NAMESPACE_USER_REL.date_updated
is 'update time';
+INSERT INTO namespace_plugin_rel (
+ id,
+ namespace_id,
+ plugin_id,
+ config,
+ sort,
+ enabled,
+ date_created,
+ date_updated
+)
+SELECT
+ CONCAT(
+ FLOOR((CAST(SYSTIMESTAMP AS DATE) - TO_DATE('1970-01-01',
'YYYY-MM-DD')) * 86400) * 1000,
+ LPAD(TO_CHAR(FLOOR(DBMS_RANDOM.VALUE * 1000000)), 6, '0')
+ ),
+ '649330b6-c2d7-4edc-be8e-8a54df9eb385',
+ id,
+ config,
+ sort,
+ enabled,
+ date_created,
+ date_updated
+FROM plugin;
+
+INSERT INTO namespace_user_rel (
+ id,
+ namespace_id,
+ user_id,
+ date_created,
+ date_updated
+)
+SELECT
+ CONCAT(
+ FLOOR((CAST(SYSTIMESTAMP AS DATE) - TO_DATE('1970-01-01',
'YYYY-MM-DD')) * 86400) * 1000,
+ LPAD(TO_CHAR(FLOOR(DBMS_RANDOM.VALUE * 1000000)), 6, '0')
+ ),
+ '649330b6-c2d7-4edc-be8e-8a54df9eb385',
+ id,
+ date_created,
+ date_updated
+FROM dashboard_user;
diff --git a/db/upgrade/2.6.1-upgrade-2.7.0-pg.sql
b/db/upgrade/2.6.1-upgrade-2.7.0-pg.sql
index 71c2ca5c3a..5f841b95ea 100755
--- a/db/upgrade/2.6.1-upgrade-2.7.0-pg.sql
+++ b/db/upgrade/2.6.1-upgrade-2.7.0-pg.sql
@@ -134,49 +134,6 @@ COMMENT ON COLUMN
"public"."namespace_plugin_rel"."enabled" IS 'Whether the plug
COMMENT ON COLUMN "public"."namespace_plugin_rel"."date_created" IS 'Creation
time';
COMMENT ON COLUMN "public"."namespace_plugin_rel"."date_updated" IS 'Update
time';
-INSERT INTO "public"."namespace_plugin_rel" VALUES
('1801816010882822145','649330b6-c2d7-4edc-be8e-8a54df9eb385','1', NULL, 20, 0,
'2022-05-25 18:02:53.000', '2022-05-25 18:02:53.000');
-INSERT INTO "public"."namespace_plugin_rel" VALUES
('1801816010882822146','649330b6-c2d7-4edc-be8e-8a54df9eb385','10', NULL, 140,
0, '2022-05-25 18:02:53.000', '2022-05-25 18:02:53.000');
-INSERT INTO "public"."namespace_plugin_rel" VALUES
('1801816010882822147','649330b6-c2d7-4edc-be8e-8a54df9eb385','11',
'{"protocol":"zookeeper","register":"127.0.0.1:2181","threadpool":"shared"}',
310, 0, '2022-05-25 18:02:53.000', '2022-05-25 18:02:53.000');
-INSERT INTO "public"."namespace_plugin_rel" VALUES
('1801816010882822148','649330b6-c2d7-4edc-be8e-8a54df9eb385','12', NULL, 310,
0, '2022-05-25 18:02:53.000', '2022-05-25 18:02:53.000');
-INSERT INTO "public"."namespace_plugin_rel" VALUES
('1801816010882822149','649330b6-c2d7-4edc-be8e-8a54df9eb385','13',
'{"multiSelectorHandle":"1","multiRuleHandle":"0","threadpool":"shared"}', 310,
0, '2022-05-25 18:02:53.000', '2022-05-25 18:02:53.000');
-INSERT INTO "public"."namespace_plugin_rel" VALUES
('1801816010882822150','649330b6-c2d7-4edc-be8e-8a54df9eb385','14', NULL, 80,
1, '2022-05-25 18:02:53.000', '2022-05-25 18:02:53.000');
-INSERT INTO "public"."namespace_plugin_rel" VALUES
('1801816010882822151','649330b6-c2d7-4edc-be8e-8a54df9eb385','15',
'{"multiSelectorHandle":"1","multiRuleHandle":"0","threadpool":"shared"}', 310,
0, '2022-05-25 18:02:53.000', '2022-05-25 18:02:53.000');
-INSERT INTO "public"."namespace_plugin_rel" VALUES
('1801816010882822152','649330b6-c2d7-4edc-be8e-8a54df9eb385','16', NULL, 110,
0, '2022-05-25 18:02:53.000', '2022-05-25 18:02:53.000');
-INSERT INTO "public"."namespace_plugin_rel" VALUES
('1801816010882822153','649330b6-c2d7-4edc-be8e-8a54df9eb385','17',
'{"registerProtocol":"direct","registerAddress":"127.0.0.1:2181","corethreads":0,"threads":2147483647,"queues":0,"threadpool":"shared"}',
310, 0, '2022-05-25 18:02:53.000', '2022-05-25 18:02:53.000');
-INSERT INTO "public"."namespace_plugin_rel" VALUES
('1801816010882822154','649330b6-c2d7-4edc-be8e-8a54df9eb385','18', NULL, 160,
0, '2022-05-25 18:02:53.000', '2022-05-25 18:02:53.000');
-INSERT INTO "public"."namespace_plugin_rel" VALUES
('1801816010882822155','649330b6-c2d7-4edc-be8e-8a54df9eb385','19',
'{"secretKey":"key"}', 30, 0, '2022-05-25 18:02:53.000', '2022-05-25
18:02:53.000');
-INSERT INTO "public"."namespace_plugin_rel" VALUES
('1801816010882822156','649330b6-c2d7-4edc-be8e-8a54df9eb385','2',
'{"model":"black"}', 50, 0, '2022-05-25 18:02:53.000', '2022-05-25
18:02:53.000');
-INSERT INTO "public"."namespace_plugin_rel" VALUES
('1801816010882822157','649330b6-c2d7-4edc-be8e-8a54df9eb385','20', NULL, 120,
0, '2022-05-25 18:02:53.000', '2022-05-25 18:02:53.000');
-INSERT INTO "public"."namespace_plugin_rel" VALUES
('1801816010882822158','649330b6-c2d7-4edc-be8e-8a54df9eb385','21', NULL, 40,
0, '2022-05-25 18:02:53.000', '2022-05-25 18:02:53.000');
-INSERT INTO "public"."namespace_plugin_rel" VALUES
('1801816010882822159','649330b6-c2d7-4edc-be8e-8a54df9eb385','22', NULL, 70,
0, '2022-05-25 18:02:53.000', '2022-05-25 18:02:53.000');
-INSERT INTO "public"."namespace_plugin_rel" VALUES
('1801816010882822160','649330b6-c2d7-4edc-be8e-8a54df9eb385','23', NULL, 220,
0, '2022-05-25 18:02:53.000', '2022-05-25 18:02:53.000');
-INSERT INTO "public"."namespace_plugin_rel" VALUES
('1801816010882822161','649330b6-c2d7-4edc-be8e-8a54df9eb385','24', NULL, 100,
1, '2022-05-25 18:02:53.000', '2022-05-25 18:02:53.000');
-INSERT INTO "public"."namespace_plugin_rel" VALUES
('1801816010882822162','649330b6-c2d7-4edc-be8e-8a54df9eb385','25', NULL, 410,
1, '2022-05-25 18:02:53.000', '2022-05-25 18:02:53.000');
-INSERT INTO "public"."namespace_plugin_rel" VALUES
('1801816010882822163','649330b6-c2d7-4edc-be8e-8a54df9eb385','26',
'{"multiSelectorHandle":"1"}', 200, 1, '2022-05-25 18:02:53.000', '2022-05-25
18:02:53.000');
-INSERT INTO "public"."namespace_plugin_rel" VALUES
('1801816010882822164','649330b6-c2d7-4edc-be8e-8a54df9eb385','27', NULL, 125,
1, '2022-05-25 18:02:53.000', '2022-05-25 18:02:53.000');
-INSERT INTO "public"."namespace_plugin_rel" VALUES
('1801816010882822165','649330b6-c2d7-4edc-be8e-8a54df9eb385','28', '{"port":
9500,"bossGroupThreadCount": 1,"maxPayloadSize":
65536,"workerGroupThreadCount": 12,"userName": "shenyu","password":
"shenyu","isEncryptPassword": false,"encryptMode": "","leakDetectorLevel":
"DISABLED"}', 125, 0, '2022-05-25 18:02:53.000', '2022-05-25 18:02:53.000');
-INSERT INTO "public"."namespace_plugin_rel" VALUES
('1801816010882822166','649330b6-c2d7-4edc-be8e-8a54df9eb385','29',
'{"topic":"shenyu-access-logging", "namesrvAddr":
"localhost:9876","producerGroup":"shenyu-plugin-logging-rocketmq"}', 170, 0,
'2022-05-25 18:02:53.000', '2022-05-25 18:02:53.000');
-INSERT INTO "public"."namespace_plugin_rel" VALUES
('1801816010882822167','649330b6-c2d7-4edc-be8e-8a54df9eb385','3', NULL, 90, 0,
'2022-05-25 18:02:53.000', '2022-05-25 18:02:53.000');
-INSERT INTO "public"."namespace_plugin_rel" VALUES
('1801816010882822168','649330b6-c2d7-4edc-be8e-8a54df9eb385','30',
'{"cacheType":"memory"}', 10, 0, '2022-05-25 18:02:53.000', '2022-05-25
18:02:53.000');
-INSERT INTO "public"."namespace_plugin_rel" VALUES
('1801816010882822169','649330b6-c2d7-4edc-be8e-8a54df9eb385','31', NULL, 1, 0,
'2022-06-16 14:40:35.000', '2022-06-16 14:40:55.000');
-INSERT INTO "public"."namespace_plugin_rel" VALUES
('1801816010882822170','649330b6-c2d7-4edc-be8e-8a54df9eb385','32',
'{"host":"localhost", "port": "9200"}', 190, 0, '2022-06-19 22:00:00.000',
'2022-06-19 22:00:00.000');
-INSERT INTO "public"."namespace_plugin_rel" VALUES
('1801816010882822171','649330b6-c2d7-4edc-be8e-8a54df9eb385','33',
'{"host":"localhost", "port": "9092"}', 180, 0, '2022-07-04 22:00:00.000',
'2022-07-02 22:00:00.000');
-INSERT INTO "public"."namespace_plugin_rel" VALUES
('1801816010882822172','649330b6-c2d7-4edc-be8e-8a54df9eb385','34',
'{"projectName": "shenyu", "logStoreName": "shenyu-logstore", "topic":
"shenyu-topic"}', 175, 0, '2022-06-30 21:00:00.000', '2022-06-30 21:00:00.000');
-INSERT INTO "public"."namespace_plugin_rel" VALUES
('1801816010882822173','649330b6-c2d7-4edc-be8e-8a54df9eb385','35',
'{"topic":"shenyu-access-logging", "serviceUrl": "pulsar://localhost:6650"}',
185, 0, '2022-06-30 21:00:00.000', '2022-06-30 21:00:00.000');
-INSERT INTO "public"."namespace_plugin_rel" VALUES
('1801816010882822174','649330b6-c2d7-4edc-be8e-8a54df9eb385','36',
'{"endpoint": "ap-guangzhou.cls.tencentcs.com", "topic": "shenyu-topic"}', 176,
0, '2022-06-30 21:00:00.000', '2022-06-30 21:00:00.000');
-INSERT INTO "public"."namespace_plugin_rel" VALUES
('1801816010882822175','649330b6-c2d7-4edc-be8e-8a54df9eb385','38',
'{"host":"127.0.0.1","port":"8123","databse":"shenyu-gateway","username":"foo","password":"bar"}',
195, 0, '2022-06-30 21:00:00.000', '2022-06-30 21:00:00.000');
-INSERT INTO "public"."namespace_plugin_rel" VALUES
('1801816010882822176','649330b6-c2d7-4edc-be8e-8a54df9eb385','39',
'{"endpoint":"http://localhost:8000"}', 40, 0, '2022-09-11 12:00:00.000',
'2022-09-11 12:00:00.000');
-INSERT INTO "public"."namespace_plugin_rel" VALUES
('1801816010882822177','649330b6-c2d7-4edc-be8e-8a54df9eb385','4',
'{"master":"mymaster","mode":"standalone","url":"192.168.1.1:6379","password":"abc"}',
60, 0, '2022-05-25 18:02:53.000', '2022-05-25 18:02:53.000');
-INSERT INTO "public"."namespace_plugin_rel" VALUES
('1801816010882822178','649330b6-c2d7-4edc-be8e-8a54df9eb385','40', NULL, 150,
0, '2022-07-24 19:00:00.000', '2022-07-24 19:00:00.000');
-INSERT INTO "public"."namespace_plugin_rel" VALUES
('1801816010882822179','649330b6-c2d7-4edc-be8e-8a54df9eb385','42', NULL, 320,
1, '2023-05-30 18:02:53.000', '2022-05-30 18:02:53.000');
-INSERT INTO "public"."namespace_plugin_rel" VALUES
('1801816010882822180','649330b6-c2d7-4edc-be8e-8a54df9eb385','43',
'{"totalSizeInBytes":"104857600","maxBlockMs":"0","ioThreadCount":"1","batchSizeThresholdInBytes":"524288","batchCountThreshold":"4096","lingerMs":"2000","retries":"100","baseRetryBackoffMs":"100","maxRetryBackoffMs":"100","enableLocalTest":"true","setGiveUpExtraLongSingleLog":"false"}',
177, 0, '2023-07-05 14:03:53.686', '2023-07-06 12:42:07.234');
-INSERT INTO "public"."namespace_plugin_rel" VALUES
('1801816010882822181','649330b6-c2d7-4edc-be8e-8a54df9eb385','44',
'{"defaultHandleJson":"{\"authorization\":\"test:test123\"}"}', 150, 0,
'2022-07-24 19:00:00.000', '2022-07-24 19:00:00.000');
-INSERT INTO "public"."namespace_plugin_rel" VALUES
('1801816010882822182','649330b6-c2d7-4edc-be8e-8a54df9eb385','45',
'{"host":"127.0.0.1","port":5672,"password":"admin","username":"admin","exchangeName":"exchange.logging.plugin","queueName":"queue.logging.plugin","routingKey":"topic.logging","virtualHost":"/","exchangeType":"direct","durable":"true","exclusive":"false","autoDelete":"false"}',
171, 0, '2023-11-06 15:49:56.454', '2023-11-10 10:40:58.447');
-INSERT INTO "public"."namespace_plugin_rel" VALUES
('1801816010882822183','649330b6-c2d7-4edc-be8e-8a54df9eb385','5',
'{"multiSelectorHandle":"1","multiRuleHandle":"0"}', 200, 1, '2022-05-25
18:02:53.000', '2022-05-25 18:02:53.000');
-INSERT INTO "public"."namespace_plugin_rel" VALUES
('1801816010882822184','649330b6-c2d7-4edc-be8e-8a54df9eb385','6',
'{"register":"zookeeper://localhost:2181","multiSelectorHandle":"1","threadpool":"shared","corethreads":0,"threads":2147483647,"queues":0}',
310, 0, '2022-05-25 18:02:53.000', '2022-05-25 18:02:53.000');
-INSERT INTO "public"."namespace_plugin_rel" VALUES
('1801816010882822185','649330b6-c2d7-4edc-be8e-8a54df9eb385','8',
'{"enabled":false,"registerType":"eureka","serverLists":"http://localhost:8761/eureka","props":{}}',
200, 0, '2022-05-25 18:02:53.000', '2022-05-25 18:02:53.000');
-INSERT INTO "public"."namespace_plugin_rel" VALUES
('1801816010882822186','649330b6-c2d7-4edc-be8e-8a54df9eb385','9', NULL, 130,
0, '2022-05-25 18:02:53.000', '2022-05-25 18:02:53.000');
-
INSERT INTO "public"."resource" VALUES ('1792749362445840479',
'1357956838021890048', 'SHENYU.MENU.SYSTEM.MANAGMENT.NAMESPACEPLUGIN',
'namespacePlugin', '/config/namespacePlugin', 'namespacePlugin', 1, 2, 'build',
0, 0, '', 1, '2024-06-25 18:02:53.000', '2024-06-25 18:02:53.000');
INSERT INTO "public"."resource" VALUES ('1792749362445840480',
'1792749362445840479', 'SHENYU.BUTTON.SYSTEM.LIST', '', '', '', 2, 0, '', 1, 0,
'system:namespacePlugin:list', 1, '2024-06-25 18:02:53.000', '2024-06-25
18:02:53.000');
@@ -238,21 +195,21 @@ COMMENT ON COLUMN
"public"."proxy_selector"."namespace_id" IS 'namespaceId';
ALTER TABLE "public"."alert_receiver" ADD COLUMN namespace_id VARCHAR(50) NOT
NULL;
COMMENT ON COLUMN "public"."alert_receiver"."namespace_id" IS 'namespaceId';
-UPDATE "public"."selector" SET namespace_id =
'649330b6-c2d7-4edc-be8e-8a54df9eb385' WHERE namespace_id IS NULL;
+UPDATE "public"."selector" SET namespace_id =
'649330b6-c2d7-4edc-be8e-8a54df9eb385' WHERE namespace_id IS NULL OR
LENGTH(namespace_id) = 0;
-UPDATE "public"."rule" SET namespace_id =
'649330b6-c2d7-4edc-be8e-8a54df9eb385' WHERE namespace_id IS NULL;
+UPDATE "public"."rule" SET namespace_id =
'649330b6-c2d7-4edc-be8e-8a54df9eb385' WHERE namespace_id IS NULL OR
LENGTH(namespace_id) = 0;
-UPDATE "public"."meta_data" SET namespace_id =
'649330b6-c2d7-4edc-be8e-8a54df9eb385' WHERE namespace_id IS NULL;
+UPDATE "public"."meta_data" SET namespace_id =
'649330b6-c2d7-4edc-be8e-8a54df9eb385' WHERE namespace_id IS NULL OR
LENGTH(namespace_id) = 0;
-UPDATE "public"."app_auth" SET namespace_id =
'649330b6-c2d7-4edc-be8e-8a54df9eb385' WHERE namespace_id IS NULL;
+UPDATE "public"."app_auth" SET namespace_id =
'649330b6-c2d7-4edc-be8e-8a54df9eb385' WHERE namespace_id IS NULL OR
LENGTH(namespace_id) = 0;
-UPDATE "public"."discovery" SET namespace_id =
'649330b6-c2d7-4edc-be8e-8a54df9eb385' WHERE namespace_id IS NULL;
+UPDATE "public"."discovery" SET namespace_id =
'649330b6-c2d7-4edc-be8e-8a54df9eb385' WHERE namespace_id IS NULL OR
LENGTH(namespace_id) = 0;
-UPDATE "public"."discovery_upstream" SET namespace_id =
'649330b6-c2d7-4edc-be8e-8a54df9eb385' WHERE namespace_id IS NULL;
+UPDATE "public"."discovery_upstream" SET namespace_id =
'649330b6-c2d7-4edc-be8e-8a54df9eb385' WHERE namespace_id IS NULL OR
LENGTH(namespace_id) = 0;
-UPDATE "public"."proxy_selector" SET namespace_id =
'649330b6-c2d7-4edc-be8e-8a54df9eb385' WHERE namespace_id IS NULL;
+UPDATE "public"."proxy_selector" SET namespace_id =
'649330b6-c2d7-4edc-be8e-8a54df9eb385' WHERE namespace_id IS NULL OR
LENGTH(namespace_id) = 0;
-UPDATE "public"."alert_receiver" SET namespace_id =
'649330b6-c2d7-4edc-be8e-8a54df9eb385' WHERE namespace_id IS NULL;
+UPDATE "public"."alert_receiver" SET namespace_id =
'649330b6-c2d7-4edc-be8e-8a54df9eb385' WHERE namespace_id IS NULL OR
LENGTH(namespace_id) = 0;
-- ----------------------------
-- Table structure for scale
@@ -340,3 +297,42 @@ COMMENT ON COLUMN "public"."namespace_user_rel"."user_id"
IS 'user_id';
COMMENT ON COLUMN "public"."namespace_user_rel"."date_created" IS 'create
time';
COMMENT ON COLUMN "public"."namespace_user_rel"."date_updated" IS 'update
time';
+INSERT INTO "public"."namespace_plugin_rel" (
+ id,
+ namespace_id,
+ plugin_id,
+ config,
+ sort,
+ enabled,
+ date_created,
+ date_updated
+)
+SELECT
+ CONCAT(EXTRACT(EPOCH FROM clock_timestamp()) * 1000::BIGINT,
LPAD((RANDOM() * 1000000)::BIGINT::TEXT, 6, '0')),
+ '649330b6-c2d7-4edc-be8e-8a54df9eb385',
+ id,
+ config,
+ sort,
+ enabled,
+ date_created,
+ date_updated
+FROM "public"."plugin";
+
+
+INSERT INTO "public"."namespace_user_rel" (
+ id,
+ namespace_id,
+ user_id,
+ date_created,
+ date_updated
+)
+SELECT
+ CONCAT(
+ FLOOR(EXTRACT(EPOCH FROM NOW()) * 1000),
+ LPAD(CAST(FLOOR(RANDOM() * 1000000) AS TEXT), 6, '0')
+ ),
+ '649330b6-c2d7-4edc-be8e-8a54df9eb385',
+ id,
+ date_created,
+ date_updated
+FROM dashboard_user;
\ No newline at end of file
