/** * Returns the sort order at the specified index * @param index Index to get * @return The sort order at the index */ public Boolean getOrderType( int index ) { return orderByItems.get(index).isAscending(); }
/** * Returns the sort order at the specified index * @param index Index to get * @return The sort order at the index */ public Boolean getOrderType( int index ) { return orderByItems.get(index).isAscending(); }
/** * Returns the sort order at the specified index * @param index Index to get * @return The sort order at the index */ public Boolean getOrderType( int index ) { return orderByItems.get(index).isAscending(); }
public List<Boolean> getTypes() { ArrayList<Boolean> result = new ArrayList<Boolean>(orderByItems.size()); for (OrderByItem item : orderByItems) { result.add(item.isAscending()); } return result; }
public List<Boolean> getTypes() { ArrayList<Boolean> result = new ArrayList<Boolean>(orderByItems.size()); for (OrderByItem item : orderByItems) { result.add(item.isAscending()); } return result; }
public List<Boolean> getTypes() { ArrayList<Boolean> result = new ArrayList<Boolean>(orderByItems.size()); for (OrderByItem item : orderByItems) { result.add(item.isAscending()); } return result; }
static boolean supportsNullOrdering(QueryMetadataInterface metadata, CapabilitiesFinder capFinder, Object modelID, OrderByItem symbol) throws QueryMetadataException, TeiidComponentException { boolean supportsNullOrdering = CapabilitiesUtil.supports(Capability.QUERY_ORDERBY_NULL_ORDERING, modelID, metadata, capFinder); NullOrder defaultNullOrder = CapabilitiesUtil.getDefaultNullOrder(modelID, metadata, capFinder); if (symbol.getNullOrdering() != null && !supportsNullOrdering) { if (symbol.getNullOrdering() == NullOrdering.FIRST) { if (defaultNullOrder != NullOrder.FIRST && !(symbol.isAscending() && defaultNullOrder == NullOrder.LOW) && !(!symbol.isAscending() && defaultNullOrder == NullOrder.HIGH)) { return false; } } else if (defaultNullOrder != NullOrder.LAST && !(symbol.isAscending() && defaultNullOrder == NullOrder.HIGH) && !(!symbol.isAscending() && defaultNullOrder == NullOrder.LOW)) { return false; } } return true; } }
static boolean supportsNullOrdering(QueryMetadataInterface metadata, CapabilitiesFinder capFinder, Object modelID, OrderByItem symbol) throws QueryMetadataException, TeiidComponentException { boolean supportsNullOrdering = CapabilitiesUtil.supports(Capability.QUERY_ORDERBY_NULL_ORDERING, modelID, metadata, capFinder); NullOrder defaultNullOrder = CapabilitiesUtil.getDefaultNullOrder(modelID, metadata, capFinder); if (symbol.getNullOrdering() != null && !supportsNullOrdering) { if (symbol.getNullOrdering() == NullOrdering.FIRST) { if (defaultNullOrder != NullOrder.FIRST && !(symbol.isAscending() && defaultNullOrder == NullOrder.LOW) && !(!symbol.isAscending() && defaultNullOrder == NullOrder.HIGH)) { return false; } } else if (defaultNullOrder != NullOrder.LAST && !(symbol.isAscending() && defaultNullOrder == NullOrder.HIGH) && !(!symbol.isAscending() && defaultNullOrder == NullOrder.LOW)) { return false; } } return true; } }
static boolean supportsNullOrdering(QueryMetadataInterface metadata, CapabilitiesFinder capFinder, Object modelID, OrderByItem symbol) throws QueryMetadataException, TeiidComponentException { boolean supportsNullOrdering = CapabilitiesUtil.supports(Capability.QUERY_ORDERBY_NULL_ORDERING, modelID, metadata, capFinder); NullOrder defaultNullOrder = CapabilitiesUtil.getDefaultNullOrder(modelID, metadata, capFinder); if (symbol.getNullOrdering() != null && !supportsNullOrdering) { if (symbol.getNullOrdering() == NullOrdering.FIRST) { if (defaultNullOrder != NullOrder.FIRST && !(symbol.isAscending() && defaultNullOrder == NullOrder.LOW) && !(!symbol.isAscending() && defaultNullOrder == NullOrder.HIGH)) { return false; } } else if (defaultNullOrder != NullOrder.LAST && !(symbol.isAscending() && defaultNullOrder == NullOrder.HIGH) && !(!symbol.isAscending() && defaultNullOrder == NullOrder.LOW)) { return false; } } return true; } }
if (item.getNullOrdering() != null && ((item.isAscending() && item.getNullOrdering() == NullOrdering.LAST) || (!item.isAscending() && item.getNullOrdering() == NullOrdering.FIRST))) { if (item.isAscending()) { if (direction == null) { direction = OrderBy.ASC;
if (item.getNullOrdering() != null && ((item.isAscending() && item.getNullOrdering() == NullOrdering.LAST) || (!item.isAscending() && item.getNullOrdering() == NullOrdering.FIRST))) { if (item.isAscending()) { if (direction == null) { direction = OrderBy.ASC;
if (item.getNullOrdering() != null && ((item.isAscending() && item.getNullOrdering() == NullOrdering.LAST) || (!item.isAscending() && item.getNullOrdering() == NullOrdering.FIRST))) { if (item.isAscending()) { if (direction == null) { direction = OrderBy.ASC;
public org.teiid.language.OrderBy translate(OrderBy orderBy, boolean set) { if(orderBy == null){ return null; } List<OrderByItem> items = orderBy.getOrderByItems(); List<SortSpecification> translatedItems = new ArrayList<SortSpecification>(); for (int i = 0; i < items.size(); i++) { Expression symbol = items.get(i).getSymbol(); Ordering direction = items.get(i).isAscending() ? Ordering.ASC: Ordering.DESC; SortSpecification orderByItem = null; if(!set && (items.get(i).isUnrelated() || symbol instanceof ElementSymbol)){ orderByItem = new SortSpecification(direction, translate(symbol)); } else { orderByItem = new SortSpecification(direction, new ColumnReference(null, Symbol.getShortName(((Symbol)symbol).getOutputName()), null, symbol.getType())); } orderByItem.setNullOrdering(items.get(i).getNullOrdering()); translatedItems.add(orderByItem); } return new org.teiid.language.OrderBy(translatedItems); }
Integer index = GroupingNode.getIndex(ex1, expressionIndexes); wsi.sortIndexes.add(index); wsi.orderType.add(item.isAscending()); wsi.nullOrderings.add(item.getNullOrdering());
Integer index = GroupingNode.getIndex(ex1, expressionIndexes); wsi.sortIndexes.add(index); wsi.orderType.add(item.isAscending()); wsi.nullOrderings.add(item.getNullOrdering());
for (int i = 0; i < items.size(); i++) { Expression symbol = items.get(i).getSymbol(); Ordering direction = items.get(i).isAscending() ? Ordering.ASC: Ordering.DESC;
for (int i = 0; i < items.size(); i++) { Expression symbol = items.get(i).getSymbol(); Ordering direction = items.get(i).isAscending() ? Ordering.ASC: Ordering.DESC;
@Override public void visit( OrderByItem obj ) { Expression ses = obj.getSymbol(); if (ses instanceof AliasSymbol) { AliasSymbol as = (AliasSymbol)ses; outputDisplayName(as.getOutputName()); } else { visitNode(ses); } if (!obj.isAscending()) { append(SPACE); append(DESC); } // Don't print default "ASC" if (obj.getNullOrdering() != null) { append(SPACE); append(NonReserved.NULLS); append(SPACE); append(obj.getNullOrdering().name()); } }
@Override public void visit( OrderByItem obj ) { Expression ses = obj.getSymbol(); if (ses instanceof AliasSymbol) { AliasSymbol as = (AliasSymbol)ses; outputDisplayName(as.getOutputName()); } else { visitNode(ses); } if (!obj.isAscending()) { append(SPACE); append(DESC); } // Don't print default "ASC" if (obj.getNullOrdering() != null) { append(SPACE); append(NonReserved.NULLS); append(SPACE); append(obj.getNullOrdering().name()); } }
@Override public void visit( OrderByItem obj ) { Expression ses = obj.getSymbol(); if (ses instanceof AliasSymbol) { AliasSymbol as = (AliasSymbol)ses; outputDisplayName(as.getOutputName()); } else { visitNode(ses); } if (!obj.isAscending()) { append(SPACE); append(DESC); } // Don't print default "ASC" if (obj.getNullOrdering() != null) { append(SPACE); append(NonReserved.NULLS); append(SPACE); append(obj.getNullOrdering().name()); } }