/** 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);
}
