package com.whyc.task;
|
|
import com.whyc.service.HistoryDataArchivingService;
|
import org.springframework.beans.factory.annotation.Autowired;
|
import org.springframework.stereotype.Component;
|
|
import java.util.TimerTask;
|
|
/**
|
* 暂定保存六个月的数据,六个月之前的数据存档到年分表中存档
|
*
|
* 电源告警历史 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 {
|
|
@Autowired
|
private HistoryDataArchivingService service;
|
|
@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);
|
}
|
|
|
}
|
