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.UpdateModificationQuerySpecification Maven / Gradle / Ivy
/*
* Copyright 2014 - 2020 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.ReturningObjectBuilder;
import com.blazebit.persistence.impl.AbstractCommonQueryBuilder;
import com.blazebit.persistence.impl.util.SqlUtils;
import com.blazebit.persistence.spi.DbmsModificationState;
import com.blazebit.persistence.spi.UpdateJoinStyle;
import javax.persistence.Parameter;
import javax.persistence.Query;
import java.util.ArrayList;
import java.util.Arrays;
import java.util.Collection;
import java.util.List;
import java.util.Map;
import java.util.Set;
/**
*
* @author Christian Beikov
* @since 1.5.0
*/
public class UpdateModificationQuerySpecification extends ModificationQuerySpecification {
private final String tableToUpdate;
private final String tableAlias;
private final String[] idColumns;
private final List setColumns;
private final Map aliasMapping;
private final Query updateExampleQuery;
public UpdateModificationQuerySpecification(AbstractCommonQueryBuilder commonQueryBuilder, Query baseQuery, Query exampleQuery, Set> parameters, Set parameterListNames, boolean recursive, List ctes, boolean shouldRenderCteNodes,
boolean isEmbedded, String[] returningColumns, ReturningObjectBuilder objectBuilder, Map includedModificationStates, Map returningAttributeBindingMap, boolean queryPlanCacheEnabled,
String tableToUpdate, String tableAlias, String[] idColumns, List setColumns, Map aliasMapping, Query updateExampleQuery) {
super(commonQueryBuilder, baseQuery, exampleQuery, parameters, parameterListNames, recursive, ctes, shouldRenderCteNodes, isEmbedded, returningColumns, objectBuilder, includedModificationStates, returningAttributeBindingMap, queryPlanCacheEnabled);
this.tableToUpdate = tableToUpdate;
this.tableAlias = tableAlias;
this.idColumns = idColumns;
this.setColumns = setColumns;
this.aliasMapping = aliasMapping;
this.updateExampleQuery = updateExampleQuery;
}
@Override
protected void initialize() {
List participatingQueries = new ArrayList<>();
for (Map.Entry> entry : listParameters.entrySet()) {
baseQuery.setParameter(entry.getKey(), entry.getValue());
}
String sql = extendedQuerySupport.getSql(em, baseQuery);
StringBuilder sb = new StringBuilder(sql.length());
String tableToUpdate = this.tableToUpdate;
if (SqlUtils.indexOfSelect(sql) == -1) {
// Plain update statement without joins
sb.append(sql);
tableToUpdate = sql.substring(sql.indexOf(' ') + 1, sql.indexOf(' ', sql.indexOf(' ') + 1));
} else {
int fromIndex = SqlUtils.indexOfFrom(sql);
int groupByIndex;
switch (dbmsDialect.getUpdateJoinStyle()) {
case FROM:
case FROM_ALIAS:
sb.append("update ");
if (dbmsDialect.getUpdateJoinStyle() == UpdateJoinStyle.FROM_ALIAS) {
sb.append(tableAlias);
} else {
sb.append(tableToUpdate);
}
sb.append(" set ");
applySetClause(sb, Arrays.asList(SqlUtils.getSelectItemExpressions(sql, 0)));
sb.append(sql, fromIndex, sql.length());
if (dbmsDialect.getUpdateJoinStyle() == UpdateJoinStyle.FROM) {
sb.append(" and ").append(tableToUpdate).append('.').append(idColumns[0]).append(" = ").append(tableAlias).append(".").append(idColumns[0]);
for (int i = 1; i < idColumns.length; i++) {
String idColumn = idColumns[i];
sb.append(" and ").append(tableToUpdate).append('.').append(idColumn).append(" = ").append(tableAlias).append(".").append(idColumns[i]);
}
}
break;
case REFERENCE:
groupByIndex = SqlUtils.indexOfGroupBy(sql, fromIndex);
sb.append("update ");
sb.append(tableToUpdate);
sb.append(", (select ");
for (Map.Entry entry : aliasMapping.entrySet()) {
sb.append(entry.getKey()).append(" as ").append(entry.getValue(), entry.getValue().indexOf('.') + 1, entry.getValue().length()).append(", ");
}
sb.setLength(sb.length() - 2);
sb.append(sql, fromIndex, groupByIndex);
sb.append(") tmp ");
sb.append("set ");
applySetClause(sb, SqlUtils.getExpressionItems(sql, groupByIndex + SqlUtils.GROUP_BY.length(), sql.length()));
sb.append(" where ");
sb.append(tableToUpdate).append('.').append(idColumns[0]).append(" = tmp.c0");
for (int i = 1; i < idColumns.length; i++) {
String idColumn = idColumns[i];
sb.append(" and ").append(tableToUpdate).append('.').append(idColumn).append(" = tmp.c").append(i);
}
break;
case MERGE:
groupByIndex = SqlUtils.indexOfGroupBy(sql, fromIndex);
sb.append("merge into ");
sb.append(tableToUpdate);
sb.append(" using (select ");
for (Map.Entry entry : aliasMapping.entrySet()) {
sb.append(entry.getKey()).append(" as ").append(entry.getValue(), entry.getValue().indexOf('.') + 1, entry.getValue().length()).append(", ");
}
sb.setLength(sb.length() - 2);
sb.append(sql, fromIndex, groupByIndex);
sb.append(") tmp on (");
sb.append(tableToUpdate).append('.').append(idColumns[0]).append(" = tmp.c0");
for (int i = 1; i < idColumns.length; i++) {
String idColumn = idColumns[i];
sb.append(" and ").append(tableToUpdate).append('.').append(idColumn).append(" = tmp.c").append(i);
}
sb.append(") when matched then update set ");
applySetClause(sb, SqlUtils.getExpressionItems(sql, groupByIndex + SqlUtils.GROUP_BY.length(), sql.length()));
break;
default:
throw new UnsupportedOperationException("Unsupported update join style: " + dbmsDialect.getUpdateJoinStyle());
}
}
StringBuilder withClause = applyCtes(sb, baseQuery, participatingQueries);
// NOTE: CTEs will only be added, if this is a subquery
Map addedCtes = applyExtendedSql(sb, false, isEmbedded, withClause, tableToUpdate, returningColumns, includedModificationStates);
participatingQueries.add(baseQuery);
boolean hasCtes = withClause != null && withClause.length() != 0 || addedCtes != null && !addedCtes.isEmpty();
if (hasCtes && returningAttributeBindingMap.isEmpty() && !dbmsDialect.usesExecuteUpdateWhenWithClauseInModificationQuery()) {
query = exampleQuery;
} else {
query = updateExampleQuery;
}
this.sql = sb.toString();
this.participatingQueries = participatingQueries;
this.addedCtes = addedCtes;
this.dirty = false;
}
private void applySetClause(StringBuilder sb, List selectItemExpressions) {
for (int i = 0; i < selectItemExpressions.size(); i++) {
if (i != 0) {
sb.append(", ");
}
String item = selectItemExpressions.get(i);
sb.append(setColumns.get(i)).append(" = ");
sb.append(item, item.indexOf('=') + 1, item.lastIndexOf(" then "));
}
}
}
