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相关配置文件。