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; }
@Override public String toString() { return toSql(); }
@Override protected GroupByItem clone() { GroupByItem g = new GroupByItem(_selectItem.clone()); return g; }
@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; } }
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; }
@Override public String toSql() { return toSql(false); }
@Override protected GroupByItem clone() { GroupByItem g = new GroupByItem(_selectItem.clone()); return g; }
public Query groupBy(GroupByItem... items) { for (GroupByItem item : items) { SelectItem selectItem = item.getSelectItem(); if (selectItem != null && selectItem.getQuery() == null) { selectItem.setQuery(this); } } _groupByClause.addItems(items); return this; }
@Override public String toSql() { return toSql(false); }
public Query groupBy(String... groupByTokens) { for (String groupByToken : groupByTokens) { SelectItem selectItem = findSelectItem(groupByToken, true); groupBy(new GroupByItem(selectItem)); } return this; }
public Query groupBy(GroupByItem... items) { for (GroupByItem item : items) { SelectItem selectItem = item.getSelectItem(); if (selectItem != null && selectItem.getQuery() == null) { selectItem.setQuery(this); } } _groupByClause.addItems(items); return this; }
@Override public String toString() { return toSql(); }
public Query groupBy(String... groupByTokens) { for (String groupByToken : groupByTokens) { SelectItem selectItem = findSelectItem(groupByToken, true); groupBy(new GroupByItem(selectItem)); } return this; }
groupByItems.stream().map(gbi -> gbi.getSelectItem()).collect(Collectors.toList()); final DataSetHeader groupByHeader = new CachingDataSetHeader(groupBySelects);
protected String rewriteGroupByItem(Query query, GroupByItem item) { return item.toSql(isSchemaIncludedInColumnPaths()); }
public Query groupBy(Column... columns) { for (Column column : columns) { SelectItem selectItem = new SelectItem(column).setQuery(this); _groupByClause.addItem(new GroupByItem(selectItem)); } return this; }
groupByItems.stream().map(gbi -> gbi.getSelectItem()).collect(Collectors.toList()); final DataSetHeader groupByHeader = new CachingDataSetHeader(groupBySelects);
protected String rewriteGroupByItem(Query query, GroupByItem item) { return item.toSql(isSchemaIncludedInColumnPaths()); }
public Query groupBy(Column... columns) { for (Column column : columns) { SelectItem selectItem = new SelectItem(column).setQuery(this); _groupByClause.addItem(new GroupByItem(selectItem)); } return this; }