Examples of org.teiid.query.sql.lang.From.addGroup()

org.teiid.query.sql.lang.From.addGroup()
Adds a new group to the list (it will be wrapped in a UnaryFromClause) @param group Group to add

        List symbols = new ArrayList();
        symbols.add(new ElementSymbol("a1"));  //$NON-NLS-1$
        Select select = new Select(symbols);       
        
        From from = new From();
        from.addGroup(new GroupSymbol("g")); //$NON-NLS-1$
        
        Criteria criteria = new CompareCriteria(new ElementSymbol("a2"), CompareCriteria.EQ,  //$NON-NLS-1$
            new Constant(new Integer(5)));
        
        Query query = new Query();

View Full Code Here

        List symbols = new ArrayList();
        symbols.add(new ElementSymbol("a1"));  //$NON-NLS-1$
        Select select = new Select(symbols);       
        
        From from = new From();
        from.addGroup(new GroupSymbol("g")); //$NON-NLS-1$
        
        Criteria criteria = new CompareCriteria(new ElementSymbol("a2"), CompareCriteria.EQ,  //$NON-NLS-1$
            new Constant(new Integer(5)));
        
        Query query = new Query();

View Full Code Here

        List symbols = new ArrayList();
        symbols.add(new ElementSymbol("a1"));  //$NON-NLS-1$
        Select select = new Select(symbols);       
        
        From from = new From();
        from.addGroup(new GroupSymbol("g")); //$NON-NLS-1$
        
        Criteria criteria = new CompareCriteria(new ElementSymbol("a2"), CompareCriteria.EQ,  //$NON-NLS-1$
            new Constant(new Integer(5)));
        
        Query query = new Query();

View Full Code Here

    }
    
  static Query exampleIn(boolean semiJoin) {
    GroupSymbol g = new GroupSymbol("db.g"); //$NON-NLS-1$
        From from = new From();
        from.addGroup(g);


        Select select = new Select();
        select.addSymbol(new ElementSymbol("a")); //$NON-NLS-1$


        Expression expr = new ElementSymbol("b"); //$NON-NLS-1$

View Full Code Here

               
    @Test public void testSubquerySetCriteria1() { 


        GroupSymbol g = new GroupSymbol("db.g"); //$NON-NLS-1$
        From from = new From();
        from.addGroup(g);


        Select select = new Select();
        select.addSymbol(new ElementSymbol("a")); //$NON-NLS-1$


        Expression expr = new ElementSymbol("b"); //$NON-NLS-1$

View Full Code Here

    }                


    @Test public void testSubquerySetCriteriaWithExec() { 
        GroupSymbol g = new GroupSymbol("db.g"); //$NON-NLS-1$
        From from = new From();
        from.addGroup(g);


        Select select = new Select();
        select.addSymbol(new ElementSymbol("a")); //$NON-NLS-1$


        Expression expr = new ElementSymbol("b"); //$NON-NLS-1$

View Full Code Here

    }          


    @Test public void testSubquerySetCriteriaWithUnion() { 
        GroupSymbol g = new GroupSymbol("db.g"); //$NON-NLS-1$
        From from = new From();
        from.addGroup(g);


        Select select = new Select();
        select.addSymbol(new ElementSymbol("a")); //$NON-NLS-1$


        Expression expr = new ElementSymbol("b"); //$NON-NLS-1$

View Full Code Here

            Query query = new Query();
            Select select = new Select();
            select.addSymbol(new AllSymbol());
            query.setSelect(select);
            From from = new From();
            from.addGroup(new GroupSymbol("TestDocument.TestDocument")); //$NON-NLS-1$
            query.setFrom(from);            
            CompareCriteria crit = new CompareCriteria(new ElementSymbol("Subject"), CompareCriteria.EQ, new Constant(string)); //$NON-NLS-1$
            query.setCriteria(crit);


            helpTest(sql, query.toString(), query);

View Full Code Here

        Query query = new Query();
        Select select = new Select();
        select.addSymbol(new AllSymbol());
        query.setSelect(select);
        From from = new From();
        from.addGroup(new GroupSymbol("TestDocument.TestDocument")); //$NON-NLS-1$
        query.setFrom(from);           
        CompareCriteria crit = new CompareCriteria(new ElementSymbol("Subject"), CompareCriteria.EQ, new Constant("AZ")); //$NON-NLS-1$ //$NON-NLS-2$
        query.setCriteria(crit);


        helpTest(sql, query.toString(), query);

View Full Code Here

    Query query = new Query();
    Select select = new Select();
    ElementSymbol e = new ElementSymbol("\u05e0"); //$NON-NLS-1$
    select.addSymbol(e);
    From from = new From();
    from.addGroup(new GroupSymbol("g")); //$NON-NLS-1$
    query.setSelect(select);
    query.setFrom(from);


    helpTest(sql, query.toString(), query);
  }

View Full Code Here

0 1 2 3 4 5 6 7 8 9

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.