Examples with QueryParameters com.github.tfaga.lynx.beans.QueryParameters used on opensource projects

Example 6 with QueryParameters

use of com.github.tfaga.lynx.beans.QueryParameters in project lynx by TFaga.

the class JPAUtilsFieldsTest method testEmbeddedField.

// Currently unsupported
@Test(expected = NoSuchEntityFieldException.class)
public void testEmbeddedField() {
    QueryParameters q = new QueryParameters();
    q.getFields().add("address.country");
    JPAUtils.queryEntities(em, User.class, q);
}

Example 7 with QueryParameters

use of com.github.tfaga.lynx.beans.QueryParameters in project lynx by TFaga.

the class JPAUtilsFieldsTest method testMultipleFields.

@Test
public void testMultipleFields() {
    QueryParameters q = new QueryParameters();
    q.getFields().add("firstname");
    q.getFields().add("email");
    q.getFields().add("role");
    List<User> users = JPAUtils.queryEntities(em, User.class, q);
    Assert.assertNotNull(users);
    Assert.assertEquals(100, users.size());
    Assert.assertNotNull(users.get(0).getFirstname());
    Assert.assertNotNull(users.get(0).getEmail());
    Assert.assertNotNull(users.get(0).getRole());
    Assert.assertNull(users.get(0).getLastname());
    Assert.assertEquals("Jason", users.get(0).getFirstname());
    Assert.assertEquals("jramos0@ox.ac.uk", users.get(0).getEmail());
    Assert.assertEquals(0, users.get(0).getRole().intValue());
}

Example 8 with QueryParameters

use of com.github.tfaga.lynx.beans.QueryParameters in project lynx by TFaga.

the class JPAUtilsFiltersTest method testNotEqual.

@Test
public void testNotEqual() {
    QueryFilter qf = new QueryFilter();
    qf.setField("lastname");
    qf.setOperation(FilterOperation.NEQ);
    qf.setValue("Willis");
    QueryParameters q = new QueryParameters();
    q.getFilters().add(qf);
    List<User> users = JPAUtils.queryEntities(em, User.class, q);
    Assert.assertNotNull(users);
    Assert.assertEquals(97, users.size());
}

Example 9 with QueryParameters

use of com.github.tfaga.lynx.beans.QueryParameters in project lynx by TFaga.

the class JPAUtilsFiltersTest method testSingleDateFilter.

@Test
public void testSingleDateFilter() {
    Date d = Date.from(ZonedDateTime.parse("2014-11-26T11:15:08Z").toInstant());
    QueryFilter qf = new QueryFilter();
    qf.setField("createdAt");
    qf.setOperation(FilterOperation.GT);
    qf.setDateValue(d);
    QueryParameters q = new QueryParameters();
    q.getFilters().add(qf);
    List<User> users = JPAUtils.queryEntities(em, User.class, q);
    Assert.assertNotNull(users);
    Assert.assertEquals(39, users.size());
}

Example 10 with QueryParameters

use of com.github.tfaga.lynx.beans.QueryParameters in project lynx by TFaga.

the class JPAUtilsFiltersTest method testLikeic.

@Test
public void testLikeic() {
    QueryFilter qf = new QueryFilter();
    qf.setField("firstname");
    qf.setOperation(FilterOperation.LIKEIC);
    qf.setValue("jA%");
    QueryParameters q = new QueryParameters();
    q.getFilters().add(qf);
    List<User> users = JPAUtils.queryEntities(em, User.class, q);
    Assert.assertNotNull(users);
    Assert.assertEquals(5, users.size());
}