/** * Constructs an instance of this class from an ordered list of elements. * @param parameters The ordered list of SingleElementSymbol */ public OrderBy( List<? extends Expression> parameters ) { for (Expression singleElementSymbol : parameters) { orderByItems.add(new OrderByItem(singleElementSymbol, ASC)); } }
/** * Constructs an instance of this class from an ordered list of elements. * @param parameters The ordered list of SingleElementSymbol */ public OrderBy( List<? extends Expression> parameters ) { for (Expression singleElementSymbol : parameters) { orderByItems.add(new OrderByItem(singleElementSymbol, ASC)); } }
/** * Constructs an instance of this class from an ordered list of elements. * @param parameters The ordered list of SingleElementSymbol */ public OrderBy( List<? extends Expression> parameters ) { for (Expression singleElementSymbol : parameters) { orderByItems.add(new OrderByItem(singleElementSymbol, ASC)); } }
/** * Adds a new variable to the list of order by elements with the * specified sort order * @param element Element to add * @param type True for ascending, false for descending */ public void addVariable( Expression element, boolean type ) { if(element != null) { orderByItems.add(new OrderByItem(element, type)); } }
/** * Adds a new variable to the list of order by elements with the * specified sort order * @param element Element to add * @param type True for ascending, false for descending */ public void addVariable( Expression element, boolean type ) { if(element != null) { orderByItems.add(new OrderByItem(element, type)); } }
/** * Adds a new variable to the list of order by elements with the * specified sort order * @param element Element to add * @param type True for ascending, false for descending */ public OrderByItem addVariable( Expression element, boolean type ) { if(element != null) { OrderByItem result = new OrderByItem(element, type); orderByItems.add(result); return result; } return null; }
/** * Constructs an instance of this class from an ordered set of elements. * @param parameters The ordered list of SingleElementSymbol * @param types The list of directions by which the results are ordered (Boolean, true=ascending) */ public OrderBy( List<? extends Expression> parameters, List<Boolean> types ) { Iterator<Boolean> typeIter = types.iterator(); for (Expression singleElementSymbol : parameters) { orderByItems.add(new OrderByItem(singleElementSymbol, typeIter.next())); } }
/** * Constructs an instance of this class from an ordered set of elements. * @param parameters The ordered list of SingleElementSymbol * @param types The list of directions by which the results are ordered (Boolean, true=ascending) */ public OrderBy( List<? extends Expression> parameters, List<Boolean> types ) { Iterator<Boolean> typeIter = types.iterator(); for (Expression singleElementSymbol : parameters) { orderByItems.add(new OrderByItem(singleElementSymbol, typeIter.next())); } }
/** * Constructs an instance of this class from an ordered set of elements. * @param parameters The ordered list of SingleElementSymbol * @param types The list of directions by which the results are ordered (Boolean, true=ascending) */ public OrderBy( List<? extends Expression> parameters, List<Boolean> types ) { Iterator<Boolean> typeIter = types.iterator(); for (Expression singleElementSymbol : parameters) { orderByItems.add(new OrderByItem(singleElementSymbol, typeIter.next())); } }
@Override public OrderByItem clone() { OrderByItem clone = new OrderByItem((Expression)this.symbol.clone(), ascending); clone.expressionPosition = this.expressionPosition; clone.nullOrdering = this.nullOrdering; return clone; }
@Override public OrderByItem clone() { OrderByItem clone = new OrderByItem((Expression)this.symbol.clone(), ascending); clone.expressionPosition = this.expressionPosition; clone.nullOrdering = this.nullOrdering; return clone; }
@Override public OrderByItem clone() { OrderByItem clone = new OrderByItem((Expression)this.symbol.clone(), ascending); clone.expressionPosition = this.expressionPosition; clone.nullOrdering = this.nullOrdering; return clone; }
@Test public void testOrderByNullOrdering(){ OrderBy orderBy = new OrderBy(); OrderByItem item = new OrderByItem(new ElementSymbol("c"), true); item.setNullOrdering(NullOrdering.FIRST); orderBy.getOrderByItems().add(item); item = new OrderByItem(new ElementSymbol("d"), false); item.setNullOrdering(NullOrdering.LAST); orderBy.getOrderByItems().add(item); Query query = getOrderByQuery(orderBy); helpTest("SELECT a FROM db.g WHERE b = aString ORDER BY c NULLS FIRST,d desc nulls last", //$NON-NLS-1$ "SELECT a FROM db.g WHERE b = aString ORDER BY c NULLS FIRST, d DESC NULLS LAST", //$NON-NLS-1$ query); }
OrderByItem item = new OrderByItem(ex, ascending); if (nullOrdering != null) { item.setNullOrdering(nullOrdering);
OrderByItem item = new OrderByItem(ex, ascending); if (nullOrdering != null) { item.setNullOrdering(nullOrdering);
OrderByItem item = new OrderByItem(ex, ascending); if (nullOrdering != null) { item.setNullOrdering(nullOrdering);