whyclxw
2025-05-28 e16302f9d475c7cc4dd18c5abf1a23cb5502e362
src/main/java/com/whyc/task/HistoryDataArchivingTask.java
@@ -9,10 +9,10 @@
/**
 * 暂定保存六个月的数据,六个月之前的数据存档到年分表中存档
 *
 * 电源告警历史 db_pwrdev_alarm.tb_pwrdev_alarm_history
 * 电池告警历史 db_alarm.tb_battalarm_data_history
 * 设备告警历史 db_alarm.tb_devalarm_data_history
 * 操作事件 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 {
@@ -22,9 +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_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);
    }