activiti清空测试数据脚本

-- 清空运行中测试数据
DELETE FROM `act_ru_variable`
DELETE FROM `act_ru_task`
DELETE FROM `act_ru_identitylink`
-- 这个表清空报错 需要层层查询，删除最外层的记录，一层层往里删除
DELETE FROM `act_ru_execution`

SELECT t1.* FROM act_ru_execution t1 -- 子
LEFT JOIN (
	SELECT t1.* FROM act_ru_execution t1 -- 子
	LEFT JOIN (
		SELECT t1.* FROM act_ru_execution t1 -- 子
		LEFT JOIN (
			SELECT t1.* FROM act_ru_execution t1 -- 子
			LEFT JOIN act_ru_execution t2 ON t1.PARENT_ID_=t2.id_ -- 父
			WHERE   t2.id_ IS NOT NULL
		) t2 ON t1.PARENT_ID_=t2.id_ -- 父
	WHERE   t2.id_ IS NOT NULL
	) t2 ON t1.PARENT_ID_=t2.id_ -- 父
	WHERE   t2.id_ IS NOT NULL
) t2 ON t1.PARENT_ID_=t2.id_ -- 父
WHERE   t2.id_ IS NOT NULL


-- 清空历史流程测试数据
DELETE FROM `act_hi_varinst`
DELETE FROM `act_hi_taskinst`
DELETE FROM `act_hi_identitylink`
DELETE FROM `act_hi_comment`
DELETE FROM `act_hi_procinst`

-- 清空对象型流程变量
DELETE FROM `act_ge_bytearray` WHERE deployment_id_ IS NULL AND name_ NOT IN('source','source-extra')

主要是遇到act_ru_execution表有外键关联，清空比较麻烦。