public List<SelectItem> getEvaluatedSelectItems() { final List<SelectItem> result = new ArrayList<SelectItem>(); final List<GroupByItem> items = getItems(); for (GroupByItem item : items) { result.add(item.getSelectItem()); } return result; }
public List<SelectItem> getEvaluatedSelectItems() { final List<SelectItem> result = new ArrayList<SelectItem>(); final List<GroupByItem> items = getItems(); for (GroupByItem item : items) { result.add(item.getSelectItem()); } return result; }
protected String rewriteGroupByClause(Query query, GroupByClause groupByClause) { StringBuilder sb = new StringBuilder(); if (groupByClause.getItemCount() > 0) { sb.append(AbstractQueryClause.PREFIX_GROUP_BY); List<GroupByItem> items = groupByClause.getItems(); for (int i = 0; i < items.size(); i++) { GroupByItem item = items.get(i); if (i != 0) { sb.append(AbstractQueryClause.DELIM_COMMA); } sb.append(rewriteGroupByItem(query, item)); } } return sb.toString(); }
protected String rewriteGroupByClause(Query query, GroupByClause groupByClause) { StringBuilder sb = new StringBuilder(); if (groupByClause.getItemCount() > 0) { sb.append(AbstractQueryClause.PREFIX_GROUP_BY); List<GroupByItem> items = groupByClause.getItems(); for (int i = 0; i < items.size(); i++) { GroupByItem item = items.get(i); if (i != 0) { sb.append(AbstractQueryClause.DELIM_COMMA); } sb.append(rewriteGroupByItem(query, item)); } } return sb.toString(); }
private List<Column> getSplitColumns() { List<Column> result = new ArrayList<Column>(); if (_query.getGroupByClause().getItemCount() != 0) { List<GroupByItem> groupByItems = _query.getGroupByClause().getItems(); for (GroupByItem groupByItem : groupByItems) { Column column = groupByItem.getSelectItem().getColumn();
private List<Column> getSplitColumns() { List<Column> result = new ArrayList<Column>(); if (_query.getGroupByClause().getItemCount() != 0) { List<GroupByItem> groupByItems = _query.getGroupByClause().getItems(); for (GroupByItem groupByItem : groupByItems) { Column column = groupByItem.getSelectItem().getColumn();
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<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();
@Override public Query clone() { final Query q = new Query(); q.setMaxRows(_maxRows); q.setFirstRow(_firstRow); q.getSelectClause().setDistinct(_selectClause.isDistinct()); for (FromItem item : _fromClause.getItems()) { q.from(item.clone()); } for (SelectItem item : _selectClause.getItems()) { q.select(item.clone(q)); } for (FilterItem item : _whereClause.getItems()) { q.where(item.clone()); } for (GroupByItem item : _groupByClause.getItems()) { q.groupBy(item.clone()); } for (FilterItem item : _havingClause.getItems()) { q.having(item.clone()); } for (OrderByItem item : _orderByClause.getItems()) { q.orderBy(item.clone()); } return q; } }
@Override public Query clone() { final Query q = new Query(); q.setMaxRows(_maxRows); q.setFirstRow(_firstRow); q.getSelectClause().setDistinct(_selectClause.isDistinct()); for (FromItem item : _fromClause.getItems()) { q.from(item.clone()); } for (SelectItem item : _selectClause.getItems()) { q.select(item.clone(q)); } for (FilterItem item : _whereClause.getItems()) { q.where(item.clone()); } for (GroupByItem item : _groupByClause.getItems()) { q.groupBy(item.clone()); } for (FilterItem item : _havingClause.getItems()) { q.having(item.clone()); } for (OrderByItem item : _orderByClause.getItems()) { q.orderBy(item.clone()); } return q; } }