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());
}