@Test
public void testListerSeances() {
List<Seance> listeCours = seanceDao.listerSeances();
Assert.assertEquals(4, listeCours.size());
Assert.assertEquals(1L, listeCours.get(0).getId().longValue());
Assert.assertEquals("cours1", listeCours.get(0).getTitre());
Assert.assertEquals("cours de debuggage", listeCours.get(0).getDescription());
Assert.assertEquals(
new GregorianCalendar(2014, Calendar.JULY, 26).getTime().getTime(),
listeCours.get(0).getDate().getTime());
Assert.assertEquals(3L, listeCours.get(1).getId().longValue());
Assert.assertEquals("tp1", listeCours.get(1).getTitre());
Assert.assertEquals("tp de debuggage", listeCours.get(1).getDescription());
Assert.assertEquals(
new GregorianCalendar(2014, Calendar.JULY, 29).getTime().getTime(),
listeCours.get(1).getDate().getTime());
Assert.assertEquals(TypeSeance.TP, listeCours.get(1).getType());
Assert.assertEquals(
new GregorianCalendar(2014, Calendar.JULY, 29, 18, 0).getTime().getTime(),
listeCours.get(1).getDateLimiteRendu().getTime());
Assert.assertTrue(listeCours.get(1).getIsNote());
}
@Test
public void testModifierSeance() throws Exception {
Seance seance =
new Seance(
1L,
"monTitre",
"maDescription",
new GregorianCalendar(2014, Calendar.SEPTEMBER, 6).getTime(),
true,
new GregorianCalendar(2014, Calendar.SEPTEMBER, 6, 18, 5).getTime(),
TypeSeance.TP);
seanceDao.modifierSeance(seance);
Connection connection = DataSourceProvider.getInstance().getDataSource().getConnection();
Statement stmt = connection.createStatement();
ResultSet results = stmt.executeQuery("SELECT * FROM seance WHERE id=1");
if (results.next()) {
Assert.assertEquals(1L, results.getLong("id"));
Assert.assertEquals("monTitre", results.getString("titre"));
Assert.assertEquals("maDescription", results.getString("description"));
Assert.assertEquals(
new GregorianCalendar(2014, Calendar.SEPTEMBER, 6, 0, 0).getTime(),
results.getTimestamp("date"));
Assert.assertTrue(results.getBoolean("isnote"));
Assert.assertEquals(
new GregorianCalendar(2014, Calendar.SEPTEMBER, 6, 18, 5).getTime(),
results.getTimestamp("datelimiterendu"));
Assert.assertEquals(TypeSeance.TP, TypeSeance.valueOf(results.getString("type")));
} else {
Assert.fail();
}
stmt.close();
connection.close();
}
@Test
public void testListerTPNotesParDateRendu() {
Calendar cal = new GregorianCalendar(2014, Calendar.AUGUST, 29, 15, 27, 0);
List<Seance> listeTps = seanceDao.listerTPNotesParDateRendu(cal.getTime());
Assert.assertEquals(1, listeTps.size());
Assert.assertEquals(4L, listeTps.get(0).getId().longValue());
Assert.assertEquals("tp2", listeTps.get(0).getTitre());
Assert.assertEquals("tp de correction", listeTps.get(0).getDescription());
Assert.assertEquals(
new GregorianCalendar(2014, Calendar.AUGUST, 29).getTime(), listeTps.get(0).getDate());
Assert.assertTrue(listeTps.get(0).getIsNote());
}
@Test
public void testGetSeance() {
Seance seance = seanceDao.getSeance(3L);
Assert.assertNotNull(seance);
Assert.assertEquals(3L, seance.getId().longValue());
Assert.assertEquals("tp1", seance.getTitre());
Assert.assertEquals("tp de debuggage", seance.getDescription());
Assert.assertEquals(TypeSeance.TP, seance.getType());
Assert.assertEquals(new GregorianCalendar(2014, Calendar.JULY, 29).getTime(), seance.getDate());
Assert.assertEquals(
new GregorianCalendar(2014, Calendar.JULY, 29, 18, 0, 0).getTime(),
seance.getDateLimiteRendu());
}
@Test
public void testListerSeancesNotees() {
List<Seance> listeCours = seanceDao.listerSeancesNotees();
Assert.assertEquals(2, listeCours.size());
Assert.assertEquals(3L, listeCours.get(0).getId().longValue());
Assert.assertEquals("tp1", listeCours.get(0).getTitre());
Assert.assertEquals("tp de debuggage", listeCours.get(0).getDescription());
Assert.assertEquals(
new GregorianCalendar(2014, Calendar.JULY, 29).getTime().getTime(),
listeCours.get(0).getDate().getTime());
Assert.assertEquals(4L, listeCours.get(1).getId().longValue());
Assert.assertEquals("tp2", listeCours.get(1).getTitre());
Assert.assertEquals("tp de correction", listeCours.get(1).getDescription());
Assert.assertEquals(
new GregorianCalendar(2014, Calendar.AUGUST, 29).getTime().getTime(),
listeCours.get(1).getDate().getTime());
}
@Test
public void testAjouterSeanceComplete() throws Exception {
Seance seance =
new Seance(
null,
"monTitre",
"maDescription",
new GregorianCalendar(2014, Calendar.SEPTEMBER, 6).getTime(),
true,
new GregorianCalendar(2014, Calendar.SEPTEMBER, 6, 18, 5).getTime(),
TypeSeance.TP);
Seance seanceCreee = seanceDao.ajouterSeance(seance);
Assert.assertNotNull(seanceCreee.getId());
Connection connection = DataSourceProvider.getInstance().getDataSource().getConnection();
PreparedStatement stmt = connection.prepareStatement("SELECT * FROM seance WHERE id=?");
stmt.setLong(1, seanceCreee.getId());
ResultSet results = stmt.executeQuery();
if (results.next()) {
Assert.assertEquals(seanceCreee.getId().longValue(), results.getLong("id"));
Assert.assertEquals("monTitre", results.getString("titre"));
Assert.assertEquals("maDescription", results.getString("description"));
Assert.assertEquals(
new GregorianCalendar(2014, Calendar.SEPTEMBER, 6, 0, 0).getTime(),
results.getTimestamp("date"));
Assert.assertTrue(results.getBoolean("isnote"));
Assert.assertEquals(
new GregorianCalendar(2014, Calendar.SEPTEMBER, 6, 18, 5).getTime(),
results.getTimestamp("datelimiterendu"));
Assert.assertEquals(TypeSeance.TP, TypeSeance.valueOf(results.getString("type")));
} else {
Assert.fail();
}
stmt.close();
connection.close();
}
