protected Ordering ordering( DynamicOperand operand, Order order, NullOrder nullOrder ) { return new Ordering(operand, order, nullOrder); }
protected Ordering ordering( DynamicOperand operand, Order order, NullOrder nullOrder ) { return new Ordering(operand, order, nullOrder); }
protected OrderByBuilder addOrdering( DynamicOperand operand ) { Ordering ordering = new Ordering(operand, order, nullOrder); QueryBuilder.this.orderings.add(ordering); return builder; }
protected OrderByBuilder addOrdering( DynamicOperand operand ) { Ordering ordering = new Ordering(operand, order, nullOrder); QueryBuilder.this.orderings.add(ordering); return builder; }
@Override public Ordering descending( javax.jcr.query.qom.DynamicOperand operand ) { DynamicOperand jcrOperand = CheckArg.getInstanceOf(operand, DynamicOperand.class, "operand"); return new Ordering(jcrOperand, Order.DESCENDING, NullOrder.NULLS_FIRST); }
@Override public javax.jcr.query.qom.Ordering descendingNullsLast( javax.jcr.query.qom.DynamicOperand operand ) { DynamicOperand jcrOperand = CheckArg.getInstanceOf(operand, DynamicOperand.class, "operand"); return new Ordering(jcrOperand, Order.DESCENDING, NullOrder.NULLS_LAST); }
@Override public Ordering descending( javax.jcr.query.qom.DynamicOperand operand ) { DynamicOperand jcrOperand = CheckArg.getInstanceOf(operand, DynamicOperand.class, "operand"); return new Ordering(jcrOperand, Order.DESCENDING, NullOrder.NULLS_FIRST); }
@Override public Ordering ascending( javax.jcr.query.qom.DynamicOperand operand ) { DynamicOperand jcrOperand = CheckArg.getInstanceOf(operand, DynamicOperand.class, "operand"); return new Ordering(jcrOperand, Order.ASCENDING, NullOrder.NULLS_LAST); }
@Override public Ordering ascending( javax.jcr.query.qom.DynamicOperand operand ) { DynamicOperand jcrOperand = CheckArg.getInstanceOf(operand, DynamicOperand.class, "operand"); return new Ordering(jcrOperand, Order.ASCENDING, NullOrder.NULLS_LAST); }
@Override public javax.jcr.query.qom.Ordering ascendingNullsFirst( javax.jcr.query.qom.DynamicOperand operand ) { DynamicOperand jcrOperand = CheckArg.getInstanceOf(operand, DynamicOperand.class, "operand"); return new Ordering(jcrOperand, Order.ASCENDING, NullOrder.NULLS_FIRST); }
@Override public javax.jcr.query.qom.Ordering ascendingNullsFirst( javax.jcr.query.qom.DynamicOperand operand ) { DynamicOperand jcrOperand = CheckArg.getInstanceOf(operand, DynamicOperand.class, "operand"); return new Ordering(jcrOperand, Order.ASCENDING, NullOrder.NULLS_FIRST); }
@Override public javax.jcr.query.qom.Ordering descendingNullsLast( javax.jcr.query.qom.DynamicOperand operand ) { DynamicOperand jcrOperand = CheckArg.getInstanceOf(operand, DynamicOperand.class, "operand"); return new Ordering(jcrOperand, Order.DESCENDING, NullOrder.NULLS_LAST); }
protected Ordering ascendingScore( String... tableNames ) { return new Ordering(score(tableNames), Order.ASCENDING, NullOrder.NULLS_LAST); }
protected Ordering descendingScore( String... tableNames ) { return new Ordering(score(tableNames), Order.DESCENDING, NullOrder.NULLS_LAST); }
@Test public void shouldConstructReadableStringWithNoColumns() { source = new NamedSelector(selector("nt:unstructured")); columns = Collections.emptyList(); constraint = new PropertyExistence(selector("selector1"), "jcr:uuid"); orderings = Collections.singletonList(new Ordering(new NodeName(selector("selector1")), Order.ASCENDING, NullOrder.NULLS_LAST)); query = new Query(source, constraint, orderings, columns, limits, distinct); assertThat(Visitors.readable(query), is("SELECT * FROM [nt:unstructured] WHERE selector1.[jcr:uuid] IS NOT NULL ORDER BY NAME(selector1) ASC NULLS LAST")); }
@Test public void shouldConstructReadableStringWithNoConstraint() { source = new NamedSelector(selector("nt:unstructured")); columns = Collections.singletonList(new Column(selector("selector1"))); constraint = null; orderings = Collections.singletonList(new Ordering(new NodeName(selector("selector1")), Order.ASCENDING, NullOrder.NULLS_LAST)); query = new Query(source, constraint, orderings, columns, limits, distinct); assertThat(Visitors.readable(query), is("SELECT selector1.* FROM [nt:unstructured] ORDER BY NAME(selector1) ASC NULLS LAST")); }
protected Ordering ascending( String table, String columnName ) { return new Ordering(new PropertyValue(new SelectorName(table), columnName), Order.ASCENDING, NullOrder.NULLS_LAST); }
protected Ordering descending( String table, String columnName ) { return new Ordering(new PropertyValue(new SelectorName(table), columnName), Order.DESCENDING, NullOrder.NULLS_LAST); }
@Test public void shouldConstructReadableStringWithLimits() { source = new NamedSelector(selector("nt:unstructured")); columns = Collections.singletonList(new Column(selector("selector1"))); constraint = new PropertyExistence(selector("selector1"), "jcr:uuid"); orderings = Collections.singletonList(new Ordering(new NodeName(selector("selector1")), Order.ASCENDING, NullOrder.NULLS_LAST)); limits = new Limit(10, 100); query = new Query(source, constraint, orderings, columns, limits, distinct); assertThat(Visitors.readable(query), is("SELECT selector1.* FROM [nt:unstructured] WHERE selector1.[jcr:uuid] IS NOT NULL ORDER BY NAME(selector1) ASC NULLS LAST LIMIT 10 OFFSET 100")); }
@Test public void shouldConstructReadableString() { source = new NamedSelector(selector("nt:unstructured")); columns = Collections.singletonList(new Column(selector("selector1"))); constraint = new PropertyExistence(selector("selector1"), "jcr:uuid"); orderings = Collections.singletonList(new Ordering(new NodeName(selector("selector1")), Order.ASCENDING, NullOrder.NULLS_LAST)); query = new Query(source, constraint, orderings, columns, limits, distinct); assertThat(Visitors.readable(query), is("SELECT selector1.* FROM [nt:unstructured] WHERE selector1.[jcr:uuid] IS NOT NULL ORDER BY NAME(selector1) ASC NULLS LAST")); }