package com.sqltest.db;

import com.sqltest.base.BaseTest;
import com.sqltest.dto.UserInfoDto;
import com.sqltest.model.UserInfo;
import com.sqltest.model.UserType;
import io.github.cotide.dapper.query.Sql;
import io.github.cotide.dapper.query.enums.OrderBy;
import org.junit.Test;
import java.util.Arrays;

public class SelectLambdaTest extends BaseTest {


    @Test
    public void sqlSelectLambda() {

        Sql sql = Sql.builder().select(
                UserInfo::getId,
                UserInfo::getName)
                .from(UserInfo.class)
                .where(UserInfo::getName,"Test")
                .whereIn(UserInfo::getId,1,2)
                .order(UserInfo::getCreateTime, OrderBy.DESC);
        System.out.println("Sql语句:");
        System.out.println(sql.getFinalSql());
        System.out.println("SQL参数值:");
        sql.getFinalArgs().forEach(System.out::println);
    }


    @Test
    public void sqlSelectLambda1() {

        Sql sql = Sql.builder().select(
                UserInfo::getId)
                .from(UserInfo.class)
                .where(UserInfo::getName,"Test")
                .whereIn(UserInfo::getId,1,2)
                .order(UserInfo::getCreateTime, OrderBy.DESC);

        System.out.println("Sql语句:");
        System.out.println(sql.getFinalSql());
        System.out.println("SQL参数值:");
        sql.getFinalArgs().forEach(System.out::println);
    }

}