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