public void testSampleDomainQuery21() { QueryFactory qf = getQueryFactory(); Query q = qf.from(getModelFactory().getUserImplClass()) .not().having("addresses").isNull().build(); List<User> list = q.list(); assertEquals(2, list.size()); assertTrue(Arrays.asList(1, 2).contains(list.get(0).getId())); assertTrue(Arrays.asList(1, 2).contains(list.get(1).getId())); }
public void testIsNullNumericWithProjection2() { QueryFactory qf = getQueryFactory(); Query q = qf.from(getModelFactory().getUserImplClass()) .select("name", "age") .not().having("age").isNull() .build(); List<Object[]> list = q.list(); assertEquals(1, list.size()); assertEquals("John", list.get(0)[0]); assertEquals(22, list.get(0)[1]); }
public void testNullOnIntegerField() { QueryFactory qf = getQueryFactory(); Query q = qf.from(getModelFactory().getUserImplClass()) .having("age").isNull() .build(); List<User> list = q.list(); assertEquals(2, list.size()); assertNull(list.get(0).getAge()); assertNull(list.get(1).getAge()); }
public void testIsNotNullOnIntegerField() { QueryFactory qf = getQueryFactory(); Query q = qf.from(getModelFactory().getUserImplClass()) .not().having("age").isNull() .build(); List<User> list = q.list(); assertEquals(1, list.size()); assertEquals("John", list.get(0).getName()); assertEquals("Doe", list.get(0).getSurname()); assertNotNull(list.get(0).getAge()); }
public void testIsNull1() { QueryFactory qf = getQueryFactory(); Query q = qf.from(getModelFactory().getUserImplClass()) .having("surname").isNull() .build(); List<User> list = q.list(); assertEquals(0, list.size()); }
public void testIsNull3() { if (testNullCollections()) { QueryFactory qf = getQueryFactory(); Query q = qf.from(getModelFactory().getUserImplClass()) .having("addresses").isNull() .build(); List<User> list = q.list(); assertEquals(1, list.size()); assertEquals(3, list.get(0).getId()); } }
public void testIsNullNumericWithProjection1() { QueryFactory qf = getQueryFactory(); Query q = qf.from(getModelFactory().getUserImplClass()) .select("name", "surname", "age") .orderBy("name", SortOrder.ASC) .orderBy("surname", SortOrder.ASC) .orderBy("age", SortOrder.ASC) .having("age").isNull() .build(); List<Object[]> list = q.list(); assertEquals(2, list.size()); assertEquals("Spider", list.get(0)[0]); assertEquals("Man", list.get(0)[1]); assertNull(list.get(0)[2]); assertEquals("Spider", list.get(1)[0]); assertEquals("Woman", list.get(1)[1]); assertNull(list.get(1)[2]); }
public void testIsNull2() { QueryFactory qf = getQueryFactory(); Query q = qf.from(getModelFactory().getUserImplClass()) .not().having("surname").isNull() .build(); List<User> list = q.list(); assertEquals(3, list.size()); }