package com.gxx.record_app.base.dao;

import java.util.List;

import org.apache.ibatis.annotations.Select;
import org.apache.ibatis.annotations.SelectProvider;
import org.springframework.stereotype.Repository;

import com.gxx.record_app.base.vo.TransMonitor;
import com.gxx.record_app.base.vo.TransMonitorWithBLOBs;
import com.gxx.record_app.dto.MonitorDto;

@Repository
public interface TransMonitorMapper {
    int deleteByPrimaryKey(Integer id);

    int insert(TransMonitorWithBLOBs record);

    int insertSelective(TransMonitorWithBLOBs record);

    TransMonitorWithBLOBs selectByPrimaryKey(Integer id);

    int updateByPrimaryKeySelective(TransMonitorWithBLOBs record);

    int updateByPrimaryKeyWithBLOBs(TransMonitorWithBLOBs record);

    int updateByPrimaryKey(TransMonitor record);
    
    /**
     * 查询交易监控
     * @param monitorDto
     * @return
     */
	@SelectProvider(type=TransMonitorSqlProvider.class,method="queryTransMonitor")
    public List<TransMonitorWithBLOBs> queryTransMonitor(MonitorDto monitorDto);
    
    /**
     * 查询交易监控总数
     * @param monitorDto
     * @return
     */
	@SelectProvider(type=TransMonitorSqlProvider.class,method="countTransMonitor")
    public long countTransMonitor(MonitorDto monitorDto);
    
    /**
     * 查询平均耗时
     * @param monitorDto
     * @return
     */
	@SelectProvider(type=TransMonitorSqlProvider.class,method="queryAvgUsedTime")
    public double queryAvgUsedTime(MonitorDto monitorDto);
	
	/**
	 * 查询所有监控方法路径
	 * @return
	 */
	@Select("SELECT DISTINCT METHOD_ROUTE FROM TRANS_MONITOR")
	public List<String> queryAllMethodRoutes();
}