Package org.teiid.query.sql.lang

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

5346
5347
5348
5349
5350
5351
5352
5353
5354
5355
5356
        JoinPredicate jp1 = new JoinPredicate(g2, g3, JoinType.JOIN_RIGHT_OUTER, jcrits2);
        JoinPredicate jp2 = new JoinPredicate(g1, jp1, JoinType.JOIN_INNER, jcrits1);      
        JoinPredicate jp3 = new JoinPredicate(jp2, g4, JoinType.JOIN_INNER, jcrits3);      
       
        from.addClause(jp3);
        query.setFrom(from);          

        helpTest(sql, sqlExpected, query);       
    }
 
View Full Code Here
5390
5391
5392
5393
5394
5395
5396
5397
5398
5399
5400
        JoinPredicate jp1 = new JoinPredicate(g2, g3, JoinType.JOIN_RIGHT_OUTER, jcrits1);
        JoinPredicate jp2 = new JoinPredicate(jp1, g4, JoinType.JOIN_CROSS);      
        JoinPredicate jp3 = new JoinPredicate(g1, jp2, JoinType.JOIN_INNER, jcrits2);      
       
        from.addClause(jp3);
        query.setFrom(from);          

        helpTest(sql, sqlExpected, query);       
    }     
     
View Full Code Here
2972
2973
2974
2975
2976
2977
2978
2979
2980
2981
2982
        query.setSelect(select);
        query.setFrom(from);
       
        SubqueryFromClause sfc = new SubqueryFromClause("y", query); //$NON-NLS-1$
        From from2 = new From();
        from2.addClause(sfc);
       
        Select select2 = new Select();
        select2.addSymbol(new ElementSymbol("a")); //$NON-NLS-1$
        select2.addSymbol(new ElementSymbol("b")); //$NON-NLS-1$
       
View Full Code Here
3003
3004
3005
3006
3007
3008
3009
3010
3011
3012
3013
        query.setSelect(select);
        query.setFrom(from);
       
        SubqueryFromClause sfc = new SubqueryFromClause("y", query); //$NON-NLS-1$
        From from2 = new From();
        from2.addClause(sfc);
       
        Select select2 = new Select();
        select2.addSymbol(new ElementSymbol("a")); //$NON-NLS-1$
        select2.addSymbol(new ElementSymbol("b")); //$NON-NLS-1$
       
View Full Code Here
3039
3040
3041
3042
3043
3044
3045
3046
3047
3048
3049
        CompareCriteria join = new CompareCriteria(new ElementSymbol("m.g1.a"), CompareCriteria.EQ, new ElementSymbol("y.c")); //$NON-NLS-1$ //$NON-NLS-2$
        List crits = new ArrayList();
        crits.add(join);
        JoinPredicate jp = new JoinPredicate(ufc, sfc, JoinType.JOIN_INNER, crits);
        From from2 = new From();
        from2.addClause(jp);
                       
        Select select2 = new Select();
        select2.addSymbol(new ElementSymbol("a")); //$NON-NLS-1$
        select2.addSymbol(new ElementSymbol("b")); //$NON-NLS-1$
       
View Full Code Here
3087
3088
3089
3090
3091
3092
3093
3094
3095
3096
3097
      StoredProcedure storedQuery = new StoredProcedure();
      storedQuery.setProcedureName("proc1"); //$NON-NLS-1$
     
        From from = new From();
        SubqueryFromClause sfc = new SubqueryFromClause("x", storedQuery); //$NON-NLS-1$
        from.addClause(sfc);
       
        Select select = new Select();
        select.addSymbol(new ElementSymbol("x.a")); //$NON-NLS-1$
       
        Query query = new Query();
View Full Code Here
213
214
215
216
217
218
219
220
221
222
223
      new ElementSymbol("g2.a2")); //$NON-NLS-1$
    ArrayList<Criteria> crits = new ArrayList<Criteria>();
    crits.add(jcrit);   
    JoinPredicate jp = new JoinPredicate(g1, g2, JoinType.JOIN_INNER, crits);
    From from = new From();
    from.addClause(jp);

    AllSymbol all = new AllSymbol();
    Select select = new Select();
    select.addSymbol(all);
View Full Code Here
233
234
235
236
237
238
239
240
241
242
243
  @Test public void testCrossJoin() {
    UnaryFromClause g1 = new UnaryFromClause(new GroupSymbol("g1")); //$NON-NLS-1$
    UnaryFromClause g2 = new UnaryFromClause(new GroupSymbol("g2")); //$NON-NLS-1$
    JoinPredicate jp = new JoinPredicate(g1, g2, JoinType.JOIN_CROSS);   
    From from = new From();
    from.addClause(jp); 

    AllSymbol all = new AllSymbol();
    Select select = new Select();
    select.addSymbol(all);
View Full Code Here
254
255
256
257
258
259
260
261
262
263
264
  @Test public void testFromClauses() {
    UnaryFromClause g1 = new UnaryFromClause(new GroupSymbol("g1")); //$NON-NLS-1$
    UnaryFromClause g2 = new UnaryFromClause(new GroupSymbol("g2")); //$NON-NLS-1$
    JoinPredicate jp = new JoinPredicate(g1, g2, JoinType.JOIN_CROSS);   
    From from = new From();
    from.addClause(jp); 
    from.addClause(new UnaryFromClause(new GroupSymbol("g3"))); //$NON-NLS-1$

    AllSymbol all = new AllSymbol();
    Select select = new Select();
    select.addSymbol(all);
View Full Code Here
255
256
257
258
259
260
261
262
263
264
265
    UnaryFromClause g1 = new UnaryFromClause(new GroupSymbol("g1")); //$NON-NLS-1$
    UnaryFromClause g2 = new UnaryFromClause(new GroupSymbol("g2")); //$NON-NLS-1$
    JoinPredicate jp = new JoinPredicate(g1, g2, JoinType.JOIN_CROSS);   
    From from = new From();
    from.addClause(jp); 
    from.addClause(new UnaryFromClause(new GroupSymbol("g3"))); //$NON-NLS-1$

    AllSymbol all = new AllSymbol();
    Select select = new Select();
    select.addSymbol(all);
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.