@Test public void countTeamsForSprintTest() { userDao.save(insertedUser); projectDao.save(insertedProject); pbiDao.save(insertedPBI); sprintDao.save(insertedSprint); teamDao.save(insertedTeam); workItemDao.save(insertedWorkItem); teamDao.flushSession(); assertEquals("Count number is not valid", 1, teamDao.countTeamsForSprint(insertedSprint)); workItemDao.delete(insertedWorkItem); teamDao.delete(insertedTeam); teamDao.flushSession(); assertEquals("Count number is not valid", 0, teamDao.countTeamsForSprint(insertedSprint)); }
@Test public void deleteByIdTest() { userDao.save(insertedUser); projectDao.save(insertedProject); int rowsBeforeInsert = super.countRowsInTable("Teams"); teamDao.save(insertedTeam); teamDao.flushSession(); long teamId = insertedTeam.getIdTeam(); teamDao.delete(teamId); teamDao.flushSession(); int rowsAfterDelete = super.countRowsInTable("Teams"); assertEquals( "JDBC query must return the same number of teams", rowsBeforeInsert, rowsAfterDelete); Team selectedTeam = teamDao.getTeam(teamId); assertNull("Selected team after delete should be null", selectedTeam); }
@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); }