public void testDeleteMailingList() {
MailingList mailingList = new MailingList();
mailingList.setComponentId("componentId");
ExternalUser user = new ExternalUser();
user.setEmail("*****@*****.**");
user.setComponentId("componentId");
mailingList.getExternalSubscribers().add(user);
user = new ExternalUser();
user.setEmail("*****@*****.**");
user.setComponentId("componentId");
mailingList.getExternalSubscribers().add(user);
String id = mailingListDao.createMailingList(mailingList);
assertNotNull(id);
mailingList = mailingListDao.findById(id);
assertNotNull(mailingList);
assertEquals("componentId", mailingList.getComponentId());
assertEquals(1, countRowsInTable("SC_MAILINGLIST_LIST"));
assertEquals(2, countRowsInTable("SC_MAILINGLIST_EXTERNAL_USER"));
assertNotNull(mailingList.getExternalSubscribers());
assertEquals(2, mailingList.getExternalSubscribers().size());
mailingListDao.deleteMailingList(mailingList);
mailingList = mailingListDao.findById(id);
assertNull(mailingList);
assertEquals(0, countRowsInTable("SC_MAILINGLIST_LIST"));
assertEquals(0, countRowsInTable("SC_MAILINGLIST_EXTERNAL_USER"));
}
