后端

增量升级(v2.9.0->v3.0.0)

程序发布前执行项

1、Apollo配置

1.1 platform.tzHub

仅仅天舟云本身升级需要配置，产品线只需要确认域名配置是否配置和正确性
产品线配置放在产品线各自的独有配置文件中，不建议修改公共配置platform.tzHub

lcp.hub.initialAuth = false
lcp.hub.app.IsGroupManage = 0
# 默认菜单根节点配置：页面Id；页面编码；页面名称
lcp.hub.root.page = TZC;TZC;TZC

1.2 CSB-LEGOX

程序配置applicantion.yml修改配置

csb:
    mybatis:
        basePackage: com.cvte.csb.select.core.mapper,com.cvte.csb.sys.*.mapper,com.cvte.csb.sys.base.mapper,com.cvte.csb.dashboard.core.mapper,com.cvte.csb.serial.core.mapper,com.cvte.csb.dictionary.mapper,com.cvte.csb.log.mapper,com.cvte.csb.file.mapper,com.cvte.csb.wfp.core.mapper

csb-sys-base 有新增字段

ALTER TABLE sys_page ADD real_page_id varchar(64);

以下按需执行以下按需执行

-- Oracle版本
ALTER TABLE sys_view_datasource ADD datasource_code varchar2(64) NULL;

COMMENT ON COLUMN sys_view_datasource.datasource_code IS '视图主编码';

ALTER TABLE sys_view_datasource ADD sys_database_type varchar2(64) NULL;

COMMENT ON COLUMN sys_view_datasource.sys_database_type IS '数据源类型:表单 数据库';

ALTER TABLE sys_view_datasource ADD biz_id varchar2(32) NULL;

COMMENT ON COLUMN sys_view_datasource.biz_id IS '业务归属来源ID';

ALTER TABLE sys_view_datasource ADD biz_type varchar2(255) NULL;

COMMENT ON COLUMN sys_view_datasource.biz_type IS '业务归属类型';

ALTER TABLE sys_view_datasource ADD app_id varchar2(64) NULL;

COMMENT ON COLUMN sys_view_datasource.app_id IS '应用ID';

ALTER TABLE sys_view_datasource ADD tenant_id varchar2(64) NULL;

COMMENT ON COLUMN sys_view_datasource.tenant_id IS '租户号';

ALTER TABLE sys_view_datasource ADD product_id varchar2(64) NULL;

COMMENT ON COLUMN sys_view_datasource.product_id IS '产品ID';



ALTER TABLE sys_view_condition ADD view_source_id varchar2(36) NULL;

COMMENT ON COLUMN sys_view_condition.view_source_id IS '视图资源ID';



ALTER TABLE sys_view ADD view_type varchar2(128) NULL;

COMMENT ON COLUMN sys_view.view_type IS '视图类型';

ALTER TABLE sys_view ADD user_id varchar2(128) NULL;

COMMENT ON COLUMN sys_view.user_id IS '用户id';



ALTER TABLE sys_user_view_field_order ADD sys_view_column_id varchar(32) NULL;
COMMENT ON COLUMN sys_user_view_field_order.sys_view_column_id IS '视图字段ID';

2、Nacos配置

无

3、数据库脚本

业务库

无

配置库

独立部署程序自动执行，不需要手动执行
只有多租户需要人工数据库执行：研发、行政

ALTER TABLE obj_http ADD tags varchar(256) NULL;
ALTER TABLE obj_http ADD todo_prefix varchar(256) NULL;
COMMENT ON COLUMN obj_http.todo_prefix IS '待办入口地址前缀(如https://xxx.gz.cvte.cn/patrol)';

ALTER TABLE state_machine_template ADD column IF NOT EXISTS workflow_type varchar(100) NULL;
COMMENT ON COLUMN state_machine_template.workflow_type IS '流程类型';
ALTER TABLE state_machine_template ADD column IF NOT EXISTS system_code varchar(200) NULL;
COMMENT ON COLUMN state_machine_template.system_code IS '系统编码';

ALTER TABLE obj_application ADD column IF NOT EXISTS table_name_prefix varchar(200) NULL;
COMMENT ON COLUMN obj_application.table_name_prefix IS '物理表前缀';

-- PostgreSQL 实现方案
ALTER TABLE tz_list_scheme ADD COLUMN db_id VARCHAR(64);
COMMENT ON COLUMN tz_list_scheme.db_id IS '数据源id';

CREATE TABLE obj_common_config (
                                   id varchar(32) NOT NULL,
                                   biz_id varchar(64) NULL,
                                   biz_type varchar(64) NULL,
                                   config_content text NULL,
                                   is_deleted varchar(1) NULL,
                                   is_enabled varchar(1) NULL,
                                   crt_user varchar(50) NULL,
                                   crt_host varchar(100) NULL,
                                   crt_name varchar(50) NULL,
                                   crt_time timestamp NULL,
                                   upd_user varchar(50) NULL,
                                   upd_name varchar(50) NULL,
                                   upd_host varchar(100) NULL,
                                   upd_time timestamp NULL,
                                   app_id varchar(64) NULL, -- 应用ID
                                   tenant_id varchar(64) NULL, -- 租户号
                                   product_id varchar(64) NULL, -- 产品id
                                   CONSTRAINT obj_common_config_pk PRIMARY KEY (id)
);

数据初始化 - 集成流程

目前仅仅研发需要执行，其他产品线不执行

研发业务域 : sit环境

INSERT INTO obj_http
(id, http_name, http_code, http_desc, http_host, http_type, http_base_url, auth_type, auth_config, is_enabled, is_deleted, tenant_id, app_id, crt_user, crt_name, crt_time, crt_host, upd_user, upd_name, upd_time, upd_host, product_id, tags, todo_prefix)
VALUES('ee31f34422a046af8841cb7db7eea388', 'PDM', 'CPLM-OBJECT', '', 'cplmobjsit.gz.cvte.cn', 'https', NULL, 'iac', '{"appId":"2a1fe9c4-4f65-419c-bd4e-3aa18d3b6e58","appSecret":"836f4178-bbf6-47ba-905d-b1fc991138be"}', '1', '0', 'c9a8ac72-483a-44c5-892e-74428e7010c3', '2a1fe9c4-4f65-419c-bd4e-3aa18d3b6e58', 'yeduanwang', '叶端旺', '2025-01-21 16:15:23.803', '172.17.212.249', 'yeduanwang', '叶端旺', '2025-01-21 16:16:22.229', '172.17.212.249', NULL, 'integrated', 'https://cplmsit.gz.cvte.cn/pdm/flow/flow_center/oa');

不需该功能的业务域不执行

数据初始化 - 菜单发布

研发业务域: sit

INSERT INTO obj_http
(id, http_name, http_code, http_desc, http_host, http_type, http_base_url, auth_type, auth_config, is_enabled, is_deleted, tenant_id, app_id, crt_user, crt_name, crt_time, crt_host, upd_user, upd_name, upd_time, upd_host, product_id, tags, todo_prefix)
VALUES('ee31f34422a046af8841cb7db7eea3881', 'PDM', 'MEMU_PUBLISH', '', 'cplmobjsit.gz.cvte.cn', 'https', NULL, 'iac', '{"appId":"2a1fe9c4-4f65-419c-bd4e-3aa18d3b6e58","appSecret":"836f4178-bbf6-47ba-905d-b1fc991138be"}', '1', '0', 'c9a8ac72-483a-44c5-892e-74428e7010c3', '2a1fe9c4-4f65-419c-bd4e-3aa18d3b6e58', 'yeduanwang', '叶端旺', '2025-01-21 16:15:23.803', '172.17.212.249', 'yeduanwang', '叶端旺', '2025-01-21 16:16:22.229', '172.17.212.249', NULL, 'menu_publish', NULL);

不需该功能的业务域不执行

业务库

无

配置库

程序发布

应用运维同步

   无