public Object doInJpa(EntityManager entityManager) throws PersistenceException {
// lets delete any exiting records before the test
entityManager.createQuery("delete from " + entityName).executeUpdate();
// now lets create a dummy entry
MultiSteps dummy = new MultiSteps("cheese");
dummy.setStep(4);
entityManager.persist(dummy);
return null;
}
});
List<?> results = jpaTemplate.find(queryText);
assertEquals("Should have no results: " + results, 0, results.size());
// lets produce some objects
template.send(endpoint, new Processor() {
public void process(Exchange exchange) {
exchange.getIn().setBody(new MultiSteps("foo@bar.com"));
}
});
// now lets assert that there is a result
results = jpaTemplate.find(queryText);
assertEquals("Should have results: " + results, 1, results.size());
MultiSteps mail = (MultiSteps)results.get(0);
assertEquals("address property", "foo@bar.com", mail.getAddress());
// now lets create a consumer to consume it
consumer = endpoint.createConsumer(new Processor() {
public void process(Exchange e) {
LOG.info("Received exchange: " + e.getIn());
receivedExchange = e;
latch.countDown();
}
});
consumer.start();
boolean received = latch.await(50, TimeUnit.SECONDS);
assertTrue("Did not receive the message!", received);
assertReceivedResult(receivedExchange);
// lets now test that the database is updated
// we need to sleep as we will be invoked from inside the transaction!
Thread.sleep(1000);
transactionStrategy.execute(new JpaCallback<Object>() {
public Object doInJpa(EntityManager entityManager) throws PersistenceException {
// now lets assert that there are still 2 entities left
List<?> rows = entityManager.createQuery("select x from MultiSteps x").getResultList();
assertEquals("Number of entities: " + rows, 2, rows.size());
int counter = 1;
for (Object rowObj : rows) {
assertTrue("Rows are not instances of MultiSteps", rowObj instanceof MultiSteps);
final MultiSteps row = (MultiSteps) rowObj;
LOG.info("entity: " + counter++ + " = " + row);
if (row.getAddress().equals("foo@bar.com")) {
LOG.info("Found updated row: " + row);
assertEquals("Updated row step for: " + row, getUpdatedStepValue(), row.getStep());
} else {
// dummy row
assertEquals("dummy row step for: " + row, 4, row.getStep());
}
}
return null;
}
});