Examples of org.teiid.jdbc.AbstractQueryTest

org.teiid.jdbc.AbstractQueryTest
This class can be used as the base class to write Query tests for integration testing. Just like the scripted one this one should provide all those required flexibility in testing.

        
        // run test
        getTransactionContainter().runTransaction(userTxn);      


        // now verify the results
        AbstractQueryTest test = new QueryExecution(userTxn.getSource("pm1"));
        test.execute("select * from g1 where e1 >= 700 and e1 < 720");
        test.assertRowCount(0);
  
        
        test = new QueryExecution(userTxn.getSource("pm2"));
        test.execute("select * from g1 where e1 >= 700 and e1 < 720");
        test.assertRowCount(0);        
     
    }

View Full Code Here

        
        // run test
        getTransactionContainter().runTransaction(userTxn);       
        
        // now verify the results
        AbstractQueryTest test = new QueryExecution(userTxn.getSource("pm1"));
        test.execute("select * from g1 where e1 >= 100 and e1 < 120");
        test.assertRowCount(0);
        
        test = new QueryExecution(userTxn.getSource("pm2"));
        test.execute("select * from g1 where e1 >= 100 and e1 < 120");
        test.assertRowCount(0);
        test.execute("select * from g2 where e1 >= 100 and e1 < 120");
        test.assertRowCount(0);        
    }

View Full Code Here

        
        // run test
        getTransactionContainter().runTransaction(userTxn);      


        // now verify the results
        AbstractQueryTest test = new QueryExecution(userTxn.getSource("pm1"));
        test.execute("select * from g1 where e1 >= 600 and e1 < 615");
        test.assertRowCount(0);
        test.execute("select * from g2 where e1 >= 600 and e1 < 615");
        test.assertRowCount(0);
        test.execute("select distinct e2 from g1 where e1 >= 600 and e1 < 615");
        test.assertRowCount(0);
      
    }

View Full Code Here

        
        // run test
        getTransactionContainter().runTransaction(userTxn);       


        // now verify the results
        AbstractQueryTest test = new QueryExecution(userTxn.getSource("pm1"));
        test.execute("select * from g1 where e1 = 100");
        test.assertRowCount(1);
    }

View Full Code Here

        
        // run test
        getTransactionContainter().runTransaction(userTxn);      


        // now verify the results
        AbstractQueryTest test = new QueryExecution(userTxn.getSource("pm1"));
        test.execute("select * from g1 where e1 >= 100");
        test.assertRowCount(10);
        test.execute("select * from g2 where e1 >= 100");
        test.assertRowCount(10);        
      
    }

View Full Code Here

        
        // run test
        getTransactionContainter().runTransaction(userTxn);      


        // now verify the results
        AbstractQueryTest test = new QueryExecution(userTxn.getSource("pm1"));
        test.execute("select * from g1 where e1 >= 200");
        test.assertRowCount(10);
     
    }

View Full Code Here

        
        // run test
        getTransactionContainter().runTransaction(userTxn);       
        
        // now verify the results
        AbstractQueryTest test = new QueryExecution(userTxn.getSource("pm1"));
        test.execute("select * from g1 where e1 = 500");
        test.assertRowCount(1);
        
        test = new QueryExecution(userTxn.getSource("pm2"));
        test.execute("select * from g1 where e1 = 500");
        test.assertRowCount(1);
    }

View Full Code Here

        
        // run test
        getTransactionContainter().runTransaction(userTxn);      


        // now verify the results
        AbstractQueryTest test = new QueryExecution(userTxn.getSource("pm1"));
        test.execute("select * from g1 where e1 >= 700 and e1 < 710");
        test.assertRowCount(10);
      
        
        test = new QueryExecution(userTxn.getSource("pm2"));
        test.execute("select * from g1 where e1 >= 700 and e1 < 710");
        test.assertRowCount(10);        
      
    }

View Full Code Here

        
        // run test
        getTransactionContainter().runTransaction(userTxn);       
        
        // now verify the results
        AbstractQueryTest test = new QueryExecution(userTxn.getSource("pm1"));
        test.execute("select * from g1 where e1 >= 800 and e1 < 807");
        test.assertRowCount(7);
        
        test = new QueryExecution(userTxn.getSource("pm2"));
        test.execute("select * from g1 where e1 >= 800 and e1 < 807");
        test.assertRowCount(7);
        test.execute("select * from g2 where e1 >= 800 and e1 < 807");
        test.assertRowCount(7);        


    }

View Full Code Here

0 1 2

TOP

Related Classes of org.teiid.jdbc.AbstractQueryTest

org.teiid.script.io.ResultSetReader

org.teiid.test.testcases.AutoWrapTransactionTests

org.teiid.test.testcases.CommonTransactionTests

org.teiid.test.testcases.LocalTransactionTests

org.teiid.test.testcases.OffWrapTransactionTests

org.teiid.test.testcases.OnWrapTransactionTests

java.io.FileWriter

java.io.BufferedWriter

java.io.StringReader

java.io.FileReader

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.