Examples of OrderByItem

com.googlecode.gql4j.GqlQuery.OrderByItem
org.apache.metamodel.query.OrderByItem
Represents an ORDER BY item. An OrderByItem sorts the resulting DataSet according to a SelectItem that may or may not be a part of the query already. @see OrderByClause @see SelectItem
org.eclipse.persistence.jpa.jpql.parser.OrderByItem
An orderby_item must be one of the following:
1. A {@link StateFieldPathExpression state_field_path_expression} that evaluates to an orderablestate field of an entity or embeddable class abstract schema type designated in the SELECT clause by one of the following:
  - A general_identification_variable
  - A single_valued_object_path_expression
2. A {@link StateFieldPathExpression state_field_path_expression} that evaluates to the samestate field of the same entity or embeddable abstract schema type as a {@link StateFieldPathExpression state_field_path_expression} in the SELECT clause
3. A {@link ResultVariable result_variable} that refers to an orderable item in the SELECTclause for which the same {@link ResultVariable result_variable} has been specified. This may bethe result of an aggregate_expression, a scalar_expression, or a {@link StateFieldPathExpression state_field_path_expression} in the SELECT clause.
The keyword ASC specifies that ascending ordering be used for the associated orderby_item; the keyword DESC specifies that descending ordering be used. Ascending ordering is the default.
The keyword NULLS FIRST specifies that nulls first ordering be used for the associated orderby_item; the keyword NULLS LAST specifies that nulls last ordering be used. Ascending ordering is the default.
JPA 1.0:
BNF: orderby_item ::= state_field_path_expression [ ASC | DESC ]
JPA 2.0
BNF: orderby_item ::= state_field_path_expression | result_variable [ ASC | DESC ]
EclipseLink 2.4:
BNF: orderby_item ::= state_field_path_expression | result_variable [ ASC | DESC ] [ NULLS FIRST | NULLS LAST ]
@version 2.4.2 @since 2.3 @author Pascal Filion
org.ofbiz.sql.OrderByItem
org.teiid.query.sql.lang.OrderByItem

Examples of com.googlecode.gql4j.GqlQuery.OrderByItem

  
  @Test
  public void testOrderBy_1() {
    ParseResult actual = GqlQuery.parse("SELECT * from a order by a desc");
    ParseResult expected = new ParseResult().setSelect(new Select(false)).setFrom(new From("a")).setOrderBy(
        new OrderBy().withItem(new OrderByItem("a").setDirection(false)));
    assertEquals(expected, actual);
  }

View Full Code Here

Examples of com.googlecode.gql4j.GqlQuery.OrderByItem

  
  @Test
  public void testOrderBy_2() {
    ParseResult actual = GqlQuery.parse("SELECT * from a order by a desc, b, c asc");
    ParseResult expected = new ParseResult().setSelect(new Select(false)).setFrom(new From("a")).setOrderBy(
        new OrderBy().withItem(new OrderByItem("a").setDirection(false))
        .withItem(new OrderByItem("b").setDirection(true))
        .withItem(new OrderByItem("c").setDirection(true)));
    assertEquals(expected, actual);
  }

View Full Code Here

Examples of org.apache.metamodel.query.OrderByItem


    public static DataSet getOrdered(DataSet dataSet, final OrderByItem... orderByItems) {
        if (orderByItems != null && orderByItems.length != 0) {
            final int[] sortIndexes = new int[orderByItems.length];
            for (int i = 0; i < orderByItems.length; i++) {
                OrderByItem item = orderByItems[i];
                int indexOf = dataSet.indexOf(item.getSelectItem());
                sortIndexes[i] = indexOf;
            }


            final List<Row> data = readDataSetFull(dataSet);
            if (data.isEmpty()) {
                return new EmptyDataSet(dataSet.getSelectItems());
            }


            final Comparator<Object> valueComparator = ObjectComparator.getComparator();


            // create a comparator for doing the actual sorting/ordering
            final Comparator<Row> comparator = new Comparator<Row>() {
                public int compare(Row o1, Row o2) {
                    for (int i = 0; i < sortIndexes.length; i++) {
                        int sortIndex = sortIndexes[i];
                        Object sortObj1 = o1.getValue(sortIndex);
                        Object sortObj2 = o2.getValue(sortIndex);
                        int compare = valueComparator.compare(sortObj1, sortObj2);
                        if (compare != 0) {
                            OrderByItem orderByItem = orderByItems[i];
                            boolean ascending = orderByItem.isAscending();
                            if (ascending) {
                                return compare;
                            } else {
                                return compare * -1;
                            }

View Full Code Here

Examples of org.apache.metamodel.query.OrderByItem


        q.groupBy(roleColumn);
        SelectItem countSelectItem = new SelectItem(FunctionType.COUNT, contributorIdColumn).setAlias("my_count");
        q.select(new SelectItem(roleColumn), countSelectItem);
        q.having(new FilterItem(countSelectItem, OperatorType.GREATER_THAN, 1));
        q.orderBy(new OrderByItem(countSelectItem));
        assertEquals(
                "SELECT c.name, COUNT(c.contributor_id) AS my_count FROM MetaModelSchema.role c GROUP BY c.name HAVING COUNT(c.contributor_id) > 1 ORDER BY COUNT(c.contributor_id) ASC",
                q.toString());


        DataSet data = getDataContext().executeQuery(q);

View Full Code Here

Examples of org.apache.metamodel.query.OrderByItem


    public void testOrderBy() throws Exception {
        Query q = new Query();
        q.from(new FromItem(table1).setAlias("c"));
        q.select(table1.getColumns());
        OrderByItem countryOrderBy = new OrderByItem(q.getSelectClause().getItem(2), Direction.DESC);
        OrderByItem nameOrderBy = new OrderByItem(q.getSelectClause().getItem(1));
        q.orderBy(countryOrderBy, nameOrderBy);


        assertEquals(
                "SELECT c.contributor_id, c.name, c.country FROM MetaModelSchema.contributor c ORDER BY c.country DESC, c.name ASC",
                q.toString());

View Full Code Here

Examples of org.apache.metamodel.query.OrderByItem

        assertNull(havingItem.getExpression());
        assertNotNull(havingItem.getSelectItem().getFunction());
        assertEquals("*", havingItem.getSelectItem().getExpression());


        // ORDER BY tbl.foo ASC
        OrderByItem orderByItem = q.getOrderByClause().getItem(0);
        assertNull(orderByItem.getSelectItem().getExpression());
        assertNotNull(orderByItem.getSelectItem().getColumn());
        assertEquals(Direction.ASC, orderByItem.getDirection());
    }

View Full Code Here

Examples of org.apache.metamodel.query.OrderByItem

    }


    public void testGetOrdered() throws Exception {
        DataSet dataSet = createDataSet3();
        List<OrderByItem> orderByItems = new ArrayList<OrderByItem>();
        orderByItems.add(new OrderByItem(dataSet.getSelectItems()[0]));


        dataSet = MetaModelHelper.getOrdered(dataSet, orderByItems);
        assertTrue(dataSet.next());
        assertEquals("Row[values=[w00p, true]]", dataSet.getRow().toString());
        assertTrue(dataSet.next());

View Full Code Here

Examples of org.apache.metamodel.query.OrderByItem

        q.groupBy(titleColumn);
        q.getSelectClause().removeItem(q.getSelectClause().getSelectItem(productPriceColumn));
        SelectItem quantitySum = new SelectItem(FunctionType.SUM, quantityColumn).setAlias("orderAmount");
        q.select(quantitySum);
        q.having(new FilterItem(quantitySum, OperatorType.GREATER_THAN, 25));
        q.orderBy(new OrderByItem(q.getSelectClause().getItem(0)));


        assertEquals("SELECT \"products\".\"title\" AS product-title, SUM(\"orderlines\".\"quantity\") AS orderAmount "
                + "FROM public.\"products\", public.\"orderlines\" "
                + "WHERE \"products\".\"prod_id\" = \"orderlines\".\"prod_id\" " + "GROUP BY \"products\".\"title\" "
                + "HAVING SUM(\"orderlines\".\"quantity\") > 25 " + "ORDER BY \"products\".\"title\" ASC", q.toString());

View Full Code Here

Examples of org.apache.metamodel.query.OrderByItem

        q.from(customersTable, "c");
        q.from(employeeTable, "o");
        SelectItem countrySelect = new SelectItem(countryColumn);
        q.select(countrySelect, new SelectItem(FunctionType.SUM, creditLimitColumn));
        q.groupBy(countryColumn);
        q.orderBy(new OrderByItem(countrySelect));
        q.where(new FilterItem(new SelectItem(employeeNumberColumn1), OperatorType.EQUALS_TO, new SelectItem(
                employeeNumberColumn2)));


        assertEquals(
                "SELECT c.\"COUNTRY\", SUM(c.\"CREDITLIMIT\") FROM PUBLIC.\"CUSTOMERS\" c, PUBLIC.\"EMPLOYEES\" o WHERE c.\"SALESREPEMPLOYEENUMBER\" = o.\"EMPLOYEENUMBER\" GROUP BY c.\"COUNTRY\" ORDER BY c.\"COUNTRY\" ASC",

View Full Code Here

Examples of org.apache.metamodel.query.OrderByItem

  private OrderByItem orderByitem;


  public SatisfiedOrderByBuilderImpl(Column column, Query query,
      GroupedQueryBuilder queryBuilder) {
    super(queryBuilder);
    orderByitem = new OrderByItem(new SelectItem(column));
    query.orderBy(orderByitem);
  }

View Full Code Here

0 1 2 3

TOP

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.