@Override public void parse(String delim, String itemToken) { _query.orderBy(itemToken); }
@Override public void parse(String delim, String itemToken) { _query.orderBy(itemToken); }
public Query orderBy(Column column) { return orderBy(column, Direction.ASC); }
public Query orderBy(Column column) { return orderBy(column, Direction.ASC); }
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; }
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; }
public Query orderBy(Column column, Direction direction) { SelectItem selectItem = _selectClause.getSelectItem(column); if (selectItem == null) { selectItem = new SelectItem(column); } return orderBy(new OrderByItem(selectItem, direction)); }
@Override public Query optimizeQuery(Query q, Category category) { if (category == Category.VALID) { q.setMaxRows(maxRows); if (firstRow > 1) { q.setFirstRow(firstRow); } if (orderColumn != null) { Column physicalColumn = orderColumn.getPhysicalColumn(); q.orderBy(physicalColumn); } } else { throw new IllegalStateException("Can only optimize the VALID max rows category"); } return q; }
public SatisfiedOrderByBuilderImpl(FunctionType function, Column column, Query query, GroupedQueryBuilder queryBuilder) { super(queryBuilder); orderByitem = new OrderByItem(new SelectItem(function, column)); query.orderBy(orderByitem); }
public SatisfiedOrderByBuilderImpl(FunctionType function, Column column, Query query, GroupedQueryBuilder queryBuilder) { super(queryBuilder); orderByitem = new OrderByItem(new SelectItem(function, column)); query.orderBy(orderByitem); }
public Query orderBy(Column column, Direction direction) { SelectItem selectItem = _selectClause.getSelectItem(column); if (selectItem == null) { selectItem = new SelectItem(column); } return orderBy(new OrderByItem(selectItem, direction)); }
public SatisfiedOrderByBuilderImpl(Column column, Query query, GroupedQueryBuilder queryBuilder) { super(queryBuilder); orderByitem = new OrderByItem(new SelectItem(column)); query.orderBy(orderByitem); }
public SatisfiedOrderByBuilderImpl(Column column, Query query, GroupedQueryBuilder queryBuilder) { super(queryBuilder); orderByitem = new OrderByItem(new SelectItem(column)); query.orderBy(orderByitem); }
q.orderBy(physicalColumn);
@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; } }