[incubator-streampark] branch dev updated: update upgrade sql according to data-h2.sql (#2561)

[be...@apache.org]

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

benjobs pushed a commit to branch dev
in repository https://gitbox.apache.org/repos/asf/incubator-streampark.git


The following commit(s) were added to refs/heads/dev by this push:
     new f7c2a93c2 update upgrade sql according to data-h2.sql (#2561)
f7c2a93c2 is described below

commit f7c2a93c2fd3bad6447178eea3f9136909f313ce
Author: totoro <zh...@foxmail.com>
AuthorDate: Mon Apr 3 19:43:22 2023 +0800

    update upgrade sql according to data-h2.sql (#2561)
    
    Co-authored-by: zhoulii <zh...@hikvision.com.cn>
---
 .../main/assembly/script/upgrade/mysql/2.1.0.sql   | 36 ++++++++++++++++++++++
 .../main/assembly/script/upgrade/pgsql/2.1.0.sql   | 36 ++++++++++++++++++++++
 2 files changed, 72 insertions(+)

diff --git a/streampark-console/streampark-console-service/src/main/assembly/script/upgrade/mysql/2.1.0.sql b/streampark-console/streampark-console-service/src/main/assembly/script/upgrade/mysql/2.1.0.sql
index 15bab3f2a..faf1d70eb 100644
--- a/streampark-console/streampark-console-service/src/main/assembly/script/upgrade/mysql/2.1.0.sql
+++ b/streampark-console/streampark-console-service/src/main/assembly/script/upgrade/mysql/2.1.0.sql
@@ -101,3 +101,39 @@ set foreign_key_checks = 1;
 -- Issue-2513 Start --
 drop table if exists "public"."t_flink_tutorial";
 -- Issue-2513 End --
+
+-- PR-2545: Split the setting menu
+
+-- delete the old setting menu and associated permissions
+delete from `t_menu` where menu_id in (100033,100034,100040,100041,100068,100076,100077,100078);
+
+-- create setting menu and associated sub menus
+insert into `t_menu` values (100080, 0, 'menu.setting', '/setting', 'PageView', null, 'setting', '0', 1, 5, now(), now());
+insert into `t_menu` values (100081, 100080, 'setting.system', '/setting/system', 'setting/System/index', null, 'team', '0', 1, 1, now(), now());
+insert into `t_menu` values (100082, 100080, 'setting.alarm', '/setting/alarm', 'setting/Alarm/index', null, 'user', '0', 1, 2, now(), now());
+insert into `t_menu` values (100083, 100080, 'setting.flinkHome', '/setting/flinkHome', 'setting/FlinkHome/index', null, 'smile', '0', 1, 3, now(), now());
+insert into `t_menu` values (100084, 100080, 'setting.flinkCluster', '/setting/flinkCluster', 'setting/FlinkCluster/index', 'menu:view', 'cluster', '0', 1, 4, now(), now());
+insert into `t_menu` values (100085, 100080, 'setting.externalLink', '/setting/externalLink', 'setting/ExternalLink/index', 'menu:view', 'link', '0', 1, 5, now(), now());
+insert into `t_menu` values (100086, 100080, 'setting.yarnQueue', '/setting/yarnQueue', 'setting/YarnQueue/index', 'menu:view', 'bars', '0', 1, 6, now(), now());
+
+-- create permissions for setting.system menu
+insert into `t_menu` values (100087, 100081, 'view', null, null, 'setting:view', null, '1', 1, null, now(), now());
+insert into `t_menu` values (100088, 100081, 'setting update', null, null, 'setting:update', null, '1', 1, null, now(), now());
+
+-- create permissions for setting.flinkCluster menu
+insert into `t_menu` values (100089, 100084, 'add cluster', '/setting/add_cluster', 'setting/FlinkCluster/AddCluster', 'cluster:create', '', '0', 0, null, now(), now());
+insert into `t_menu` values (100090, 100084, 'edit cluster', '/setting/edit_cluster', 'setting/FlinkCluster/EditCluster', 'cluster:update', '', '0', 0, null, now(), now());
+
+-- create permissions for setting.yarnQueue menu
+insert into `t_menu` values (100091, 100086, 'add yarn queue', null, null, 'yarnQueue:create', '', '1', 0, null, now(), now());
+insert into `t_menu` values (100092, 100086, 'edit yarn queue', null, null, 'yarnQueue:update', '', '1', 0, null, now(), now());
+insert into `t_menu` values (100093, 100086, 'delete yarn queue', null, null, 'yarnQueue:delete', '', '1', 0, null, now(), now());
+
+-- set permissions for role 100002(team admin)
+insert into `t_role_menu` values (null, 100002, 100080);
+insert into `t_role_menu` values (null, 100002, 100081);
+insert into `t_role_menu` values (null, 100002, 100082);
+insert into `t_role_menu` values (null, 100002, 100083);
+insert into `t_role_menu` values (null, 100002, 100084);
+insert into `t_role_menu` values (null, 100002, 100085);
+insert into `t_role_menu` values (null, 100002, 100086);
diff --git a/streampark-console/streampark-console-service/src/main/assembly/script/upgrade/pgsql/2.1.0.sql b/streampark-console/streampark-console-service/src/main/assembly/script/upgrade/pgsql/2.1.0.sql
index bfb649d29..aff68882b 100644
--- a/streampark-console/streampark-console-service/src/main/assembly/script/upgrade/pgsql/2.1.0.sql
+++ b/streampark-console/streampark-console-service/src/main/assembly/script/upgrade/pgsql/2.1.0.sql
@@ -117,3 +117,39 @@ ALTER TABLE public.t_flink_app ALTER COLUMN state TYPE int4 USING state::int4;
 -- Issue-2513 Start --
 drop table if exists "public"."t_flink_tutorial";
 -- Issue-2513 End --
+
+-- PR-2545: Split the setting menu
+
+-- delete the old setting menu and associated permissions
+delete from "public"."t_menu" where "menu_id" in (100033,100034,100040,100041,100068,100076,100077,100078);
+
+-- create setting menu and associated sub menus
+insert into "public"."t_menu" values (100080, 0, 'menu.setting', '/setting', 'PageView', null, 'setting', '0', 1, 5, now(), now());
+insert into "public"."t_menu" values (100081, 100080, 'setting.system', '/setting/system', 'setting/System/index', null, 'team', '0', 1, 1, now(), now());
+insert into "public"."t_menu" values (100082, 100080, 'setting.alarm', '/setting/alarm', 'setting/Alarm/index', null, 'user', '0', 1, 2, now(), now());
+insert into "public"."t_menu" values (100083, 100080, 'setting.flinkHome', '/setting/flinkHome', 'setting/FlinkHome/index', null, 'smile', '0', 1, 3, now(), now());
+insert into "public"."t_menu" values (100084, 100080, 'setting.flinkCluster', '/setting/flinkCluster', 'setting/FlinkCluster/index', 'menu:view', 'cluster', '0', 1, 4, now(), now());
+insert into "public"."t_menu" values (100085, 100080, 'setting.externalLink', '/setting/externalLink', 'setting/ExternalLink/index', 'menu:view', 'link', '0', 1, 5, now(), now());
+insert into "public"."t_menu" values (100086, 100080, 'setting.yarnQueue', '/setting/yarnQueue', 'setting/YarnQueue/index', 'menu:view', 'bars', '0', 1, 6, now(), now());
+
+-- create permissions for setting.system menu
+insert into "public"."t_menu" values (100087, 100081, 'view', null, null, 'setting:view', null, '1', 1, null, now(), now());
+insert into "public"."t_menu" values (100088, 100081, 'setting update', null, null, 'setting:update', null, '1', 1, null, now(), now());
+
+-- create permissions for setting.flinkCluster menu
+insert into "public"."t_menu" values (100089, 100084, 'add cluster', '/setting/add_cluster', 'setting/FlinkCluster/AddCluster', 'cluster:create', '', '0', 0, null, now(), now());
+insert into "public"."t_menu" values (100090, 100084, 'edit cluster', '/setting/edit_cluster', 'setting/FlinkCluster/EditCluster', 'cluster:update', '', '0', 0, null, now(), now());
+
+-- create permissions for setting.yarnQueue menu
+insert into "public"."t_menu" values (100091, 100086, 'add yarn queue', null, null, 'yarnQueue:create', '', '1', 0, null, now(), now());
+insert into "public"."t_menu" values (100092, 100086, 'edit yarn queue', null, null, 'yarnQueue:update', '', '1', 0, null, now(), now());
+insert into "public"."t_menu" values (100093, 100086, 'delete yarn queue', null, null, 'yarnQueue:delete', '', '1', 0, null, now(), now());
+
+-- set permissions for role 100002(team admin)
+insert into "public"."t_role_menu" values (null, 100002, 100080);
+insert into "public"."t_role_menu" values (null, 100002, 100081);
+insert into "public"."t_role_menu" values (null, 100002, 100082);
+insert into "public"."t_role_menu" values (null, 100002, 100083);
+insert into "public"."t_role_menu" values (null, 100002, 100084);
+insert into "public"."t_role_menu" values (null, 100002, 100085);
+insert into "public"."t_role_menu" values (null, 100002, 100086);