@Test public void testUpdate() { try { NotaB notaBU = new NotaB(); notaBU.setDescrizione("asd2"); boolean test = notaBDAO.update(conn, notaBU, notaB1); db.rollbackConnection(conn); assertTrue(test); } catch (DAOException e) { fail(e.getMessage()); } catch (DBAccessException e) { fail(e.getMessage()); } finally { try { db.closeConnection(conn); } catch (DBAccessException e) { e.printStackTrace(); } } // TEST 2 try { notaBDAO.update(conn, new Allegato(), notaB1); fail(); } catch (DAOException e) { assertTrue(e.getMessageKey().equals(INV_OBJ_NOTA_B)); } finally { try { db.closeConnection(conn); } catch (DBAccessException e) { e.printStackTrace(); } } // TEST 3 try { notaBDAO.update(conn, null, notaB1); fail(); } catch (DAOException e) { // return; assertTrue(e.getMessageKey().equals(INV_OBJ_NOTA_B)); } finally { try { db.closeConnection(conn); } catch (DBAccessException e) { e.printStackTrace(); } } }
@Test public void testFind() { try { RowSet rs = notaBDAO.find(notaB1, 2); try { boolean b = rs.next(); assertTrue(b); } catch (SQLException e) { fail(e.getMessage()); } } catch (DAOException e) { fail(e.getMessage()); } finally { try { db.closeConnection(conn); } catch (DBAccessException e) { e.printStackTrace(); } } // TEST 2 try { notaBDAO.find(new Allegato(), 2); fail(); } catch (DAOException e) { assertTrue(e.getMessageKey().equals(INV_OBJ_NOTA_B)); } finally { try { db.closeConnection(conn); } catch (DBAccessException e) { e.printStackTrace(); } } // TEST 3 try { notaBDAO.find(null, 2); fail(); } catch (DAOException e) { assertTrue(e.getMessageKey().equals(INV_OBJ_NOTA_B)); } finally { try { db.closeConnection(conn); } catch (DBAccessException e) { e.printStackTrace(); } } }
@Test public void testFindByAll() { try { RowSet rs = notaBDAO.findByAll(); assertTrue(rs.next()); } catch (DAOException e) { fail(e.getMessageKey()); } catch (SQLException e) { fail(e.getMessage()); } finally { try { db.closeConnection(conn); } catch (DBAccessException e) { e.printStackTrace(); } } }
@Test public void testRemove() { try { boolean res = notaBDAO.remove(conn, notaB1.getIdNotaB()); db.rollbackConnection(conn); assertTrue(res); } catch (DBAccessException e) { fail(e.getMessage()); } catch (DAOException e) { fail(e.getMessage()); } finally { try { db.closeConnection(conn); } catch (DBAccessException e) { e.printStackTrace(); } } }
@Test public void testCreate() { try { notaB2.setData(cd.getTime()); notaBDAO.create(conn, notaB2); String query = NOTA_B_FIND_BYPK; Statement stmt2 = conn.createStatement(); ResultSet rs = stmt2.executeQuery( "SELECT `AUTO_INCREMENT` FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA = 'db_qualita' AND TABLE_NAME = 'nota_b'"); rs.next(); int id = rs.getInt(1); PreparedStatement stmt = conn.prepareStatement(query); stmt.setInt(1, id - 1); rs = stmt.executeQuery(); rs.next(); int a = rs.getInt(1); db.rollbackConnection(conn); assertTrue(rs.getInt(1) == (id - 1)); } catch (DAOException e) { fail(e.getMessage()); } catch (SQLException e) { fail(e.getMessage()); } catch (DBAccessException e) { e.printStackTrace(); } finally { try { db.closeConnection(conn); } catch (DBAccessException e) { e.printStackTrace(); } } // TEST 2 test null try { notaBDAO.create(null, notaB2); fail(); } catch (DAOException e) { // return; assertTrue(e.getMessageKey().equals(INV_OBJ_NOTA_B)); } finally { try { db.closeConnection(conn); } catch (DBAccessException e) { e.printStackTrace(); } } // TEST 3 test class exception try { notaBDAO.create(conn, new Allegato()); fail(); } catch (DAOException e) { assertTrue(e.getMessageKey().equals(INV_OBJ_NOTA_B)); } finally { try { db.closeConnection(conn); } catch (DBAccessException e) { e.printStackTrace(); } } }