Package com.alvazan.orm.api.z8spi.meta

Examples of com.alvazan.orm.api.z8spi.meta.TypedRow

312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
    log.info("testTimeSeries");

    NoSqlTypedSession s = mgr.getTypedSession();
   
    String cf = "TimeSeriesData";
    TypedRow row = s.createTypedRow(cf);
    row.setRowKey(BigInteger.valueOf(25));
    row.addColumn("temp", new BigDecimal(55.6));
    row.addColumn("someName", "dean");
   
    s.put(cf, row);
    s.flush();
   
    //NOW, let's find the row we put
    TypedRow result = s.find(cf, row.getRowKey());
    Assert.assertEquals(row.getRowKey(), result.getRowKey());
    Assert.assertEquals(row.getColumn("temp").getValue(), result.getColumn("temp").getValue());
    Assert.assertEquals(row.getColumn("someName").getValue(), result.getColumn("someName").getValue());
   
    Cursor<KeyValue<TypedRow>> rowsIter = s.createQueryCursor("select s FROM TimeSeriesData as s where s.key = 25", 500).getPrimaryViewCursor();
    rowsIter.next();
    KeyValue<TypedRow> keyValue = rowsIter.getCurrent();
    TypedRow theRow = keyValue.getValue();
    Assert.assertEquals(row.getRowKey(), theRow.getRowKey());
    Assert.assertEquals(row.getColumn("temp").getValue(), theRow.getColumn("temp").getValue());

    //Testing a negative value in the SQL here
    Cursor<KeyValue<TypedRow>> rows2 = s.createQueryCursor("select s FROM TimeSeriesData as s where s.key > -25", 500).getPrimaryViewCursor();
    rows2.next();
    KeyValue<TypedRow> keyValue2 = rows2.getCurrent();
    TypedRow theRow2 = keyValue2.getValue();
    Assert.assertEquals(row.getRowKey(), theRow2.getRowKey());
    Assert.assertEquals(row.getColumn("temp").getValue(), theRow2.getColumn("temp").getValue());
  }
View Full Code Here
375
376
377
378
379
380
381
382
383
384
385
386
387
388
    NoSqlTypedSession session = mgr.getTypedSession();
   
    String sql = "select * FROM MyEntity as e WHERE e.cat = \"deano\"";

    TypedRow typedRow = session.createTypedRow("MyEntity");

    typedRow.addColumn("cat", "deano");
    typedRow.setRowKey("dean1");
   
    session.put("MyEntity", typedRow);
   
    session.flush();
   
View Full Code Here
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
    mgr.put(meta);
    mgr.put(tm);

    mgr.flush();
   
    TypedRow row = typedSession.createTypedRow(colFamily);
    BigInteger rowKey = new BigInteger("0");
    row.setRowKey(rowKey);
    row.addTimeValue(0, new BigDecimal(56));
    row.addTimeValue(10, new BigDecimal(56));
    row.addTimeValue(20, new BigDecimal(56));
    row.addTimeValue(30, new BigDecimal(56));
    row.addTimeValue(40, new BigDecimal(56));
    row.addTimeValue(50, new BigDecimal(56));
    row.addTimeValue(60, new BigDecimal(56));
    row.addTimeValue(70, new BigDecimal(56));
    row.addTimeValue(80, new BigDecimal(56));
    row.addTimeValue(90, new BigDecimal(56));
    row.addTimeValue(100, new BigDecimal(56));

    typedSession.put(colFamily, row);
    typedSession.flush();
   
    Cursor<TimeValColumn> timeVal = typedSession.timeSeriesSlice(colFamily, rowKey, 40, 60, 200);
View Full Code Here
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
    NoSqlTypedSession s = mgr.getTypedSession();
    QueryResult result = s.createQueryCursor(sql, 10); // only need last
    Cursor<KeyValue<TypedRow>> cursor = result.getPrimaryViewCursor();
    cursor.beforeFirst();
    List<TypedRow> list = new ArrayList<TypedRow>();
    TypedRow myRow = null;
    while(cursor.next()) {
      list.add(cursor.getCurrent().getValue());
      if("email1".equals(cursor.getCurrent().getKey()))
        myRow = cursor.getCurrent().getValue();
    }
    Assert.assertEquals(3, list.size());
   
    Assert.assertEquals("anemail1", myRow.getColumn("name").getValue());
  }
View Full Code Here
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
    Cursor<List<TypedRow>> rows = result.getAllViewsCursor();
   
    rows.next();
    List<TypedRow> joinedRow = rows.getCurrent();
   
    TypedRow typedRow = joinedRow.get(0);
    TypedRow theJoinedRow = joinedRow.get(1);
   
    log.info("joinedRow="+joinedRow);
    Assert.assertEquals("e", typedRow.getView().getAlias());
    Assert.assertEquals("act1", typedRow.getRowKeyString());
    Assert.assertEquals("acc1", theJoinedRow.getRowKey());
   
    rows.next();
    joinedRow = rows.getCurrent();
   
    typedRow = joinedRow.get(0);
    theJoinedRow = joinedRow.get(1);
   
    log.info("joinedRow="+joinedRow);
    Assert.assertEquals("e", typedRow.getView().getAlias());
    Assert.assertEquals("act7", typedRow.getRowKeyString());
    Assert.assertEquals("acc1", theJoinedRow.getRowKey());
  }
View Full Code Here
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
    rows.afterLast();
   
    rows.previous();
    List<TypedRow> joinedRow = rows.getCurrent();
   
    TypedRow typedRow = joinedRow.get(0);
    TypedRow theJoinedRow = joinedRow.get(1);
   
    log.info("joinedRow="+joinedRow);
    Assert.assertEquals("e", typedRow.getView().getAlias());
    Assert.assertEquals("act7", typedRow.getRowKeyString());
    Assert.assertEquals("acc1", theJoinedRow.getRowKey());
   
    rows.previous();
    joinedRow = rows.getCurrent();
   
    typedRow = joinedRow.get(0);
    theJoinedRow = joinedRow.get(1);
   
    log.info("joinedRow="+joinedRow);
    Assert.assertEquals("e", typedRow.getView().getAlias());
    Assert.assertEquals("act1", typedRow.getRowKeyString());
    Assert.assertEquals("acc1", theJoinedRow.getRowKey());
  }
View Full Code Here
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
    rows.afterLast();
   
    rows.previous();
    List<TypedRow> joinedRow = rows.getCurrent();
   
    TypedRow typedRow = joinedRow.get(0);
    TypedRow theJoinedRow = joinedRow.get(1);
   
    log.info("joinedRow="+joinedRow);
    Assert.assertEquals("e", typedRow.getView().getAlias());
    Assert.assertEquals("act7", typedRow.getRowKeyString());
    Assert.assertEquals("acc1", theJoinedRow.getRowKey());
   
    rows.previous();
    joinedRow = rows.getCurrent();
   
    typedRow = joinedRow.get(0);
    theJoinedRow = joinedRow.get(1);
   
    log.info("joinedRow="+joinedRow);
    Assert.assertEquals("e", typedRow.getView().getAlias());
    Assert.assertEquals("act1", typedRow.getRowKeyString());
    Assert.assertEquals("acc1", theJoinedRow.getRowKey());
  }
View Full Code Here
475
476
477
478
479
480
481
482
483
484
485
   
    rows.next();
    List<TypedRow> joinedRow = rows.getCurrent();
    Assert.assertEquals(1, joinedRow.size());
   
    TypedRow typedRow = joinedRow.get(0);

    log.info("joinedRow="+joinedRow);
    Assert.assertEquals("e", typedRow.getView().getAlias());
    Assert.assertEquals("act1", typedRow.getRowKeyString());
  }
View Full Code Here
516
517
518
519
520
521
522
523
524
525
526
527
528
    Cursor<List<TypedRow>> rows = result.getAllViewsCursor();
   
    rows.next();
    List<TypedRow> joinedRow = rows.getCurrent();
   
    TypedRow typedRow = joinedRow.get(0);
    TypedRow theJoinedRow = joinedRow.get(1);
   
    log.info("joinedRow="+joinedRow);
    Assert.assertEquals("e", typedRow.getView().getAlias());
    Assert.assertEquals("act1", typedRow.getRowKeyString());
    Assert.assertEquals("acc1", theJoinedRow.getRowKey());
  }
View Full Code Here
557
558
559
560
561
562
563
564
565
566
567
568
569
570
571
572
573
574
575
576
577
578
579
580
581
582
583
584
585
586
587
    Cursor<List<TypedRow>> rows = result.getAllViewsCursor();
   
    rows.next();
    List<TypedRow> joinedRow = rows.getCurrent();
   
    TypedRow typedRow = joinedRow.get(0);
    TypedRow theJoinedRow = joinedRow.get(1);
   
    log.info("joinedRow="+joinedRow);
    Assert.assertEquals("e", typedRow.getView().getAlias());
    Assert.assertEquals("act1", typedRow.getRowKeyString());
    Assert.assertEquals("acc1", theJoinedRow.getRowKey());
   
      rows.next();
      List<TypedRow> joinedRow1 = rows.getCurrent();
      TypedRow typedRow1 = joinedRow1.get(0);
      TypedRow theJoinedRow1 = joinedRow1.get(1);
      log.info("joinedRow1= "+joinedRow1);
      Assert.assertEquals("e", typedRow1.getView().getAlias());
      Assert.assertEquals("act5", typedRow1.getRowKeyString());
      Assert.assertEquals(null, theJoinedRow1.getRowKey());

      rows.next();
      List<TypedRow> joinedRow2 = rows.getCurrent();
      TypedRow typedRow2 = joinedRow2.get(0);
      TypedRow theJoinedRow2 = joinedRow2.get(1);
      log.info("joinedRow1= "+joinedRow2);
      Assert.assertEquals("e", typedRow2.getView().getAlias());
      Assert.assertEquals("act7", typedRow2.getRowKeyString());
      Assert.assertEquals("acc1", theJoinedRow2.getRowKey());
  }
View Full Code Here
TOP

Related Classes of com.alvazan.orm.api.z8spi.meta.TypedRow

  • com.alvazan.orm.api.z8spi.conv.ByteArray
  • com.alvazan.orm.layer3.typed.CursorFillNulls
  • com.alvazan.orm.layer3.typed.CursorJoinedViews
  • com.alvazan.orm.layer3.typed.NoSqlTypedSessionImpl
  • com.alvazan.ssql.cmdline.CmdIndex
  • com.alvazan.test.TestColumnSlice
  • com.alvazan.test.TestJoins
  • com.alvazan.test.TestMultipleColumnFamilies
  • com.alvazan.test.TestNewRawLayer
  • com.alvazan.test.TestVirtualCf
    • 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.