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.

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


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

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


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


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

View Full Code Here

      Query q = qf.from(User.class)
            .having("name").eq("Spider")
            .and().having("surname").eq("Man")
            .toBuilder().build();


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


   public void testAnd2() throws Exception {

View Full Code Here

      Query q = qf.from(User.class)
            .having("name").eq("Spider")
            .and(qf.having("surname").eq("Man"))
            .toBuilder().build();


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


   public void testAnd3() throws Exception {

View Full Code Here

      Query q = qf.from(User.class)
            .having("gender").eq(User.Gender.MALE)
            .and().having("gender").eq(User.Gender.FEMALE)
            .toBuilder().build();


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


   public void testAnd4() throws Exception {
      QueryFactory qf = Search.getSearchManager(cache).getQueryFactory();

View Full Code Here

            .having("name").eq("Spider")
            .or(qf.having("name").eq("John"))
            .and(qf.having("surname").eq("Man"))
            .toBuilder().build();


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


   public void testOr1() throws Exception {
      QueryFactory qf = Search.getSearchManager(cache).getQueryFactory();

View Full Code Here

      Query q = qf.from(User.class)
            .having("surname").eq("Man")
            .or().having("surname").eq("Woman")
            .toBuilder().build();


      List<User> list = q.list();
      assertEquals(2, list.size());
      for (User u : list) {
         assertEquals("Spider", u.getName());
      }
   }

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.