/**
 * @author 50560
 * @create 2022-09-15 9:53
 */

import com.alibaba.fastjson.JSONArray;
import com.gyee.backconfig.BackConfigMain;
import com.gyee.backconfig.mapper.auto.XrpProjectplanMapper;
import com.gyee.backconfig.model.auto.XrpProjectplan;
import org.apache.commons.math3.analysis.integration.IterativeLegendreGaussIntegrator;
import org.junit.Test;
import org.junit.runner.Result;
import org.junit.runner.RunWith;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.boot.test.context.SpringBootTest;
import org.springframework.test.context.junit4.SpringRunner;

import javax.xml.bind.SchemaOutputResolver;
import java.util.*;

/**
 *@BelongsProject: workpathnew
 *@BelongsPackage: PACKAGE_NAME
 *@Author: xiruipeng
 *@CreateTime: 2022-09-15  09:53
 *@Description: TODO
 *@Version: 1.0
 */
@SpringBootTest(classes = {BackConfigMain.class})
@RunWith(SpringRunner.class)
public class BackConfigMainTests<test> {
    @Autowired
    private XrpProjectplanMapper xrpProjectplanMapper;

    @Test
    public void selectListPP(){
        //查询一个list集合
        List<XrpProjectplan> xrpProjectplanList = xrpProjectplanMapper.selectList(null);
        xrpProjectplanList.forEach(System.out::println);
    }

//    插入一行
    @Test
    public void testInsert(){
        ArrayList<XrpProjectplan> xrpProjectplans = new ArrayList<>();
        XrpProjectplan xrpProjectplan = new XrpProjectplan();
        xrpProjectplan.setId(String.valueOf(100l));
        xrpProjectplan.setProjectid("3");
        xrpProjectplan.setGeneratingcapacity("2.4");
        xrpProjectplan.setOutagehours(3.2);
        xrpProjectplan.setYear("4");
        xrpProjectplan.setMonth("6");
        xrpProjectplan.setWindpower("22");
        /*for (int i = 0; i < 10; i++) {
            XrpProjectplan xrpProjectplan = new XrpProjectplan();
            xrpProjectplan.setProjectid("3"+i);
            xrpProjectplan.setGeneratingcapacity("2.4"+i);
            xrpProjectplan.setOutagehours(3.2+i);
            xrpProjectplan.setYear("4"+i);
            xrpProjectplan.setMonth("6"+i);
            xrpProjectplan.setWindpower("22"+i);
            xrpProjectplans.add(xrpProjectplan);
        }

        for (XrpProjectplan projectplan : xrpProjectplans) {
            System.out.println("-------"+projectplan.getMonth());
            int insert = xrpProjectplanMapper.insert(projectplan);
            System.out.println("result"+ insert);
        }*/
        int insert = xrpProjectplanMapper.insert(xrpProjectplan);
        System.out.println("result"+ insert);
        System.out.println("id"+xrpProjectplan.getId());
    }

    //deletbyid-按照id进行删除
    @Test
    public void testDelete(){
        int result = xrpProjectplanMapper.deleteById(1);
        System.out.println("result"+result);
    }


    @Test
    public void testByMap(){
        Map<String,Object> map=new HashMap<>();
        //根据map设置的条件
        map.put("projectid","2");
        map.put("id",234);
        int result = xrpProjectplanMapper.deleteByMap(map);
        System.out.println("result:"+result);

    }

    @Test
    public void testByDeleteBatch(){
        List<String> longs = Arrays.asList("f21682be7be3191100926f994f89c7de", "45602bfc1ff27b11517f149981a0c4df");
        int result = xrpProjectplanMapper.deleteBatchIds(longs);
        System.out.println("result:"+result);

    }

    //修改信息
    @Test
    public void testUpate(){
        XrpProjectplan xrpProjectplan = new XrpProjectplan();
//        xrpProjectplan.setId(String.valueOf(1570251306048020483l));
//        xrpProjectplan.setId("1233344");
//        xrpProjectplan.setProjectid("3");
        xrpProjectplan.setGeneratingcapacity("2.4");
        xrpProjectplan.setOutagehours(3.2);
        xrpProjectplan.setYear("4");
        xrpProjectplan.setMonth("6");
        xrpProjectplan.setWindpower("22");
        int result = xrpProjectplanMapper.updateById(xrpProjectplan);
    }

//批量查询
    @Test
    public void testSelect(){
        /*XrpProjectplan xrpProjectplan = xrpProjectplanMapper.selectById(1570251304856838146L);
        System.out.println(xrpProjectplan);*/
        List<String > String = Arrays.asList("f21682be7be3191100926f994f89c7de", "597be69f450213db6d2b9e5c4c3b377f", "d71feaac476bdf52da6714f6607afec7");
        List<XrpProjectplan> xrpProjectplanList = xrpProjectplanMapper.selectBatchIds(String);
        xrpProjectplanList.forEach(System.out::println);
        Map<String, Object> map = new HashMap<>();
//        map.put("id",1570250808607682562L);
        map.put("projectid","40");
        List<XrpProjectplan> xrpProjectplanList1 = xrpProjectplanMapper.selectByMap(map);
        xrpProjectplanList1.forEach(System.out::println);
    }

    @Test
    public void testMapperXml(){
        Map<String, Object> map = xrpProjectplanMapper.selectMapById("597be69f450213db6d2b9e5c4c3b377f");
        System.out.println(map);
    }
}