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 = 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 = 102");
        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 e2 = '500'");
        test.assertRowCount(1);
        test.closeConnection();
        
        test = new QueryExecution(userTxn.getSource("pm2"));
        test.execute("select * from g1 where e2 = '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 e2 = '501'");
        test.assertRowCount(1);
        
        test = new QueryExecution(userTxn.getSource("pm2"));
        test.execute("select * from g1 where e2 = '501'");
        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 and e1 < 112");
        test.assertRowCount(12);
        
        test = new QueryExecution(userTxn.getSource("pm2"));
        test.execute("select * from g1 where e1 >= 100 and e1 < 112");
        test.assertRowCount(12);
        test.execute("select * from g2 where e1 >= 100 and e1 < 112");
        test.assertRowCount(12);        
    }

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")) {
      protected boolean compareCaseSensitive() {
    return false;
      }
        };
        test.execute("select * from g1 where e1 >= 100 and e1 < 115");
        test.assertRowCount(15);
        test.execute("select * from g2 where e1 >= 100 and e1 < 115");
        test.assertRowCount(15);
        test.execute("select distinct e2 from g1 where e1 > 100");
        
        // NOTE:  if this is an oracle source, it failes because it return varchar2
        if (userTxn.getSource("pm1").getMetaData().getDatabaseProductName().toLowerCase().indexOf("oracle") > -1) {
            test.assertResultsSetEquals(new String[] {"e2[varchar2]", "blah"});
        } else {
            test.assertResultsSetEquals(new String[] {"e2[varchar]", "blah"});
        }
     
    }

View Full Code Here

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


        // now verify the results
        AbstractQueryTest test = new QueryExecution(userTxn.getSource("pm1")){
      protected boolean compareCaseSensitive() {
    return false;
      }
        };
        test.execute("select * from g1 where e1 >= 200 and e1 < 207");
        test.assertRowCount(5);
        test.execute("select * from g2 where e1 >= 200 and e1 < 207");
        test.assertRowCount(5);
        test.execute("select distinct e2 from g1 where e1 >= 200 and e1 < 207");
        test.assertResultsSetEquals(new String[] {"e2[varchar2]", "blah"});
      
    }

View Full Code Here

            }
        };
        getTransactionContainter().runTransaction(userTxn);
                
        // now verify the results (this may finish under one second, then this test is not valid)
        AbstractQueryTest test = new QueryExecution(userTxn.getSource("pm1"));
        test.execute("select * from g1 where e1 >= 600 and e1 < 650");
        test.assertRowCount(0);
        test.execute("select * from g2 where e1 >= 600 and e1 < 650");
        test.assertRowCount(0);
        test.execute("select distinct e2 from g1 where e1 >= 600 and e1 < 650");
        test.assertRowCount(0);
    }

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.