com.diboot.core.binding.JoinsBinder Maven / Gradle / Ivy
Show all versions of diboot-core Show documentation
/*
* Copyright (c) 2015-2020, www.dibo.ltd ([email protected]).
*
* Licensed under the Apache License, Version 2.0 (the "License"); you may not
* use this file except in compliance with the License. You may obtain a copy of
* the License at
*
* https://www.apache.org/licenses/LICENSE-2.0
*
* Unless required by applicable law or agreed to in writing, software
* distributed under the License is distributed on an "AS IS" BASIS, WITHOUT
* WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. See the
* License for the specific language governing permissions and limitations under
* the License.
*/
package com.diboot.core.binding;
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.baomidou.mybatisplus.extension.service.IService;
import com.diboot.core.binding.helper.ServiceAdaptor;
import com.diboot.core.binding.parser.ParserCache;
import com.diboot.core.binding.query.dynamic.AnnoJoiner;
import com.diboot.core.binding.query.dynamic.DynamicJoinQueryWrapper;
import com.diboot.core.binding.query.dynamic.DynamicSqlProvider;
import com.diboot.core.config.BaseConfig;
import com.diboot.core.exception.InvalidUsageException;
import com.diboot.core.mapper.DynamicQueryMapper;
import com.diboot.core.util.BeanUtils;
import com.diboot.core.util.ContextHolder;
import com.diboot.core.util.S;
import com.diboot.core.util.V;
import com.diboot.core.vo.Pagination;
import lombok.extern.slf4j.Slf4j;
import java.lang.reflect.Field;
import java.util.*;
/**
* join连接查询绑定器
* @author [email protected]
* @version v2.1
* @date 2020/04/15
*/
@Slf4j
public class JoinsBinder {
/**
* 关联查询一条数据
* @param queryWrapper
* @param entityClazz 返回结果entity/vo类
* @return
* @throws Exception
*/
public static T queryOne(QueryWrapper queryWrapper, Class entityClazz){
List list = executeJoinQuery(queryWrapper, entityClazz, null, true);
if(V.notEmpty(list)){
return list.get(0);
}
return null;
}
/**
* 关联查询符合条件的全部数据集合（不分页）
* @param queryWrapper 调用QueryBuilder.to*QueryWrapper得到的实例
* @param entityClazz 返回结果entity/vo类
* @return
* @throws Exception
*/
public static List queryList(QueryWrapper queryWrapper, Class entityClazz){
return queryList(queryWrapper, entityClazz, null);
}
/**
* 关联查询符合条件的指定页数据（分页）
* @param queryWrapper 调用QueryBuilder.to*QueryWrapper得到的实例
* @param entityClazz 返回结果entity/vo类
* @param pagination 分页
* @return
* @throws Exception
*/
public static List queryList(QueryWrapper queryWrapper, Class entityClazz, Pagination pagination){
return executeJoinQuery(queryWrapper, entityClazz, pagination, false);
}
/**
* 关联查询符合条件的指定页数据（分页）
* @param queryWrapper 调用QueryBuilder.to*QueryWrapper得到的实例
* @param entityClazz 返回结果entity/vo类
* @param page 分页
* @return
* @throws Exception
*/
public static IPage queryPage(QueryWrapper queryWrapper, Class entityClazz, Page page){
return executeJoinQueryPage(queryWrapper, entityClazz, page, false);
}
/**
* 关联查询符合条件的指定页数据（分页）
* @param queryWrapper 调用QueryBuilder.to*QueryWrapper得到的实例
* @param entityClazz 返回结果entity/vo类
* @param page 分页
* @return
* @throws Exception
*/
public static IPage> queryMapsPage(QueryWrapper queryWrapper, Class entityClazz, Page page){
return executeJoinQueryMapsPage(queryWrapper, entityClazz, page, false);
}
/**
* 关联查询（分页）
* @param queryWrapper 调用QueryBuilder.to*QueryWrapper得到的实例
* @param entityClazz 返回结果entity/vo类
* @param pagination 分页
* @return
* @throws Exception
*/
private static List executeJoinQuery(QueryWrapper queryWrapper, Class entityClazz, Pagination pagination, boolean limit1){
// 非动态查询，走BaseService
if(!(queryWrapper instanceof DynamicJoinQueryWrapper)){
IService iService = ContextHolder.getIServiceByEntity(entityClazz);
if(iService != null){
return ServiceAdaptor.queryList(iService, (QueryWrapper)queryWrapper, pagination, entityClazz);
}
else{
throw new InvalidUsageException("exception.invalidUsage.joinsBinder.executeJoinQuery.message", entityClazz.getSimpleName());
}
}
long begin = System.currentTimeMillis();
// 转换为queryWrapper
DynamicJoinQueryWrapper dynamicJoinWrapper = (DynamicJoinQueryWrapper)queryWrapper;
dynamicJoinWrapper.setMainEntityClass(entityClazz);
List> mapList;
if(pagination == null){
if(limit1){
Page page = new Page<>(1, 1);
page.setSearchCount(false);
IPage> pageResult = getDynamicQueryMapper().queryForListWithPage(page, dynamicJoinWrapper);
mapList = pageResult.getRecords();
}
else{
mapList = getDynamicQueryMapper().queryForList(dynamicJoinWrapper);
}
}
else{
// 格式化orderBy
String originOrderBy = pagination.getOrderBy();
formatOrderBy(dynamicJoinWrapper, entityClazz, pagination);
IPage> pageResult = getDynamicQueryMapper().queryForListWithPage(pagination.toPage(entityClazz), dynamicJoinWrapper);
pagination.setTotalCount(pageResult.getTotal());
// 还原orderBy
pagination.setOrderBy(originOrderBy);
mapList = pageResult.getRecords();
}
long ms = (System.currentTimeMillis() - begin);
if(ms > 5000){
log.warn("{} 动态Join查询执行耗时 {} ms，建议优化", dynamicJoinWrapper.getDtoClass().getSimpleName(), ms);
}
if(V.isEmpty(mapList)){
return Collections.emptyList();
}
if(mapList.size() > BaseConfig.getBatchSize()){
log.warn("{} 动态Join查询记录数过大( {} 条), 建议优化", dynamicJoinWrapper.getDtoClass().getSimpleName(), mapList.size());
}
// 转换查询结果
List entityList = new ArrayList<>();
for(Map colValueMap : mapList){
Map fieldValueMap = new HashMap<>();
// 格式化map
for(Map.Entry entry : colValueMap.entrySet()){
if(entry.getKey().endsWith(DynamicSqlProvider.PLACEHOLDER_COLUMN_FLAG)) {
log.debug("忽略查询占位字段 {}", entry.getKey());
continue;
}
String fieldName = S.toLowerCaseCamel(entry.getKey());
// 如果是布尔类型，检查entity中的定义是Boolean/boolean
if(entry.getValue() instanceof Boolean && S.startsWithIgnoreCase(entry.getKey(),"is_")){
// 检查有is前缀的Boolean类型
Field boolType = BeanUtils.extractField(entityClazz, fieldName);
if(boolType == null){
// 检查无is前缀的boolean类型
String tempFieldName = S.toLowerCaseCamel(S.substringAfter(entry.getKey(), "_"));
boolType = BeanUtils.extractField(entityClazz, tempFieldName);
if(boolType != null){
fieldName = tempFieldName;
}
}
}
fieldValueMap.put(fieldName, entry.getValue());
}
// 绑定map到entity
try{
T entityInst = entityClazz.newInstance();
BeanUtils.bindProperties(entityInst, fieldValueMap);
entityList.add(entityInst);
}
catch (Exception e){
log.warn("new实例并绑定属性值异常", e);
}
}
return entityList;
}
/**
* 关联查询（分页）
* @param queryWrapper 调用QueryBuilder.to*QueryWrapper得到的实例
* @param entityClazz 返回结果entity/vo类
* @param page 分页
* @return
* @throws Exception
*/
private static IPage executeJoinQueryPage(QueryWrapper queryWrapper, Class entityClazz, Page page, boolean limit1){
IPage result;
// 非动态查询，走BaseService
if(queryWrapper instanceof DynamicJoinQueryWrapper == false){
IService iService = ContextHolder.getIServiceByEntity(entityClazz);
if(iService != null){
return ServiceAdaptor.queryListPage(iService, (QueryWrapper)queryWrapper, page, entityClazz);
}
else{
throw new InvalidUsageException("单表查询对象无BaseService/IService实现: "+entityClazz.getSimpleName());
}
}
long begin = System.currentTimeMillis();
// 转换为queryWrapper
DynamicJoinQueryWrapper dynamicJoinWrapper = (DynamicJoinQueryWrapper)queryWrapper;
dynamicJoinWrapper.setMainEntityClass(entityClazz);
if (page ==null) {
if(limit1){
page = new Page<>(1, 1, false);
} else {
page = new Page<>(1, -1, false);
}
}
IPage> pageResult = getDynamicQueryMapper().queryForListWithPage(page, dynamicJoinWrapper);
result = pageResult.convert( colValueMap -> {
Map fieldValueMap = new HashMap<>();
// 格式化map
for(Map.Entry entry : colValueMap.entrySet()){
if(entry.getKey().endsWith(DynamicSqlProvider.PLACEHOLDER_COLUMN_FLAG)) {
log.debug("忽略查询占位字段 {}", entry.getKey());
continue;
}
String fieldName = S.toLowerCaseCamel(entry.getKey());
// 如果是布尔类型，检查entity中的定义是Boolean/boolean
if(entry.getValue() instanceof Boolean && S.startsWithIgnoreCase(entry.getKey(),"is_")){
// 检查有is前缀的Boolean类型
Field boolType = BeanUtils.extractField(entityClazz, fieldName);
if(boolType == null){
// 检查无is前缀的boolean类型
String tempFieldName = S.toLowerCaseCamel(S.substringAfter(entry.getKey(), "_"));
boolType = BeanUtils.extractField(entityClazz, tempFieldName);
if(boolType != null){
fieldName = tempFieldName;
}
}
}
fieldValueMap.put(fieldName, entry.getValue());
}
try{
T entityInst = entityClazz.newInstance();
BeanUtils.bindProperties(entityInst, fieldValueMap);
return entityInst;
}
catch (Exception e){
log.warn("new实例并绑定属性值异常", e);
}
return null;
});
long ms = (System.currentTimeMillis() - begin);
if(ms > 5000){
log.warn("{} 动态Join查询执行耗时 {} ms，建议优化", dynamicJoinWrapper.getDtoClass().getSimpleName(), ms);
}
if(result.getRecords().size() > BaseConfig.getBatchSize()){
log.warn("{} 动态Join查询记录数过大( {} 条), 建议优化", dynamicJoinWrapper.getDtoClass().getSimpleName(), result.getRecords().size());
}
return result ;
}
/**
* 关联查询（分页）
* @param queryWrapper 调用QueryBuilder.to*QueryWrapper得到的实例
* @param entityClazz 返回结果entity/vo类
* @param page 分页
* @return
* @throws Exception
*/
private static IPage> executeJoinQueryMapsPage(QueryWrapper queryWrapper, Class entityClazz, Page page, boolean limit1){
// 非动态查询，走BaseService
if(queryWrapper instanceof DynamicJoinQueryWrapper == false){
IService iService = ContextHolder.getIServiceByEntity(entityClazz);
if(iService != null){
return ServiceAdaptor.queryMapsPage(iService, (QueryWrapper)queryWrapper, page, entityClazz);
}
else{
throw new InvalidUsageException("单表查询对象无BaseService/IService实现: "+entityClazz.getSimpleName());
}
}
long begin = System.currentTimeMillis();
// 转换为queryWrapper
DynamicJoinQueryWrapper dynamicJoinWrapper = (DynamicJoinQueryWrapper)queryWrapper;
dynamicJoinWrapper.setMainEntityClass(entityClazz);
if (page ==null) {
if(limit1){
page = new Page<>(1, 1, false);
} else {
page = new Page<>(1, -1, false);
}
}
IPage> pageResult = getDynamicQueryMapper().queryForListWithPage(page, dynamicJoinWrapper);
long ms = (System.currentTimeMillis() - begin);
if(ms > 5000){
log.warn("{} 动态Join查询执行耗时 {} ms，建议优化", dynamicJoinWrapper.getDtoClass().getSimpleName(), ms);
}
if(pageResult.getRecords().size() > BaseConfig.getBatchSize()){
log.warn("{} 动态Join查询记录数过大( {} 条), 建议优化", dynamicJoinWrapper.getDtoClass().getSimpleName(), pageResult.getRecords().size());
}
return pageResult ;
}
/**
* 格式化orderBy
* @param queryWrapper
* @param pagination
*/
private static void formatOrderBy(DynamicJoinQueryWrapper queryWrapper, Class entityClazz, Pagination pagination){
// 格式化排序
if(V.notEmpty(pagination.getOrderBy())){
List orderByList = new ArrayList<>();
String[] orderByFields = S.split(pagination.getOrderBy());
for(String field : orderByFields){
String fieldName = field, orderType = null;
if(field.contains(":")){
String[] fieldAndOrder = S.split(field, ":");
fieldName = fieldAndOrder[0];
orderType = fieldAndOrder[1];
}
// 获取列定义的AnnoJoiner 得到别名
List joinerList = ParserCache.getAnnoJoiners(queryWrapper.getDtoClass(), Collections.singletonList(fieldName));
if (joinerList.isEmpty()) {
fieldName = "self." + S.toSnakeCase(fieldName);
orderByList.add(V.isEmpty(orderType) ? fieldName : fieldName + ":" + orderType);
} else {
for (AnnoJoiner annoJoiner : joinerList) {
if (V.notEmpty(annoJoiner.getAlias())) {
fieldName = annoJoiner.getAlias() + "." + annoJoiner.getColumnName();
} else {
fieldName = "self." + annoJoiner.getColumnName();
}
orderByList.add(V.isEmpty(orderType) ? fieldName : fieldName + ":" + orderType);
}
}
}
pagination.setOrderBy(S.join(orderByList));
}
}
/**
* 获取mapper实例
* @return
*/
private static DynamicQueryMapper getDynamicQueryMapper(){
return ContextHolder.getBean(DynamicQueryMapper.class);
}
}