| | |
| | | |
| | | <!-- 通用查询映射结果 --> |
| | | <resultMap id="BaseResultMap" type="com.zy.asrs.entity.ApiLog"> |
| | | <id column="id" property="id" /> |
| | | <result column="uuid" property="uuid" /> |
| | | <result column="namespace" property="namespace" /> |
| | | <result column="url" property="url" /> |
| | | <result column="appkey" property="appkey" /> |
| | | <result column="timestamp" property="timestamp" /> |
| | | <result column="client_ip" property="clientIp" /> |
| | | <result column="request" property="request" /> |
| | | <result column="response" property="response" /> |
| | | <result column="err" property="err" /> |
| | | <result column="result" property="result" /> |
| | | <result column="status" property="status" /> |
| | | <result column="create_time" property="createTime" /> |
| | | <result column="update_time" property="updateTime" /> |
| | | <result column="memo" property="memo" /> |
| | | <id column="id" property="id"/> |
| | | <result column="uuid" property="uuid"/> |
| | | <result column="namespace" property="namespace"/> |
| | | <result column="url" property="url"/> |
| | | <result column="appkey" property="appkey"/> |
| | | <result column="timestamp" property="timestamp"/> |
| | | <result column="client_ip" property="clientIp"/> |
| | | <result column="request" property="request"/> |
| | | <result column="response" property="response"/> |
| | | <result column="err" property="err"/> |
| | | <result column="result" property="result"/> |
| | | <result column="status" property="status"/> |
| | | <result column="create_time" property="createTime"/> |
| | | <result column="update_time" property="updateTime"/> |
| | | <result column="memo" property="memo"/> |
| | | |
| | | </resultMap> |
| | | |
| | | <delete id="clearWeekBefore"> |
| | | |
| | | |
| | | delete from man_api_log |
| | | where 1=1 |
| | | and datediff(week,create_time,getdate()) >= 1 |
| | | and result != 1 |
| | | and datediff(week,create_time,getdate()) >= 1 |
| | | and result != 1 |
| | | </delete> |
| | | |
| | | </mapper> |