Examples of org.infinispan.query.dsl.Query.list()

org.infinispan.query.dsl.Query.list()
Returns the results of a search as a list. @return list of objects that were found from the search.


      Query q = qf.from(User.class)
            .having("name").eq("Jacob")
            .toBuilder().build();


      List<User> list = q.list();
      assertEquals(0, list.size());
   }


   public void testEqInNested1() throws Exception {
      QueryFactory qf = Search.getQueryFactory(remoteCache);

View Full Code Here

      // all users in a given post code
      Query q = qf.from(User.class)
            .having("addresses.postCode").eq("X1234")
            .toBuilder().build();


      List<User> list = q.list();
      assertEquals(1, list.size());
      assertEquals("X1234", list.get(0).getAddresses().get(0).getPostCode());
   }


   public void testEqInNested2() throws Exception {

View Full Code Here


      Query q = qf.from(User.class)
            .having("addresses.postCode").eq("Y12")
            .toBuilder().build();


      List<User> list = q.list();
      assertEquals(1, list.size());
      assertEquals(2, list.get(0).getAddresses().size());
   }


   public void testLike() throws Exception {

View Full Code Here

      // all rent payments made from a given account
      Query q = qf.from(Transaction.class)
            .having("description").like("%rent%")
            .toBuilder().build();


      List<Transaction> list = q.list();
      assertEquals(1, list.size());
      assertEquals(1, list.get(0).getAccountId());
      assertEquals(1500, list.get(0).getAmount(), 0);
   }

View Full Code Here

      // all the transactions that happened in January 2013
      Query q = qf.from(Transaction.class)
            .having("date").between(DATE_FORMAT.parse("2013-01-01").getTime(), DATE_FORMAT.parse("2013-01-31").getTime())
            .toBuilder().build();


      List<Transaction> list = q.list();
      assertEquals(4, list.size());
      for (Transaction t : list) {
         assertTrue(t.getDate() <= DATE_FORMAT.parse("2013-01-31").getTime());
         assertTrue(t.getDate() >= DATE_FORMAT.parse("2013-01-01").getTime());
      }

View Full Code Here

      // all the transactions that happened in January 2013
      Query q = qf.from(Transaction.class)
            .having("date").between(DATE_FORMAT.parse("2013-01-01").getTime(), DATE_FORMAT.parse("2013-01-31").getTime()).includeUpper(false)
            .toBuilder().build();


      List<Transaction> list = q.list();
      assertEquals(3, list.size());
      for (Transaction t : list) {
         assertTrue(t.getDate() < DATE_FORMAT.parse("2013-01-31").getTime());
         assertTrue(t.getDate() >= DATE_FORMAT.parse("2013-01-01").getTime());
      }

View Full Code Here

      // all the transactions that happened in January 2013
      Query q = qf.from(Transaction.class)
            .having("date").between(DATE_FORMAT.parse("2013-01-01").getTime(), DATE_FORMAT.parse("2013-01-31").getTime()).includeLower(false)
            .toBuilder().build();


      List<Transaction> list = q.list();
      assertEquals(3, list.size());
      for (Transaction t : list) {
         assertTrue(t.getDate() <= DATE_FORMAT.parse("2013-01-31").getTime());
         assertTrue(t.getDate() > DATE_FORMAT.parse("2013-01-01").getTime());
      }

View Full Code Here

      // all the transactions greater than a given amount
      Query q = qf.from(Transaction.class)
            .having("amount").gt(1500)
            .toBuilder().build();


      List<Transaction> list = q.list();
      assertEquals(1, list.size());
      assertTrue(list.get(0).getAmount() > 1500);
   }


   public void testGte() throws Exception {

View Full Code Here


      Query q = qf.from(Transaction.class)
            .having("amount").gte(1500)
            .toBuilder().build();


      List<Transaction> list = q.list();
      assertEquals(2, list.size());
      for (Transaction t : list) {
         assertTrue(t.getAmount() >= 1500);
      }
   }

View Full Code Here


      Query q = qf.from(Transaction.class)
            .having("amount").lt(1500)
            .toBuilder().build();


      List<Transaction> list = q.list();
      assertEquals(4, list.size());
      for (Transaction t : list) {
         assertTrue(t.getAmount() < 1500);
      }
   }

View Full Code Here

0 1 2 3 4 5 6 7 8 9

TOP

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.