Package com.alvazan.orm.api.z3api

Examples of com.alvazan.orm.api.z3api.QueryResult

262
263
264
265
266
267
268
269
270
271
272
273
274
275
 
  @Test
  public void testInnerJoinParts2() throws InterruptedException {
    NoSqlTypedSession s = mgr.getTypedSession();

    QueryResult result = s.createQueryCursor("select * FROM Account as a WHERE a.isActive = false", 50);
   
    Cursor<IndexColumnInfo> cursor = result.getCursor();
    List<ViewInfo> views = result.getViews();
   
    ViewInfo viewAct = views.get(0);
    String alias1 = viewAct.getAlias();
    Assert.assertEquals("a", alias1);
   
View Full Code Here
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
 
  @Test
  public void testInnerJoinParts2Backward() throws InterruptedException {
    NoSqlTypedSession s = mgr.getTypedSession();

    QueryResult result = s.createQueryCursor("select * FROM Account as a WHERE a.isActive = false", 50);
   
    Cursor<IndexColumnInfo> cursor = result.getCursor();
    cursor.afterLast();
    List<ViewInfo> views = result.getViews();
   
    ViewInfo viewAct = views.get(0);
    String alias1 = viewAct.getAlias();
    Assert.assertEquals("a", alias1);
   
View Full Code Here
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
 
  @Test
  public void testInnerJoinBackward() throws InterruptedException {
    NoSqlTypedSession s = mgr.getTypedSession();

    QueryResult result = s.createQueryCursor("select * FROM Activity as e INNER JOIN e.account  as a WHERE e.numTimes < 15 and a.isActive = false", 50);
   
    Cursor<IndexColumnInfo> cursor = result.getCursor();
    cursor.afterLast();
    List<ViewInfo> views = result.getViews();
   
    ViewInfo viewAct = views.get(0);
    ViewInfo viewAcc = views.get(1);
    String alias1 = viewAct.getAlias();
    String alias2 = viewAcc.getAlias();
    Assert.assertEquals("e", alias1);
    Assert.assertEquals("a", alias2);
   
    Assert.assertTrue(cursor.previous());
    compareKeys(cursor, viewAct, viewAcc, "act7", "acc1");
    Assert.assertTrue(cursor.previous());
    compareKeys(cursor, viewAct, viewAcc, "act1", "acc1");
    Assert.assertFalse(cursor.previous());
   
    Cursor<List<TypedRow>> rows = result.getAllViewsCursor();
    rows.afterLast();
   
    rows.previous();
    List<TypedRow> joinedRow = rows.getCurrent();
   
View Full Code Here
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
   */
  @Test
  public void testInnerJoinBackwardRepeatedly() throws InterruptedException {
    NoSqlTypedSession s = mgr.getTypedSession();

    QueryResult result = s.createQueryCursor("select * FROM Activity as e INNER JOIN e.account  as a WHERE e.numTimes < 15 and a.isActive = false", 50);
    List<ViewInfo> views = result.getViews();
    Cursor<IndexColumnInfo> cursor = result.getCursor();
    cursor.afterLast();
    //iterate all the way through to force everything to load once, then ensure things are still in the correct (reversed) order:
    while(cursor.previous()){cursor.getCurrent();}
    cursor.afterLast();
   
    ViewInfo viewAct = views.get(0);
    ViewInfo viewAcc = views.get(1);
    String alias1 = viewAct.getAlias();
    String alias2 = viewAcc.getAlias();
    Assert.assertEquals("e", alias1);
    Assert.assertEquals("a", alias2);
   
    Assert.assertTrue(cursor.previous());
    compareKeys(cursor, viewAct, viewAcc, "act7", "acc1");
    Assert.assertTrue(cursor.previous());
    compareKeys(cursor, viewAct, viewAcc, "act1", "acc1");
    Assert.assertFalse(cursor.previous());
   
    Cursor<List<TypedRow>> rows = result.getAllViewsCursor();
    rows.afterLast();
   
    rows.previous();
    List<TypedRow> joinedRow = rows.getCurrent();
   
View Full Code Here
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
  @Test
  public void testJoinViewButNoJoin() throws InterruptedException {
    NoSqlTypedSession s = mgr.getTypedSession();

    QueryResult result = s.createQueryCursor("select * FROM Activity as e WHERE e.numTimes < 15", 50);
    List<ViewInfo> views = result.getViews();
    Assert.assertEquals(1, views.size());
    Cursor<IndexColumnInfo> cursor = result.getCursor();

    ViewInfo viewAct = views.get(0);
    String alias1 = viewAct.getAlias();
    Assert.assertEquals("e", alias1);
   
    Assert.assertTrue(cursor.next());
    compareKeys2(cursor, viewAct, "act1");
    Assert.assertTrue(cursor.next());
    compareKeys2(cursor, viewAct, "act3");
    Assert.assertTrue(cursor.next());
    compareKeys2(cursor, viewAct, "act5");
    Assert.assertTrue(cursor.next());
    compareKeys2(cursor, viewAct, "act7");
    Assert.assertFalse(cursor.next());
   
    Cursor<List<TypedRow>> rows = result.getAllViewsCursor();
   
    rows.next();
    List<TypedRow> joinedRow = rows.getCurrent();
    Assert.assertEquals(1, joinedRow.size());
   
View Full Code Here
494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
521
  @Test
  public void testOuterJoin() throws InterruptedException {
    NoSqlTypedSession s = mgr.getTypedSession();

    QueryResult result = s.createQueryCursor("select * FROM Activity as e LEFT JOIN e.account as a WHERE e.numTimes < 15 and a.isActive = false", 50);
    List<ViewInfo> views = result.getViews();
    Cursor<IndexColumnInfo> cursor = result.getCursor();

    ViewInfo viewAct = views.get(0);
    ViewInfo viewAcc = views.get(1);
    String alias1 = viewAct.getAlias();
    String alias2 = viewAcc.getAlias();
    Assert.assertEquals("e", alias1);
    Assert.assertEquals("a", alias2);
   
    Assert.assertTrue(cursor.next());
    compareKeys(cursor, viewAct, viewAcc, "act1", "acc1");
    Assert.assertTrue(cursor.next());
    compareKeys(cursor, viewAct, viewAcc, "act7", "acc1");
    Assert.assertFalse(cursor.next());
   
    Cursor<List<TypedRow>> rows = result.getAllViewsCursor();
   
    rows.next();
    List<TypedRow> joinedRow = rows.getCurrent();
   
    TypedRow typedRow = joinedRow.get(0);
View Full Code Here
533
534
535
536
537
538
539
540
541
542
543
544
545
546
547
548
549
550
551
552
553
554
555
556
557
558
559
560
561
562
   */
  @Test
  public void testOuterJoinWithNullClause() throws InterruptedException {
    NoSqlTypedSession s = mgr.getTypedSession();
   
    QueryResult result = s.createQueryCursor("select * FROM Activity as e LEFT JOIN e.account as a WHERE e.numTimes < 15 and (e.account = null or a.isActive = false)", 50);
    List<ViewInfo> views = result.getViews();
    Cursor<IndexColumnInfo> cursor = result.getCursor();

    ViewInfo viewAct = views.get(0);
    ViewInfo viewAcc = views.get(1);
    String alias1 = viewAct.getAlias();
    String alias2 = viewAcc.getAlias();
    Assert.assertEquals("e", alias1);
    Assert.assertEquals("a", alias2);
   
    Assert.assertTrue(cursor.next());
    compareKeys(cursor, viewAct, viewAcc, "act1", "acc1");
    Assert.assertTrue(cursor.next());
    compareKeys(cursor, viewAct, viewAcc, "act5", null);
    Assert.assertTrue(cursor.next());
    compareKeys(cursor, viewAct, viewAcc, "act7", "acc1");
    Assert.assertFalse(cursor.next());
   
    Cursor<List<TypedRow>> rows = result.getAllViewsCursor();
   
    rows.next();
    List<TypedRow> joinedRow = rows.getCurrent();
   
    TypedRow typedRow = joinedRow.get(0);
View Full Code Here
242
243
244
245
246
247
248
249
250
  }

  @Override
  public int executeQuery(String query) {
    int batchSize = 250;
    QueryResult result = createQueryCursor(query, batchSize);
    Cursor<List<TypedRow>> cursor = result.getAllViewsCursor();
    return updateBatch(cursor, result);
  }
View Full Code Here
352
353
354
355
356
357
358
359
360
361
362
363
        valueString = ""+ (((Float)value).floatValue());
    }
    else
      valueString = null;
    int batchSize = 250;
    QueryResult result = createQueryCursor(query+valueString,batchSize);
    Cursor<IndexColumnInfo> cursor = result.getCursor();
    int rowCount = 0;
    while(cursor.next())
      rowCount++;
    return rowCount;
  }
View Full Code Here
17
18
19
20
21
22
23
24
25
26
27
28
29
30
public class CmdSelect {

  void processSelect(String cmd, NoSqlEntityManager mgr) {
    NoSqlTypedSession s = mgr.getTypedSession();
    try {
      QueryResult result = s.createQueryCursor(cmd, 100);
      Cursor<List<TypedRow>> cursor = result.getAllViewsCursor();

      processBatch(cursor, result.getViews());
     
    } catch(ParseException e) {
      Throwable childExc = e.getCause();
      throw new InvalidCommand("Scalable-SQL command was invalid.  Reason="+childExc.getMessage()+" AND you may want to add -v option to playcli to get more info", e);
    }
View Full Code Here
TOP

Related Classes of com.alvazan.orm.api.z3api.QueryResult

  • com.alvazan.orm.layer3.typed.NoSqlTypedSessionImpl
  • com.alvazan.ssql.cmdline.CmdIndex
  • com.alvazan.ssql.cmdline.CmdListPartitions
  • com.alvazan.ssql.cmdline.CmdSelect
  • com.alvazan.test.TestJoins
  • com.alvazan.test.TestVirtualCf
  • com.example.PlayORMExample
    • Copyright © 2018 www.massapicom. 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.