package com.job.zsc;

import com.job.zsc.dustexceptionanalysis.analysis.Exceeding;
import com.job.zsc.dustexceptionanalysis.database.DustRepository;
import com.job.zsc.mapper.dustexception.OnlineAnalysisMapper;
import com.job.zsc.pojo.DustExceptionSetting;
import com.job.zsc.pojo.DustSiteData;
import org.junit.jupiter.api.Test;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.boot.test.context.SpringBootTest;

import java.sql.SQLOutput;
import java.text.ParseException;
import java.text.SimpleDateFormat;
import java.util.*;

@SpringBootTest
class QianduanApplicationTests {

    @Test
    void contextLoads() throws ParseException {

            String oldDateStr ="2023-05-01T16:00:00.000Z";
            Date date1 = null;
            SimpleDateFormat df2 = null;

                oldDateStr = oldDateStr.replace("Z", " UTC");
                SimpleDateFormat df = new SimpleDateFormat("yyyy-MM-dd'T'HH:mm:ss.SSS Z");
                Date date = df.parse(oldDateStr);
                SimpleDateFormat sdf = new SimpleDateFormat ("EEE MMM dd HH:mm:ss Z yyyy", Locale.UK);
                date1 = sdf.parse(date.toString());
                df2 = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");

            System.out.print(date1);
            //return df2.format(date1);

    }
    @Autowired
    private DustRepository dustRepository;
    @Test
    void readSiteData(){
//        DustExceptionSetting dustExceptionSetting = DustExceptionSetting.getInstance();
//        读取异常分析判定的配置
        List<DustExceptionSetting> list= dustRepository.readExceptionSetting();
        System.out.println("11111");

        System.out.println(list.size());
        System.out.println(list.get(0));


//        List<DustSiteData> dustData = dustRepository.getDustData("2023-10-01 00:00:00","2023-10-01 01:00:00");
////      System.out.println(dustData.get(0).getMnCode());
//        int a  = Exceeding.main(dustData);
//        System.out.println(a);


    }


//    @Test
//    void exceeding(){
//
//    }

}