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

Example 6 with QueryFilter

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

the class JPAUtilsFiltersTest method testOneToManyRelationMultiple.

@Test
public void testOneToManyRelationMultiple() {
    QueryFilter qf = new QueryFilter();
    qf.setField("projects.name");
    qf.setOperation(FilterOperation.EQ);
    qf.setValue("Orange");
    QueryParameters q = new QueryParameters();
    q.getFilters().add(qf);
    List<User> users = JPAUtils.queryEntities(em, User.class, q);
    Assert.assertNotNull(users);
    Assert.assertEquals(3, users.size());
    qf = new QueryFilter();
    qf.setField("projects.name");
    qf.setOperation(FilterOperation.IN);
    qf.getValues().add("Maroon");
    qf.getValues().add("Orange");
    q = new QueryParameters();
    q.getFilters().add(qf);
    users = JPAUtils.queryEntities(em, User.class, q);
    Assert.assertNotNull(users);
    Assert.assertEquals(9, users.size());
}

Example 7 with QueryFilter

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

the class JPAUtilsFiltersTest method testNinFilter.

@Test
public void testNinFilter() {
    QueryFilter qf = new QueryFilter();
    qf.setField("firstname");
    qf.setOperation(FilterOperation.NIN);
    qf.getValues().add("Bruce");
    qf.getValues().add("Karen");
    qf.getValues().add("Sandra");
    qf.getValues().add("Laura");
    QueryParameters q = new QueryParameters();
    q.getFilters().add(qf);
    List<User> users = JPAUtils.queryEntities(em, User.class, q);
    Assert.assertNotNull(users);
    Assert.assertEquals(91, users.size());
}

Example 8 with QueryFilter

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

the class JPAUtilsFiltersTest method testOneToManyRelation.

@Test
public void testOneToManyRelation() {
    QueryFilter qf = new QueryFilter();
    qf.setField("projects.id");
    qf.setOperation(FilterOperation.EQ);
    qf.setValue("10");
    QueryParameters q = new QueryParameters();
    q.getFilters().add(qf);
    List<User> users = JPAUtils.queryEntities(em, User.class, q);
    Assert.assertNotNull(users);
    Assert.assertEquals(1, users.size());
    qf = new QueryFilter();
    qf.setField("projects.name");
    qf.setOperation(FilterOperation.NIN);
    qf.getValues().add("Green");
    qf.getValues().add("Violet");
    q = new QueryParameters();
    q.getFilters().add(qf);
    users = JPAUtils.queryEntities(em, User.class, q);
    Assert.assertNotNull(users);
    Assert.assertEquals(55, users.size());
}

Example 9 with QueryFilter

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

the class JPAUtilsFiltersTest method testBooleanFilter.

@Test
public void testBooleanFilter() {
    QueryFilter qf = new QueryFilter();
    qf.setField("confirmed");
    qf.setOperation(FilterOperation.EQ);
    qf.setValue("true");
    QueryParameters q = new QueryParameters();
    q.getFilters().add(qf);
    List<User> users = JPAUtils.queryEntities(em, User.class, q);
    Assert.assertNotNull(users);
    Assert.assertEquals(55, users.size());
}

Example 10 with QueryFilter

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

the class JPAUtilsFiltersTest method testBooleanInFilter.

@Test
public void testBooleanInFilter() {
    QueryFilter qf = new QueryFilter();
    qf.setField("confirmed");
    qf.setOperation(FilterOperation.IN);
    qf.getValues().add("False");
    QueryParameters q = new QueryParameters();
    q.getFilters().add(qf);
    List<User> users = JPAUtils.queryEntities(em, User.class, q);
    Assert.assertNotNull(users);
    Assert.assertEquals(45, users.size());
}