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)
            .orderBy("name", SortOrder.ASC).maxResults(2).build();


      assertEquals(4, q.getResultSize());


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


   public void testStartOffset() throws Exception {

View Full Code Here

      Query q = qf.from(User.class)
            .orderBy("name", SortOrder.ASC).startOffset(2).build();


      assertEquals(4, q.getResultSize());


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


   public void testProjection1() throws Exception {

View Full Code Here

      Query q = qf.from(User.class)
            .setProjection("id", "name").build();


      assertEquals(4, q.getResultSize());


      List<Object[]> list = q.list();
      assertEquals(4, list.size());
      for (Object[] u : list) {
         assertNotNull(u[1]);
         assertTrue(u[0] instanceof Integer);
      }

View Full Code Here


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


      List<User> list = q.list();
      assertEquals(1, list.size());
      assertEquals("John", list.get(0).getName());
      assertEquals("Doe", list.get(0).getSurname());
   }

View Full Code Here


      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.getSearchManager(cache).getQueryFactory();

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"), DATE_FORMAT.parse("2013-01-31"))
            .toBuilder().build();


      List<Transaction> list = q.list();
      assertEquals(4, 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 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")).includeUpper(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

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.