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