package com.moral.mapper;

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

import com.moral.entity.History;
import org.apache.ibatis.annotations.Param;

public interface HistoryMapper {
    int insert(History record);

    int insertSelective(History record);

    Map<String, Object> getAvgData(Map<String, Object> parameters);

    Map<String, Object> getMaxAndMinData(Map<String, Object> parameters);

    List<Map<String, Object>> getSensorData(Map<String, Object> parameters);

    List<Map<String, Object>> getSensorDataByMac(Map<String, Object> parameters);

    List<Map<String, Object>> getSensorDataByMacOnce(Map<String, Object> parameters);

    List<Map<String, Object>> getSensorDataOnce(Map<String, Object> parameters);

    Map<String, Object> getMinData(Map<String, Object> parameters);

    List<History> selectByMacAndTime(Map<String, Object> parameters);

    int insertHistorySpecialTable(Map<String, Object> parameters);

    int deleteHistoryData(String oldTime);

    void deletePartition(@Param("p") String p);

    void createHistoryTable(@Param("yearMonthDay") String yearMonthDay);

    void dropHistoryTable(@Param("yearMonthDay") String yearMonthDay);

    History selectLastDataByMac(@Param("yearMonthDay") String yearMonthDay, @Param("mac") String mac);

}