WindTurbineDataMapper.java 886 B

123456789101112131415161718192021222324252627282930
  1. package com.znzn.project.dc.dtdata.mapper;
  2. import com.baomidou.mybatisplus.core.mapper.BaseMapper;
  3. import com.znzn.project.dc.dtdata.entity.WindTurbineData;
  4. import org.apache.ibatis.annotations.Mapper;
  5. import org.apache.ibatis.annotations.Select;
  6. import java.util.Map;
  7. /**
  8. * <p>
  9. * 风力发电机数据表 Mapper 接口
  10. * </p>
  11. *
  12. * @author 魏志亮
  13. * @since 2026-01-08
  14. */
  15. @Mapper
  16. public interface WindTurbineDataMapper extends BaseMapper<WindTurbineData> {
  17. @Select("select * from wind_turbine_data where turbine_id = #{turbineId} and data_time > #{dataTime} order by data_time desc limit 1 ")
  18. Map<String, Object> getLastHourLatestData(String dataTime,String turbineId);
  19. void addMonthlyPartition(String partitionName, String partitionEndDate);
  20. void dropExpiredPartition(String expiredPartitionName);
  21. int checkPartitionExists(String partitionName);
  22. }