Package com.rapleaf.jack.test_project.database_1.iface

Examples of com.rapleaf.jack.test_project.database_1.iface.IUserPersistence.query()

316
317
318
319
320
321
322
323
324
325
326
    assertEquals(1, orderedResult1.indexOf(userE));
    assertEquals(0, orderedResult1.indexOf(userD));

    // a chained ordered query ordered by multiple fields should be ordered accordingly.
    // expected result: [userA, userB, userC, userE, userD, userG, userF, userH]
    orderedResult1 = users.query().whereNumPosts(greaterThan(0)).orderByNumPosts(ASC).orderByBio(ASC).findWithOrder();
    assertEquals(8, orderedResult1.size());
    assertEquals(0, orderedResult1.indexOf(userA));
    assertEquals(1, orderedResult1.indexOf(userB));
    assertEquals(2, orderedResult1.indexOf(userC));
    assertEquals(3, orderedResult1.indexOf(userE));
View Full Code Here
329
330
331
332
333
334
335
336
337
338
339
    assertEquals(6, orderedResult1.indexOf(userF));
    assertEquals(7, orderedResult1.indexOf(userH));

    // a chained ordered query ordered by multiple fields should be ordered accordingly.
    // expected result: [C, H, D, A, F, E, G, B]
    orderedResult1 = users.query().whereNumPosts(greaterThan(0)).orderBySomeDecimal().orderByBio(DESC).findWithOrder();
    assertEquals(8, orderedResult1.size());
    assertEquals(0, orderedResult1.indexOf(userC));
    assertEquals(1, orderedResult1.indexOf(userH));
    assertEquals(2, orderedResult1.indexOf(userD));
    assertEquals(3, orderedResult1.indexOf(userA));
View Full Code Here
355
356
357
358
359
360
361
362
363
364
365
    List<User> orderedResult1;
    List<User> orderedResult2;

    // A query by one id should return a list with one element.
    orderedResult1 = users.query().id(sampleUsers[0].getId()).order().findWithOrder();
    assertEquals(1, orderedResult1.size());
    assertTrue(orderedResult1.contains(sampleUsers[0]));

    // A query by several ids ordered by default should return a list ordered by id in an ascending manner.
    Set<Long> sampleIds = new HashSet<Long>();
View Full Code Here
364
365
366
367
368
369
370
371
372
373
374
    // A query by several ids ordered by default should return a list ordered by id in an ascending manner.
    Set<Long> sampleIds = new HashSet<Long>();
    sampleIds.add(sampleUsers[0].getId());
    sampleIds.add(sampleUsers[1].getId());
    sampleIds.add(sampleUsers[2].getId());
    orderedResult1 = users.query().idIn(sampleIds).order().findWithOrder();
    orderedResult2 = users.query().idIn(sampleIds).orderById(ASC).findWithOrder();
    assertEquals(3, orderedResult1.size());
    assertEquals(0, orderedResult1.indexOf(sampleUsers[0]));
    assertEquals(1, orderedResult1.indexOf(sampleUsers[1]));
    assertEquals(2, orderedResult1.indexOf(sampleUsers[2]));
View Full Code Here
365
366
367
368
369
370
371
372
373
374
375
    Set<Long> sampleIds = new HashSet<Long>();
    sampleIds.add(sampleUsers[0].getId());
    sampleIds.add(sampleUsers[1].getId());
    sampleIds.add(sampleUsers[2].getId());
    orderedResult1 = users.query().idIn(sampleIds).order().findWithOrder();
    orderedResult2 = users.query().idIn(sampleIds).orderById(ASC).findWithOrder();
    assertEquals(3, orderedResult1.size());
    assertEquals(0, orderedResult1.indexOf(sampleUsers[0]));
    assertEquals(1, orderedResult1.indexOf(sampleUsers[1]));
    assertEquals(2, orderedResult1.indexOf(sampleUsers[2]));
    assertEquals(orderedResult1, orderedResult2);
View Full Code Here
375
376
377
378
379
380
381
382
383
384
385
    assertEquals(orderedResult1, orderedResult2);

    // A query by several ids ordered by a specific field should return a list ordered accordingly.
    sampleIds.add(sampleUsers[3].getId());
    sampleIds.add(sampleUsers[4].getId());
    orderedResult1 = users.query().idIn(sampleIds).orderByNumPosts(DESC).orderById(DESC).findWithOrder();
    assertEquals(5, orderedResult1.size());
    assertEquals(0, orderedResult1.indexOf(sampleUsers[3]));
    assertEquals(1, orderedResult1.indexOf(sampleUsers[1]));
    assertEquals(2, orderedResult1.indexOf(sampleUsers[4]));
    assertEquals(3, orderedResult1.indexOf(sampleUsers[2]));
View Full Code Here
398
399
400
401
402
403
404
405
406
407
408
      sampleUsers[i].save();
    }

    List<User> resultList;

    resultList = users.query()
        .whereNumPosts(lessThan(5))
        .orderByNumPosts()
        .limit(3)
        .findWithOrder();
View Full Code Here
409
410
411
412
413
414
415
416
417
418
419
    assertEquals(3, resultList.size());
    for (int i = 0; i < resultList.size(); i++) {
      assertEquals(i, resultList.get(i).getNumPosts());
    }

    resultList = users.query()
        .whereNumPosts(greaterThan(3))
        .orderByNumPosts()
        .limit(2, 3)
        .findWithOrder();
View Full Code Here
422
423
424
425
426
427
428
429
430
431
432
      assertEquals(i + 6, resultList.get(i).getNumPosts());
    }

    Set<User> resultSet;

    resultSet = users.query()
        .whereNumPosts(lessThan(5))
        .orderByNumPosts()
        .limit(3)
        .find();
View Full Code Here
430
431
432
433
434
435
436
437
438
439
440
        .limit(3)
        .find();

    assertEquals(3, resultSet.size());

    resultSet = users.query()
        .whereNumPosts(greaterThan(3))
        .orderByNumPosts()
        .limit(2, 3)
        .find();
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.