public List<SelectItem> getEvaluatedSelectItems() { final List<FilterItem> items = getItems(); return MetaModelHelper.getEvaluatedSelectItems(items); }
@Override public String toSql() { return "DELETE FROM " + _table.getQualifiedLabel() + new FilterClause(null, " WHERE ").addItems(_whereItems); } }
protected String rewriteHavingClause(Query query, FilterClause havingClause) { StringBuilder sb = new StringBuilder(); if (havingClause.getItemCount() > 0) { sb.append(AbstractQueryClause.PREFIX_HAVING); List<FilterItem> items = havingClause.getItems(); for (int i = 0; i < items.size(); i++) { FilterItem item = items.get(i); if (i != 0) { sb.append(AbstractQueryClause.DELIM_AND); } sb.append(rewriteFilterItem(item)); } } return sb.toString(); }
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++; } }
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> havingSelectItems = query.getHavingClause().getEvaluatedSelectItems(); final List<SelectItem> orderBySelectItems = query.getOrderByClause().getEvaluatedSelectItems(); final List<FilterItem> havingItems = query.getHavingClause().getItems(); final List<OrderByItem> orderByItems = query.getOrderByClause().getItems();
@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; }
public Query where(FilterItem... items) { _whereClause.addItems(items); return this; }
public Query() { _selectClause = new SelectClause(this); _fromClause = new FromClause(this); _whereClause = new FilterClause(this, AbstractQueryClause.PREFIX_WHERE); _groupByClause = new GroupByClause(this); _havingClause = new FilterClause(this, AbstractQueryClause.PREFIX_HAVING); _orderByClause = new OrderByClause(this); }
if (!getScalarFunctionSelectItems(query.getWhereClause().getEvaluatedSelectItems()).isEmpty()) { return true; if (!getScalarFunctionSelectItems(query.getHavingClause().getEvaluatedSelectItems()).isEmpty()) { return true;
protected String rewriteWhereClause(Query query, FilterClause whereClause) { StringBuilder sb = new StringBuilder(); if (whereClause.getItemCount() > 0) { sb.append(AbstractQueryClause.PREFIX_WHERE); List<FilterItem> items = whereClause.getItems(); for (int i = 0; i < items.size(); i++) { FilterItem item = items.get(i); if (i != 0) { sb.append(AbstractQueryClause.DELIM_AND); } sb.append(rewriteFilterItem(item)); } } return sb.toString(); }
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++; } }
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> havingSelectItems = query.getHavingClause().getEvaluatedSelectItems(); final List<SelectItem> orderBySelectItems = query.getOrderByClause().getEvaluatedSelectItems(); final List<FilterItem> havingItems = query.getHavingClause().getItems(); final List<OrderByItem> orderByItems = query.getOrderByClause().getItems();
@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; }
public Query having(FilterItem... items) { _havingClause.addItems(items); return this; }
public Query() { _selectClause = new SelectClause(this); _fromClause = new FromClause(this); _whereClause = new FilterClause(this, AbstractQueryClause.PREFIX_WHERE); _groupByClause = new GroupByClause(this); _havingClause = new FilterClause(this, AbstractQueryClause.PREFIX_HAVING); _orderByClause = new OrderByClause(this); }
if (!getScalarFunctionSelectItems(query.getWhereClause().getEvaluatedSelectItems()).isEmpty()) { return true; if (!getScalarFunctionSelectItems(query.getHavingClause().getEvaluatedSelectItems()).isEmpty()) { return true;
public List<SelectItem> getEvaluatedSelectItems() { final List<FilterItem> items = getItems(); return MetaModelHelper.getEvaluatedSelectItems(items); }