package org.apache.fulcrum.security.torque.turbine;
   /*
    * 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.sql.Connection;
  import java.util.List;
  
  import org.apache.fulcrum.security.entity.Role;
  import org.apache.fulcrum.security.torque.om.TorqueTurbineRolePeer;
  import org.apache.fulcrum.security.torque.peer.TorqueTurbinePeer;
  import org.apache.fulcrum.security.torque.peer.managers.PeerRoleManager;
  import org.apache.fulcrum.security.util.DataBackendException;
  import org.apache.torque.NoRowsException;
  import org.apache.torque.TooManyRowsException;
  import org.apache.torque.TorqueException;
  import org.apache.torque.criteria.Criteria;
  /**
   * This implementation persists to a database via Torque.
   *
   * @author <a href="mailto:tv@apache.org">Thomas Vandahl</a>
   * @version $Id:$
   */
  public class TorqueTurbineRoleManagerImpl extends PeerRoleManager 
  {
  
  	/** Serial version */
  	private static final long serialVersionUID = 1L;
  
  	/**
       * @see org.apache.fulcrum.security.torque.TorqueAbstractRoleManager#doSelectAllRoles(java.sql.Connection)
       */
      @Override
  	@SuppressWarnings("unchecked")
  	protected <T extends Role> List<T> doSelectAllRoles(Connection con) throws TorqueException
      {
          Criteria criteria = new Criteria();
  
          if ( (getCustomPeer())) {
              try
              {
              	TorqueTurbinePeer<T> peerInstance = (TorqueTurbinePeer<T>)getPeerInstance();
              	
                  return peerInstance.doSelect( criteria, con );
              }
              catch ( DataBackendException e )
              {
                  throw new TorqueException( e );
              }
          } else {
              return (List<T>)TorqueTurbineRolePeer.doSelect(criteria, con);
          }
      }
  
      /**
       * @see org.apache.fulcrum.security.torque.TorqueAbstractRoleManager#doSelectById(java.lang.Integer, java.sql.Connection)
       */
      @Override
  	@SuppressWarnings("unchecked")
  	protected <T extends Role> T doSelectById(Integer id, Connection con) throws NoRowsException, TooManyRowsException, TorqueException
      {
          if ( (getCustomPeer())) {
              try
              {
              	TorqueTurbinePeer<T> peerInstance = (TorqueTurbinePeer<T>)getPeerInstance();
              	
                  return peerInstance.retrieveByPK( id, con );
              }
              catch ( DataBackendException e )
              {
                  throw new TorqueException( e );
              }
          } else {
              return  (T)  TorqueTurbineRolePeer.retrieveByPK(id, con);
          }
      }
  
      /**
       * @see org.apache.fulcrum.security.torque.TorqueAbstractRoleManager#doSelectByName(java.lang.String, java.sql.Connection)
       */
      @Override
  	@SuppressWarnings("unchecked")
  	protected <T extends Role> T doSelectByName(String name, Connection con) throws NoRowsException, TooManyRowsException, TorqueException
      {
          Criteria criteria = new Criteria();
         criteria.setIgnoreCase(true);
         criteria.setSingleRecord(true);
         
         List<T> roles = null;
         if ( (getCustomPeer())) {
             try
             {
             	TorqueTurbinePeer<T> peerInstance = (TorqueTurbinePeer<T>)getPeerInstance();
             	
             	criteria.where(peerInstance.getTableMap().getColumn(getColumnName()), name);
                 roles = peerInstance.doSelect( criteria, con );
             }
             catch ( DataBackendException e )
             {
                 throw new TorqueException( e );
             }
         } else {
             criteria.where(TorqueTurbineRolePeer.ROLE_NAME, name);
             roles =  (List<T>) TorqueTurbineRolePeer.doSelect(criteria, con);
         }
 
         if (roles.isEmpty())
         {
             throw new NoRowsException(name);
         }
         return roles.get(0);
     }
 }