Examples of org.infinispan.query.dsl.QueryFactory

org.infinispan.query.dsl.QueryFactory
Factory for query DSL objects. Query construction starts here, usually by invoking the {@link #from} method whichreturns a {@link QueryBuilder} capable of constructing {@link Query} objects. The other methods are use for creatingsub-conditions. @author anistor@redhat.com @since 6.0

      assertEquals("Spider", list.get(1).getName());
   }


   @Test(enabled = false, description = "String literal escaping is not properly done yet")   //todo [anistor] fix disabled test
   public void testStringEscape() throws Exception {
      QueryFactory qf = Search.getQueryFactory(remoteCache);


      // all transactions that have a given description. the description contains characters that need to be escaped.
      Query q = qf.from(Account.class)
            .having("description").eq("John Doe's first bank account")
            .toBuilder().build();


      List<Account> list = q.list();
      assertEquals(1, list.size());

View Full Code Here

      assertEquals(1, list.size());
      assertEquals(2, list.get(0).getId());
   }


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


      // all male users
      Query q = qf.from(User.class)
            .having("gender").eq(User.Gender.MALE)
            .toBuilder().build();


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

View Full Code Here

      assertEquals("John", list.get(0).getName());
      assertEquals("Spider", list.get(1).getName());
   }


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


      // all users ordered descendingly by name
      Query q = qf.from(User.class)
            .orderBy("name", SortOrder.DESC)
            .build();


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

View Full Code Here

      assertEquals("Spider", list.get(1).getName());
      assertEquals("John", list.get(2).getName());
   }


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


      // name projection of all users ordered descendingly by name
      Query q = qf.from(User.class)
            .orderBy("name", SortOrder.DESC)
            .setProjection("name")
            .build();


      List<Object[]> list = q.list();

View Full Code Here

      assertEquals("Spider", list.get(1)[0]);
      assertEquals("John", list.get(2)[0]);
   }


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


      // all users with a given name and surname
      Query q = qf.from(User.class)
            .having("name").eq("John")
            .and().having("surname").eq("Doe")
            .toBuilder().build();


      List<User> list = q.list();

View Full Code Here

      assertEquals("John", list.get(0).getName());
      assertEquals("Doe", list.get(0).getSurname());
   }


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


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


      List<Transaction> list = q.list();

View Full Code Here

      assertEquals(1, list.get(0).getAccountId());
      assertTrue(list.get(0).getDescription().contains("rent"));
   }


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


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


      List<Transaction> list = q.list();

View Full Code Here

      assertTrue(list.get(2).getDate() > DATE_FORMAT.parse("2013-01-01").getTime());
      assertTrue(list.get(3).getDate() == DATE_FORMAT.parse("2013-01-31").getTime());
   }


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


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


      List<Object[]> list = q.list();

View Full Code Here

         assertTrue(d >= DATE_FORMAT.parse("2013-01-01").getTime());
      }
   }


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


      // all the transactions for a an account having amount greater than a given amount
      Query q = qf.from(Transaction.class)
            .having("accountId").eq(2)
            .and().having("amount").gt(40)
            .toBuilder().build();


      List<Transaction> list = q.list();

View Full Code Here

      assertTrue(list.get(0).getAmount() > 40);
      assertTrue(list.get(1).getAmount() > 40);
   }


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


      Query q = qf.from(User.class)
            .having("name").eq("John")
            .and().having("addresses.postCode").eq("X1234")
            .and(qf.having("accountIds").eq(1))
            .toBuilder().build();


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

View Full Code Here

0 1 2 3 4 5 6 7 8 9

TOP

Related Classes of org.infinispan.query.dsl.QueryFactory

org.infinispan.client.hotrod.marshall.EmbeddedCompatTest

org.infinispan.client.hotrod.query.HotRodQueryTest

org.infinispan.client.hotrod.query.MultiHotRodServerQueryTest

org.infinispan.client.hotrod.query.RemoteQueryDslConditionsTest

org.infinispan.client.hotrod.query.RemoteQueryDslIterationTest

org.infinispan.client.hotrod.query.RemoteQueryJmxTest

org.infinispan.objectfilter.test.AbstractMatcherTest

org.infinispan.query.dsl.embedded.ClusteredQueryDslConditionsTest

org.infinispan.query.dsl.embedded.NonIndexedQueryDslConditionsTest

org.infinispan.query.dsl.embedded.QueryDslConditionsTest

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.