| | |
| | | |
| | | 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 { |
| | |
| | | |
| | | @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); |
| | | } |
| | | |