/******************************************************************************
    * VirginsDaoJdbc.java - Implement the Dao interface for the Virgins
    * 
    * PicMan - The BuckoSoft Picture Manager in Java
    * Copyright(c) 2005 - Dick Balaska
    * 
    */
   package com.buckosoft.PicMan.db;
   
  import java.util.List;
  
  import javax.sql.DataSource;
  
  import java.sql.ResultSet;
  import java.sql.SQLException;
  import java.sql.Types;
  
  import org.apache.commons.logging.Log;
  import org.apache.commons.logging.LogFactory;
  
  import org.springframework.dao.DataAccessException;
  import org.springframework.jdbc.core.SqlParameter;
  import org.springframework.jdbc.object.SqlFunction;
  import org.springframework.jdbc.object.SqlUpdate;
  import org.springframework.jdbc.object.MappingSqlQuery;
  
  import com.buckosoft.PicMan.domain.Virgin;
  
  /** Implement the Dao Interface for the {@link com.buckosoft.PicMan.domain.Virgin}s.
   * @author Dick Balaska
   * @since 2005/07/31
   * @see <a href="http://cvs.buckosoft.com/Projects/java/PicMan/PicMan/src/com/buckosoft/PicMan/db/VirginsDaoJdbc.java">VirginsDaoJdbc.java</a>
   */
  public class VirginsDaoJdbc implements VirginsDao {
  
  	private final static boolean DEBUG = false;
  	private final static boolean DEBUGCONNECTIONLEAK = false;
  	
  	protected final Log logger = LogFactory.getLog(getClass());
  	
  //	private	PicManFacade	pmf;
  	private DataSource ds;
  
  	/** Set the reference to the JDBC datasource.
  	 * @param ds The datasource as configured by Spring.
  	 * @see <a href="http://cvs.buckosoft.com/Projects/java/PicMan/PicMan/WebContent/WEB-INF/picManDatabase/picManDatabase.xml">picManDatabase.xml</a>
  	 */ 
  	public void setDataSource(DataSource ds) {
  		this.ds = ds;
  	}
  
  	/** Get the list of Virgins, the Pics that haven't been filtered yet.
  	 * @return The List
  	 */
  	@SuppressWarnings("unchecked")
  	public List<Virgin> getVirgins() throws DataAccessException {
  		if (DEBUG)
  			logger.info("Getting Virgins");
  		VirginsQuery vq = new VirginsQuery(ds);
  		return(vq.execute());
  	}
  
  	
  	/* (non-Javadoc)
  	 * @see com.buckosoft.PicMan.db.VirginsDao#getVirgins(int)
  	 */
  	@SuppressWarnings("unchecked")
  	public List<Virgin> getVirgins(int max) throws DataAccessException {
  		if (DEBUG)
  			logger.info("Getting Virgins(" + max + ")");
  		VirginsQuery vq = new VirginsQuery(ds, max);
  		return(vq.execute(max));
  	}
  
  	/* (non-Javadoc)
  	 * @see com.buckosoft.PicMan.db.VirginsDao#isVirgin(java.lang.String)
  	 */
  	public boolean isVirgin(String picName) {
  		VirginsQuery vq = new VirginsQuery(ds, picName);
  		Virgin v = (Virgin)vq.findObject(picName);
  		if (DEBUG)
  			logger.info("IsVirgin: " + picName + ": " + v != null ? "true" : "false");
  		return(v != null ? true : false);
  	}
  	
  	/** Add a pic to the Virgin database
  	 * @param picName The name of the pic to add
  	 */
  	public void	addVirgin(String picName) throws DataAccessException {
  		if (DEBUG)
  			logger.info("addVirgin: " + picName);
  		VirginInsert vi = new VirginInsert(ds);
  		Virgin v = new Virgin();
  		v.setName(picName);
  		vi.insert(v);
  	}
  	
  	/** Delete a pic from the Virgin database
  	 * @param picName The name of the pic to remove
 	 */
 	public void	deleteVirgin(String picName) throws DataAccessException {
 		if (DEBUG)
 			logger.info("deleteVirgin: " + picName);
 		VirginDelete vd = new VirginDelete(ds);
 		Virgin v = new Virgin();
 		v.setName(picName);
 		vd.delete(v);
 	}
 
 	/** Get the number of Virgins in the database
 	 * @return the count
 	 */
 	public int	getVirginCount() {
 		if (DEBUG)
 			logger.info("getVirginCount:");
 		if (DEBUGCONNECTIONLEAK)
 			return(69);
 		if (sql_getVirginCountQUERYr == null)
 			sql_getVirginCountQUERYr = new VirginsCount(ds);
 		return(sql_getVirginCountQUERYr.run());
 	}
 	private VirginsCount	sql_getVirginCountQUERYr;
 	
 	///////////////////////////////////////////////////////////////////////////
 	class VirginsQuery extends MappingSqlQuery {
 		
 		VirginsQuery(DataSource ds) {
 			super(ds, "SELECT * from virgins");
 			compile();
 		}
 		
 		VirginsQuery(DataSource ds, int max) {
 			super(ds, "SELECT * from virgins LIMIT ?");
 			declareParameter(new SqlParameter(Types.INTEGER));
 			compile();
 		}
 		
 		VirginsQuery(DataSource ds, String picName) {
 			super(ds, "SELECT * from virgins WHERE pic = ?");
 			declareParameter(new SqlParameter(Types.VARCHAR));
 			compile();
 		}
 		
 		
 		protected Object mapRow(ResultSet rs, int rowNum) throws SQLException {
 			Virgin v = new Virgin();
 			v.setName(rs.getString("pic"));
 			return(v);
 		}
 	}
 	
 	/**
 	 * <code>Virgin</code> Count Object.
 	 */
 	class VirginsCount extends SqlFunction {
 		
 		VirginsCount(DataSource ds) {
 			super(ds, "SELECT COUNT(*) from virgins");
 			compile();
 		}		
 	}
 
 	/**
 	 * <code>Virgin</code> Insert Object.
 	 */
 	protected class VirginInsert extends SqlUpdate {
 		
 		/**
 		 * Create a new instance of VirginInsert.
 		 * @param ds the DataSource to use for the insert
 		 */
 		protected VirginInsert(DataSource ds) {
 			super(ds, "INSERT INTO virgins VALUES(?)");
 			declareParameter(new SqlParameter(Types.VARCHAR));
 			compile();
 		}
 		
 		protected void insert(Virgin v) {
 			Object[] objs = new Object[] {
 					v.getName()};
 			super.update(objs);
 			// retrieveIdentity(owner);
 		}
 	}
 	
 	/**
 	 * <code>Virgin</code> Delete Object.
 	 */
 	protected class VirginDelete extends SqlUpdate {
 		
 		/**
 		 * Create a new instance of VirginRemove.
 		 * @param ds the DataSource to use for the delete
 		 */
 		protected VirginDelete(DataSource ds) {
 			super(ds, "DELETE FROM virgins WHERE pic = (?)");
 			declareParameter(new SqlParameter(Types.VARCHAR));
 			compile();
 		}
 		
 		protected void delete(Virgin v) {
 			Object[] objs = new Object[] {
 					v.getName()};
 			super.update(objs);
 			// retrieveIdentity(owner);
 		}
 	}
 }