Please wait. This can take some minutes ...
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.blazebit.persistence.impl.query.SetOperationQuerySpecification Maven / Gradle / Ivy
/*
* Copyright 2014 - 2019 Blazebit.
*
* 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
*
* http://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.blazebit.persistence.impl.query;
import com.blazebit.persistence.impl.AbstractCommonQueryBuilder;
import com.blazebit.persistence.impl.plan.CustomSelectQueryPlan;
import com.blazebit.persistence.impl.plan.SelectQueryPlan;
import com.blazebit.persistence.spi.OrderByElement;
import com.blazebit.persistence.spi.SetOperationType;
import javax.persistence.Parameter;
import javax.persistence.Query;
import java.util.ArrayList;
import java.util.Collection;
import java.util.List;
import java.util.Map;
import java.util.Set;
/**
*
* @author Christian Beikov
* @since 1.2.0
*/
public class SetOperationQuerySpecification extends CustomQuerySpecification {
private final Query leftMostQuery;
private final List setOperands;
private final SetOperationType operator;
private final List orderByElements;
private final boolean nested;
public SetOperationQuerySpecification(AbstractCommonQueryBuilder commonQueryBuilder, Query leftMostQuery, Query baseQuery, List setOperands, SetOperationType operator,
List orderByElements, boolean nested, Set> parameters, Set parameterListNames, String limit, String offset,
List keyRestrictedLeftJoinAliases, List entityFunctionNodes, boolean recursive, List ctes, boolean shouldRenderCteNodes) {
super(commonQueryBuilder, baseQuery, parameters, parameterListNames, limit, offset, keyRestrictedLeftJoinAliases, entityFunctionNodes, recursive, ctes, shouldRenderCteNodes);
this.leftMostQuery = leftMostQuery;
this.setOperands = setOperands;
this.operator = operator;
this.orderByElements = orderByElements;
this.nested = nested;
}
@Override
public Query getBaseQuery() {
return baseQuery;
}
@Override
protected void initialize() {
String sqlQuery;
List participatingQueries = new ArrayList();
List cteQueries = new ArrayList();
bindListParameters(baseQuery);
if (leftMostQuery instanceof CustomSQLQuery) {
CustomSQLQuery customQuery = (CustomSQLQuery) leftMostQuery;
bindListParameters(leftMostQuery);
List customQueryParticipants = customQuery.getParticipatingQueries();
participatingQueries.addAll(customQueryParticipants);
sqlQuery = customQuery.getSql();
} else if (leftMostQuery instanceof CustomSQLTypedQuery) {
CustomSQLTypedQuery customQuery = (CustomSQLTypedQuery) leftMostQuery;
bindListParameters(leftMostQuery);
List customQueryParticipants = customQuery.getParticipatingQueries();
participatingQueries.addAll(customQueryParticipants);
sqlQuery = customQuery.getSql();
} else {
participatingQueries.add(baseQuery);
sqlQuery = extendedQuerySupport.getSql(em, baseQuery);
}
int size = sqlQuery.length() + 10;
List setOperands = new ArrayList();
setOperands.add(sqlQuery);
for (Query q : this.setOperands) {
String setOperandSql;
bindListParameters(q);
if (q instanceof CustomSQLQuery) {
CustomSQLQuery customQuery = (CustomSQLQuery) q;
List customQueryParticipants = customQuery.getParticipatingQueries();
participatingQueries.addAll(customQueryParticipants);
setOperandSql = customQuery.getSql();
} else if (q instanceof CustomSQLTypedQuery) {
CustomSQLTypedQuery customQuery = (CustomSQLTypedQuery) q;
List customQueryParticipants = customQuery.getParticipatingQueries();
participatingQueries.addAll(customQueryParticipants);
setOperandSql = customQuery.getSql();
} else {
setOperandSql = extendedQuerySupport.getSql(em, q);
participatingQueries.add(q);
}
setOperands.add(setOperandSql);
size += setOperandSql.length() + 30;
}
StringBuilder sqlSb = new StringBuilder(size);
dbmsDialect.appendSet(sqlSb, operator, nested, setOperands, orderByElements, limit, offset);
StringBuilder withClause = applyCtes(sqlSb, baseQuery, cteQueries);
// No limit/offset here since that has been taken care of before
Map addedCtes = dbmsDialect.appendExtendedSql(sqlSb, statementType, false, false, withClause, null, null, null, null);
cteQueries.addAll(participatingQueries);
participatingQueries = cteQueries;
this.sql = sqlSb.toString();
this.participatingQueries = participatingQueries;
this.addedCtes = addedCtes;
this.dirty = false;
}
@Override
public SelectQueryPlan createSelectPlan(int firstResult, int maxResults) {
final String sql = getSql();
return new CustomSelectQueryPlan<>(extendedQuerySupport, serviceProvider, baseQuery, participatingQueries, sql, firstResult, maxResults);
}
private void bindListParameters(Query q) {
for (Parameter parameter : q.getParameters()) {
Collection value = listParameters.get(parameter.getName());
if (value != null) {
q.setParameter((Parameter) parameter, value);
}
}
}
}