private void replaceParametersInWhereClause(Object[] values, final AtomicInteger parameterIndex, Query originalQuery, Query newQuery) { // creates a clone of the original query, but rebuilds a completely new // where clause based on parameter values final List<FilterItem> items = originalQuery.getWhereClause().getItems(); int i = 0; for (FilterItem filterItem : items) { final FilterItem newFilter = copyFilterItem(filterItem, values, parameterIndex); if (filterItem != newFilter) { newQuery.getWhereClause().removeItem(i); newQuery.getWhereClause().addItem(i, newFilter); } i++; } }
private void replaceParametersInWhereClause(Object[] values, final AtomicInteger parameterIndex, Query originalQuery, Query newQuery) { // creates a clone of the original query, but rebuilds a completely new // where clause based on parameter values final List<FilterItem> items = originalQuery.getWhereClause().getItems(); int i = 0; for (FilterItem filterItem : items) { final FilterItem newFilter = copyFilterItem(filterItem, values, parameterIndex); if (filterItem != newFilter) { newQuery.getWhereClause().removeItem(i); newQuery.getWhereClause().addItem(i, newFilter); } i++; } }
@Override protected SatisfiedWhereBuilder<GroupedQueryBuilder> applyFilter(FilterItem filter) { if (_parentOrFilter == null) { _query.where(filter); } else { if (_parentOrFilter.getChildItemCount() == 1) { _query.getWhereClause().removeItem(_orFilters.get(0)); _query.getWhereClause().addItem(_parentOrFilter); } } _orFilters.add(filter); return this; }
@Override protected SatisfiedWhereBuilder<GroupedQueryBuilder> applyFilter(FilterItem filter) { if (_parentOrFilter == null) { _query.where(filter); } else { if (_parentOrFilter.getChildItemCount() == 1) { _query.getWhereClause().removeItem(_orFilters.get(0)); _query.getWhereClause().addItem(_parentOrFilter); } } _orFilters.add(filter); return this; }
private void buildParameterListInWhereClause(List<QueryParameter> parameters, Query query) { List<FilterItem> items = query.getWhereClause().getItems(); for (FilterItem item : items) { buildParameterFromFilterItem(parameters, item); } }
private void buildParameterListInWhereClause(List<QueryParameter> parameters, Query query) { List<FilterItem> items = query.getWhereClause().getItems(); for (FilterItem item : items) { buildParameterFromFilterItem(parameters, item); } }
public String rewriteQuery(Query query) { query = beforeRewrite(query); final StringBuilder sb = new StringBuilder(); sb.append(rewriteSelectClause(query, query.getSelectClause())); sb.append(rewriteFromClause(query, query.getFromClause())); sb.append(rewriteWhereClause(query, query.getWhereClause())); sb.append(rewriteGroupByClause(query, query.getGroupByClause())); sb.append(rewriteHavingClause(query, query.getHavingClause())); sb.append(rewriteOrderByClause(query, query.getOrderByClause())); return sb.toString(); }
public String rewriteQuery(Query query) { query = beforeRewrite(query); final StringBuilder sb = new StringBuilder(); sb.append(rewriteSelectClause(query, query.getSelectClause())); sb.append(rewriteFromClause(query, query.getFromClause())); sb.append(rewriteWhereClause(query, query.getWhereClause())); sb.append(rewriteGroupByClause(query, query.getGroupByClause())); sb.append(rewriteHavingClause(query, query.getHavingClause())); sb.append(rewriteOrderByClause(query, query.getOrderByClause())); return sb.toString(); }
for (FilterItem filterItem : query.getWhereClause().getItems()) { if (firstWhere) { sb.append(" WHERE ");
for (FilterItem filterItem : query.getWhereClause().getItems()) { if (firstWhere) { sb.append(" WHERE ");
if (!getScalarFunctionSelectItems(query.getWhereClause().getEvaluatedSelectItems()).isEmpty()) { return true;
if (!getScalarFunctionSelectItems(query.getWhereClause().getEvaluatedSelectItems()).isEmpty()) { return true;
&& query.getOrderByClause().isEmpty()) { final List<FilterItem> whereItems = query.getWhereClause().getItems();
&& query.getOrderByClause().isEmpty()) { final List<FilterItem> whereItems = query.getWhereClause().getItems();
&& query.getOrderByClause().isEmpty()) { final List<FilterItem> whereItems = query.getWhereClause().getItems();
&& query.getOrderByClause().isEmpty()) { final List<FilterItem> whereItems = query.getWhereClause().getItems();
final List<SelectItem> selectItems = query.getSelectClause().getItems(); final List<FromItem> fromItems = query.getFromClause().getItems(); final List<FilterItem> whereItems = query.getWhereClause().getItems(); final List<SelectItem> whereSelectItems = query.getWhereClause().getEvaluatedSelectItems(); final List<GroupByItem> groupByItems = query.getGroupByClause().getItems(); final List<SelectItem> groupBySelectItems = query.getGroupByClause().getEvaluatedSelectItems();
final List<SelectItem> selectItems = query.getSelectClause().getItems(); final List<FromItem> fromItems = query.getFromClause().getItems(); final List<FilterItem> whereItems = query.getWhereClause().getItems(); final List<SelectItem> whereSelectItems = query.getWhereClause().getEvaluatedSelectItems(); final List<GroupByItem> groupByItems = query.getGroupByClause().getItems(); final List<SelectItem> groupBySelectItems = query.getGroupByClause().getEvaluatedSelectItems();