Package org.teiid.test.framework.query

Examples of org.teiid.test.framework.query.QueryExecution.assertRowCount()

447
448
449
450
451
452
453
454
455
456
457
      }
        };
        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
490
491
492
493
494
495
496
497
498
499
500
        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
492
493
494
495
496
497
498
499
500
501
502
        // 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
494
495
496
497
498
499
500
501
502
503
504
        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);
    }

    /**
     * Sources = 2
     * Commands = multiple - Success
View Full Code Here
553
554
555
556
557
558
559
560
561
562
563
        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 < 750");
        test.assertRowCount(0);
        test.execute("select * from g2 where e1 >= 600 and e1 < 750");
        test.assertRowCount(0);
        test.execute("select distinct e2 from g1 where e1 >= 600 and e1 < 750");
        test.assertRowCount(0);
     
View Full Code Here
555
556
557
558
559
560
561
562
563
564
565
        // 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 < 750");
        test.assertRowCount(0);
        test.execute("select * from g2 where e1 >= 600 and e1 < 750");
        test.assertRowCount(0);
        test.execute("select distinct e2 from g1 where e1 >= 600 and e1 < 750");
        test.assertRowCount(0);
     
    }   
   
View Full Code Here
557
558
559
560
561
562
563
564
565
566
567
        test.execute("select * from g1 where e1 >= 600 and e1 < 750");
        test.assertRowCount(0);
        test.execute("select * from g2 where e1 >= 600 and e1 < 750");
        test.assertRowCount(0);
        test.execute("select distinct e2 from g1 where e1 >= 600 and e1 < 750");
        test.assertRowCount(0);
     
    }   
   
       
    static String[] getMultipleSourceBatch() {
View Full Code Here
54
55
56
57
58
59
60
61
62
63
64
        getTransactionContainter().runTransaction(userTxn);     

        // now verify the results
        AbstractQueryTest test = new QueryExecution(userTxn.getSource("pm1"));
        test.execute("select * from g1 where e1 >= 200 and e1 < 220");
        test.assertRowCount(0);
        test.execute("select * from g2 where e1 >= 200 and e1 < 220");
        test.assertRowCount(0);       
     
    }
   
View Full Code Here
56
57
58
59
60
61
62
63
64
65
66
        // now verify the results
        AbstractQueryTest test = new QueryExecution(userTxn.getSource("pm1"));
        test.execute("select * from g1 where e1 >= 200 and e1 < 220");
        test.assertRowCount(0);
        test.execute("select * from g2 where e1 >= 200 and e1 < 220");
        test.assertRowCount(0);       
     
    }
   
    /**
     * Sources = 1
View Full Code Here
91
92
93
94
95
96
97
98
99
100
101
        getTransactionContainter().runTransaction(userTxn);     

        // now verify the results
        AbstractQueryTest test = new QueryExecution(userTxn.getSource("pm1"));
        test.execute("select * from g1 where e1 >= 200 and e1 < 220");
        test.assertRowCount(0);
   
    }   
   
    /**
     * Sources = 2
View Full Code Here
TOP
Copyright © 2018 www.massapi.com. 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.