/**
   * 1. 名字包含雨并且年齡小于40
   * sql：name like '%雨%' and age < 40
   * <p>
   * 應(yīng)用場景：
   * 當(dāng)表字段非常多，但是你只需要查詢少數(shù)幾列,
   * 沒必要返回的泛型為實(shí)體的list，如果返回的泛型為實(shí)體,絕大多字段都是null,這樣做不優(yōu)雅
   * 用返回泛型為map建議使用
   */
  @Test
  public void selectByWrapperMaps() {
    QueryWrapper<User> queryWrapper = new QueryWrapper<>();
    queryWrapper.like("name", "雨").lt("age", 40);
    //建議使用
    List<Map<String, Object>> userList = userMapper.selectMaps(queryWrapper);
    //不建議使用
//    List<User> userList = userMapper.selectList(queryWrapper);
    userList.forEach(System.out::println);
  }
  /*
    sql形式:SELECT id,name,age,email,manager_id,create_time FROM user WHERE name LIKE ? AND age < ?
   */

  /**
   * 按照直屬上級(jí)分組，查詢每組的平均年齡。最大年齡、最小年齡。
   * 并且只取年齡總和小于500的組
   * select avg(age) avg_age,min(age) min_age,max(age) max_age from user
   * group by manager_id
   * having sum(age) < 500 ;
   */

  @Test
  public void selectByWrapperMaps2() {
    QueryWrapper<User> queryWrapper = new QueryWrapper<>();
    queryWrapper.select("avg(age) avg_age", "min(age) min_age", "max(age) max_age")
        .groupBy("manager_id")
        .having("sum(age) < {0}", 500);

    List<Map<String, Object>> userList = userMapper.selectMaps(queryWrapper);
    userList.forEach(System.out::println);
//  sql形式：SELECT avg(age) avg_age,min(age) min_age,max(age) max_age FROM user
//  GROUP BY manager_id HAVING sum(age) < ?
}