@Test
public void removeResponsesOfAGivenUser() {
ScheduleEvent scheduleEvent = scheduleEventDao.getScheduleEvent(theScheduledEvent().getId());
assertThat(scheduleEvent.getResponses().size(), is(2));
scheduleEventDao.purgeResponseScheduleEvent(scheduleEvent, 0);
ScheduleEvent actual = scheduleEventDao.getScheduleEvent(scheduleEvent.getId());
assertThat(actual.getResponses().size(), is(1));
}
@Test
public void createANewScheduleEvent() throws Exception {
ScheduleEvent event = new ScheduleEvent();
event.setAuthor(0);
event.setCreationDate(Timestamp.valueOf("2012-04-10 17:56:35.761"));
event.setTitle("A new event");
event.setDescription("test the persistence of the new event");
Contributor contributor = new Contributor();
contributor.setUserId(0);
contributor.setUserName("Bart Simpson");
contributor.setScheduleEvent(event);
event.getContributors().add(contributor);
scheduleEventDao.createScheduleEvent(event);
int rowCount =
databaseTester
.getConnection()
.getRowCount("sc_scheduleevent_list", "where id = '" + event.getId() + "'");
assertThat(rowCount, is(1));
rowCount =
databaseTester
.getConnection()
.getRowCount(
"sc_scheduleevent_contributor", "where id = '" + contributor.getId() + "'");
assertThat(rowCount, is(1));
}
@Test
public void listScheduleEventsForAnExistingContributor() {
String contributorId = "2";
Set<ScheduleEvent> events = scheduleEventDao.listScheduleEventsByContributorId(contributorId);
assertThat(events.size(), is(1));
ScheduleEvent theEvent = events.iterator().next();
assertThat(theEvent, isEqualTo(theScheduledEvent()));
}
@Test
public void deleteAScheduleEvent() throws Exception {
ScheduleEvent scheduleEvent = theScheduledEvent();
scheduleEventDao.deleteScheduleEvent(scheduleEvent);
int eventCount =
databaseTester
.getConnection()
.getRowCount("sc_scheduleevent_list", "where id = '" + scheduleEvent.getId() + "'");
assertThat(eventCount, is(0));
}
@Test
public void getAnUnexistingScheduleEvent() {
ScheduleEvent actual = scheduleEventDao.getScheduleEvent("toto");
assertThat(actual, nullValue());
}
@Test
public void getAnExistingScheduleEvent() {
ScheduleEvent expected = theScheduledEvent();
ScheduleEvent actual = scheduleEventDao.getScheduleEvent(expected.getId());
assertThat(actual, isEqualTo(expected));
}
@Test
public void listScheduleEventsForAnUnexistingContributor() {
String contributorId = "100";
Set<ScheduleEvent> events = scheduleEventDao.listScheduleEventsByContributorId(contributorId);
assertThat(events.isEmpty(), is(true));
}
