@Override public String getSql() { return extendedQuerySupport.getSql(em, query); }
String sql = extendedQuerySupport.getSql(em, baseQuery); String ownerAlias = extendedQuerySupport.getSqlAlias(em, baseQuery, entityAlias); String targetAlias = extendedQuerySupport.getSqlAlias(em, baseQuery, CollectionUpdateModificationQuerySpecification.COLLECTION_BASE_QUERY_ALIAS);
Query valuesExampleQuery = getValuesExampleQuery(clazz, valueCount, identifiableReference, valueClazzAttributeName, rootAlias, castedParameter, attributes, valuesSb, strategy, dummyTable, node); String exampleQuerySql = mainQuery.cbf.getExtendedQuerySupport().getSql(mainQuery.em, valuesExampleQuery); String exampleQuerySqlAlias = mainQuery.cbf.getExtendedQuerySupport().getSqlAlias(mainQuery.em, valuesExampleQuery, "e"); String exampleQueryCollectionSqlAlias = null; pluralTableAlias = cbf.getExtendedQuerySupport().getSqlAlias(em, baseQuery, node.getValueClazzAlias(node.getAlias() + "_")); syntheticPredicate = syntheticPredicate.replace(exampleQueryCollectionSqlAlias, pluralTableAlias); String baseQuerySql = cbf.getExtendedQuerySupport().getSql(em, baseQuery); int[] indexRange = SqlUtils.indexOfFullJoin(baseQuerySql, pluralTableAlias); String baseTableAlias = " " + valuesTableSqlAlias + " ";
@Override protected void initialize() { List<Query> participatingQueries = new ArrayList<Query>(); for (Map.Entry<String, Collection<?>> entry : listParameters.entrySet()) { baseQuery.setParameter(entry.getKey(), entry.getValue()); } String sqlQuery = extendedQuerySupport.getSql(em, baseQuery); StringBuilder sqlSb = applySqlTransformations(sqlQuery); // Need to inline LIMIT and OFFSET dbmsDialect.appendExtendedSql(sqlSb, statementType, false, true, null, limit, offset, null, null); participatingQueries.add(baseQuery); this.sql = sqlSb.toString(); this.participatingQueries = participatingQueries; this.dirty = false; }
String insertExampleSql = extendedQuerySupport.getSql(em, insertExampleQuery); String ownerAlias = extendedQuerySupport.getSqlAlias(em, insertExampleQuery, entityAlias); String targetAlias = extendedQuerySupport.getSqlAlias(em, insertExampleQuery, COLLECTION_BASE_QUERY_ALIAS);
@Override protected void initialize() { List<Query> participatingQueries = new ArrayList<Query>(); for (Map.Entry<String, Collection<?>> entry : listParameters.entrySet()) { baseQuery.setParameter(entry.getKey(), entry.getValue()); } StringBuilder sqlSb = new StringBuilder(extendedQuerySupport.getSql(em, baseQuery)); StringBuilder withClause = applyCtes(sqlSb, baseQuery, participatingQueries); // NOTE: CTEs will only be added, if this is a subquery Map<String, String> addedCtes = applyExtendedSql(sqlSb, false, false, withClause, returningColumns, null); participatingQueries.add(baseQuery); this.sql = sqlSb.toString(); this.participatingQueries = participatingQueries; this.addedCtes = addedCtes; this.dirty = false; } }
String sql = extendedQuerySupport.getSql(em, baseQuery); String ownerAlias = extendedQuerySupport.getSqlAlias(em, baseQuery, entityAlias); String targetAlias = extendedQuerySupport.getSqlAlias(em, baseQuery, CollectionDeleteModificationQuerySpecification.COLLECTION_BASE_QUERY_ALIAS);
protected void initialize() { List<Query> participatingQueries = new ArrayList<>(); for (Map.Entry<String, Collection<?>> entry : listParameters.entrySet()) { baseQuery.setParameter(entry.getKey(), entry.getValue()); } String sqlQuery = extendedQuerySupport.getSql(em, baseQuery); StringBuilder sqlSb = applySqlTransformations(sqlQuery); StringBuilder withClause = applyCtes(sqlSb, baseQuery, participatingQueries); Map<String, String> addedCtes = applyExtendedSql(sqlSb, false, false, withClause, null, null); participatingQueries.add(baseQuery); this.sql = sqlSb.toString(); this.participatingQueries = participatingQueries; this.addedCtes = addedCtes; this.dirty = false; }
private String getSql(Query query) { if (query instanceof CustomSQLQuery) { return ((CustomSQLQuery) query).getSql(); } else if (query instanceof CustomSQLTypedQuery<?>) { return ((CustomSQLTypedQuery<?>) query).getSql(); } return extendedQuerySupport.getSql(em, query); }
@Override protected void initialize() { List<Query> participatingQueries = new ArrayList<Query>(); for (Map.Entry<String, Collection<?>> entry : listParameters.entrySet()) { baseQuery.setParameter(entry.getKey(), entry.getValue()); } String sqlQuery = extendedQuerySupport.getSql(em, baseQuery); StringBuilder sqlSb = applySqlTransformations(sqlQuery); StringBuilder withClause = applyCtes(sqlSb, baseQuery, participatingQueries); // NOTE: CTEs will only be added, if this is a subquery Map<String, String> addedCtes = applyExtendedSql(sqlSb, false, isEmbedded, withClause, returningColumns, includedModificationStates); participatingQueries.add(baseQuery); // Some dbms like DB2 will need to wrap modification queries in select queries when using CTEs boolean hasCtes = withClause != null && withClause.length() != 0 || addedCtes != null && !addedCtes.isEmpty(); if (hasCtes && returningAttributeBindingMap.isEmpty() && !dbmsDialect.usesExecuteUpdateWhenWithClauseInModificationQuery()) { query = exampleQuery; } else { query = baseQuery; } this.sql = sqlSb.toString(); this.participatingQueries = participatingQueries; this.addedCtes = addedCtes; this.dirty = false; }
StringBuilder sqlSb = new StringBuilder(extendedQuerySupport.getSql(em, baseQuery));
String sql = extendedQuerySupport.getSql(em, baseQuery); StringBuilder sqlSb = applySqlTransformations(sql); if (cutoffColumns > 0) {