package org.apache.continuum.dao;
   
   /*
    * Licensed to the Apache Software Foundation (ASF) under one
    * or more contributor license agreements.  See the NOTICE file
    * distributed with this work for additional information
    * regarding copyright ownership.  The ASF licenses this file
    * to you under the Apache License, Version 2.0 (the
    * "License"); you may not use this file except in compliance
   * with the License.  You may obtain a copy of the License at
   *
   *   http://www.apache.org/licenses/LICENSE-2.0
   *
   * Unless required by applicable law or agreed to in writing,
   * software distributed under the License is distributed on an
   * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
   * KIND, either express or implied.  See the License for the
   * specific language governing permissions and limitations
   * under the License.
   */
  
  import java.util.Collection;
  import java.util.List;
  
  import javax.jdo.Extent;
  import javax.jdo.PersistenceManager;
  import javax.jdo.Query;
  import javax.jdo.Transaction;
  
  import org.apache.continuum.model.release.ContinuumReleaseResult;
  import org.apache.maven.continuum.store.ContinuumObjectNotFoundException;
  import org.apache.maven.continuum.store.ContinuumStoreException;
  import org.springframework.stereotype.Repository;
  
  /**
   * @author <a href="mailto:ctan@apache.org">Maria Catherine Tan</a>
   * @plexus.component role="org.apache.continuum.dao.ContinuumReleaseResultDao"
   */
  @Repository("continuumReleaseResultDao")
  public class ContinuumReleaseResultDaoImpl
      extends AbstractDao
      implements ContinuumReleaseResultDao
  {
      public ContinuumReleaseResult addContinuumReleaseResult( ContinuumReleaseResult releaseResult )
          throws ContinuumStoreException
      {
          return (ContinuumReleaseResult) addObject( releaseResult );
      }
  
      public List<ContinuumReleaseResult> getAllContinuumReleaseResults()
      {
          return getAllObjectsDetached( ContinuumReleaseResult.class );
      }
  
      public ContinuumReleaseResult getContinuumReleaseResult( int releaseResultId )
          throws ContinuumObjectNotFoundException, ContinuumStoreException
      {
          return (ContinuumReleaseResult) getObjectById( ContinuumReleaseResult.class, releaseResultId );
      }
  
      public ContinuumReleaseResult getContinuumReleaseResult( int projectId, String releaseGoal, long startTime, long endTime )
          throws ContinuumStoreException
      {
          PersistenceManager pm = getPersistenceManager();
  
          Transaction tx = pm.currentTransaction();
  
          try
          {
              tx.begin();
              
              Extent extent = pm.getExtent( ContinuumReleaseResult.class, true );
  
              Query query = pm.newQuery( extent );
  
              query.declareImports( "import java.lang.String" );
              
              query.declareParameters( "int projectId, String releaseGoal, long startTime, long endTime" );
              
              query.setFilter( "this.project.id == projectId && this.releaseGoal == releaseGoal && this.startTime == startTime && this.endTime == endTime" );
              
              Object[] params = new Object[4];
              params[0] = projectId;
              params[1] = releaseGoal;
              params[2] = startTime;
              params[3] = endTime;
  
              Collection result = (Collection) query.executeWithArray( params );
  
              if ( result.size() == 0 )
              {
                  tx.commit();
  
                  return null;
              }
  
              Object object = pm.detachCopy( result.iterator().next() );
  
              tx.commit();
             
             return (ContinuumReleaseResult) object;
         }
         finally
         {
             rollback( tx );
         }
 
     }
     
     public List<ContinuumReleaseResult> getContinuumReleaseResultsByProjectGroup( int projectGroupId )
     {
         PersistenceManager pm = getPersistenceManager();
 
         Transaction tx = pm.currentTransaction();
 
         try
         {
             tx.begin();
 
             Extent extent = pm.getExtent( ContinuumReleaseResult.class, true );
 
             Query query = pm.newQuery( extent, "projectGroup.id == " + projectGroupId );
 
             List result = (List) query.execute();
 
             result = (List) pm.detachCopyAll( result );
 
             tx.commit();
 
             return result;
         }
         finally
         {
             rollback( tx );
         }
     }
 
     public List<ContinuumReleaseResult> getContinuumReleaseResultsByProject( int projectId )
     {
         PersistenceManager pm = getPersistenceManager();
 
         Transaction tx = pm.currentTransaction();
 
         try
         {
             tx.begin();
 
             Extent extent = pm.getExtent( ContinuumReleaseResult.class, true );
 
             Query query = pm.newQuery( extent, "project.id == " + projectId );
 
             List result = (List) query.execute();
 
             result = (List) pm.detachCopyAll( result );
 
             tx.commit();
 
             return result;
         }
         finally
         {
             rollback( tx );
         }
     }
 
     public void removeContinuumReleaseResult( ContinuumReleaseResult releaseResult )
         throws ContinuumStoreException
     {
         removeObject( releaseResult );
     }
 
 }