Package org.teiid.query.sql.lang

Examples of org.teiid.query.sql.lang.OrderBy.addVariable()

5439
5440
5441
5442
5443
5444
5445
5446
5447
5448
5449
        ElementSymbol c1 = new ElementSymbol("c1", false); //$NON-NLS-1$
        select.addSymbol(c1);
        select.addSymbol(new ElementSymbol("c2", false));         //$NON-NLS-1$

        OrderBy orderBy = new OrderBy();
        orderBy.addVariable(c1);

        Query query = new Query();
        query.setSelect(select);
        query.setFrom(from);
        query.setOrderBy(orderBy);
View Full Code Here
6308
6309
6310
6311
6312
6313
6314
6315
6316
6317
6318
    Select select = new Select();
    select.addSymbol(new ElementSymbol("x")); //$NON-NLS-1$
    select.addSymbol(new ElementSymbol("y")); //$NON-NLS-1$

    OrderBy orderby = new OrderBy();
    orderby.addVariable(new ElementSymbol("1"), true); //$NON-NLS-1$

    Query query = new Query();
    query.setSelect(select);
    query.setFrom(from);
    query.setOrderBy(orderby);
View Full Code Here
6328
6329
6330
6331
6332
6333
6334
6335
6336
6337
6338
    Select select = new Select();
    select.addSymbol(new ElementSymbol("x")); //$NON-NLS-1$
    select.addSymbol(new ElementSymbol("y")); //$NON-NLS-1$

    OrderBy orderby = new OrderBy();
    orderby.addVariable(new ExpressionSymbol("expr", new Constant(1)), true); //$NON-NLS-1$

    Query query = new Query();
    query.setSelect(select);
    query.setFrom(from);
    query.setOrderBy(orderby);       
View Full Code Here
299
300
301
302
303
304
305
306
307
308
309
            OrderBy by = rs.getOrderBy();
            if (by == null) {
                by = new OrderBy();
            }
            ElementSymbol mappedSymbol = (ElementSymbol)sourceNode.getSymbolMap().get(new ElementSymbol(elementNode.getNameInSource()));
            by.addVariable((ElementSymbol)mappedSymbol.clone(), ((Boolean)types.get(i)).booleanValue());
            rs.setOrderBy(by);
    }
  }
       
}
View Full Code Here
395
396
397
398
399
400
401
402
403
404
405
        return createTupleSource(projectedCols, Criteria.combineCriteria(ii.nonCoveredCriteria), null, primary, agg);
      }
      //order by pk to localize lookup costs, then join
      OrderBy pkOrderBy = new OrderBy();
      for (ElementSymbol elementSymbol : pkColumns) {
        pkOrderBy.addVariable(elementSymbol);
      }
      primary.valueTs = ii.table.createTupleSource(pkColumns,
          Criteria.combineCriteria(ii.coveredCriteria), pkOrderBy, ii, agg);
      return createTupleSource(projectedCols, Criteria.combineCriteria(ii.nonCoveredCriteria), orderBy, primary, agg);
    }
View Full Code Here
546
547
548
549
550
551
552
553
554
555
556
        helpTest(option, "OPTION NOCACHE");     //$NON-NLS-1$
    }
   
  public void testOrderBy1() {
    OrderBy ob = new OrderBy();
    ob.addVariable(new ElementSymbol("e1")); //$NON-NLS-1$
   
    helpTest(ob, "ORDER BY e1");     //$NON-NLS-1$
  }

  public void testOrderBy2() {
View Full Code Here
553
554
555
556
557
558
559
560
561
562
563
    helpTest(ob, "ORDER BY e1");     //$NON-NLS-1$
  }

  public void testOrderBy2() {
    OrderBy ob = new OrderBy();
    ob.addVariable(new ElementSymbol("e1")); //$NON-NLS-1$
    ob.addVariable(new AliasSymbol("x", new ElementSymbol("e2"))); //$NON-NLS-1$ //$NON-NLS-2$
   
    helpTest(ob, "ORDER BY e1, x");     //$NON-NLS-1$
  }
View Full Code Here
554
555
556
557
558
559
560
561
562
563
564
  }

  public void testOrderBy2() {
    OrderBy ob = new OrderBy();
    ob.addVariable(new ElementSymbol("e1")); //$NON-NLS-1$
    ob.addVariable(new AliasSymbol("x", new ElementSymbol("e2"))); //$NON-NLS-1$ //$NON-NLS-2$
   
    helpTest(ob, "ORDER BY e1, x");     //$NON-NLS-1$
  }

  public void testOrderBy3() {
View Full Code Here
561
562
563
564
565
566
567
568
569
570
571
    helpTest(ob, "ORDER BY e1, x");     //$NON-NLS-1$
  }

  public void testOrderBy3() {
    OrderBy ob = new OrderBy();
    ob.addVariable(new ElementSymbol("e1"), OrderBy.DESC); //$NON-NLS-1$
    ob.addVariable(new ElementSymbol("x"), OrderBy.DESC); //$NON-NLS-1$
   
    helpTest(ob, "ORDER BY e1 DESC, x DESC");     //$NON-NLS-1$
  }
View Full Code Here
562
563
564
565
566
567
568
569
570
571
572
  }

  public void testOrderBy3() {
    OrderBy ob = new OrderBy();
    ob.addVariable(new ElementSymbol("e1"), OrderBy.DESC); //$NON-NLS-1$
    ob.addVariable(new ElementSymbol("x"), OrderBy.DESC); //$NON-NLS-1$
   
    helpTest(ob, "ORDER BY e1 DESC, x DESC");     //$NON-NLS-1$
  }

  public void testQuery1() {
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.