@Override public void visit(SortSpecification obj) { visitNode(obj.getExpression()); }
@Override public void visit(SortSpecification obj) { if (this.orderBy.length() > 0) { this.orderBy.append(Tokens.COMMA); } ColumnReference column = (ColumnReference)obj.getExpression(); this.orderBy.append(column.getMetadataObject().getName()); // default is ascending if (obj.getOrdering() == Ordering.DESC) { this.orderBy.append(Tokens.SPACE).append(DESC.toLowerCase()); } }
public void visit(SortSpecification obj) { append(obj.getExpression()); if (obj.getOrdering() == Ordering.DESC) { buffer.append(Tokens.SPACE) .append(DESC); } // Don't print default "ASC" if (obj.getNullOrdering() != null) { buffer.append(Tokens.SPACE) .append(NonReserved.NULLS) .append(Tokens.SPACE) .append(obj.getNullOrdering().name()); } }
@Override public void visit(SortSpecification obj) { if (this.orderBy.length() > 0) { this.orderBy.append(Tokens.COMMA); } ColumnReference column = (ColumnReference)obj.getExpression(); try { Column c = ODataMetadataProcessor.normalizePseudoColumn(this.metadata, column.getMetadataObject()); this.orderBy.append(c.getName()); } catch (TranslatorException e) { this.exceptions.add(e); } // default is ascending if (obj.getOrdering() == Ordering.DESC) { this.orderBy.append(Tokens.SPACE).append(DESC.toLowerCase()); } }
@Override public void visit(SortSpecification obj) { append(obj.getExpression()); Object expr = this.onGoingExpression.pop(); ColumnDetail alias = this.expressionMap.get(expr); if (this.sort == null) { this.sort = new BasicDBObject(alias.getProjectedName(), (obj.getOrdering() == Ordering.ASC)?1:-1); } else { this.sort.put(alias.getProjectedName(), (obj.getOrdering() == Ordering.ASC)?1:-1); } }
private void validateOrderBy(Select obj) { Collection<ColumnReference> whereColumns = CollectorVisitor.collectElements(obj.getWhere()); for (SortSpecification sort:obj.getOrderBy().getSortSpecifications()) { boolean matched = false; for (ColumnReference where:whereColumns) { ColumnReference col = (ColumnReference)sort.getExpression(); if (col.getName().equals(where.getName())) { matched = true; } } if (!matched) { this.exceptions.add(new TranslatorException(SimpleDBPlugin.Event.TEIID24005, SimpleDBPlugin.Util.gs(SimpleDBPlugin.Event.TEIID24005))); break; } } }
while(orderItr.hasNext()) { SortSpecification item = orderItr.next(); String itemName = getExpressionQueryString(item.getExpression()); LogManager.logTrace(LogConstants.CTX_CONNECTOR, "Adding sort key for item:", itemName); //$NON-NLS-1$ if(item.getOrdering() == Ordering.ASC) {
Expression ex = ss.getExpression(); if (!(ex instanceof ColumnReference)) { continue;