package com.terra.bigdata.util;

import com.terra.bigdata.service.Yssh3dreliService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.beans.factory.annotation.Value;
import org.springframework.scheduling.annotation.Scheduled;
import org.springframework.stereotype.Component;

import java.text.SimpleDateFormat;
import java.util.Date;

/**
 * 定时任务处理数据控制器
 *
 * @author xingjs
 * @date 2023/02/06
 */
//@Component("sqlDataTask")
public class ScheduledTasksUtils {

    //定时任务表达式
    @Value("${task.cron}")
    private String timingTaskExpression;

    @Autowired
    private Yssh3dreliService yssh3dreliService;


    //每天晚上23:59:00点执行创建第二天的数据表
    @Scheduled(cron = "0 59 23 * * ?")
    public void createTable() {
        System.out.println("执行有参方法，参数为：" + timingTaskExpression);
        //yssh2dreliService.create2dreliTable();
        //System.out.println("========创建2维热力表执行完毕======== ");
        //yssh3dreliService.create3dreliTable();
        System.out.println("========创建3维热力执行完毕======== ");
    }


    //删除前一年的数据 每天晚上0点执行
    @Scheduled(cron = "0 0 0 * * ?")
    public void deletePreviousYearsData() {
        //yssh2dreliService.drop2dreliTable();
        //System.out.println("========删除2维热力表执行完毕======== ");
        yssh3dreliService.drop3dreliTable();
        System.out.println("========删除3维热力执行完毕======== ");
    }

}