Package org.teiid.query.sql.proc

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

98
99
100
101
102
103
104
105
106
107
    int equals = 0;
    UnitTestUtil.helpTestEquivalence(equals, b1, b1a);
  }
 
  public void testNonEquivalence(){
    Block b1 = sample1();
    Block b2 = sample2();
    int equals = -1;
    UnitTestUtil.helpTestEquivalence(equals, b1, b2);
  }
View Full Code Here
105
106
107
108
109
110
111
112
113
114
    int equals = -1;
    UnitTestUtil.helpTestEquivalence(equals, b1, b2);
  }
 
  public void testClone() {
    Block b1 = sample1();
    Block b2 = (Block)b1.clone();
    UnitTestUtil.helpTestEquivalence(0, b1, b2);
    assertNotSame(b1.getStatements().get(0), b2.getStatements().get(0));
  }
View Full Code Here
42
43
44
45
46
47
48
49
50
51
  } 
 
  // ################################## TEST HELPERS ################################ 

  public static final IfStatement sample1() {
    Block ifBlock = TestBlock.sample1();
    Block elseBlock = TestBlock.sample2();
    Criteria criteria = TestHasCriteria.sample1();
    return new IfStatement(criteria, ifBlock, elseBlock);
  }
View Full Code Here
49
50
51
52
53
54
55
56
57
58
    Criteria criteria = TestHasCriteria.sample1();
    return new IfStatement(criteria, ifBlock, elseBlock);
  }

  public static final IfStatement sample2() {
    Block ifBlock = TestBlock.sample2();
    Block elseBlock = TestBlock.sample1();
    Criteria criteria = TestHasCriteria.sample2();
    return new IfStatement(criteria, ifBlock, elseBlock);
  }
View Full Code Here
1514
1515
1516
1517
1518
1519
1520
1521
1522
1523
1524
        Delete d1 = new Delete();
        d1.setGroup(new GroupSymbol("g")); //$NON-NLS-1$
      CommandStatement cmdStmt =  new CommandStatement(d1);
      AssignmentStatement assigStmt =  new AssignmentStatement(new ElementSymbol("a"), new Constant(new Integer(1))); //$NON-NLS-1$
      RaiseErrorStatement errStmt =  new RaiseErrorStatement(new Constant("My Error")); //$NON-NLS-1$
      Block b = new Block();
      b.addStatement(cmdStmt);
      b.addStatement(assigStmt);
      b.addStatement(errStmt);
    helpTest(b, "BEGIN\nDELETE FROM g;\na = 1;\nERROR 'My Error';\nEND"); //$NON-NLS-1$
    }
View Full Code Here
1527
1528
1529
1530
1531
1532
1533
1534
1535
1536
1537
1538
1539
1540
1541
1542
1543
1544
1545
1546
1547
1548
1549
    // construct If statement

        Delete d1 = new Delete();
        d1.setGroup(new GroupSymbol("g")); //$NON-NLS-1$
      CommandStatement cmdStmt =  new CommandStatement(d1);
      Block ifblock = new Block(cmdStmt);
    // construct If criteria     
    ElementSymbol sy1 = new ElementSymbol("x"); //$NON-NLS-1$
    List elmnts = new ArrayList(1);
    elmnts.add(sy1);
    CriteriaSelector cs = new CriteriaSelector(CriteriaSelector.LIKE, elmnts);     
      Criteria crit = new HasCriteria(cs);     
      IfStatement ifStmt = new IfStatement(crit, ifblock);     
     
      // other statements
      RaiseErrorStatement errStmt =  new RaiseErrorStatement(new Constant("My Error")); //$NON-NLS-1$
      Block b = new Block();
      b.addStatement(cmdStmt);
      b.addStatement(ifStmt);
      b.addStatement(errStmt);     

    helpTest(b, "BEGIN\nDELETE FROM g;\nIF(HAS LIKE CRITERIA ON (x))\nBEGIN\nDELETE FROM g;\nEND\nERROR 'My Error';\nEND"); //$NON-NLS-1$
    }
View Full Code Here
1553
1554
1555
1556
1557
1558
1559
1560
1561
1562
1563
1564
1565
1566
        Delete d1 = new Delete();
        d1.setGroup(new GroupSymbol("g")); //$NON-NLS-1$
      CommandStatement cmdStmt =  new CommandStatement(d1);
      AssignmentStatement assigStmt =  new AssignmentStatement(new ElementSymbol("a"), new Constant(new Integer(1))); //$NON-NLS-1$
      RaiseErrorStatement errStmt =  new RaiseErrorStatement(new Constant("My Error")); //$NON-NLS-1$
      Block ifblock = new Block();
      ifblock.addStatement(cmdStmt);
      ifblock.addStatement(assigStmt);
      ifblock.addStatement(errStmt);

    // construct If criteria     
    ElementSymbol sy1 = new ElementSymbol("x"); //$NON-NLS-1$
    List elmnts = new ArrayList(1);
    elmnts.add(sy1);
View Full Code Here
1574
1575
1576
1577
1578
1579
1580
1581
1582
1583
1584
    public void testIfStatement2() {
    // construct If block
        Delete d1 = new Delete();
        d1.setGroup(new GroupSymbol("g")); //$NON-NLS-1$
      CommandStatement cmdStmt =  new CommandStatement(d1);
      Block ifblock = new Block(cmdStmt);

    // construct If criteria     
    ElementSymbol sy1 = new ElementSymbol("x"); //$NON-NLS-1$
    List elmnts = new ArrayList(1);
    elmnts.add(sy1);
View Full Code Here
1594
1595
1596
1597
1598
1599
1600
1601
1602
1603
1604
1605
1606
1607
1608
1609
1610
1611
1612
1613
1614
1615
1616
        Delete d1 = new Delete();
        d1.setGroup(new GroupSymbol("g")); //$NON-NLS-1$
      CommandStatement cmdStmt =  new CommandStatement(d1);
      AssignmentStatement assigStmt =  new AssignmentStatement(new ElementSymbol("a"), new Constant(new Integer(1))); //$NON-NLS-1$
      RaiseErrorStatement errStmt =  new RaiseErrorStatement(new Constant("My Error")); //$NON-NLS-1$
      Block ifblock = new Block();
      ifblock.addStatement(cmdStmt);
      ifblock.addStatement(assigStmt);
      ifblock.addStatement(errStmt);

    // construct If criteria     
    ElementSymbol sy1 = new ElementSymbol("x"); //$NON-NLS-1$
    List elmnts = new ArrayList(1);
    elmnts.add(sy1);
    CriteriaSelector cs = new CriteriaSelector(CriteriaSelector.LIKE, elmnts);     
      Criteria crit = new HasCriteria(cs);
     
      Block elseblock = new Block();
      elseblock.addStatement(cmdStmt);
     
      IfStatement ifStmt = new IfStatement(crit, ifblock, elseblock);
    helpTest(ifStmt, "IF(HAS LIKE CRITERIA ON (x))\nBEGIN\nDELETE FROM g;\na = 1;\nERROR 'My Error';\nEND\nELSE\nBEGIN\nDELETE FROM g;\nEND"); //$NON-NLS-1$
    }   
View Full Code Here
1619
1620
1621
1622
1623
1624
1625
1626
1627
1628
1629
1630
        Delete d1 = new Delete();
        d1.setGroup(new GroupSymbol("g")); //$NON-NLS-1$
      CommandStatement cmdStmt =  new CommandStatement(d1);
      AssignmentStatement assigStmt =  new AssignmentStatement(new ElementSymbol("a"), new Constant(new Integer(1))); //$NON-NLS-1$
      RaiseErrorStatement errStmt =  new RaiseErrorStatement(new Constant("My Error")); //$NON-NLS-1$
      Block b = new Block();
      b.addStatement(cmdStmt);
      b.addStatement(assigStmt);
      b.addStatement(errStmt);
      CreateUpdateProcedureCommand cup = new CreateUpdateProcedureCommand(b);
    helpTest(cup, "CREATE PROCEDURE\nBEGIN\nDELETE FROM g;\na = 1;\nERROR 'My Error';\nEND");       //$NON-NLS-1$
    }
View Full Code Here
TOP

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

  • org.teiid.query.optimizer.ProcedurePlanner
  • org.teiid.query.parser.TestOptionsAndHints
  • org.teiid.query.parser.TestParser
  • org.teiid.query.resolver.TestProcedureResolving
  • org.teiid.query.rewriter.QueryRewriter
  • org.teiid.query.sql.lang.Command
  • org.teiid.query.sql.proc.TestBlock
  • org.teiid.query.sql.proc.TestIfStatement
  • org.teiid.query.sql.proc.TestLoopStatement
  • org.teiid.query.sql.proc.TestWhileStatement
    • 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.