Examples of org.dayatang.domain.internal.InCriterion

org.dayatang.domain.internal.InCriterion
代表某个属性的值包含在指定集合或数组中的查询条件 @author yyang

     * Test of in method, of class CriteriaQuery.
     */
    @Test
    public void testInCollection() {
        List<?> criterions = Arrays.asList("a", "b");
      assertEquals(new InCriterion("name", criterions), instance.in("name", criterions).getQueryCriterion());
    }

View Full Code Here

     * Test of in method, of class CriteriaQuery.
     */
    @Test
    public void testInArray() {
        Object[] criterions = new Object[] {"a", "b"};
      assertEquals(new InCriterion("name", criterions), instance.in("name", criterions).getQueryCriterion());
    }

View Full Code Here

    }
    
    @Test
    public void testGetQueryString() {
      EqCriterion criterion1 = new EqCriterion("name", "abc");
      InCriterion criterion2 = new InCriterion("age", Arrays.asList(1, 2));
        instance.eq("name", "abc")
                        .isEmpty("post")
                        .notNull("birthday")
                        .in("age", Arrays.asList(1, 2))
                        .getQueryString();        
        assertEquals("select distinct(rootEntity) from org.dayatang.domain.entity.MyEntity as rootEntity  "
                + "where rootEntity.name = :rootEntity_name" + criterion1.hashCode() + " "
                + "and rootEntity.post is empty "
                + "and rootEntity.birthday is not null "
                + "and rootEntity.age in :rootEntity_age" + criterion2.hashCode(),
                instance.getQueryString());
        assertEquals(NamedParameters.create()
                .add("rootEntity_name" + criterion1.hashCode(), "abc")
                .add("rootEntity_age" + criterion2.hashCode(), Arrays.asList(1, 2)),
                instance.getParameters());
    }

View Full Code Here

    }
    
    @Test
    public void testGetQueryString2() {
      EqCriterion criterion1 = new EqCriterion("name", "abc");
      InCriterion criterion2 = new InCriterion("age", Arrays.asList(1, 2));
      
      
        assertEquals("select distinct(rootEntity) from org.dayatang.domain.entity.MyEntity as rootEntity  "
                + "where rootEntity.name = :rootEntity_name" + criterion1.hashCode() + " "
                + "and rootEntity.post is empty "
                + "and rootEntity.birthday is not null "
                + "and rootEntity.age in :rootEntity_age" + criterion2.hashCode() + " "
                + "order by rootEntity.name asc", 
                instance.eq("name", "abc")
                        .isEmpty("post")
                        .notNull("birthday")
                        .in("age", Arrays.asList(1, 2))

View Full Code Here

TOP

Related Classes of org.dayatang.domain.internal.InCriterion

org.apache.commons.lang3.builder.EqualsBuilder

org.apache.commons.lang3.builder.HashCodeBuilder

org.dayatang.domain.NamedParameters

org.dayatang.domain.repository.CriteriaQueryTest

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.