package com.sf;

import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.sf.mapper.BookInfoMapper;
import com.sf.po.BookCategory;
import com.sf.po.BookInfo;
import com.sf.service.IBookCategoryService;
import com.sf.service.IBookContentService;
import org.junit.jupiter.api.Test;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.boot.test.context.SpringBootTest;

import java.util.List;

@SpringBootTest
class NovelDemoApplicationTests {

    @Autowired
    private BookInfoMapper bookInfoMapper;

    @Test
    void contextLoads() {
        List<BookInfo> list = bookInfoMapper.selectList(null);
        System.out.println();
    }

    @Test
    public void testSelect(){
        QueryWrapper<BookInfo> queryWrapper = new QueryWrapper<>();
        queryWrapper.eq("book_name","人类简史");
        long cnt = bookInfoMapper.selectCount(queryWrapper);
        System.out.println(cnt);
    }

    @Test
    public void testSelectLambda(){
        LambdaQueryWrapper<BookInfo> lambdaQueryWrapper = new LambdaQueryWrapper();
        lambdaQueryWrapper.eq(BookInfo::getBookName,"人类简史");
//        lambdaQueryWrapper.select();
    }

    // 分页
    @Test
    public void testPage(){
        IPage<BookInfo> page = new Page<>();
        // 一页显示几行
        // 当前是第几页
        page.setCurrent(1);
        page.setSize(10);

        // 根据作者 查询所有作品
        QueryWrapper<BookInfo> wrapper = new QueryWrapper<>();
        wrapper.eq("author_id","0");
        IPage<BookInfo> bookInfoIPage = bookInfoMapper.selectPage(page,wrapper);
        List<BookInfo> result = bookInfoIPage.getRecords();
        result.forEach(System.out::println);
    }

    @Test
    public void testMapper(){
        bookInfoMapper.addVisitCount(1431630596354977795L);
    }


    @Autowired
    private IBookContentService bookContentService;
    @Autowired
    private IBookCategoryService bookCategoryService;

    @Test
    public void testService(){
        List<BookCategory> list = bookCategoryService.list();
        System.out.println(list);
    }

}