package com.dy.pipIrrDemo.mp;

import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.baomidou.mybatisplus.core.toolkit.Wrappers;
import com.dy.common.multiDataSource.DataSourceContext;
import com.dy.pipIrrGlobal.daoDemo.DemoMpMapper;
import com.dy.pipIrrGlobal.pojoDemo.DemoMp;
import org.junit.Before;
import org.junit.Test;
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 java.util.Arrays;
import java.util.HashMap;
import java.util.List;
import java.util.Map;

@RunWith(SpringRunner.class)
@SpringBootTest
public class MpTest2 {

    @Autowired
    private DemoMpMapper demoMpMapper ;

    @Before
    public void setup(){
        DataSourceContext.set("ym");
    }

    @Test
    public void selectById(){
        DemoMp po = this.demoMpMapper.selectById(2023110716001900000L) ;
        System.out.println(po);
    }
    @Test
    public void selectBatchIds(){
        List<Long> listIds = Arrays.asList(1L, 2L, 2023110716001900000L) ;
        List<DemoMp> poList = this.demoMpMapper.selectBatchIds(listIds) ;
        System.out.println(poList);
    }
    @Test
    public void selectByMap(){
        Map<String, Object > paramMap = new HashMap<>() ;
        paramMap.put("name", "李四");
        paramMap.put("age", "22") ;
        List<DemoMp> poList = this.demoMpMapper.selectByMap(paramMap) ;
        System.out.println(poList);
    }

    @Test
    public void selectByWrapperLt(){
        QueryWrapper<DemoMp> queryWrapper = new QueryWrapper<>();
        //QueryWrapper<DemoMp> queryWrapper = Wrappers.<DemoMp>query() ;
        queryWrapper.like("name", "四").lt("age", 40) ;
        List<DemoMp> poList = this.demoMpMapper.selectList(queryWrapper) ;
        poList.forEach(System.out::println);
    }

    @Test
    public void selectByWrapperBt(){
        QueryWrapper<DemoMp> queryWrapper = new QueryWrapper<>();
        //QueryWrapper<DemoMp> queryWrapper = Wrappers.<DemoMp>query() ;
        queryWrapper.like("name", "四")
                .between("age", 20, 40)
                .isNotNull("dt");
        List<DemoMp> poList = this.demoMpMapper.selectList(queryWrapper) ;
        poList.forEach(System.out::println);
    }

    @Test
    public void selectByWrapperOr(){
        QueryWrapper<DemoMp> queryWrapper = new QueryWrapper<>();
        //QueryWrapper<DemoMp> queryWrapper = Wrappers.<DemoMp>query() ;
        queryWrapper.like("name", "四")
                .or()
                .between("age", 20, 40)
                .isNotNull("dt")
                .orderByAsc("id")
                .orderByAsc("age");
        List<DemoMp> poList = this.demoMpMapper.selectList(queryWrapper) ;
        poList.forEach(System.out::println);
    }

    @Test
    public void selectByWrapperOr1(){
        QueryWrapper<DemoMp> queryWrapper = new QueryWrapper<>();
        //QueryWrapper<DemoMp> queryWrapper = Wrappers.<DemoMp>query() ;
        queryWrapper.likeLeft("name", "四")
                .and(wq->wq.between("age", 20, 40).or().isNotNull("dt"))
                .orderByAsc("id")
                .orderByAsc("age");
        List<DemoMp> poList = this.demoMpMapper.selectList(queryWrapper) ;
        poList.forEach(System.out::println);
    }

    @Test
    public void selectByWrapperOr2(){
        QueryWrapper<DemoMp> queryWrapper = new QueryWrapper<>();
        //QueryWrapper<DemoMp> queryWrapper = Wrappers.<DemoMp>query() ;
        queryWrapper.likeLeft("name", "四")
                .and(wq->wq.between("age", 20, 40).isNotNull("dt"))
                .orderByAsc("id")
                .orderByAsc("age");
        List<DemoMp> poList = this.demoMpMapper.selectList(queryWrapper) ;
        poList.forEach(System.out::println);
    }

    @Test
    public void selectByWrapperOr3(){
        QueryWrapper<DemoMp> queryWrapper = new QueryWrapper<>();
        //QueryWrapper<DemoMp> queryWrapper = Wrappers.<DemoMp>query() ;
        queryWrapper.likeLeft("name", "四")
                .or(wq->wq.lt("age", 100).gt("age", 10).isNotNull("dt"))
                .orderByAsc("id")
                .orderByAsc("age");
        List<DemoMp> poList = this.demoMpMapper.selectList(queryWrapper) ;
        poList.forEach(System.out::println);
    }

    @Test
    public void selectByWrapperOr4(){
        QueryWrapper<DemoMp> queryWrapper = new QueryWrapper<>();
        //QueryWrapper<DemoMp> queryWrapper = Wrappers.<DemoMp>query() ;
        queryWrapper.nested(wq->wq.lt("age", 50).or().isNotNull("dt"))
                .likeLeft("name", "四")
                .orderByAsc("id")
                .orderByAsc("age");
        List<DemoMp> poList = this.demoMpMapper.selectList(queryWrapper) ;
        poList.forEach(System.out::println);
    }


    @Test
    public void selectByWrapperAnd(){
        QueryWrapper<DemoMp> queryWrapper = new QueryWrapper<>();
        //QueryWrapper<DemoMp> queryWrapper = Wrappers.<DemoMp>query() ;
        queryWrapper.likeLeft("name", "四")
                .and(wq->wq.between("age", 20, 40))
                .isNotNull("dt")
                .orderByAsc("id")
                .orderByAsc("age");
        List<DemoMp> poList = this.demoMpMapper.selectList(queryWrapper) ;
        poList.forEach(System.out::println);
    }


    @Test
    public void selectByWrapperIn(){
        QueryWrapper<DemoMp> queryWrapper = new QueryWrapper<>();
        //QueryWrapper<DemoMp> queryWrapper = Wrappers.<DemoMp>query() ;
        queryWrapper.in("age", Arrays.asList(38, 45))
                .orderByAsc("id")
                .orderByAsc("age");
        List<DemoMp> poList = this.demoMpMapper.selectList(queryWrapper) ;
        poList.forEach(System.out::println);
    }

    @Test
    public void selectByWrapperLimit(){
        QueryWrapper<DemoMp> queryWrapper = new QueryWrapper<>();
        //QueryWrapper<DemoMp> queryWrapper = Wrappers.<DemoMp>query() ;
        queryWrapper.in("age", Arrays.asList(38, 45)).last("limit 1")
                .orderByAsc("id")
                .orderByAsc("age");
        List<DemoMp> poList = this.demoMpMapper.selectList(queryWrapper) ;
        poList.forEach(System.out::println);
    }

    @Test
    public void selectByWrapperLimitSupper(){
        QueryWrapper<DemoMp> queryWrapper = new QueryWrapper<>();
        //QueryWrapper<DemoMp> queryWrapper = Wrappers.<DemoMp>query() ;
        queryWrapper.select("id", "name").in("age", Arrays.asList(38, 45)).last("limit 1")
                .orderByAsc("id")
                .orderByAsc("age");
        List<DemoMp> poList = this.demoMpMapper.selectList(queryWrapper) ;
        poList.forEach(System.out::println);
    }

}