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