Examples of DeclareStatement

org.allspice.structured.statement.DeclareStatement
The "declare" statement. @author egoff
org.teiid.query.sql.proc.DeclareStatement

This class represents a statement used to declare variables in the storedprocedure language. It extends the Statement that could part of a Block. This this object holds variable and it's type.

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

        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

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

        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

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

    }
    
    @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

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

  }
  
  // ################################## TEST HELPERS ################################  


  public static final DeclareStatement sample1() { 
    return new DeclareStatement(new ElementSymbol("a"), "String"); //$NON-NLS-1$ //$NON-NLS-2$
  }

View Full Code Here

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

  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

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

  }
  
  // ################################## 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

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

    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

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

    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

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

    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

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

    int equals = 0;
    UnitTestUtil.helpTestEquivalence(equals, s1, s1a);
  }
  
  public void testNonEquivalence(){
    DeclareStatement s1 = sample1();
    DeclareStatement s2 = sample2();
    int equals = -1;
    UnitTestUtil.helpTestEquivalence(equals, s1, s2);
  }

View Full Code Here

0 1 2 3 4

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.