customerDao.count(null);
}
@Test
public void testFindByExample() {
customerDao.add(new Customer("Rembrandt", "van Rijn", date(), 3));
customerDao.add(new Customer("Saskia", "van Rijn", date(), 4));
Customer paulus = new Customer("Paulus", "Potter", date(), 5);
paulus.setBlackListed(true);
customerDao.add(paulus);
flush();
clear();
CustomerExample example = new CustomerExample();
List<Customer> result = customerDao.findByExample(example);
assertEquals(3, result.size());
example = new CustomerExample();
example.setBlackListed(true);
result = customerDao.findByExample(example);
assertEquals(1, result.size());
example = new CustomerExample();
example.setBlackListed(false);
result = customerDao.findByExample(example);
assertEquals(2, result.size());
example = new CustomerExample();
example.setFirstName("Rembrandt");
Customer customer = customerDao.findByExample(example).get(0);
assertEquals(3, customer.getCustomerNr().intValue());
example = new CustomerExample();
example.setFirstName("rEMBRANDT");
customer = customerDao.findByExample(example).get(0);
assertEquals(3, customer.getCustomerNr().intValue());
example = new CustomerExample();
example.setFirstName("Rem");
customer = customerDao.findByExample(example).get(0);
assertEquals(3, customer.getCustomerNr().intValue());
example = new CustomerExample();
example.setFirstName(null);
example.setLastName("Rij");
customer = customerDao.findByExample(example).get(0);
assertEquals(3, customer.getCustomerNr().intValue());
customer = customerDao.findByExample(example).get(1);
assertEquals(4, customer.getCustomerNr().intValue());
example.setFirstName("mbr");
customer = customerDao.findByExample(example).get(0);
assertEquals(3, customer.getCustomerNr().intValue());
example = new CustomerExample();
example.setBlackListed(null);
example.setCustomerNr(5);
customer = customerDao.findByExample(example).get(0);
assertEquals(5, customer.getCustomerNr().intValue());
}