@Test
public void getTeamsForUser() {
userDao.save(insertedUser);
projectDao.save(insertedProject);
teamDao.save(insertedTeam);
List<Team> teams = teamDao.getTeamsForUser(insertedUser);
assertEquals("List of teams for particular user should not be empty", 1, teams.size());
Team selectedTeam = teamDao.getTeamsForUser(insertedUser).get(0);
assertEquals("Selected team is not equal to expected one", insertedTeam, selectedTeam);
}
@Test
public void getTeamByIdTest() {
userDao.save(insertedUser);
projectDao.save(insertedProject);
teamDao.save(insertedTeam);
teamDao.flushSession();
long insertedTeamId = insertedTeam.getIdTeam();
Team selectedTeam = teamDao.getTeam(insertedTeamId);
assertEquals("Selected teams are not equal", selectedTeam, insertedTeam);
}
@Test
public void loadTeamByIdTest() {
userDao.save(insertedUser);
projectDao.save(insertedProject);
teamDao.save(insertedTeam);
teamDao.flushSession();
long teamId = insertedTeam.getIdTeam();
Team loadedTeam = teamDao.loadTeam(teamId);
assertEquals("Loaded object is not equal", loadedTeam.getAlias(), insertedTeam.getAlias());
assertEquals("Loaded object is not equal", loadedTeam.getName(), insertedTeam.getName());
}
@Test
public void getTeamsByProject() {
userDao.save(insertedUser);
projectDao.save(insertedProject);
teamDao.save(insertedTeam);
teamDao.flushSession();
List<Team> teams = teamDao.getTeamsForProject(insertedProject);
if (teams.size() != 1) {
fail("List should have one related team");
}
assertEquals("Selected team is not equal", teams.get(0), insertedTeam);
}
@Test
public void getTeamId() {
userDao.save(insertedUser);
projectDao.save(insertedProject);
teamDao.save(insertedTeam);
teamDao.flushSession();
long teamId = teamDao.getTeamId(insertedTeam.getAlias());
assertEquals(
"Team's selected id is not equal to expected one",
insertedTeam.getIdTeam(),
new Long(teamId));
}
@Test
public void saveTest() {
userDao.save(insertedUser);
projectDao.save(insertedProject);
int rowsBeforeSave = super.countRowsInTable("Teams");
teamDao.save(insertedTeam);
teamDao.flushSession();
int rowsAfterSave = super.countRowsInTable("Teams");
assertEquals("Number of rows has not increased", rowsBeforeSave + 1, rowsAfterSave);
long insertedTeamId = insertedTeam.getIdTeam();
assertEquals("Teams are not equal", teamDao.getTeam(insertedTeamId), insertedTeam);
}
@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 getTeamsTest() {
userDao.save(insertedUser);
projectDao.save(insertedProject);
teamDao.save(insertedTeam);
teamDao.flushSession();
List<Team> teams = teamDao.getTeams();
if (teams.isEmpty()) {
fail("List of teams cannot be empty after insert");
}
assertEquals(
"JDBC query must show the same number of teams",
super.countRowsInTable("Teams"),
teams.size());
Team team = teams.get(teams.size() - 1);
assertEquals("Selected team is not equal", team.getAlias(), "ZZ");
assertEquals("Selected team is not equal", team.getName(), "Test Testowy");
}
@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);
}