扩展官方的发布功能:读取流程的节点及路由信息,并写入表中。
1.将流程节点全部读取出来,并写入biz_activity表中;
表结构如下:
2.将节点流向sequenceFlow读取,并写入Biz_Transition表中
表结构如下:
1.将流程节点全部读取出来,并写入biz_activity表中;
表结构如下:
CREATE TABLE `biz_activity` (
`id_` bigint(20) NOT NULL,
`Proc_Def_id` varchar(20) COLLATE utf8_bin NOT NULL,
`type_` varchar(20) COLLATE utf8_bin NOT NULL,
`key_` varchar(20) COLLATE utf8_bin NOT NULL,
`name_` varchar(20) COLLATE utf8_bin DEFAULT NULL,
`x` varchar(20) COLLATE utf8_bin DEFAULT NULL,
`y` varchar(20) COLLATE utf8_bin DEFAULT NULL,
`height` varchar(20) COLLATE utf8_bin DEFAULT NULL,
`width` varchar(20) COLLATE utf8_bin DEFAULT NULL,
PRIMARY KEY (`id_`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
2.将节点流向sequenceFlow读取,并写入Biz_Transition表中
表结构如下:
CREATE TABLE `biz_transition` (
`ID_` bigint(20) NOT NULL,
`PROC_DEF_ID` varchar(20) COLLATE utf8_bin NOT NULL,
`KEY_` varchar(20) COLLATE utf8_bin NOT NULL,
`NAME_` varchar(20) COLLATE utf8_bin DEFAULT NULL,
`SOURCE_REF` varchar(20) COLLATE utf8_bin NOT NULL,
`TARGET_REF` varchar(20) COLLATE utf8_bin NOT NULL,
PRIMARY KEY (`ID_`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Biz_Transition';