Package org.teiid.query.sql.proc

Examples of org.teiid.query.sql.proc.DeclareStatement

4880
4881
4882
4883
4884
4885
4886
4887
4888
4889
4890
4891
4892
4893
4894
4895
4896
4897
4898
4899
4900
4901
4902
4903
4904
4905
4906
4907
4908
4909
4910
4911
4912
4913
4914
4915
    /**IF statement with has criteria no on */
    @Test public void testCreateUpdateProcedureCommand8(){
        //declare var1
        ElementSymbol var1 = new ElementSymbol("var1"); //$NON-NLS-1$
        String shortType = new String("short"); //$NON-NLS-1$
        Statement declStmt = new DeclareStatement(var1, shortType);
       
        //ifblock
        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();
        query.setSelect(select);
        query.setFrom(from);
        query.setCriteria(criteria);
       
        AssignmentStatement queryStmt = new AssignmentStatement(var1, query);
             
        Block ifBlock = new Block();     
        ifBlock.addStatement(queryStmt);
       
        //else block
        ElementSymbol var2 = new ElementSymbol("var2"); //$NON-NLS-1$
        Statement elseDeclStmt = new DeclareStatement(var2, shortType);    
       
        List elseSymbols = new ArrayList();
        elseSymbols.add(new ElementSymbol("b1"));  //$NON-NLS-1$
        Select elseSelect = new Select(elseSymbols);
   
View Full Code Here
5412
5413
5414
5415
5416
5417
5418
5419
5420
5421
5422
        query.setSelect(select);
        query.setFrom(from);
       
        ElementSymbol x = new ElementSymbol("x"); //$NON-NLS-1$
        String intType = new String("integer"); //$NON-NLS-1$
        Statement dStmt = new DeclareStatement(x, intType);
        c1 = new ElementSymbol("mycursor.c1", true); //$NON-NLS-1$
        Statement assignmentStmt = new AssignmentStatement(x, c1);
        Block block = new Block();
        block.addStatement(dStmt);
        block.addStatement(assignmentStmt);
View Full Code Here
5448
5449
5450
5451
5452
5453
5454
5455
5456
5457
5458
        query.setFrom(from);
        query.setOrderBy(orderBy);
       
        ElementSymbol x = new ElementSymbol("x"); //$NON-NLS-1$
        String intType = new String("integer"); //$NON-NLS-1$
        Statement dStmt = new DeclareStatement(x, intType);
        c1 = new ElementSymbol("mycursor.c1", true); //$NON-NLS-1$
        Statement assignmentStmt = new AssignmentStatement(x, c1);
        Block block = new Block();
        block.addStatement(dStmt);
        block.addStatement(assignmentStmt);
View Full Code Here
5491
5492
5493
5494
5495
5496
5497
5498
5499
5500
5501
    }
   
    @Test public void testVirtualProcedure(){       
        ElementSymbol x = new ElementSymbol("x"); //$NON-NLS-1$
        String intType = new String("integer"); //$NON-NLS-1$
        Statement dStmt = new DeclareStatement(x, intType);
       
        GroupSymbol g = new GroupSymbol("m.g"); //$NON-NLS-1$
        From from = new From();
        from.addGroup(g);
       
View Full Code Here
43
44
45
46
47
48
49
  }
 
  // ################################## TEST HELPERS ################################ 

  public static final DeclareStatement sample1() {
    return new DeclareStatement(new ElementSymbol("a"), "String"); //$NON-NLS-1$ //$NON-NLS-2$
  }
View Full Code Here
47
48
49
50
51
52
53
  public static final DeclareStatement sample1() {
    return new DeclareStatement(new ElementSymbol("a"), "String"); //$NON-NLS-1$ //$NON-NLS-2$
  }
 
  public static final DeclareStatement sample2() {
    return new DeclareStatement(new ElementSymbol("b"), "Integer"); //$NON-NLS-1$ //$NON-NLS-2$
  }
View Full Code Here
53
54
55
56
57
58
59
60
  }
 
  // ################################## ACTUAL TESTS ################################ 
 
  public void testGetVariable() {
    DeclareStatement s1 = sample1();
    assertEquals("Incorrect variable ", s1.getVariable(), new ElementSymbol("a"));     //$NON-NLS-1$ //$NON-NLS-2$
  }
View Full Code Here
58
59
60
61
62
63
64
65
    DeclareStatement s1 = sample1();
    assertEquals("Incorrect variable ", s1.getVariable(), new ElementSymbol("a"));     //$NON-NLS-1$ //$NON-NLS-2$
  }
 
  public void testGetVariableType() {
    DeclareStatement s1 = sample1();
    assertEquals("Incorrect variable type ", s1.getVariableType(), "String"); //$NON-NLS-1$ //$NON-NLS-2$
  }
View Full Code Here
63
64
65
66
67
68
69
70
71
    DeclareStatement s1 = sample1();
    assertEquals("Incorrect variable type ", s1.getVariableType(), "String"); //$NON-NLS-1$ //$NON-NLS-2$
  }
 
  public void testSelfEquivalence(){
    DeclareStatement s1 = sample1();
    int equals = 0;
    UnitTestUtil.helpTestEquivalence(equals, s1, s1);
  }
View Full Code Here
69
70
71
72
73
74
75
76
77
78
    int equals = 0;
    UnitTestUtil.helpTestEquivalence(equals, s1, s1);
  }

  public void testEquivalence(){
    DeclareStatement s1 = sample1();
    DeclareStatement s1a = sample1();
    int equals = 0;
    UnitTestUtil.helpTestEquivalence(equals, s1, s1a);
  }
View Full Code Here
TOP

Related Classes of org.teiid.query.sql.proc.DeclareStatement

  • org.teiid.query.parser.TestOptionsAndHints
  • org.teiid.query.parser.TestParser
  • org.teiid.query.sql.proc.TestDeclareStatement
  • org.teiid.query.sql.visitor.TestSQLStringVisitor
    • Copyright © 2018 www.massapicom. 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.