/** Test of the add, update, and delete methods of class QuestionRepo. */ @Test public void testAddUpdateDelete() throws Exception { QuestionEntity q = new QuestionEntity(); QuestionRepo repo = new QuestionRepo(DatabaseConnectionInfo.createDefault()); /** *************** */ /** ***** add ***** */ /** *************** */ System.out.println("add"); q.setQid(123); q.setPostedByUserId(1); q.setPostedTimestamp(new Date()); q.setTitle("DB Test Question Title"); q.setText("DB Test Question body text"); boolean rowAdded = repo.add(q); assertTrue("add - record was not added", rowAdded); /** *************** */ /** *** update **** */ /** *************** */ System.out.println("update"); q.setPostedByUserId(2); q.setPostedTimestamp(new Date()); q.setTitle("DB Test Question Title 2"); q.setText("DB Test Question body text 2"); boolean rowUpdated = repo.update(q); assertTrue("update - record was not updated", rowUpdated); /** *************** */ /** *** delete **** */ /** *************** */ System.out.println("delete"); boolean rowDeleted = repo.delete(q); assertTrue("delete - no record deleted", rowDeleted); assertTrue("delete - qid was not reset", q.getQid() == 0); }