从 v0.10.0升级到v0.11.0

企业门户APP

数据升级

请先备份每个库的表结构及数据，便于出问题之后恢复
先升级hzero相关的数据: 参考hzero更新文档中的数据升级，数据处理 初始化hzero基础服务的数据库 [hzero升级文档]
从 gitlab 上下载 hips_0.11.0分支的数据库脚本和Excel期初数据(注意阅读readme)

ssh: 
~ git clone git@code.choerodon.com.cn:hippius-internal/hippius-resource.git
https: 
~ git clone https://code.choerodon.com.cn/hippius-internal/hippius-resource.git

~ git checkout hips_0.11.0

想部署单个服务版本的海马汇执行

./hippius.sh

想部署all版本的海马汇,执行

./hippius-all.sh

且需修改路由

update hzero_admin.hadm_service_route set service_code='hippius-all' where name in ('hipsmsg','hipsam','hipsst','hipspfm','hipssm','hipsdv');

数据修复

修复租户app角色 > admin 用户调用下面的接口,初始化租户下的app角色

【POST】 http://ip/hipspfm/hippius/v1/corpInfo/initTenantAppRoles

参数token：
Authorization  bearer xxxxxxx

返回空

修复消息模版多语言数据

[POST] http://ip//hipsmsg/v1/message/template/hotfix

参数token：
Authorization  bearer xxxxxxx

返回空

SQL执行数据修复(all默认是hzero_platform库)

租户ID修复数据(hzero_platform库)

UPDATE hipsplat_contact_tag_tl tl 
SET tl.tenant_id = ( SELECT hips.tenant_id FROM hipsplat_contact_tag hips WHERE hips.tag_id = tl.tag_id ) ;
UPDATE hipsplat_employee_info_tl tl 
SET tl.tenant_id = ( SELECT hips.tenant_id FROM hipsplat_employee_info hips WHERE hips.info_id = tl.info_id ) ;
UPDATE hipsplat_employee_property_tl tl 
SET tl.tenant_id = ( SELECT hips.tenant_id FROM hipsplat_employee_property hips WHERE hips.property_id = tl.property_id ) ;
UPDATE hipsplat_qr_code_tl tl 
SET tl.tenant_id = ( SELECT hips.tenant_id FROM hipsplat_qr_code hips WHERE hips.qr_id = tl.qr_id ) ;

素材库多语言修复

INSERT INTO hipsmsg_material_tl (material_id, lang, title,summary,content,redirect_url,organization_id ) (
    SELECT
        material_id,
        'zh_CN',
        title,
				summary,
				content,
				redirect_url,
				organization_id
    FROM
        hipsmsg_material t
    WHERE
        NOT EXISTS ( SELECT 1 FROM hipsmsg_material_tl tl WHERE t.material_id = tl.material_id AND tl.lang = 'zh_CN' ) 
    );
    
INSERT INTO hipsmsg_material_tl (material_id, lang, title,summary,content,redirect_url,organization_id ) (
    SELECT
        material_id,
        'en_US',
        title,
				summary,
				content,
				redirect_url,
				organization_id
    FROM
        hipsmsg_material t
    WHERE
        NOT EXISTS ( SELECT 1 FROM hipsmsg_material_tl tl WHERE t.material_id = tl.material_id AND tl.lang = 'en_US' ) 
    );
    
    
update hipsmsg_material SET choice_lang = 'zh_CN,en_US' where choice_lang IS NULL OR choice_lang='';

消息表多语言修复

INSERT INTO hipsmsg_message_tl (message_id, lang, title,summary,content,send_args,tenant_id) (
    SELECT
        message_id,
        'zh_CN',
        title,
				summary,
				content,
				send_args,
				tenant_id
    FROM
        hipsmsg_message t
    WHERE
        NOT EXISTS ( SELECT 1 FROM hipsmsg_message_tl tl WHERE t.message_id = tl.message_id AND tl.lang = 'zh_CN' ) 
    );
		
		
		INSERT INTO hipsmsg_message_tl (message_id, lang, title,summary,content,send_args,tenant_id) (
    SELECT
        message_id,
        'en_US',
        title,
				summary,
				content,
				send_args,
				tenant_id
    FROM
        hipsmsg_message t
    WHERE
        NOT EXISTS ( SELECT 1 FROM hipsmsg_message_tl tl WHERE t.message_id = tl.message_id AND tl.lang = 'en_US' ) 
    );

素材图文多语言修复

INSERT INTO hipsmsg_rich_text_message_tl (rt_msg_id, lang, title,summary,content ) (
    SELECT
        rt_msg_id,
        'zh_CN',
        title,
				summary,
				content
    FROM
        hipsmsg_rich_text_message t
    WHERE
        NOT EXISTS ( SELECT 1 FROM hipsmsg_rich_text_message_tl tl WHERE t.rt_msg_id = tl.rt_msg_id AND tl.lang = 'zh_CN' ) 
    );
		
		
INSERT INTO hipsmsg_rich_text_message_tl (rt_msg_id, lang, title,summary,content ) (
    SELECT
        rt_msg_id,
        'en_US',
        title,
				summary,
				content
    FROM
        hipsmsg_rich_text_message t
    WHERE
        NOT EXISTS ( SELECT 1 FROM hipsmsg_rich_text_message_tl tl WHERE t.rt_msg_id = tl.rt_msg_id AND tl.lang = 'en_US' ) 
    );

素材外链多语言修复

INSERT INTO hipsmsg_url_message_tl (url_msg_id, lang, title,summary,redirect_url ) (
    SELECT
        url_msg_id,
        'zh_CN',
        title,
				summary,
				redirect_url
    FROM
        hipsmsg_url_message t
    WHERE
        NOT EXISTS ( SELECT 1 FROM hipsmsg_url_message_tl tl WHERE t.url_msg_id = tl.url_msg_id AND tl.lang = 'zh_CN' ) 
    );
		
		
INSERT INTO hipsmsg_url_message_tl (url_msg_id, lang, title,summary,redirect_url ) (
    SELECT
        url_msg_id,
        'en_US',
        title,
				summary,
				redirect_url
    FROM
        hipsmsg_url_message t
    WHERE
        NOT EXISTS ( SELECT 1 FROM hipsmsg_url_message_tl tl WHERE t.url_msg_id = tl.url_msg_id AND tl.lang = 'en_US' ) 
    );

修复banner多语言数据

INSERT INTO hipsam_banner_tl (id, lang, material_title,material_content,redirect_url,material_summary,tenant_id ) (
    SELECT
        id,
        'zh_CN',
        material_title,
				material_content,
				redirect_url,
				material_summary,
				tenant_id
    FROM
        hipsam_banner t
    WHERE
        NOT EXISTS ( SELECT 1 FROM hipsam_banner_tl tl WHERE t.id = tl.id AND tl.lang = 'zh_CN' ) 
    );
		
		
		INSERT INTO hipsam_banner_tl (id, lang, material_title,material_content,redirect_url,material_summary,tenant_id ) (
    SELECT
        id,
        'en_US',
        material_title,
				material_content,
				redirect_url,
				material_summary,
				tenant_id
    FROM
        hipsam_banner t
    WHERE
        NOT EXISTS ( SELECT 1 FROM hipsam_banner_tl tl WHERE t.id = tl.id AND tl.lang = 'en_US' ) 
    );

修复广告多语言数据

INSERT INTO hipsam_ad_tl (id, lang, title,redirect_url,content,summary,organization_id ) (
    SELECT
        id,
        'zh_CN',
        title,
				redirect_url,
				content,
				summary,
				organization_id
    FROM
        hipsam_ad t
    WHERE
        NOT EXISTS ( SELECT 1 FROM hipsam_ad_tl tl WHERE t.id = tl.id AND tl.lang = 'zh_CN' ) 
    );

		
INSERT INTO hipsam_ad_tl (id, lang, title,redirect_url,content,summary,organization_id ) (
    SELECT
        id,
        'en_US',
        title,
				redirect_url,
				content,
				summary,
				organization_id
    FROM
        hipsam_ad t
    WHERE
        NOT EXISTS ( SELECT 1 FROM hipsam_ad_tl tl WHERE t.id = tl.id AND tl.lang = 'en_US' ) 
    );

服务部署

数据升级完成之后再重启已升级的服务
重启完成后，如果因数据缓存问题，可到 开发管理>系统工具 下手动刷新缓存
建议按如下顺序重启服务
- hzero-register
- hzero-gateway
- hzero-iam
- hzero-oauth
- hzero-platform
- 其它服务
- hzero-admin

前端升级

使用dist包部署的，直接现在对应版本的dist即可
非dist，修改引用的海马汇对应组件的版本为 0.10.0