7.1.0.0 升级 7.1.0.1
1. 初始化数据库脚本
在安装包中\db-scripts\upgrade 的目录下找到相应的数据库执行 upgrade_7.1.0.0-7.1.0.1.sql 脚本。
以 mysql 为例，即执行\db-scripts\bps\upgrade\mysql\upgrade_7.1.0.0-7.1.0.1.sql 文件。
该脚本中有创建新视图,需要将 metacube 替换为元数据库的 schema
-- 2023-01-11 为了适配Oracle 将以下三个表名超过30字符的表进行缩短
ALTER TABLE rcm_model_consistency_check_log RENAME to rcm_model_check_log;
ALTER TABLE rcm_model_consistency_check_log_detail RENAME to rcm_model_check_log_detail;
ALTER TABLE rcm_model_consistency_check_timing RENAME to rcm_model_check_timing;
ALTER TABLE `rcm_standard_dataelement` ADD COLUMN `CHECK_RULE_STATE` varchar(10) NULL COMMENT '判断是否具有质量规则';
ALTER TABLE `rcm_group` ADD COLUMN `AFC_GROUP_ID` varchar(64) NULL COMMENT 'AFC主题主键';
ALTER TABLE `rcm_datasource` ADD COLUMN `AFC_DS_ID` varchar(64) NULL COMMENT 'AFC主题主键';
DROP TABLE IF EXISTS `rcm_r_standard_recommendation`;
CREATE TABLE `rcm_r_standard_recommendation` (
`ID` varchar(64) NOT NULL COMMENT '主键',
`TYPE` varchar(64) NOT NULL COMMENT '推荐类型',
`SCORE` varchar(64) NOT NULL COMMENT '推荐分值',
`STANDARD_ID` varchar(64) DEFAULT NULL COMMENT '标准ID',
`STANDARD_CODE` varchar(200) DEFAULT NULL COMMENT '标准编码',
`STANDARD_NAME` varchar(500) DEFAULT NULL COMMENT '标准名称',
`STANDARD_TYPE` varchar(500) DEFAULT NULL COMMENT '标准类型',
`CATALOG_ID` varchar(64) DEFAULT NULL COMMENT '资产ID',
`CATALOG_CODE` varchar(64) DEFAULT NULL COMMENT '资产编码',
`CATALOG_NAME` varchar(64) DEFAULT NULL COMMENT '资产名称',
`CATALOG_TYPE` varchar(64) DEFAULT NULL COMMENT '资产类型',
`CREATE_BY` varchar(256) DEFAULT NULL COMMENT '创建人id',
`CREATE_NAME` varchar(256) DEFAULT NULL COMMENT '创建人名字',
`CREATE_TIME` datetime DEFAULT NULL COMMENT '创建时间',
`STATUS` varchar(256) DEFAULT NULL COMMENT '关联状态',
`DESCRIPTION` varchar(500) DEFAULT NULL COMMENT '描述',
PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='标准推荐表';
-- ----------------------------
-- Table structure for t_task_instance
-- ----------------------------
DROP TABLE IF EXISTS `t_task_instance`;
CREATE TABLE `t_task_instance` (
`TASK_INSTANCE_ID` varchar(32) NOT NULL,
`TASK_ID` varchar(32) DEFAULT NULL,
`DATASOURCE_ID` varchar(32) NOT NULL,
`TASK_STATE` varchar(2) DEFAULT NULL,
`START_TIME` decimal(31,0) DEFAULT NULL,
`END_TIME` decimal(31,0) DEFAULT NULL,
`FILE_PATH` varchar(1000) DEFAULT NULL,
`IMPORT_STRAT` char(1) DEFAULT NULL,
`IMPORT_AUDIT` char(1) DEFAULT NULL,
`DESCRIPTION` varchar(500) DEFAULT NULL,
`CREATOR` varchar(500) DEFAULT NULL,
PRIMARY KEY (`TASK_INSTANCE_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE ALGORITHM = UNDEFINED DEFINER = `root`@`%` SQL SECURITY DEFINER VIEW v_harvest_datasource (
DATASOURCE_ID,
DATASOURCE_NAME,
CATALOG_ID,
SCHEMA_NAME,
DATA_PATH,
DS_ID
) AS SELECT
`t1`.`DATASOURCE_ID` AS `DATASOURCE_ID`,
`t1`.`DATASOURCE_NAME` AS `DATASOURCE_NAME`,
`t1`.`DATA_PATH` AS `CATALOG_ID`,
upper(`t2`.`PARAM_VALUE`) AS `SCHEMA_NAME`,
`t1`.`DATA_PATH` AS `DATA_PATH`,
`t3`.`DS_ID` AS `DS_ID`
FROM
(
(
`metacube`.`t_harvest_datasource` `t1`
LEFT JOIN `metacube`.`t_harvest_datasource_param` `t2` ON (
(
(
`t1`.`DATASOURCE_ID` = `t2`.`DATASOURCE_ID`
)
AND (
`t2`.`PARAM_CODE` = 'schemas'
)
)
)
)
LEFT JOIN `rcm_datasource` `t3` ON (
(
CONVERT (
`t1`.`DATASOURCE_ID` USING utf8mb4
) = `t3`.`DS_META_ID`
)
)
);
CREATE ALGORITHM = UNDEFINED DEFINER = `root`@`%` SQL SECURITY DEFINER VIEW `v_meta_table_list` AS SELECT
`ds_desc`.`DATASOURCE_ID` AS `DS_ID`,
`ds_desc`.`DATASOURCE_NAME` AS `DS_NAME`,
`cat_desc`.`INSTANCE_ID` AS `CAT_ID`,
`cat_desc`.`INSTANCE_CODE` AS `CAT_NAME`,
`cat_desc`.`INSTANCE_NAME` AS `CAT_DESC`,
`sch_desc`.`INSTANCE_ID` AS `SCH_ID`,
`sch_desc`.`INSTANCE_CODE` AS `SCH_NAME`,
`sch_desc`.`INSTANCE_NAME` AS `SCH_DESC`,
`tab_desc`.`INSTANCE_ID` AS `TAB_ID`,
`tab_desc`.`INSTANCE_CODE` AS `TABLE_NAME`,
(
CASE
WHEN (
`tab_desc`.`INSTANCE_NAME` = `tab_desc`.`INSTANCE_CODE`
) THEN
''
ELSE
`tab_desc`.`INSTANCE_NAME`
END
) AS `TABLE_DESC`,
'' AS `TAB_META_PATH`
FROM
(
(
(
`v_md_cat_desc` `cat_desc`
LEFT JOIN `v_md_sch_desc` `sch_desc` ON (
(
`cat_desc`.`INSTANCE_ID` = `sch_desc`.`PARENT_ID`
)
)
)
LEFT JOIN `v_md_tab_desc` `tab_desc` ON (
(
`sch_desc`.`INSTANCE_ID` = `tab_desc`.`PARENT_ID`
)
)
)
LEFT JOIN `v_harvest_datasource` `ds_desc` ON (
(
`cat_desc`.`INSTANCE_ID` = `ds_desc`.`CATALOG_ID`
)
)
)
WHERE
(
`ds_desc`.`DATASOURCE_ID` IS NOT NULL
)
ORDER BY
`cat_desc`.`INSTANCE_CODE`,
`sch_desc`.`INSTANCE_CODE`,
`tab_desc`.`INSTANCE_CODE`;
CREATE ALGORITHM = UNDEFINED DEFINER = `root`@`%` SQL SECURITY DEFINER VIEW `v_meta_datasource` AS SELECT
`t1`.`DATASOURCE_ID` AS `DATASOURCE_ID`,
`t1`.`DATASOURCE_NAME` AS `DATASOURCE_NAME`,
`t1`.`DATA_PATH` AS `CATALOG_ID`,
upper(`t2`.`PARAM_VALUE`) AS `SCHEMA_NAME`,
`t3`.`INSTANCE_CODE` AS `catalog_name`
FROM
(
(
`metacube`.`t_harvest_datasource` `t1`
LEFT JOIN `metacube`.`t_harvest_datasource_param` `t2` ON (
(
(
`t1`.`DATASOURCE_ID` = `t2`.`DATASOURCE_ID`
)
AND (
`t2`.`PARAM_CODE` = 'schemas'
)
)
)
)
LEFT JOIN `metacube`.`t_md_instance` `t3` ON (
(
`t3`.`INSTANCE_ID` = `t1`.`DATA_PATH`
)
)
);
2. 更新介质
下载DAMP_7.1.0.1版本介质，将旧介质删除（前端、后端）,用新介质重新部署，无需修改nginx相关配置文件。