whyclxw
2025-05-28 e16302f9d475c7cc4dd18c5abf1a23cb5502e362
src/main/java/com/whyc/task/HistoryDataArchivingTask.java
@@ -2,19 +2,17 @@
import com.whyc.service.HistoryDataArchivingService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.boot.autoconfigure.condition.ConditionalOnBean;
import org.springframework.stereotype.Component;
import javax.annotation.Resource;
import java.util.TimerTask;
/**
 * 暂定保存六个月的数据,六个月之前的数据存档到年分表中存档
 *
 * 电源告警历史
 * 电池告警历史
 * 设备告警历史
 * 操作事件 db_user.tb_user_log
 * 电源告警历史 db_pwrdev_alarm.tb_pwrdev_alarm_history 按年分表,同时保留6个月内数据在历史表
 * 电池告警历史 db_alarm.tb_battalarm_data_history 这个不按年分表,李军监控程序已经按月分表
 * 设备告警历史 db_alarm.tb_devalarm_data_history 这个不按年分表,李军监控程序已经按月分表
 * 操作事件 db_user.tb_user_log 按年分表,同时保留6个月内数据在历史表
 */
@Component
public class HistoryDataArchivingTask extends TimerTask {
@@ -24,6 +22,9 @@
    @Override
    public void run() {
        //service.historyDataArchiving("db_pwrdev_alarm","tb_pwrdev_alarm_history",6);
        //service.historyDataArchiving("db_alarm","tb_battalarm_data_history",6);
        //service.historyDataArchiving("db_alarm","tb_devalarm_data_history",6);
        service.historyDataArchiving("db_user","tb_user_log",6);
    }