扩展官方的发布功能:读取流程的节点及路由信息,并写入表中。
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';