<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.artfess.bpm.persistence.dao.BpmCallLogDao">
	<resultMap id="BpmCallLog" type="com.artfess.bpm.persistence.model.BpmCallLog">
		<id property="id" column="ID_" jdbcType="VARCHAR"/>
		<result property="subject" column="SUBJECT_" jdbcType="VARCHAR"/>
		<result property="procDefId" column="PROC_DEF_ID_" jdbcType="VARCHAR"/>
		<result property="procDefKey" column="PROC_DEF_KEY_" jdbcType="VARCHAR"/>
		<result property="taskId" column="TASK_ID_" jdbcType="VARCHAR"/>
		<result property="supInstId" column="SUP_INST_ID_" jdbcType="VARCHAR"/>
		<result property="procInstId" column="PROC_INST_ID_" jdbcType="VARCHAR"/>
		<result property="taskKey" column="TASK_KEY_" jdbcType="VARCHAR"/>
		<result property="taskName" column="TASK_NAME_" jdbcType="VARCHAR"/>
		<result property="userId" column="USER_ID_" jdbcType="VARCHAR"/>
		<result property="eventType" column="EVENT_TYPE_" jdbcType="VARCHAR"/>
		<result property="url" column="URL_" jdbcType="VARCHAR"/>
		<result property="desc" column="DESC_" jdbcType="VARCHAR"/>
		<result property="invokeMode" column="INVOKE_MODE_" jdbcType="NUMERIC"/>
		<result property="isSuccess" column="IS_SUCCESS_" jdbcType="NUMERIC"/>
		<result property="response" column="RESPONSE_" jdbcType="VARCHAR"/>
		<result property="callTime" column="CALL_TIME_" jdbcType="TIMESTAMP"/>
		<result property="params" column="PARAMS_" jdbcType="LONGVARCHAR"/>
		<result property="header" column="HEADER_" jdbcType="VARCHAR"/>
		<result property="retryCount" column="RETRY_COUNT_" jdbcType="NUMERIC"/>
		
	</resultMap>
	
	<delete id="removePreDate"  parameterType="java.util.Date" >
		DELETE FROM bpm_call_log 
		WHERE CALL_TIME_ &lt;= #{date,jdbcType=TIMESTAMP}
	</delete>
	
</mapper>