Index: lams_tool_nb/test/java/org/lamsfoundation/lams/tool/noticeboard/dao/hibernate/TestNoticeboardAttachmentDAO.java
===================================================================
diff -u
--- lams_tool_nb/test/java/org/lamsfoundation/lams/tool/noticeboard/dao/hibernate/TestNoticeboardAttachmentDAO.java	(revision 0)
+++ lams_tool_nb/test/java/org/lamsfoundation/lams/tool/noticeboard/dao/hibernate/TestNoticeboardAttachmentDAO.java	(revision 05cd46a79bd68f88bd7284564012e6de576718bb)
@@ -0,0 +1,96 @@
+/*
+ * Created on Jul 29, 2005
+ *
+ * TODO To change the template for this generated file go to
+ * Window - Preferences - Java - Code Style - Code Templates
+ */
+package org.lamsfoundation.lams.tool.noticeboard.dao.hibernate;
+
+import org.lamsfoundation.lams.tool.noticeboard.NbDataAccessTestCase;
+import org.lamsfoundation.lams.tool.noticeboard.dao.hibernate.NoticeboardAttachmentDAO;
+import org.lamsfoundation.lams.tool.noticeboard.NoticeboardAttachment;
+import org.lamsfoundation.lams.tool.noticeboard.NoticeboardContent;
+import java.util.List;
+
+/**
+ * @author mtruong
+ *
+ * TODO To change the template for this generated type comment go to
+ * Window - Preferences - Java - Code Style - Code Templates
+ */
+public class TestNoticeboardAttachmentDAO extends NbDataAccessTestCase {
+
+    private NoticeboardAttachmentDAO attachmentDao;
+    private NoticeboardContentDAO contentDao;
+    private NoticeboardAttachment nbAttachment = null;
+    private NoticeboardContent nbContent = null;
+    
+  
+   
+    public TestNoticeboardAttachmentDAO(String name)
+    {
+        super(name);
+    }
+    
+
+    /**
+     * @see NbDataAccessTestCase#setUp()
+     */
+	 protected void setUp() throws Exception {
+	     super.setUp();
+	     attachmentDao = (NoticeboardAttachmentDAO)this.context.getBean("nbAttachmentDAO");
+	     contentDao = (NoticeboardContentDAO)this.context.getBean("nbContentDAO");
+	     super.initAllData();
+	     initNbAttachmentData();
+	 }
+	 
+	 /**
+	  * @see NbDataAccessTestCase#tearDown()
+	  */
+	 protected void tearDown() throws Exception {
+	     super.tearDown();
+	     super.cleanNbContentData(TEST_NB_ID);
+	 }
+	 
+	 public void testRetrieveAttachment()
+	 {
+	     //test retrieveAttachmentByUuid
+	    nbAttachment = attachmentDao.retrieveAttachmentByUuid(TEST_UUID);
+	    assertAttachmentData(nbAttachment);
+	     
+	     /* test getAttachmentsFromContent which will return a list of attachment ids, which we can use in the next method call to
+	     retrieveAttachment which takes in the attachmentId as the parameter. */
+	     List attachmentIds = attachmentDao.getAttachmentIdsFromContent(contentDao.findNbContentById(TEST_NB_ID));
+	     
+	     //test retrieveAttachment (by attachmentId, which was retrieved from the previous method)
+	     nbAttachment = attachmentDao.retrieveAttachment((Long)attachmentIds.get(0));
+	     assertAttachmentData(nbAttachment);
+	     
+	 }
+	 
+	 public void testSaveAttachment()
+	 {
+	     String newFilename = "new filename";
+	     nbAttachment = attachmentDao.retrieveAttachmentByUuid(TEST_UUID);
+	     nbAttachment.setFilename(newFilename);
+	     
+	     attachmentDao.saveAttachment(nbAttachment);
+	     
+	     nbAttachment = attachmentDao.retrieveAttachmentByUuid(TEST_UUID);
+	     assertEquals("Validating the new filename", nbAttachment.getFilename(), newFilename);
+	 }
+	 
+	 public void testRemoveAttachment()
+	 {
+	     nbAttachment = attachmentDao.retrieveAttachmentByUuid(TEST_UUID);
+	     
+	     attachmentDao.removeAttachment(nbAttachment);
+	     
+	     nbAttachment = attachmentDao.retrieveAttachmentByUuid(TEST_UUID);
+	     assertNull(nbAttachment);
+	     
+	 } 
+	
+	 
+	 
+}