Examples of OrderBy


Examples of org.teiid.query.sql.lang.OrderBy

    From from = new From();
    from.addGroup(new GroupSymbol("m.g")); //$NON-NLS-1$
    CompareCriteria cc = new CompareCriteria(new ElementSymbol("e1"), CompareCriteria.EQ, new Constant(new Integer(5))); //$NON-NLS-1$
    GroupBy groupBy = new GroupBy();
    groupBy.addSymbol(new ElementSymbol("e1")); //$NON-NLS-1$
    OrderBy orderBy = new OrderBy();
    orderBy.addVariable(new ElementSymbol("e1")); //$NON-NLS-1$
   
    Query query = new Query();
    query.setSelect(select);
    query.setFrom(from);
    query.setCriteria(cc);
View Full Code Here

Examples of org.teiid.query.sql.lang.OrderBy

    from.addGroup(new GroupSymbol("m.g")); //$NON-NLS-1$
    CompareCriteria cc = new CompareCriteria(new ElementSymbol("e1"), CompareCriteria.EQ, new Constant(new Integer(5))); //$NON-NLS-1$
    GroupBy groupBy = new GroupBy();
    groupBy.addSymbol(new ElementSymbol("e1")); //$NON-NLS-1$
    CompareCriteria having = new CompareCriteria(new ElementSymbol("e1"), CompareCriteria.GT, new Constant(new Integer(0))); //$NON-NLS-1$
    OrderBy orderBy = new OrderBy();
    orderBy.addVariable(new ElementSymbol("e1")); //$NON-NLS-1$
   
    Query query = new Query();
    query.setSelect(select);
    query.setFrom(from);
    query.setCriteria(cc);
View Full Code Here

Examples of org.teiid.query.sql.lang.OrderBy

    f2.addGroup(new GroupSymbol("m.g2"));     //$NON-NLS-1$
    Query q2 = new Query();
    q2.setSelect(s2);
    q2.setFrom(f2);
   
    OrderBy orderBy = new OrderBy();
    orderBy.addVariable(new ElementSymbol("e1")); //$NON-NLS-1$
   
    SetQuery sq = new SetQuery(Operation.UNION, false, q1, q2);
    sq.setOrderBy(orderBy);

    helpTest(sq, "SELECT e1 FROM m.g1 UNION SELECT e1 FROM m.g2 ORDER BY e1"); //$NON-NLS-1$
View Full Code Here

Examples of org.teiid.query.sql.lang.OrderBy

        SetQuery sq = new SetQuery(Operation.INTERSECT);
        sq.setAll(false);
        sq.setLeftQuery(q1);
        sq.setRightQuery(q2);

        OrderBy orderBy = new OrderBy();
        orderBy.addVariable(new ElementSymbol("x")); //$NON-NLS-1$
        sq.setOrderBy(orderBy)
        return sq;   
  }
View Full Code Here

Examples of org.teiid.query.sql.lang.OrderBy

        select.addSymbol(new ElementSymbol("y"));        //$NON-NLS-1$
        q2.setSelect(select);       
        From from = new From();
        from.addGroup(new GroupSymbol("h")); //$NON-NLS-1$
        q2.setFrom(from);
        OrderBy orderBy = new OrderBy();
        orderBy.addVariable(new ElementSymbol("x")); //$NON-NLS-1$
        q2.setOrderBy(orderBy);
        return q2;   
    }
View Full Code Here

Examples of org.teiid.query.sql.lang.OrderBy

        BetweenCriteria bc = new BetweenCriteria(exampleElement(true, 0), new Constant(new Integer(1000)), new Constant(new Integer(2000)));
        helpTest(bc, getSymbolMap());      
    }
   
  public void testVisitOrderBy() {
      OrderBy ob = new OrderBy();
      ob.addVariable(exampleElement(true, 0));
      ob.addVariable(exampleElement(true, 1));
      ob.addVariable(new AliasSymbol("abc", exampleElement(true, 2))); //$NON-NLS-1$
      helpTest(ob, getSymbolMap());     
  }
View Full Code Here

Examples of se.unlogic.standardutils.dao.annotations.OrderBy

    int generatedKeyColumnIndex = 1;

    for (Field field : fields) {

      DAOManaged daoManaged = field.getAnnotation(DAOManaged.class);
      OrderBy orderBy = field.getAnnotation(OrderBy.class);

      if (daoManaged != null) {

        ReflectionUtils.fixFieldAccess(field);
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.