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

Example 16 with QueryParameters

use of com.github.tfaga.lynx.beans.QueryParameters 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());
}

Example 17 with QueryParameters

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

the class JPAUtilsFiltersTest method testManyToOneRelationOnlyField.

@Test
public void testManyToOneRelationOnlyField() {
    QueryFilter qf = new QueryFilter();
    qf.setField("user");
    qf.setOperation(FilterOperation.EQ);
    qf.setValue("28");
    QueryParameters q = new QueryParameters();
    q.getFilters().add(qf);
    List<Project> projects = JPAUtils.queryEntities(em, Project.class, q);
    Assert.assertNotNull(projects);
    Assert.assertEquals(100, projects.size());
}

Example 18 with QueryParameters

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

the class JPAUtilsFiltersTest method testEnumInFilter.

@Test
public void testEnumInFilter() {
    QueryFilter qf = new QueryFilter();
    qf.setField("status");
    qf.setOperation(FilterOperation.IN);
    qf.getValues().add("ACTIVE");
    QueryParameters q = new QueryParameters();
    q.getFilters().add(qf);
    List<Project> projects = JPAUtils.queryEntities(em, Project.class, q);
    Assert.assertNotNull(projects);
    Assert.assertEquals(50, projects.size());
}

Example 19 with QueryParameters

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

the class JPAUtilsFiltersTest method testEnumNinFilter.

@Test
public void testEnumNinFilter() {
    QueryFilter qf = new QueryFilter();
    qf.setField("status");
    qf.setOperation(FilterOperation.NIN);
    qf.getValues().add("ACTIVE");
    qf.getValues().add("INACTIVE");
    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 20 with QueryParameters

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

the class JPAUtilsFiltersTest method testOneToManyRelationOnlyFieldInteger.

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