public List<SelectItem> getEvaluatedSelectItems() { final List<SelectItem> result = new ArrayList<SelectItem>(); final List<OrderByItem> items = getItems(); for (OrderByItem item : items) { result.add(item.getSelectItem()); } return result; }
@Override public String toString() { return toSql(); } }
@Override protected OrderByItem clone() { OrderByItem o = new OrderByItem(_selectItem.clone()); o._direction = _direction; return o; }
final SelectItem selectItem = orderByItem.getSelectItem(); validateSoqlSupportedSelectItem(selectItem); sb.append(column.getName()); sb.append(' '); sb.append(orderByItem.getDirection());
@Override public GroupedQueryBuilder asc() { orderByitem.setDirection(Direction.ASC); return getQueryBuilder(); }
public int compare(Row o1, Row o2) { for (int i = 0; i < sortIndexes.length; i++) { int sortIndex = sortIndexes[i]; Object sortObj1 = o1.getValue(sortIndex); Object sortObj2 = o2.getValue(sortIndex); int compare = valueComparator.compare(sortObj1, sortObj2); if (compare != 0) { OrderByItem orderByItem = orderByItems[i]; boolean ascending = orderByItem.isAscending(); if (ascending) { return compare; } else { return compare * -1; } } } return 0; } };
@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; } }
final SelectItem selectItem = orderByItem.getSelectItem(); validateSoqlSupportedSelectItem(selectItem); sb.append(column.getName()); sb.append(' '); sb.append(orderByItem.getDirection());
@Override public GroupedQueryBuilder asc() { orderByitem.setDirection(Direction.ASC); return getQueryBuilder(); }
public int compare(Row o1, Row o2) { for (int i = 0; i < sortIndexes.length; i++) { int sortIndex = sortIndexes[i]; Object sortObj1 = o1.getValue(sortIndex); Object sortObj2 = o2.getValue(sortIndex); int compare = valueComparator.compare(sortObj1, sortObj2); if (compare != 0) { OrderByItem orderByItem = orderByItems[i]; boolean ascending = orderByItem.isAscending(); if (ascending) { return compare; } else { return compare * -1; } } } return 0; } };
@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 String toString() { return toSql(); } }
public List<SelectItem> getEvaluatedSelectItems() { final List<SelectItem> result = new ArrayList<SelectItem>(); final List<OrderByItem> items = getItems(); for (OrderByItem item : items) { result.add(item.getSelectItem()); } return result; }
@Override protected OrderByItem clone() { OrderByItem o = new OrderByItem(_selectItem.clone()); o._direction = _direction; return o; }
@Override public GroupedQueryBuilder desc() { orderByitem.setDirection(Direction.DESC); return getQueryBuilder(); }
@Override public String toSql() { return toSql(false); }
for (int i = 0; i < orderByItems.length; i++) { OrderByItem item = orderByItems[i]; int indexOf = dataSet.indexOf(item.getSelectItem()); sortIndexes[i] = indexOf;
public Query orderBy(String... orderByTokens) { for (String orderByToken : orderByTokens) { orderByToken = orderByToken.trim(); final Direction direction; if (orderByToken.toUpperCase().endsWith("DESC")) { direction = Direction.DESC; orderByToken = orderByToken.substring(0, orderByToken.length() - 4).trim(); } else if (orderByToken.toUpperCase().endsWith("ASC")) { direction = Direction.ASC; orderByToken = orderByToken.substring(0, orderByToken.length() - 3).trim(); } else { direction = Direction.ASC; } OrderByItem orderByItem = new OrderByItem(findSelectItem(orderByToken, true), direction); orderBy(orderByItem); } return this; }
@Override public GroupedQueryBuilder desc() { orderByitem.setDirection(Direction.DESC); return getQueryBuilder(); }
@Override public String toSql() { return toSql(false); }