package com.ecar.apm.dao;

import java.util.List;
import java.util.Map;

import org.apache.ibatis.annotations.Delete;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import com.ecar.apm.model.HttpRequestLog;

@Mapper
public interface HttpRequestLogMapper {

	@Insert("INSERT INTO http_request_log(pid,ppguid,pguid,`status`,`costTime`,`statusCode`,log"
			+ ")  VALUES("
			+"#{httpRequestLog.pid},#{httpRequestLog.ppguid},#{httpRequestLog.pguid},#{httpRequestLog.status},#{httpRequestLog.costTime},"
			+ "#{httpRequestLog.statusCode},#{httpRequestLog.log})")
	void insert(@Param("httpRequestLog")HttpRequestLog httpRequestLog);
	
	@Select("SELECT * FROM http_request_log")
	List<HttpRequestLog> selectAll();

	@Select("select t.* from http_request_log t where t.pguid=#{pguid}")
	HttpRequestLog getByGuid(@Param("pguid")String pguid);

	@Delete("delete from http_request_log where ppguid=#{ppguid}")
	void delete(@Param("ppguid")String ppguid);
	
	@Select("select r.httpMethod,r.url,t.`status`,t.statusCode,t.costTime,t.log from http_request_log t,http_request r where t.pguid=r.guid and t.pid=#{id}")
	List<Map<String,Object>> getByPid(@Param("id")int id);
	

	@Delete("delete from http_request_log where createTime < date_sub(curdate(),interval #{day} day)")
	void cleanLogByDay(@Param("day")int day);
}