/***
    Copyright (C) 2005 The Java Community
   
    This program is free software; you can redistribute it and/or modify  it under
    the terms of the GNU General Public License as published by  the Free Software
    Foundation; either version 2 of the License, or  (at your option) any later
    version.
   
    This program is distributed in the hope that it will be useful,  but WITHOUT
   ANY WARRANTY; without even the implied warranty of  MERCHANTABILITY or FITNESS
   FOR A PARTICULAR PURPOSE. See the  GNU General Public License for more details.
  
   You should have received a copy of the GNU General Public License  along with
   this program; if not, write to the Free Software  Foundation, Inc., 59 Temple
   Place, Suite 330, Boston, MA 02111-1307 USA.
   */
  package org.bejug.javacareers.jobs.dao;
  
  import java.util.List;
  
  import org.bejug.javacareers.jobs.common.AbstractSpringContextDBUnitTests;
  import org.bejug.javacareers.jobs.model.Comment;
  import org.springframework.dao.DataAccessException;
  
  /***
   * @author Sven Schauwvliege (Last modified by $Author: shally $)
   * @version $Revision: 1.10 $ - $Date: 2005/12/20 15:36:47 $
   */
  
  
  public class CommentDaoImplTests extends AbstractSpringContextDBUnitTests {
  
      /***
       * the names of the tables need to be compaired
       */
      private static final String[] TABLE_NAMES = {"Resume", "Parameter", "Country", "Region", "Address","Contact", "Organisation", "Person", "User", "Offer", "Offer_OfferType", "Offer_Profile","JobOffer", "Comment"};
      /***
       * the columns to ignore.
       */
      private static final String[] IGNORE = {"id", "modificationdate"};
      /***
       * the jobofferdao, injected through field-injection.
       */
      protected CommentDao commentDao;
  
      /***
       * @return Returns the commentDao.
       */
      public CommentDao getCommentDao() {
          return commentDao;
      }
  
      /***
       * Test the Create, Read, Read all, Update and Delete functions for a Comment.
       *
       * @throws DataAccessException Thrown when a database exceptions occurs.
       */
      public void testCRUDComment() throws DataAccessException {
          // a known user id
          Integer userId = new Integer(500);
          
          //
          // (1) Read al offers from the database to a list.
          //
          List offers = commentDao.getComments(userId, false);
          assertTrue("read failed, amount of found objects not 5 but " + (offers.size()), offers.size() == 5);
          assertTrue("read failed ", offers.get(0).getClass() == Comment.class);
      
          // get some test comments
          Comment com50 = getCommentDao().getComment(new Integer(50));
          Comment com51 = getCommentDao().getComment(new Integer(51));
          Comment com52 = getCommentDao().getComment(new Integer(52));
          Comment com53 = getCommentDao().getComment(new Integer(53));
          Comment com54 = getCommentDao().getComment(new Integer(54));
         
          //
          // (2) delete al offers 
          //
  
          Comment deleteComment = getCommentDao().getComment(new Integer(54));
          //by cascading this should delete 50, 51, 52, 53.   
          getCommentDao().deleteComment(new Integer(50));
          //one left, 54.  
          getCommentDao().deleteComment(deleteComment);
          
          //   setComplete();
          //   transactionManager.commit(transactionStatus);
             
          List emptyComments = getCommentDao().getComments(userId, false);
          assertTrue("delete faled ", emptyComments.size() == 0);
   
          //clear the relations betzeen the comments
          com50.setParentComment(null);
          com50.getChildComments().clear();
          com50.setVersion(null);
          com51.setParentComment(null);
          com51.getChildComments().clear();
          com51.setVersion(null);
          com52.setParentComment(null);
         com52.getChildComments().clear();
         com52.setVersion(null);
         com53.setParentComment(null);
         com53.getChildComments().clear();
         com53.setVersion(null);
         com54.setParentComment(null);
         com54.getChildComments().clear();
         com54.setVersion(null);
         //
         // (3) Save all comments 
         //
         
         //add the first comment
         getCommentDao().store(com50);
         //add a child to the comment and save the comment
         com50.addChildComment(com51);
         getCommentDao().store(com50);
         //add a child to the child commment and save the child comment
         com51.addChildComment(com52);
         getCommentDao().store(com51);
         //add a other child to the comment and save the comment
         com50.addChildComment(com53);
         getCommentDao().store(com50);
         //ad the last single comment
         getCommentDao().store(com54);
 
         List foundComments = getCommentDao().getComments(userId, false);
         assertTrue("save failed, amount of found objects not 5 but " + foundComments.size(), foundComments.size() == 5);
         
         // compare the database
         assertDBAsExpected(TABLE_NAMES, IGNORE);
     }
 
     /***
      * Test the update/ get by id.
      *
      * @throws DataAccessException Thrown when a database exceptions occurs.
      */
     public void testUpdateReadComment() throws DataAccessException {
 
         // Get a comment by id
         Comment foundComment = getCommentDao().getComment(new Integer(50));
         assertEquals("error in get by id", foundComment.getContent(), "Test comment 1");
         assertEquals("error in get by id", foundComment.getId(), new Integer(50));
         
         // Update the Comment
         foundComment.setContent("update");
         getCommentDao().store(foundComment);
         Comment newComment = getCommentDao().getComment(new Integer(50));
         assertEquals("error in update", newComment.getContent(), "update");
         assertEquals("error in update", newComment.getId(), new Integer(50));
     }
 
     /***
      * {@inheritDoc}
      */
     public void onSetUpInTransaction() throws Exception {
         init(TABLE_NAMES);
 
     }
 
 }
 
 /***
  * $Log: CommentDaoImplTests.java,v $
  * Revision 1.10  2005/12/20 15:36:47  shally
  * CheckStyle and PMD changes.
  *
  * Revision 1.9  2005/08/24 08:12:19  schauwvliege
  * addded resume
  *
  * Revision 1.8  2005/08/03 13:16:03  bme_jcs
  * getDao's removed and storeObject renamed to store
  *
  * Revision 1.7  2005/08/03 09:10:58  ge0ffrey
  * JAVACAREERS-247
  *
  * Revision 1.6  2005/07/06 12:10:10  schauwvliege
  * added person/contact and location to model
  *
  * Revision 1.5  2005/07/05 15:09:30  schauwvliege
  * added person/contact and location to model
  *
  * Revision 1.4  2005/06/29 09:00:26  psong09
  * comment component updated
  *
  * Revision 1.3  2005/06/14 13:34:56  schauwvliege
  * fixed tests
  *
  * Revision 1.2  2005/06/09 08:19:04  bejug_cc
  * Fix initial import
  *
  * Revision 1.1  2005/05/25 11:06:53  ssc
  * added DBUnit tests and fixed some errors
  * 
  **/