Examples of OrderBy


Examples of com.j256.ormlite.stmt.query.OrderBy

      throw new IllegalArgumentException("Can't orderBy foreign colletion field: " + columnName);
    }
    if (orderByList == null) {
      orderByList = new ArrayList<OrderBy>();
    }
    orderByList.add(new OrderBy(columnName, ascending));
    return this;
  }
View Full Code Here

Examples of com.salesforce.phoenix.compile.OrderByCompiler.OrderBy

        // Don't pass groupBy when building where clause expression, because we do not want to wrap these
        // expressions as group by key expressions since they're pre, not post filtered.
        context.setResolver(FromCompiler.getResolver(select, connection));
        WhereCompiler.compile(context, select);
        context.setResolver(resolver); // recover resolver
        OrderBy orderBy = OrderByCompiler.compile(context, select, groupBy, limit);
        RowProjector projector = ProjectionCompiler.compile(context, select, groupBy, targetColumns);
       
        // Final step is to build the query plan
        int maxRows = statement.getMaxRows();
        if (maxRows > 0) {
View Full Code Here

Examples of com.samskivert.depot.clause.OrderBy

        }
        if (playerIds != null) {
            where.add(RatingRecord.PLAYER_ID.in(playerIds));
        }

        OrderBy ob = new OrderBy(
            new SQLExpression<?>[] { RatingRecord.RATING, RatingRecord.LAST_UPDATED },
            new OrderBy.Order[] { OrderBy.Order.DESC, OrderBy.Order.DESC });
        return from(RatingRecord.class).where(where).limit(limit).orderBy(ob).select();
    }
View Full Code Here

Examples of com.vaadin.addon.sqlcontainer.query.OrderBy

  private String getOrderByString() {
    StringBuffer orderBuffer = new StringBuffer("");
    if (orderBys != null && !orderBys.isEmpty()) {
      orderBuffer.append(" ORDER BY ");
      OrderBy lastOrderBy = orderBys.get(orderBys.size() - 1);
      for (OrderBy orderBy : orderBys) {
        orderBuffer.append(Util.escapeSQL(orderBy.getColumn()));
        if (orderBy.isAscending()) {
          orderBuffer.append(" ASC");
        } else {
View Full Code Here

Examples of com.vaadin.data.util.sqlcontainer.query.OrderBy

                try {
                    asc = ascending[i];
                } catch (Exception e) {
                    getLogger().log(Level.WARNING, "", e);
                }
                sorters.add(new OrderBy((String) propertyId[i], asc));
            }
        }
        refresh();
    }
View Full Code Here

Examples of javax.persistence.OrderBy

    if (joinColumnsAnn != null)
      introspectJoinColumns(joinColumnsAnn.value());
    else if (joinColumnAnn != null)
      introspectJoinColumns(new JoinColumn[] { joinColumnAnn });
   
    OrderBy orderByAnn = _field.getAnnotation(OrderBy.class);
   
    if (orderByAnn != null)
      _orderBy = orderByAnn.value();
  }
View Full Code Here

Examples of org.apache.ode.ql.tree.nodes.OrderBy

        throw new IllegalArgumentException("Unsupported node type "+node.getClass());
    }
   
    private Query createSelection(ASTStart node) {
        Collection<Object> childs = new ArrayList<Object>(node.jjtGetNumChildren());
        OrderBy orderBy = null;
        Limit limit = null;
        for(int index = 0;index < node.jjtGetNumChildren();index++) {
          Node childNode = node.jjtGetChild(index);
            if(childNode instanceof ASTOrderBy) {
              orderBy = createOrderBy(childNode);
View Full Code Here

Examples of org.apache.phoenix.compile.OrderByCompiler.OrderBy

        // Don't pass groupBy when building where clause expression, because we do not want to wrap these
        // expressions as group by key expressions since they're pre, not post filtered.
        context.setResolver(FromCompiler.getResolverForQuery(select, connection));
        WhereCompiler.compile(context, select, viewWhere);
        context.setResolver(resolver); // recover resolver
        OrderBy orderBy = OrderByCompiler.compile(context, select, groupBy, limit);
        RowProjector projector = ProjectionCompiler.compile(context, select, groupBy, asSubquery ? Collections.<PDatum>emptyList() : targetColumns);
       
        // Final step is to build the query plan
        int maxRows = statement.getMaxRows();
        if (maxRows > 0) {
View Full Code Here

Examples of org.apache.torque.sql.OrderBy

        List selectColumnsClone = cClone.getSelectColumns();
        assertTrue(selectColumnsClone.contains(new ColumnImpl("Author", "NAME")));
        assertTrue(selectColumnsClone.contains(new ColumnImpl("Author", "AUTHOR_ID")));
        assertEquals(c.getSelectColumns(), cClone.getSelectColumns());
        List orderByColumnsClone = cClone.getOrderByColumns();
        assertTrue(orderByColumnsClone.contains(new OrderBy(new ColumnImpl("Author.NAME"), SqlEnum.DESC, false)));
        assertTrue(orderByColumnsClone.contains(new OrderBy(new ColumnImpl("Author.AUTHOR_ID"), SqlEnum.ASC, false)));
        assertEquals(c.getOrderByColumns(), cClone.getOrderByColumns());
        Map aliasesClone = cClone.getAliases();
        assertTrue(aliasesClone.containsKey("Writer"));
        assertEquals("Author", aliasesClone.get("Writer"));
        assertEquals(c.getAliases(), cClone.getAliases());
View Full Code Here

Examples of org.codehaus.jparsec.examples.sql.ast.OrderBy

    assertParser(parser, "1 desc", new OrderBy.Item(number(1), false));
  }
 
  public void testOrderByClause() {
    Parser<OrderBy> parser = RelationParser.orderByClause(NUMBER);
    assertParser(parser, "order by 1, 2 desc, 3 asc", new OrderBy(Arrays.asList(
        new OrderBy.Item(number(1), true), new OrderBy.Item(number(2), false),
        new OrderBy.Item(number(3), true))));
  }
View Full Code Here
TOP
Copyright © 2018 www.massapi.com. All rights reserved.
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.