Activiti数据库设计和模型映射2-RE流程定义存储表

作者: 安安汐而 | 来源:发表于2019-08-23 16:03 被阅读0次

Activiti数据库设计和模型映射2-RE流程定义存储表
开发流程
Django开发流程
新闻首页实现 -- 1. 数据库模型设计
day44-模型设计
Activiti数据库设计和模型映射4-HI历史流程数据表
Activiti数据库设计和模型映射1-GE通用表
Sequelize(2) 定义表格
Sequelize(2) 定义表格
django的Models用法

Demo项目代码：
https://gitee.com/AnAnXiEr/activiti6-demo

1、ACT_RE_DEPLOYMENT 【DeploymentEntityImpl】：流程部署记录表

ID_：主键
NAME_:名称
CATEGORY:分类
TENANT_ID：多租户标志
DEPLOY_TIME_：部署时间
KEY_：标志key
ENGINE_VERSION：兼容版本

2、ACT_RE_PROCDEF 【ProcessDefinitionEntityImpl】：流程定义信息表

DEPLOYMENT_ID_:管理部署ID
RESOURCE_NAME_：流程定义资源名称
DGRM_RESOURCE_NAME_：流程图片资源名称
HAS_START_FORM_KEY_：是否存在开始表单标志
HAS_GRAPHICAL_NOTATION_：是否有图形信息
SUSPENSION_STATE_:挂起状态 1正常、2挂起
修改bpmn配置文件，设置formkey
<startEvent id="startEvent" name="开始" activiti:formKey="/process/form/key"></startEvent>

3、ACT_RE_MODEL：模型信息表（用户web设计器）

4、ACT_PROCDEF_INFO：流程定义动态改变信息表

代码

DbRepositoryTest

package com.imooc.activiti.activitidemo.dbentity;

import org.activiti.engine.test.ActivitiRule;
import org.junit.Rule;
import org.junit.Test;
import org.slf4j.Logger;
import org.slf4j.LoggerFactory;

/**
 * @Description GE通用数据库配置测试
 * @Author 胡浩
 * @Date 2019/8/23
 **/
public class DbRepositoryTest {
    private static final Logger LOGGER = LoggerFactory.getLogger(DbRepositoryTest.class);

    //测试、改为自己的mysql数据库
    @Rule
    public ActivitiRule activitiRule = new ActivitiRule("dbentity/activiti-mysql.cfg.xml");

    /**
     * 部署
     */
    @Test
    public void testDeploy() {
        //会往act_ge_byteArray表插入一条资源记录
        //会往act_re_deployment表插入一条流程部署记录表
        //会往act_re_procdef表插入一条流程定义信息表
        //<startEvent id="startEvent" name="开始" activiti:formKey="secend_approve_formkey"></startEvent>
        activitiRule.getRepositoryService().createDeployment().name("二次审批流程")
                .addClasspathResource("MyProcess.bpmn20.xml")
                .deploy();
    }

    /**
     * 挂起
     */
    @Test
    public void testSuspend() {
         //挂起
        activitiRule.getRepositoryService().suspendProcessDefinitionById("process:2:7504");

        boolean processDefinitionSuspended = activitiRule.getRepositoryService().isProcessDefinitionSuspended("process:2:7504");
        LOGGER.info("是否挂起 {}",processDefinitionSuspended);
    }


}

MyProcess.bpmn20.xml

<?xml version="1.0" encoding="UTF-8"?>
<definitions xmlns="http://www.omg.org/spec/BPMN/20100524/MODEL" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:activiti="http://activiti.org/bpmn" xmlns:bpmndi="http://www.omg.org/spec/BPMN/20100524/DI" xmlns:omgdc="http://www.omg.org/spec/DD/20100524/DC" xmlns:omgdi="http://www.omg.org/spec/DD/20100524/DI" typeLanguage="http://www.w3.org/2001/XMLSchema" expressionLanguage="http://www.w3.org/1999/XPath" targetNamespace="http://www.activiti.org/processdef">
    <process id="process" name="二级审批流程" isExecutable="true">
        <documentation>二级审批流程描述</documentation>
        <startEvent id="startEvent" name="开始" activiti:formKey="/process/form/key"></startEvent>
        <userTask id="submitForm" name="填写审批信息">
            <extensionElements>
                <activiti:formProperty id="message" name="申请信息" type="string" required="true"/>
                <activiti:formProperty id="name" name="申请人姓名" type="string" required="true"/>
                <activiti:formProperty id="submitTime" name="提交时间" type="date" datePattern="yyyy-MM-dd hh:mm" required="true"/>
                <activiti:formProperty id="submitType" name="确认申请" type="string" required="true"/>
            </extensionElements>
        </userTask>
        <sequenceFlow id="sid-DB948276-B02D-4AEC-A0F3-2F07FE14539F" sourceRef="startEvent" targetRef="submitForm"/>
        <exclusiveGateway id="decideSubmit" name="提交Or取消"/>
        <sequenceFlow id="sid-90C08259-B2E4-4040-AFD0-887A1B63BCB4" sourceRef="submitForm" targetRef="decideSubmit"/>
        <userTask id="tl_approve" name="主管审批">
            <extensionElements>
                <activiti:formProperty id="tlApprove" name="主管审批结果" type="string" required="true"/>
                <activiti:formProperty id="tlMessage" name="主管备注" type="string" required="true"/>
            </extensionElements>
        </userTask>
        <exclusiveGateway id="decideTLApprove" name="主管审批校验"/>
        <sequenceFlow id="sid-F2A588E6-D75D-4853-9776-D19EE387AC36" sourceRef="tl_approve" targetRef="decideTLApprove"/>
        <userTask id="hr_approve" name="人事审批">
            <extensionElements>
                <activiti:formProperty id="hrApprove" name="人事审批结果" type="string" required="true"/>
                <activiti:formProperty id="hrMessage" name="人事审批备注" type="string" required="true"/>
            </extensionElements>
        </userTask>
        <exclusiveGateway id="decideHrApprove" name="人事审批校验"/>
        <sequenceFlow id="sid-08679356-C5A5-40E1-9233-BC15BFEB2C58" sourceRef="hr_approve" targetRef="decideHrApprove"/>
        <endEvent id="endEvent" name="结束"/>
        <endEvent id="endEventCancel" name="取消"/>
        <sequenceFlow id="sid-C75DA753-2A7B-4188-B959-02D684EEDE82" sourceRef="decideSubmit" targetRef="tl_approve">
            <conditionExpression xsi:type="tFormalExpression">
                <![CDATA[ ${submitType == "y" || submitType=="Y"} ]]>
            </conditionExpression>
        </sequenceFlow>
        <sequenceFlow id="sid-3F088F53-AD0C-47C4-8CC7-EE9B6F0AD26A" sourceRef="decideSubmit" targetRef="endEventCancel">
            <conditionExpression xsi:type="tFormalExpression">
                <![CDATA[ ${submitType == "n" || submitType =="N"} ]]>
            </conditionExpression>
        </sequenceFlow>
        <sequenceFlow id="sid-09D306B4-A1C7-4399-9CF4-03EF3B5FE3BD" sourceRef="decideTLApprove" targetRef="hr_approve">
            <conditionExpression xsi:type="tFormalExpression">
                <![CDATA[ ${tlApprove=="y" || tlApprove=="Y"} ]]>
            </conditionExpression>
        </sequenceFlow>
        <sequenceFlow id="sid-A437F37A-0732-433E-B608-3103029C96BD" sourceRef="decideHrApprove" targetRef="endEvent">
            <conditionExpression xsi:type="tFormalExpression">
                <![CDATA[ ${hrApprove=="y" || hrApprove=="Y"} ]]>
            </conditionExpression>
        </sequenceFlow>
        <sequenceFlow id="sid-E8944E87-C69E-4DCF-85D7-A67CD378EC63" sourceRef="decideHrApprove" targetRef="submitForm">
            <conditionExpression xsi:type="tFormalExpression">
                <![CDATA[ ${hrApprove=="n" || hrApprove=="N"} ]]>
            </conditionExpression>
        </sequenceFlow>
        <sequenceFlow id="sid-A8329121-BD51-4AE9-B390-FE837F5FAD36" sourceRef="decideTLApprove" targetRef="submitForm">
            <conditionExpression xsi:type="tFormalExpression">
                <![CDATA[ ${tlApprove=="n" || tlApprove=="N"} ]]>
            </conditionExpression>
        </sequenceFlow>
    </process>
    <bpmndi:BPMNDiagram id="BPMNDiagram_process">
        <bpmndi:BPMNPlane bpmnElement="process" id="BPMNPlane_process">
            <bpmndi:BPMNShape bpmnElement="startEvent" id="BPMNShape_startEvent">
                <omgdc:Bounds height="30.0" width="30.0" x="75.0" y="100.0"/>
            </bpmndi:BPMNShape>
            <bpmndi:BPMNShape bpmnElement="submitForm" id="BPMNShape_submitForm">
                <omgdc:Bounds height="80.0" width="100.0" x="150.0" y="75.0"/>
            </bpmndi:BPMNShape>
            <bpmndi:BPMNShape bpmnElement="decideSubmit" id="BPMNShape_decideSubmit">
                <omgdc:Bounds height="40.0" width="40.0" x="285.0" y="96.0"/>
            </bpmndi:BPMNShape>
            <bpmndi:BPMNShape bpmnElement="tl_approve" id="BPMNShape_tl_approve">
                <omgdc:Bounds height="80.0" width="100.0" x="380.0" y="76.0"/>
            </bpmndi:BPMNShape>
            <bpmndi:BPMNShape bpmnElement="decideTLApprove" id="BPMNShape_decideTLApprove">
                <omgdc:Bounds height="40.0" width="40.0" x="525.0" y="96.0"/>
            </bpmndi:BPMNShape>
            <bpmndi:BPMNShape bpmnElement="hr_approve" id="BPMNShape_hr_approve">
                <omgdc:Bounds height="80.0" width="100.0" x="660.0" y="76.0"/>
            </bpmndi:BPMNShape>
            <bpmndi:BPMNShape bpmnElement="decideHrApprove" id="BPMNShape_decideHrApprove">
                <omgdc:Bounds height="40.0" width="40.0" x="810.0" y="90.0"/>
            </bpmndi:BPMNShape>
            <bpmndi:BPMNShape bpmnElement="endEvent" id="BPMNShape_endEvent">
                <omgdc:Bounds height="28.0" width="28.0" x="960.0" y="101.0"/>
            </bpmndi:BPMNShape>
            <bpmndi:BPMNShape bpmnElement="endEventCancel" id="BPMNShape_endEventCancel">
                <omgdc:Bounds height="28.0" width="28.0" x="416.0" y="180.0"/>
            </bpmndi:BPMNShape>
            <bpmndi:BPMNEdge bpmnElement="sid-90C08259-B2E4-4040-AFD0-887A1B63BCB4" id="BPMNEdge_sid-90C08259-B2E4-4040-AFD0-887A1B63BCB4">
                <omgdi:waypoint x="250.0" y="115.71090047393365"/>
                <omgdi:waypoint x="285.21153846153845" y="116.21153846153845"/>
            </bpmndi:BPMNEdge>
            <bpmndi:BPMNEdge bpmnElement="sid-E8944E87-C69E-4DCF-85D7-A67CD378EC63" id="BPMNEdge_sid-E8944E87-C69E-4DCF-85D7-A67CD378EC63">
                <omgdi:waypoint x="830.5" y="129.5"/>
                <omgdi:waypoint x="830.5" y="253.0"/>
                <omgdi:waypoint x="200.0" y="253.0"/>
                <omgdi:waypoint x="200.0" y="155.0"/>
            </bpmndi:BPMNEdge>
            <bpmndi:BPMNEdge bpmnElement="sid-F2A588E6-D75D-4853-9776-D19EE387AC36" id="BPMNEdge_sid-F2A588E6-D75D-4853-9776-D19EE387AC36">
                <omgdi:waypoint x="480.0" y="116.21645021645021"/>
                <omgdi:waypoint x="525.4130434782609" y="116.41304347826087"/>
            </bpmndi:BPMNEdge>
            <bpmndi:BPMNEdge bpmnElement="sid-A437F37A-0732-433E-B608-3103029C96BD" id="BPMNEdge_sid-A437F37A-0732-433E-B608-3103029C96BD">
                <omgdi:waypoint x="849.5" y="110.5"/>
                <omgdi:waypoint x="905.0" y="110.5"/>
                <omgdi:waypoint x="905.0" y="115.0"/>
                <omgdi:waypoint x="960.0" y="115.0"/>
            </bpmndi:BPMNEdge>
            <bpmndi:BPMNEdge bpmnElement="sid-DB948276-B02D-4AEC-A0F3-2F07FE14539F" id="BPMNEdge_sid-DB948276-B02D-4AEC-A0F3-2F07FE14539F">
                <omgdi:waypoint x="105.0" y="115.0"/>
                <omgdi:waypoint x="150.0" y="115.0"/>
            </bpmndi:BPMNEdge>
            <bpmndi:BPMNEdge bpmnElement="sid-A8329121-BD51-4AE9-B390-FE837F5FAD36" id="BPMNEdge_sid-A8329121-BD51-4AE9-B390-FE837F5FAD36">
                <omgdi:waypoint x="545.5" y="96.5"/>
                <omgdi:waypoint x="545.5" y="32.0"/>
                <omgdi:waypoint x="200.0" y="32.0"/>
                <omgdi:waypoint x="200.0" y="75.0"/>
            </bpmndi:BPMNEdge>
            <bpmndi:BPMNEdge bpmnElement="sid-09D306B4-A1C7-4399-9CF4-03EF3B5FE3BD" id="BPMNEdge_sid-09D306B4-A1C7-4399-9CF4-03EF3B5FE3BD">
                <omgdi:waypoint x="564.5579268292682" y="116.4420731707317"/>
                <omgdi:waypoint x="660.0" y="116.15197568389058"/>
            </bpmndi:BPMNEdge>
            <bpmndi:BPMNEdge bpmnElement="sid-3F088F53-AD0C-47C4-8CC7-EE9B6F0AD26A" id="BPMNEdge_sid-3F088F53-AD0C-47C4-8CC7-EE9B6F0AD26A">
                <omgdi:waypoint x="305.5" y="135.5"/>
                <omgdi:waypoint x="305.5" y="194.0"/>
                <omgdi:waypoint x="416.0" y="194.0"/>
            </bpmndi:BPMNEdge>
            <bpmndi:BPMNEdge bpmnElement="sid-C75DA753-2A7B-4188-B959-02D684EEDE82" id="BPMNEdge_sid-C75DA753-2A7B-4188-B959-02D684EEDE82">
                <omgdi:waypoint x="324.62666666666667" y="116.37333333333333"/>
                <omgdi:waypoint x="380.0" y="116.00662251655629"/>
            </bpmndi:BPMNEdge>
            <bpmndi:BPMNEdge bpmnElement="sid-08679356-C5A5-40E1-9233-BC15BFEB2C58" id="BPMNEdge_sid-08679356-C5A5-40E1-9233-BC15BFEB2C58">
                <omgdi:waypoint x="760.0" y="116.0"/>
                <omgdi:waypoint x="785.0" y="116.0"/>
                <omgdi:waypoint x="785.0" y="110.5"/>
                <omgdi:waypoint x="810.5" y="110.5"/>
            </bpmndi:BPMNEdge>
        </bpmndi:BPMNPlane>
    </bpmndi:BPMNDiagram>
</definitions>

Activiti数据库设计和模型映射2-RE流程定义存储表
Demo项目代码：https://gitee.com/AnAnXiEr/activiti6-demo 1、ACT_...
开发流程
开发流程  创建 Django 项目 创建应用 模型 数据库配置 数据库表的定义 定义模型...
Django开发流程
流程目录：创建Django项目创建应用模型：数据库配置数据库表的定义定义模型类生成数据表模板视图服务器...
新闻首页实现 -- 1. 数据库模型设计
一、数据库模型设计 1.分析文章分类表文章表文章评论表热门文章表轮播图表 2.模型定义定义数据库基类模...
day44-模型设计
1模型设计部分参数 1.1迁移表中db_table 指定db_table参数，表示模型迁移时，映射到数据库中的表名...
Activiti数据库设计和模型映射4-HI历史流程数据表
Demo项目代码：https://gitee.com/AnAnXiEr/activiti6-demo 1、ACT_...
Activiti数据库设计和模型映射1-GE通用表
Demo项目代码：https://gitee.com/AnAnXiEr/activiti6-demo 数据模型设置...
Sequelize(2) 定义表格
定义定义模型与表之间的映射,使用 define 方法. Sequelize 会自动增加 createdAt 和 ...
Sequelize(2) 定义表格
定义定义模型与表之间的映射,使用 define 方法. Sequelize 会自动增加 createdAt 和 ...
django的Models用法
模型是关于您的数据的单一的、确定的信息来源。它包含您存储的数据的基本字段和行为。通常，每个模型映射到单个数据库表。...