@BeforeClass
public static void insertTeam() {
ScrumzuUser user = new ScrumzuUser("TestUser", "Hash password", true);
insertedUser = user;
Calendar calendar = Calendar.getInstance();
calendar.set(2012, 01, 01);
Project project = new Project();
project.setAlias("XX");
project.setDescription("To jest test do JUnit");
project.setName("Projekt Testowy");
project.setOwner("Kowalski Jarosław");
project.setUrl("http://com.pl");
project.setVersion("1.23");
insertedProject = project;
Team team = new Team();
team.setAlias("ZZ");
team.setDescription("To jest test do JUnit");
team.setName("Test Testowy");
team.setProject(insertedProject);
team.setUser(insertedUser);
insertedTeam = team;
Sprint sprint = new Sprint();
sprint.setDateFrom(Calendar.getInstance().getTime());
sprint.setDateTo(calendar.getTime());
sprint.setSprintStatus(SprintStatus.CREATED);
sprint.setName("pierwszy");
sprint.setProject(insertedProject);
insertedSprint = sprint;
PBI pbi = new PBI();
pbi.setDateCreation(Calendar.getInstance().getTime());
pbi.setDescription("To jest PBI testowe JUnit");
pbi.setPriority(1);
pbi.setProject(insertedProject);
pbi.setTitle("Testowe PBI");
pbi.setType(Type.PERFORMANCE);
insertedPBI = pbi;
WorkItem workItem = new WorkItem();
workItem.setStatus(Status.DONE);
workItem.setPbi(insertedPBI);
workItem.setSprint(insertedSprint);
workItem.setTeam(insertedTeam);
workItem.setUser(insertedUser);
workItem.setDateForNow();
insertedWorkItem = workItem;
}
@Test
public void deleteWithWorkItemsTest() {
userDao.save(insertedUser);
projectDao.save(insertedProject);
pbiDao.save(insertedPBI);
sprintDao.save(insertedSprint);
teamDao.save(insertedTeam);
workItemDao.save(insertedWorkItem);
insertedTeam.addWorkItem(insertedWorkItem);
insertedWorkItem.setTeam(insertedTeam);
teamDao.flushSession();
long idTeam = insertedTeam.getIdTeam();
teamDao.delete(insertedTeam);
teamDao.flushSession();
int counter =
super.simpleJdbcTemplate.queryForInt(
"select count(*) from Teams where idTeam=?", new Object[] {idTeam});
assertEquals("JDBC query must return no teams with this id", 0, counter);
counter =
super.simpleJdbcTemplate.queryForInt(
"select count(*) from WorkItems where idTeam=?", new Object[] {idTeam});
assertEquals("JDBC query must return no workItems with this id", 0, counter);
}