/** TestExecute. */
@Test
public void testExecute() {
Calendar cal = Calendar.getInstance();
// setup the data for: Group5, Person4507, Group7, Group6, Person99, Group8, Person42
// -- the last two with the same date
System.out.println("TIME: " + cal.getTime());
getEntityManager()
.createQuery("UPDATE DomainGroup SET dateAdded = :dateAdded WHERE id=:id")
.setParameter("id", 5L)
.setParameter("dateAdded", cal.getTime())
.executeUpdate();
cal.add(Calendar.HOUR, -1);
getEntityManager()
.createQuery("UPDATE Person SET dateAdded = :dateAdded WHERE id=:id")
.setParameter("id", 4507L)
.setParameter("dateAdded", cal.getTime())
.executeUpdate();
cal.add(Calendar.HOUR, -1);
getEntityManager()
.createQuery("UPDATE DomainGroup SET dateAdded = :dateAdded WHERE id=:id")
.setParameter("id", 7L)
.setParameter("dateAdded", cal.getTime())
.executeUpdate();
cal.add(Calendar.HOUR, -1);
getEntityManager()
.createQuery("UPDATE DomainGroup SET dateAdded = :dateAdded WHERE id=:id")
.setParameter("id", 6L)
.setParameter("dateAdded", cal.getTime())
.executeUpdate();
cal.add(Calendar.HOUR, -1);
getEntityManager()
.createQuery("UPDATE Person SET dateAdded = :dateAdded WHERE id=:id")
.setParameter("id", 99L)
.setParameter("dateAdded", cal.getTime())
.executeUpdate();
cal.add(Calendar.HOUR, -1);
getEntityManager()
.createQuery("UPDATE DomainGroup SET dateAdded = :dateAdded WHERE id=:id")
.setParameter("id", 8L)
.setParameter("dateAdded", cal.getTime())
.executeUpdate();
getEntityManager()
.createQuery("UPDATE Person SET dateAdded = :dateAdded WHERE id=:id")
.setParameter("id", 42L)
.setParameter("dateAdded", cal.getTime())
.executeUpdate();
getEntityManager().clear();
List<StreamDTO> results = sut.execute(null);
for (StreamDTO result : results) {
System.out.println(
result.getEntityType() + " - " + result.getId() + " " + result.getDateAdded());
}
Assert.assertEquals(7, results.size());
Assert.assertEquals(EntityType.GROUP, results.get(0).getEntityType());
Assert.assertEquals(5, results.get(0).getId());
Assert.assertEquals(EntityType.PERSON, results.get(1).getEntityType());
Assert.assertEquals(4507, results.get(1).getId());
Assert.assertEquals(EntityType.GROUP, results.get(2).getEntityType());
Assert.assertEquals(7, results.get(2).getId());
Assert.assertEquals(EntityType.GROUP, results.get(3).getEntityType());
Assert.assertEquals(6, results.get(3).getId());
Assert.assertEquals(EntityType.PERSON, results.get(4).getEntityType());
Assert.assertEquals(99, results.get(4).getId());
Assert.assertEquals(EntityType.GROUP, results.get(5).getEntityType());
Assert.assertEquals(8, results.get(5).getId());
Assert.assertEquals(EntityType.PERSON, results.get(6).getEntityType());
Assert.assertEquals(42, results.get(6).getId());
}
/** Setup. */
@Before
public void setup() {
sut = new GetStreamsByMostRecentDbMapper(7);
sut.setEntityManager(getEntityManager());
}
