认证授权服务升级文档（V1.0 ~ V1.2）

部署变更说明

新增 Deployment authx-service/authx-service-bff ， StatefulSet authx-service/redis-server
新增 Deployment authx-service/rabbitmq-server ，用于将 user-data-service，user-authorization-service，jobs-server 连接的 rabbitmq-server 进行合并
删除 Deployment user-data-service/rabbitmq-server
修改 Secret user-data-service/rabbitmq-env-secret ，将 SPRING_RABBITMQ_HOST 修改为 rabbitmq-server.authx-service.svc.cluster.local
修改 ConfigMap user-data-service/user-data-service-goa-env ，将 JOBS_RABBITMQ_HOST 修改为 rabbitmq-server.authx-service.svc.cluster.local
修改 Deployment user-data-service/user-data-service-biz ，增加环境变量 rabbitmq-env-secret
删除 Deployment user-data-service/rabbitmq-server
修改 Secret user-authorization-service/rabbitmq-env-secret ，将 SPRING_RABBITMQ_HOST 修改为 rabbitmq-server.authx-service.svc.cluster.local
修改 ConfigMap user-authorization-service/user-authorization-sa-env ，将 USER_AUTHORIZATION_SA_USER_RABBITMQ_HOST 修改为 rabbitmq-server.authx-service.svc.cluster.local
删除 Deployment jobs-server/rabbitmq-server
修改 Secret jobs-server/rabbitmq-env-secret ，将 SPRING_RABBITMQ_HOST 修改为 rabbitmq-server.authx-service.svc.cluster.local
变更 CronJob user-data-service/user-data-service-datax-job 的定时 schedule 为 30 */4 * * *
变更 CronJob user-authorization-service/user-authorization-datax-job 的定时 schedule 为 30 */4 * * *
变更 CronJob cas-server/cas-server-datax-job 的定时 schedule 为 5 */2 * * *
删除 Job authx-service/poa-api-docs-installer ，由各服务下独立部署
新增 Job user-data-service/api-docs-installer
新增 Job user-authorization-service/api-docs-installer
新增 Job token-server/api-docs-installer

升级说明

将工作负载下的服务升级到 1.2.x 版本
数据库脚本进行升级

重新执行 Job user-data-service/user-data-service-installer

重新执行 Job user-authorization-service/user-authorization-installer

重新执行 Job cas-server/cas-server-installer

重新执行 Job token-server/token-server-installer

部署 StatefulSet authx-service/redis-server ， Deployment authx-service/rabbitmq-server
部署 Deployment authx-service/authx-service-bff
Secret user-data-service/rabbitmq-env-secret ，修改 SPRING_RABBITMQ_HOST

SPRING_RABBITMQ_HOST: rabbitmq-server.authx-service.svc.cluster.local

Secret user-authorization-service/rabbitmq-env-secret ，修改 SPRING_RABBITMQ_HOST

SPRING_RABBITMQ_HOST: rabbitmq-server.authx-service.svc.cluster.local

Secret jobs-server/rabbitmq-env-secret ，修改 SPRING_RABBITMQ_HOST

SPRING_RABBITMQ_HOST: rabbitmq-server.authx-service.svc.cluster.local

Deployment user-data-service/user-data-service-biz 下的环境变量中，引用其他资源，添加附加资源 Secret rabbitmq-env-secret
ConfigMap user-data-service/user-data-service-goa-env 下，更新 JOBS_RABBITMQ 相关的配置

JOBS_RABBITMQ_HOST: rabbitmq-server.authx-service.svc.cluster.local

ConfigMap user-authorization-service/user-authorization-sa-env 下，新增 USER_AUTHORIZATION_SA_USER_RABBITMQ 相关的配置

USER_AUTHORIZATION_SA_USER_RABBITMQ_CONSUMER_ENABLED: "false"
USER_AUTHORIZATION_SA_USER_RABBITMQ_HOST: rabbitmq-server.jobs-server.svc.cluster.local
USER_AUTHORIZATION_SA_USER_RABBITMQ_PORT: "5672"
USER_AUTHORIZATION_SA_USER_RABBITMQ_USERNAME: guest
USER_AUTHORIZATION_SA_USER_RABBITMQ_PASSWORD: guest

修改 x-datax-job 的定时策略

CronJob user-data-service/user-data-service-datax-job 下，修改 schedule 为 30 */4 * * *

CronJob user-authorization-service/user-authorization-datax-job 下，修改 schedule 为 30 */4 * * *

CronJob CronJob cas-server/cas-server-datax-job 下，修改 schedule 为 5 */2 * * *

更新 POA 的 api-docs

执行 Job user-data-service/api-docs-installer

执行 Job user-authorization-service/api-docs-installer

执行 Job token-server/api-docs-installer

初始化脚本

更新接口路由、应用、菜单、角色权限

注：如果已经存在，请忽略

use admin_center;

-- 新增接口路由

insert into TB_MGT_ROUTE (ID, DELETED, CODE, NAME, STATUS, PATH_PREFIX, URL, STRIP_PREFIX) 
values ('21', 0, 'authx-service-admin-api', '认证授权 - 聚合接口（认证、授权）', '1', '/api/v2/admin', 'http://localhost:8009', 0);
insert into TB_MGT_ROUTE (ID, DELETED, CODE, NAME, STATUS, PATH_PREFIX, URL, STRIP_PREFIX) 
values ('22', 0, 'authx-service-open-api', '认证授权 - 聚合接口（公开）', '1', '/api/v2/open', 'http://localhost:8009', 0);

commit;

update TB_MGT_ROUTE set URL='http://authx-service-bff-svc.authx-service.svc.cluster.local:8080' where ID='21';
update TB_MGT_ROUTE set URL='http://authx-service-bff-svc.authx-service.svc.cluster.local:8080' where ID='22';

commit;

-- 新增应用

insert into TB_MGT_APPLICATION (ID, DELETED, CODE, NAME, STATUS) 
values ('10', 0, '10', '用户授权', '1');

commit;

-- 更新现有菜单 的 所属 APPLICATION_ID

update TB_MGT_PERMISSION set APPLICATION_ID='10' where ID like '2____';
update TB_MGT_PERMISSION set APPLICATION_ID='10' where ID like '3____';
update TB_MGT_PERMISSION set APPLICATION_ID='10' where ID like '4____';

commit;

-- 新增功能菜单

update TB_MGT_PERMISSION
  set LFT = LFT+10
where LFT>=35
;

update TB_MGT_PERMISSION
  set RGT = RGT+10
where RGT>=35
;

insert into TB_MGT_PERMISSION (ID, DELETED, CODE, NAME, STATUS, TYPE_, ICON, URL, APPLICATION_ID, PARENT_ID, ORDER_, LEVEL_, LFT, RGT) 
values ('20650', 0, 'casConfig', '认证对接配置', '1', '2', 'el-icon-service', '/cas-server/casConfig', '10', '20000', 20650, 2, 35, 36);

insert into TB_MGT_PERMISSION (ID, DELETED, CODE, NAME, STATUS, TYPE_, ICON, URL, APPLICATION_ID, PARENT_ID, ORDER_, LEVEL_, LFT, RGT) 
values ('20700', 0, 'loginPageConfig', '登录页面配置', '1', '2', 'su-icon-tongxunxinxi', '/cas-server/loginPageConfig', '10', '20000', 20700, 2, 37, 38);
insert into TB_MGT_PERMISSION (ID, DELETED, CODE, NAME, STATUS, TYPE_, ICON, URL, APPLICATION_ID, PARENT_ID, ORDER_, LEVEL_, LFT, RGT) 
values ('20800', 0, 'linkLoginConfig', '联合登录配置', '1', '2', 'su-icon-test', '/cas-server/linkLoginConfig', '10', '20000', 20800, 2, 39, 40);

insert into TB_MGT_PERMISSION (ID, DELETED, CODE, NAME, STATUS, TYPE_, ICON, URL, APPLICATION_ID, PARENT_ID, ORDER_, LEVEL_, LFT, RGT) 
values ('20900', 0, 'infoPerfectConfig', '信息完善配置', '1', '2', 'su-icon-chongxintijiao', '/cas-server/infoPerfectConfig', '10', '20000', 20900, 2, 41, 42);

insert into TB_MGT_PERMISSION (ID, DELETED, CODE, NAME, STATUS, TYPE_, ICON, URL, APPLICATION_ID, PARENT_ID, ORDER_, LEVEL_, LFT, RGT) 
values ('21000', 0, 'lockManagement', '认证锁定管理', '1', '2', 'su-icon-shouquanjiguanli', '/cas-server/lockManagement', '10', '20000', 21000, 2, 43, 44);

commit;

insert into TB_MGT_ROLE_PERMISSION (ID, DELETED, ROLE_ID, PERMISSION_ID) 

select CONCAT('20_', ID) as ID, 0 as DELETED, '20' as ROLE_ID, ID as PERMISSION_ID 
from TB_MGT_PERMISSION
where ID like '2____'
  and (
      CONCAT('20_', ID) not in (select CONCAT('20_', PERMISSION_ID) from TB_MGT_ROLE_PERMISSION)
   or CONCAT('20_', ID) not in (select ID from TB_MGT_ROLE_PERMISSION)
  )
;

commit;