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

Example 21 with QueryParameters

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

the class JPAUtilsFiltersTest method testWrongDateField.

@Test
public void testWrongDateField() {
    Date d = Date.from(ZonedDateTime.parse("2014-11-26T11:15:08Z").toInstant());
    QueryFilter qf = new QueryFilter();
    qf.setField("lastname");
    qf.setOperation(FilterOperation.LTE);
    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(100, users.size());
}

Example 22 with QueryParameters

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

the class JPAUtilsFiltersTest method testUuidNinFilter.

@Test
public void testUuidNinFilter() {
    QueryFilter qf = new QueryFilter();
    qf.setField("publicId");
    qf.setOperation(FilterOperation.NIN);
    qf.getValues().add("b3781a0e-fb85-45d1-bd5f-d38802a546d2");
    qf.getValues().add("6a749969-9990-4ef0-856a-7e2533b6dc9e");
    QueryParameters q = new QueryParameters();
    q.getFilters().add(qf);
    List<Project> projects = JPAUtils.queryEntities(em, Project.class, q);
    Assert.assertNotNull(projects);
    Assert.assertEquals(0, projects.size());
}

Example 23 with QueryParameters

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

the class JPAUtilsFiltersTest method testNinic.

@Test
public void testNinic() {
    QueryFilter qf = new QueryFilter();
    qf.setField("firstname");
    qf.setOperation(FilterOperation.NINIC);
    qf.getValues().add("sArAH");
    qf.getValues().add("ricHArd");
    qf.getValues().add("jACk");
    QueryParameters q = new QueryParameters();
    q.getFilters().add(qf);
    List<User> users = JPAUtils.queryEntities(em, User.class, q);
    Assert.assertNotNull(users);
    Assert.assertEquals(96, users.size());
}

Example 24 with QueryParameters

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

the class JPAUtilsFiltersTest method testEnumNonexistantFilter.

@Test(expected = InvalidFieldValueException.class)
public void testEnumNonexistantFilter() {
    QueryFilter qf = new QueryFilter();
    qf.setField("status");
    qf.setOperation(FilterOperation.EQ);
    qf.setValue("NONACTIVE");
    QueryParameters q = new QueryParameters();
    q.getFilters().add(qf);
    JPAUtils.queryEntities(em, Project.class, q);
    Assert.fail("No exception was thrown");
}

Example 25 with QueryParameters

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

the class JPAUtilsOrderTest method testMultipleOrders.

@Test
public void testMultipleOrders() {
    QueryParameters q = new QueryParameters();
    QueryOrder qo = new QueryOrder();
    qo.setField("role");
    qo.setOrder(OrderDirection.DESC);
    q.getOrder().add(qo);
    qo = new QueryOrder();
    qo.setField("lastname");
    qo.setOrder(OrderDirection.ASC);
    q.getOrder().add(qo);
    qo = new QueryOrder();
    qo.setField("firstname");
    qo.setOrder(OrderDirection.DESC);
    q.getOrder().add(qo);
    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).getLastname());
    Assert.assertEquals("Larry", users.get(0).getFirstname());
    Assert.assertEquals("Bailey", users.get(0).getLastname());
    Assert.assertNotNull(users.get(99).getFirstname());
    Assert.assertNotNull(users.get(99).getLastname());
    Assert.assertEquals("Bonnie", users.get(99).getFirstname());
    Assert.assertEquals("Willis", users.get(99).getLastname());
}