@Test(expectedExceptions = IllegalStateException.class) public void testWrongQueryBuilding1() { QueryFactory qf = getQueryFactory(); qf.not().having("name").eq("John").build(); }
public void testNot11() { QueryFactory qf = getQueryFactory(); Query q = qf.from(getModelFactory().getUserImplClass()) .not(qf.not( qf.having("name").eq("John") .or(qf.having("surname").eq("Man")))) .build(); List<User> list = q.list(); assertEquals(2, list.size()); assertNotEquals(list.get(0).getSurname(), "Woman"); }
public void testNot6() { QueryFactory qf = getQueryFactory(); // QueryFactory.not() test Query q = qf.from(getModelFactory().getUserImplClass()) .not(qf.not(qf.having("gender").eq(User.Gender.FEMALE))) .build(); List<User> list = q.list(); assertEquals(1, list.size()); assertEquals("Woman", list.get(0).getSurname()); }
public void testSampleDomainQuery2() { QueryFactory qf = getQueryFactory(); // all male users, but this time retrieved in a twisted manner Query q = qf.from(getModelFactory().getUserImplClass()) .orderBy("name", SortOrder.ASC) .not(qf.having("gender").eq(User.Gender.FEMALE)) .and(qf.not().not(qf.having("gender").eq(User.Gender.MALE))) .build(); List<User> list = q.list(); assertEquals(2, list.size()); assertEquals("John", list.get(0).getName()); assertEquals("Spider", list.get(1).getName()); }