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

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

496
497
498
499
500
501
502
503
504
505
506
    }

    List<User> result;

    // Test Max
    result = users.query()
        .select(User._Fields.handle)
        .selectAgg(max(User._Fields.num_posts))
        .groupBy(User._Fields.handle)
        .orderByHandle()
        .findWithOrder();
View Full Code Here
510
511
512
513
514
515
516
517
518
519
520
    assertEquals(98, result.get(0).getNumPosts());
    assertEquals("1", result.get(1).getHandle());
    assertEquals(99, result.get(1).getNumPosts());

    // Test Min
    result = users.query()
        .select(User._Fields.handle)
        .selectAgg(AggregatorFunctions.min(User._Fields.num_posts))
        .groupBy(User._Fields.handle)
        .orderByHandle()
        .findWithOrder();
View Full Code Here
522
523
524
525
526
527
528
529
530
531
532
    assertEquals(0, result.get(0).getNumPosts());
    assertEquals(1, result.get(1).getNumPosts());


    // Test Count
    result = users.query()
        .select(User._Fields.handle)
        .selectAgg(AggregatorFunctions.count(User._Fields.num_posts))
        .groupBy(User._Fields.handle)
        .orderByHandle()
        .findWithOrder();
View Full Code Here
533
534
535
536
537
538
539
540
541
542
543
    assertEquals(50, result.get(0).getNumPosts());
    assertEquals(50, result.get(1).getNumPosts());

    // Test Sum
    result = users.query()
        .select(User._Fields.handle)
        .selectAgg(AggregatorFunctions.sum(User._Fields.num_posts))
        .groupBy(User._Fields.handle)
        .orderByHandle()
        .findWithOrder();
View Full Code Here
545
546
547
548
549
550
551
552
553
554
555
    assertEquals(2, result.size());
    assertEquals(2450, result.get(0).getNumPosts());
    assertEquals(2500, result.get(1).getNumPosts());

    // Test Avg
    result = users.query()
        .select(User._Fields.handle)
        .selectAgg(AggregatorFunctions.avg(User._Fields.num_posts))
        .groupBy(User._Fields.handle)
        .orderByHandle()
        .findWithOrder();
View Full Code Here
517
518
519
520
521
522
523
524
525
526
527
    });
    assertEquals(2, found.size());
    assertTrue(found.contains(u1));
    assertTrue(found.contains(u2));

    found = users.query().id(u1.getId()).numPosts(2).find();
    assertEquals(1, found.size());
    assertTrue(found.contains(u1));
  }

  public void testFindByField() throws IOException {
View Full Code Here
69
70
71
72
73
74
75
76
77
78
79
    userD.save();

    Set<User> result;

    // an empty query should return an empty set
    result = users.query().find();
    assertTrue(result.isEmpty());

    // A simple query
    result = users.query().bio("Janitor").find();
    assertEquals(1, result.size());
View Full Code Here
73
74
75
76
77
78
79
80
81
82
83
    // an empty query should return an empty set
    result = users.query().find();
    assertTrue(result.isEmpty());

    // A simple query
    result = users.query().bio("Janitor").find();
    assertEquals(1, result.size());
    assertTrue(result.contains(userD));

    // A chained query
    result = users.query().handle("A").bio("Trader").numPosts(1).find();
View Full Code Here
78
79
80
81
82
83
84
85
86
87
88
    result = users.query().bio("Janitor").find();
    assertEquals(1, result.size());
    assertTrue(result.contains(userD));

    // A chained query
    result = users.query().handle("A").bio("Trader").numPosts(1).find();
    assertEquals(1, result.size());
    assertTrue(result.contains(userA));

    // A chained query
    result = users.query().bio("Trader").numPosts(2).find();
View Full Code Here
83
84
85
86
87
88
89
90
91
92
93
    result = users.query().handle("A").bio("Trader").numPosts(1).find();
    assertEquals(1, result.size());
    assertTrue(result.contains(userA));

    // A chained query
    result = users.query().bio("Trader").numPosts(2).find();
    assertEquals(1, result.size());
    assertTrue(result.contains(userB));

    // A query with no results
    result = users.query().numPosts(3).bio("CEO").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.