Activiti删除测试数据(存储过程,手动SQL两种方法)
来源:互联网 发布:php setslaveokay 编辑:程序博客网 时间:2024/05/29 15:54
不用多说:Activiti 测试会出现很多垃圾数据使用如下两种方式均可删除掉Activiti表中的数据。直接接干货吧
CREATE OR REPLACE
PROCEDURE "ACP_DEL_ACTINFO" (--删除流程信息(不包括部署信息)
vs_procInst_id in VARCHAR2,
SUCESS_FLAG OUT NUMBER,
SUCESS_MSG OUT VARCHAR2
)
AS
BUSINESS_KEY VARCHAR2(4000);
Begin
SUCESS_MSG := '查询所有待删除Exe_ID';
SELECT "TO_CHAR"(WM_CONCAT("TO_CHAR"("TO_CHAR"(BUSINESS_KEY_)))) INTO BUSINESS_KEY FROM ACT_HI_PROCINST WHERE INSTR(','||vs_procInst_id||',',','||PROC_INST_ID_||',') > 0;
DELETE FROM ACT_HI_VARINST WHERE INSTR(','||vs_procInst_id||',',','||PROC_INST_ID_||',') > 0;
DELETE FROM ACT_RU_VARIABLE WHERE INSTR(','||vs_procInst_id||',',','||PROC_INST_ID_||',') > 0;
DELETE FROM ACT_RU_IDENTITYLINK WHERE INSTR(','||vs_procInst_id||',',','||PROC_INST_ID_||',') > 0;
DELETE FROM ACT_HI_TASKINST WHERE INSTR(','||vs_procInst_id||',',','||PROC_INST_ID_||',') > 0;
DELETE FROM ACT_HI_IDENTITYLINK WHERE INSTR(','||vs_procInst_id||',',','||PROC_INST_ID_||',') > 0;
DELETE FROM ACT_HI_DETAIL WHERE INSTR(','||vs_procInst_id||',',','||PROC_INST_ID_||',') > 0;
DELETE FROM ACT_HI_COMMENT WHERE INSTR(','||vs_procInst_id||',',','||PROC_INST_ID_||',') > 0;
DELETE FROM ACT_HI_ATTACHMENT WHERE INSTR(','||vs_procInst_id||',',','||PROC_INST_ID_||',') > 0;
DELETE FROM ACT_HI_ACTINST WHERE INSTR(','||vs_procInst_id||',',','||PROC_INST_ID_||',') > 0;
DELETE FROM ACT_RU_JOB WHERE INSTR(','||vs_procInst_id||',',','||PROCESS_INSTANCE_ID_||',') > 0;
DELETE FROM ACT_RU_TASK WHERE INSTR(','||vs_procInst_id||',',','||PROC_INST_ID_||',') > 0;
DELETE FROM ACT_RU_EXECUTION WHERE INSTR(','||vs_procInst_id||',',','||PROC_INST_ID_||',') > 0;
DELETE FROM ACT_HI_PROCINST WHERE INSTR(','||vs_procInst_id||',',','||PROC_INST_ID_||',') > 0;
SUCESS_FLAG := 1;
Exception
When others then
SUCESS_FLAG := 0;
SUCESS_MSG := '存储过程发生异常,断点在:'||SUCESS_MSG||',错误信息为:'||SQLERRM;
Rollback;
End ACP_DEL_ACTINFO;
------------------------------------------------------------------------华丽的分割线------------------------------------------------------------------------------------------------
MySQL手工删除数据
SELECT DISTINCT table_name,column_name FROM information_schema.columns
WHERE column_name = 'PROC_INST_ID_';
--手工删除工作流引擎数据
delete from act_ru_executionwherePROC_INST_ID_= '9c881069b3fc4ec1987748df589d9bce';
delete from act_hi_actinst wherePROC_INST_ID_ = '9c881069b3fc4ec1987748df589d9bce';
delete from act_hi_attachmentwherePROC_INST_ID_= '9c881069b3fc4ec1987748df589d9bce';
delete from act_hi_commentwherePROC_INST_ID_= '9c881069b3fc4ec1987748df589d9bce';
delete from act_hi_detailwherePROC_INST_ID_= '9c881069b3fc4ec1987748df589d9bce';
delete from act_hi_identitylinkwherePROC_INST_ID_= '9c881069b3fc4ec1987748df589d9bce';
delete from act_hi_procinstwherePROC_INST_ID_= '9c881069b3fc4ec1987748df589d9bce';
delete from act_hi_taskinstwherePROC_INST_ID_= '9c881069b3fc4ec1987748df589d9bce';
delete from act_hi_varinstwherePROC_INST_ID_= '9c881069b3fc4ec1987748df589d9bce';
delete from act_ru_event_subscrwherePROC_INST_ID_= '9c881069b3fc4ec1987748df589d9bce';
delete from act_ru_identitylinkwherePROC_INST_ID_= '9c881069b3fc4ec1987748df589d9bce';
delete from act_ru_taskwherePROC_INST_ID_= '9c881069b3fc4ec1987748df589d9bce';
delete from act_ru_variablewherePROC_INST_ID_= '9c881069b3fc4ec1987748df589d9bce';
1 0
- Activiti删除测试数据(存储过程,手动SQL两种方法)
- 两种存储过程调用方法
- 存储过程的两种返回方法
- c#调用存储过程两种方法
- c#调用存储过程两种方法
- Zencart 删除测试数据方法
- sql server平台用存储过程进行分页的两种方法
- 使用SQL Server存储过程中的返回值的两种方法
- sql删除表 存储过程
- 利用存储过程写入测试数据
- 存储过程 造批量测试数据
- mysql存储过程,生成测试数据
- mysql存储过程创建测试数据
- SQL与Oracle两种形式分页存储过程
- SQL Server两种分页的存储过程介绍
- SQL SERVER两种分页的存储过程介绍
- Oracle 循环插入测试数据(网上收集整理),存储过程
- 费控测试数据删除方法
- 二进制面试题
- std::mutex与pthread mutex区别
- Android适配——采用Values-dpi-wSize X hSize 模式,并分析原理
- 考研路茫茫——空调教室
- Java去掉字符串中所有的标签,获取纯文本内容,获取src
- Activiti删除测试数据(存储过程,手动SQL两种方法)
- Devstack快速部署OpenStack Mitaka用户指南(by qiqishuang csdn)
- LeetCode 103. Binary Tree Zigzag Level Order Traversal
- LeetCode199. Binary Tree Right Side View
- 关于原生js的一些研究
- LeetCode上Tag为广度优先搜索BFS(Breadth-first Search)的题目整理
- 【汇编】JMP跳转指令的指令长度、直接转移与间接转移、段内跳转与段间跳转
- LeetCode 3. Longest Substring Without Repeating Characters
- ftp 实现文件的上传下载以及列出文件列表Java代码