Package org.crank.crud.criteria

Examples of org.crank.crud.criteria.Group

32
33
34
35
36
37
38
39
40
41
42
        .toString());
  }

  @Test
  public void nestedPrime() {
    Group group = and(eq("firstName", "Rick"), eq("lastName", "Hightower"),
        or(eq("foo", "bar"), eq("baz", "foo")));
    assertEquals(
        "(AND [firstName_EQ_Rick, lastName_EQ_Hightower, (OR [foo_EQ_bar, baz_EQ_foo])])",
        group.toString());
  }
View Full Code Here
41
42
43
44
45
46
47
48
49
50
        group.toString());
  }

  @Test
  public void test1() {
    Group group = and().add("firstName", Operator.EQ, "Rick").add(
        "lastName", Operator.EQ, "Hightower");
    assertEquals("(AND [firstName_EQ_Rick, lastName_EQ_Hightower])", group
        .toString());
  }
View Full Code Here
49
50
51
52
53
54
55
56
57
        .toString());
  }

  @Test
  public void test2() {
    Group group = and().eq("firstName", "Rick").eq("lastName", "Hightower");
    assertEquals("(AND [firstName_EQ_Rick, lastName_EQ_Hightower])", group
        .toString());
  }
View Full Code Here
56
57
58
59
60
61
62
63
64
65
66
        .toString());
  }

  @Test
  public void nested() {
    Group group = and().eq("firstName", "Rick").eq("lastName", "Hightower")
        .add(or().eq("foo", "bar").eq("baz", "foo"));
    assertEquals(
        "(AND [firstName_EQ_Rick, lastName_EQ_Hightower, (OR [foo_EQ_bar, baz_EQ_foo])])",
        group.toString());
  }
View Full Code Here
101
102
103
104
105
106
107
108
  }

  @Test
  public void testBetween() {
    Group group = and(between("age", new Integer(1), new Integer(2)));
    assertEquals("1", "(AND [age_BETWEEN_1_2])", group.toString());
  }
View Full Code Here
107
108
109
110
111
112
113
114
115
    assertEquals("1", "(AND [age_BETWEEN_1_2])", group.toString());
  }

  @Test
  public void testIn() {
    Group group = and(in("age", 1, 2, 3, 4, 5, 40));
    assertEquals("1", "(AND [age_IN_[1, 2, 3, 4, 5, 40]])", group
        .toString());
  }
View Full Code Here
109
110
111
112
113
114
115
116
117
118
119
120
   
    Join[] joins = dataSource.joins();
    assertTrue("We should have an entity join", joins.length > 0);
    assertEquals("EntityJoin name=Z alias=zalias", joins[0].toString());
 
    Group group = dataSource.group();
    Iterator<Criterion> iter = group.iterator(); iter.next();
    assertEquals("o_null_zalias", iter.next().toString());
   
    List<Select> selects = paginator.getSelects();
    for (Select select : selects) {
      System.out.println(select);
View Full Code Here
245
246
247
248
249
250
251
252
253
254
255
  }

  @Test
  public void constructQueryString() {
    GenericDaoJpa<Employee, Long> dao = new GenericDaoJpa<Employee, Long>();
    Group group = and(eq("firstName", "Rick"), eq("lastName", "Hightower"),
        or(eq("foo", "bar"), eq("baz", "foo")));
    String string = CriteriaUtils.constructWhereClauseString(group, false);
    AssertJUnit
        .assertEquals(
            " WHERE  o.firstName = :firstName  AND  o.lastName = :lastName  AND  (  o.foo = :foo  OR  o.baz = :baz  ) ",
View Full Code Here
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
        assertEquals(" ORDER BY o.foobar ASC, o.baz DESC, UPPER( o.bacon ) DESC", orderByClause);
    }


    public void testWhereClause () {
        Group group = new Group();
        group.eq("lastName", "Jones").eq("firstName", "Tom");
        Comparison comparison = Comparison.eq("middleName", "Milhouse");
        comparison.setCaseSensitive(false);
        group.add(comparison);
        String whereClause = CriteriaUtils.constuctWhereClause(group);
        assertEquals(" WHERE  o.lastName = :lastName  AND  o.firstName = :firstName  " +
                "AND  UPPER(  o.middleName )  =  UPPER( :middleName  ) ", whereClause);

    }
View Full Code Here
370
371
372
373
374
375
376
377
378
379
    }
   
        if (logger.isDebugEnabled()) {
            logger.debug("count called with Criteria " + criteria);
        }
        final Group group = criteria != null ? Group.and(criteria) : null;

    final String squery = CriteriaUtils.createCountQuery(group, this.type, this.distinct);
    return executeCountQuery(group, squery, criteria);
  }
View Full Code Here
TOP

Related Classes of org.crank.crud.criteria.Group

  • org.crank.crud.controller.FilteringPaginatorTest
  • org.crank.crud.criteria.test.GroupTest
  • org.crank.crud.CriteriaUtils
  • org.crank.crud.CriteriaUtilsTest
  • org.crank.crud.GenericDaoJpaTest
  • org.crank.crud.GenericDaoJpaWithoutJpaTemplate
    • Copyright © 2018 www.massapicom. All rights reserved.
    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.