Examples of org.teiid.query.sql.lang.GroupBy.addSymbol()

org.teiid.query.sql.lang.GroupBy.addSymbol()
Adds a new symbol to the list of symbols. @param symbol Symbol to add to GROUP BY


    Select select = new Select();
    select.addSymbol(new ElementSymbol("a", false)); //$NON-NLS-1$
    
    GroupBy groupBy = new GroupBy();
    groupBy.addSymbol(new ElementSymbol("b", false));     //$NON-NLS-1$
    groupBy.addSymbol(new ElementSymbol("c", false)); //$NON-NLS-1$
    


    Query query = new Query();
    query.setSelect(select);

View Full Code Here

    Select select = new Select();
    select.addSymbol(new ElementSymbol("a", false)); //$NON-NLS-1$
    
    GroupBy groupBy = new GroupBy();
    groupBy.addSymbol(new ElementSymbol("b", false));     //$NON-NLS-1$
    groupBy.addSymbol(new ElementSymbol("c", false)); //$NON-NLS-1$
    


    Query query = new Query();
    query.setSelect(select);
    query.setFrom(from);

View Full Code Here


    Select select = new Select();
    select.addSymbol(new ElementSymbol("a", false)); //$NON-NLS-1$
    
    GroupBy groupBy = new GroupBy();
    groupBy.addSymbol(new ElementSymbol("b", false));     //$NON-NLS-1$
    groupBy.addSymbol(new ElementSymbol("c", false)); //$NON-NLS-1$
    
    CompareCriteria having = new CompareCriteria(new ElementSymbol("b", false), CompareCriteria.EQ, new Constant(new Integer(5))); //$NON-NLS-1$
    
    Query query = new Query();

View Full Code Here

    Select select = new Select();
    select.addSymbol(new ElementSymbol("a", false)); //$NON-NLS-1$
    
    GroupBy groupBy = new GroupBy();
    groupBy.addSymbol(new ElementSymbol("b", false));     //$NON-NLS-1$
    groupBy.addSymbol(new ElementSymbol("c", false)); //$NON-NLS-1$
    
    CompareCriteria having = new CompareCriteria(new ElementSymbol("b", false), CompareCriteria.EQ, new Constant(new Integer(5))); //$NON-NLS-1$
    
    Query query = new Query();
    query.setSelect(select);

View Full Code Here


    Select select = new Select();
    select.addSymbol(new ElementSymbol("a")); //$NON-NLS-1$
    
    GroupBy groupBy = new GroupBy();
    groupBy.addSymbol(new ElementSymbol("a")); //$NON-NLS-1$
    
    Criteria having = new CompareCriteria(
      new AggregateSymbol("count", "COUNT", false, new ElementSymbol("b", false)), //$NON-NLS-1$ //$NON-NLS-2$ //$NON-NLS-3$
      CompareCriteria.GT,
      new Constant(new Integer(0)) );

View Full Code Here


    Select select = new Select();
    select.addSymbol(new ElementSymbol("a")); //$NON-NLS-1$
    
    GroupBy groupBy = new GroupBy();
    groupBy.addSymbol(new ElementSymbol("a")); //$NON-NLS-1$
    groupBy.addSymbol(new ElementSymbol("b")); //$NON-NLS-1$
    
    CompoundCriteria having = new CompoundCriteria();
    having.setOperator(CompoundCriteria.AND);
    having.addCriteria(new CompareCriteria(

View Full Code Here

    Select select = new Select();
    select.addSymbol(new ElementSymbol("a")); //$NON-NLS-1$
    
    GroupBy groupBy = new GroupBy();
    groupBy.addSymbol(new ElementSymbol("a")); //$NON-NLS-1$
    groupBy.addSymbol(new ElementSymbol("b")); //$NON-NLS-1$
    
    CompoundCriteria having = new CompoundCriteria();
    having.setOperator(CompoundCriteria.AND);
    having.addCriteria(new CompareCriteria(
      new AggregateSymbol("count", "COUNT", false, new ElementSymbol("b", false)), //$NON-NLS-1$ //$NON-NLS-2$ //$NON-NLS-3$

View Full Code Here

      helpTest(from, "FROM m.g1, m.g2 CROSS JOIN m.g3");     //$NON-NLS-1$
    }
    
    public void testGroupBy1() {
      GroupBy gb = new GroupBy();
      gb.addSymbol(new ElementSymbol("m.g.e1")); //$NON-NLS-1$
      
      helpTest(gb, "GROUP BY m.g.e1");         //$NON-NLS-1$
    }


    public void testGroupBy2() {

View Full Code Here

      helpTest(gb, "GROUP BY m.g.e1");         //$NON-NLS-1$
    }


    public void testGroupBy2() {
      GroupBy gb = new GroupBy();
      gb.addSymbol(new ElementSymbol("m.g.e1")); //$NON-NLS-1$
      gb.addSymbol(new ElementSymbol("m.g.e2")); //$NON-NLS-1$
      gb.addSymbol(new ElementSymbol("m.g.e3")); //$NON-NLS-1$
      
      helpTest(gb, "GROUP BY m.g.e1, m.g.e2, m.g.e3");        //$NON-NLS-1$
    }

View Full Code Here

    }


    public void testGroupBy2() {
      GroupBy gb = new GroupBy();
      gb.addSymbol(new ElementSymbol("m.g.e1")); //$NON-NLS-1$
      gb.addSymbol(new ElementSymbol("m.g.e2")); //$NON-NLS-1$
      gb.addSymbol(new ElementSymbol("m.g.e3")); //$NON-NLS-1$
      
      helpTest(gb, "GROUP BY m.g.e1, m.g.e2, m.g.e3");        //$NON-NLS-1$
    }

View Full Code Here

0 1

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.