• Home
• com.easy-query
• sql-api-proxy
• 2.3.3
• source code
• EasySelectManyQueryable.java

×

Project download

Many resources are needed to download a project. Please understand that we have to compensate our server costs. Thank you in advance.
Project price only 1 $

You can buy this project and download/modify it how often you want.

com.easy.query.api.proxy.entity.select.impl.EasySelectManyQueryable Maven / Gradle / Ivy

//package com.easy.query.api.proxy.entity.select.impl;
//
//import com.easy.query.api.proxy.base.ListProxy;
//import com.easy.query.api.proxy.entity.select.EntityQueryable;
//import com.easy.query.api.proxy.entity.select.EntityQueryable2;
//import com.easy.query.api.proxy.sql.ProxyFilter;
//import com.easy.query.api.proxy.sql.ProxySelector;
//import com.easy.query.core.api.dynamic.sort.ObjectSort;
//import com.easy.query.core.api.pagination.EasyPageResult;
//import com.easy.query.core.basic.api.select.ClientQueryable;
//import com.easy.query.core.basic.api.select.Query;
//import com.easy.query.core.basic.jdbc.executor.internal.enumerable.DraftResult;
//import com.easy.query.core.basic.jdbc.executor.internal.enumerable.JdbcStreamResult;
//import com.easy.query.core.basic.jdbc.parameter.ToSQLContext;
//import com.easy.query.core.basic.pagination.EasyPageResultProvider;
//import com.easy.query.core.context.QueryRuntimeContext;
//import com.easy.query.core.enums.sharding.ConnectionModeEnum;
//import com.easy.query.core.expression.builder.core.ValueFilter;
//import com.easy.query.core.expression.lambda.Property;
//import com.easy.query.core.expression.lambda.SQLConsumer;
//import com.easy.query.core.expression.lambda.SQLExpression1;
//import com.easy.query.core.expression.lambda.SQLExpression2;
//import com.easy.query.core.expression.lambda.SQLFuncExpression1;
//import com.easy.query.core.expression.parser.core.base.tree.TreeCTEConfigurer;
//import com.easy.query.core.expression.segment.ColumnSegment;
//import com.easy.query.core.expression.sql.builder.EntityQueryExpressionBuilder;
//import com.easy.query.core.expression.sql.builder.ExpressionContext;
//import com.easy.query.core.metadata.EntityMetadata;
//import com.easy.query.core.metadata.EntityMetadataManager;
//import com.easy.query.core.metadata.NavigateMetadata;
//import com.easy.query.core.proxy.PropTypeColumn;
//import com.easy.query.core.proxy.ProxyEntity;
//import com.easy.query.core.proxy.ProxyEntityAvailable;
//import com.easy.query.core.proxy.SQLColumn;
//import com.easy.query.core.proxy.SQLGroupByExpression;
//import com.easy.query.core.proxy.SQLSelectAsExpression;
//import com.easy.query.core.proxy.SQLSelectExpression;
//import com.easy.query.core.proxy.columns.SQLQueryable;
//import com.easy.query.core.proxy.core.draft.DraftFetcher;
//import com.easy.query.core.util.EasyObjectUtil;
//import com.easy.query.core.util.EasySQLExpressionUtil;
//import com.easy.query.core.util.EasyStringUtil;
//
//import java.math.BigDecimal;
//import java.sql.Statement;
//import java.util.ArrayList;
//import java.util.Collection;
//import java.util.Iterator;
//import java.util.List;
//import java.util.Map;
//import java.util.Objects;
//import java.util.function.Function;
//import java.util.function.Supplier;
//import java.util.stream.Collectors;
//
///**
// * create time 2024/2/24 21:53
// * 文件说明
// *
// * @author xuejiaming
// */
//public class EasySelectManyQueryable, TEntity> implements EntityQueryable, List> {
//
//    private final ClientQueryable queryable;
//    private final ListProxy listProxy;
//    private final String navValue;
//    private final NavigateMetadata navigateMetadata;
//    private final QueryRuntimeContext runtimeContext;
//    private final Property navigateGetter;
//
//    public EasySelectManyQueryable(ClientQueryable queryable, ListProxy listProxy, String navValue) {
//
//        this.listProxy = listProxy;
//        this.navValue = navValue;
//        this.runtimeContext = queryable.getSQLEntityExpressionBuilder().getRuntimeContext();
//        EntityMetadata entityMetadata = listProxy.getSqlQueryable().getOriginalTable().getEntityMetadata();
//        if (Objects.equals(entityMetadata.getEntityClass(), queryable.queryClass())) {
//            selectAutoInclude0(runtimeContext.getEntityMetadataManager(), queryable, entityMetadata, navValue);
//            this.navigateMetadata = entityMetadata.getNavigateNotNull(navValue);
//            this.navigateGetter = this.navigateMetadata.getGetter();
//            this.queryable = queryable;
//        } else {
//            ExpressionContext expressionContext = queryable.getSQLEntityExpressionBuilder().getExpressionContext();
//            //如果没有include默认include
//            if (!expressionContext.hasIncludes()) {
//                EntityMetadataManager entityMetadataManager = runtimeContext.getEntityMetadataManager();
//                EntityMetadata queryEntityMetadata = runtimeContext.getEntityMetadataManager().getEntityMetadata(queryable.queryClass());
//                String[] navValueSplit = navValue.split("\\.");
//                String firstNavValue = navValueSplit[0];
//                NavigateMetadata currentNavigateMetadata = queryEntityMetadata.getNavigateNotNull(firstNavValue);
//                EntityMetadata currentEntityMetadata = entityMetadataManager.getEntityMetadata(currentNavigateMetadata.getNavigatePropertyType());
//                for (int i = 1; i < navValueSplit.length - 1; i++) {
//                    String currentNavValue = navValueSplit[i];
//                    currentNavigateMetadata = currentEntityMetadata.getNavigateNotNull(currentNavValue);
//                    currentEntityMetadata = entityMetadataManager.getEntityMetadata(currentNavigateMetadata.getNavigatePropertyType());
//                }
//                String targetPropertyOrPrimary = currentNavigateMetadata.getTargetPropertyOrPrimary(runtimeContext);
//                NavigateMetadata navigateMetadataResult = currentEntityMetadata.getNavigateNotNull(navValueSplit[navValueSplit.length - 1]);
//                this.navigateMetadata = navigateMetadataResult;
//                this.navigateGetter = navigateMetadataResult.getGetter();
//                EntityQueryExpressionBuilder sqlEntityExpressionBuilder = queryable.getSQLEntityExpressionBuilder();
//                NavigateMetadata finalCurrentNavigateMetadata = currentNavigateMetadata;
//                this.queryable = queryable.select(currentEntityMetadata.getEntityClass(), o -> {
//                            o.getAsSelector().column(listProxy.getSqlQueryable().getOriginalTable(), targetPropertyOrPrimary);
//                            //todo include
//                            EasySQLExpressionUtil.appendTargetExtraTargetProperty(finalCurrentNavigateMetadata,sqlEntityExpressionBuilder,o.getAsSelector(),listProxy.getSqlQueryable().getOriginalTable());
//
//                        })
//                        .include(t -> t.with(navValueSplit[navValueSplit.length - 1]));
//            } else {
//                //如果存在include那么就只能一张表一张表走
//                EntityMetadataManager entityMetadataManager = runtimeContext.getEntityMetadataManager();
//                EntityMetadata queryEntityMetadata = runtimeContext.getEntityMetadataManager().getEntityMetadata(queryable.queryClass());
//                String[] navValueSplit = navValue.split("\\.");
//                String firstNavValue = navValueSplit[0];
//                NavigateMetadata currentNavigateMetadata = queryEntityMetadata.getNavigateNotNull(firstNavValue);
//                EntityMetadata currentEntityMetadata = entityMetadataManager.getEntityMetadata(currentNavigateMetadata.getNavigatePropertyType());
//                List> replyExpressions = new ArrayList<>();
//                replyExpressions.add(currentNavigateMetadata.getGetter());
//                for (int i = 1; i < navValueSplit.length - 1; i++) {
//                    String currentNavValue = navValueSplit[i];
//                    currentNavigateMetadata = currentEntityMetadata.getNavigateNotNull(currentNavValue);
//                    currentEntityMetadata = entityMetadataManager.getEntityMetadata(currentNavigateMetadata.getNavigatePropertyType());
//                    replyExpressions.add(currentNavigateMetadata.getGetter());
//                }
//                NavigateMetadata navigateMetadataResult = currentEntityMetadata.getNavigateNotNull(navValueSplit[navValueSplit.length - 1]);
//                replyExpressions.add(navigateMetadataResult.getGetter());
//                this.navigateMetadata = navigateMetadataResult;
//                this.navigateGetter = obj -> {
//                    if (obj == null) {
//                        return null;
//                    }
//                    Iterator> iterator = replyExpressions.iterator();
//                    Property first = iterator.next();
//                    Object value = first.apply(obj);
//                    while (iterator.hasNext()) {
//                        if (value != null) {
//                            value = iterator.next().apply(value);
//                        } else {
//                            return null;
//                        }
//                    }
//                    return value;
//                };
//                this.queryable = queryable;
//            }
//        }
//    }
//
//    private void selectAutoInclude0(EntityMetadataManager entityMetadataManager, ClientQueryable clientQueryable, EntityMetadata entityMetadata, String navigateProperties) {
//        if (EasyStringUtil.isBlank(navigateProperties)) {
//            return;
//        }
//        int i = navigateProperties.indexOf(".");
//        String navigateProperty = i >= 0 ? navigateProperties.substring(0, i) : navigateProperties;
//        String nextNavigateProperty = i >= 0 ? navigateProperties.substring(i + 1) : null;
//
//
//        clientQueryable
//                .include(t -> {
//                    ClientQueryable