Examples of assertRowCount()

Examples of org.teiid.jdbc.AbstractQueryTest.assertRowCount()

320
321
322
323
324
325
326
327
328
329
330
       
        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);       
    }   

    /**
     * Sources = 2
     * Commands = 1, Update(prepared statement)
View Full Code Here

Examples of org.teiid.jdbc.AbstractQueryTest.assertRowCount()

344
345
346
347
348
349
350
351
352
353
354
        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

Examples of org.teiid.jdbc.AbstractQueryTest.assertRowCount()

348
349
350
351
352
353
354
355
356
357
358
        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

Examples of org.teiid.jdbc.AbstractQueryTest.assertRowCount()

394
395
396
397
398
399
400
401
402
403
404
      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
View Full Code Here

Examples of org.teiid.jdbc.AbstractQueryTest.assertRowCount()

396
397
398
399
400
401
402
403
404
405
406
      }
        };
        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"});
View Full Code Here

Examples of org.teiid.jdbc.AbstractQueryTest.assertRowCount()

445
446
447
448
449
450
451
452
453
454
455
      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

Examples of org.teiid.jdbc.AbstractQueryTest.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

Examples of org.teiid.jdbc.AbstractQueryTest.assertRowCount()

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

Examples of org.teiid.jdbc.AbstractQueryTest.assertRowCount()

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

Examples of org.teiid.jdbc.AbstractQueryTest.assertRowCount()

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
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.