Package org.teiid.test.framework.query

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

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

    /**
     * Sources = 2
View Full Code Here
343
344
345
346
347
348
349
350
351
352
353
        // 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
347
348
349
350
351
352
353
354
355
356
357
        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
393
394
395
396
397
398
399
400
401
402
403
        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");
       
View Full Code Here
76
77
78
79
80
81
82
83
84
85
86
  // run test
  getTransactionContainter().runTransaction(userTxn);

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

View Full Code Here
78
79
80
81
82
83
84
85
86
87
88
  // now verify the results
  AbstractQueryTest test = new QueryExecution(userTxn.getSource("pm1"));
  test.execute("select * from g1 where e1 >= 200 and e1 < 210");
  test.assertRowCount(10);
  test.execute("select * from g2 where e1 = 9999");
  test.assertRowCount(0);
    }

    /**
     * Sources = 1 Commands = multiple Success Batching = Full Processing,
View Full Code Here
114
115
116
117
118
119
120
121
122
123
124
  // run test
  getTransactionContainter().runTransaction(userTxn);

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

View Full Code Here
116
117
118
119
120
121
122
123
124
125
126
  // now verify the results
  AbstractQueryTest test = new QueryExecution(userTxn.getSource("pm1"));
  test.execute("select * from g1 where e1 >= 200 and e1 < 210");
  test.assertRowCount(0);
  test.execute("select * from g2 where e1 = 9999");
  test.assertRowCount(0);
    }

    /**
     * Sources = 2 Commands = 1, Update Batching = Full Processing, Single
View Full Code Here
155
156
157
158
159
160
161
162
163
164
165
  // 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 < 110");
  test.assertRowCount(0);

  test = new QueryExecution(userTxn.getSource("pm2"));
  test.execute("select * from g1 where e1 >= 100 and e1 < 110");
  test.assertRowCount(0);
View Full Code Here
159
160
161
162
163
164
165
166
167
168
169
  AbstractQueryTest test = new QueryExecution(userTxn.getSource("pm1"));
  test.execute("select * from g1 where e1 >= 100 and e1 < 110");
  test.assertRowCount(0);

  test = new QueryExecution(userTxn.getSource("pm2"));
  test.execute("select * from g1 where e1 >= 100 and e1 < 110");
  test.assertRowCount(0);
  test.execute("select * from g2 where e1 >= 100 and e1 < 110");
  test.assertRowCount(0);
    }
   
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.