/******************************************************************************
    * MosaicVectorsDaoJdbc.java - Implement the Dao interface for the MosaicVectors
    * 
    * PicMan - The BuckoSoft Picture Manager in Java
    * Copyright(c) 2007 - Dick Balaska
    * 
    */
   package com.buckosoft.PicMan.db;
   
  import java.sql.ResultSet;
  import java.sql.SQLException;
  import java.sql.Types;
  import java.util.LinkedList;
  import java.util.List;
  
  import javax.sql.DataSource;
  
  import org.apache.commons.logging.Log;
  import org.apache.commons.logging.LogFactory;
  import org.springframework.jdbc.core.SqlParameter;
  import org.springframework.jdbc.object.MappingSqlQuery;
  import org.springframework.jdbc.object.SqlUpdate;
  
  import com.buckosoft.PicMan.domain.Pic;
  import com.buckosoft.PicMan.domain.mosaic.MosaicVector;
  
  /** Implement the Dao Interface for the {@link com.buckosoft.PicMan.domain.mosaic.MosaicVector}s.
   * @author Dick Balaska
   * @since 2007/12/14
   * @see <a href="http://cvs.buckosoft.com/Projects/java/PicMan/PicMan/src/com/buckosoft/PicMan/db/MosaicVectorsDaoJdbc.java">MosaicVectorsDaoJdbc.java</a>
   */
  public class MosaicVectorsDaoJdbc implements MosaicVectorsDao {
  	private static final boolean DEBUG = true;
  	protected final Log logger = LogFactory.getLog(getClass());
  
  
  	private DataSource ds;
  
  	private	String	replaceString;
  
  	/** 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;
  	}
  
  	public MosaicVectorsDaoJdbc() {
  		StringBuilder sb = new StringBuilder();
  		sb.append("REPLACE INTO mosaicVectors (pid");
  		int d;
  		int x;
  		int y;
  		for (d=1; d<=MosaicVector.MAXDEPTH; d++) {
  			for (x=0; x<d; x++) {
  				for (y=0; y<d; y++) {
  					sb.append(",c");
  					sb.append(d);
  					sb.append("_");
  					sb.append(x);
  					sb.append("_");
  					sb.append(y);
  				}
  			}
  		}
  		sb.append(") VALUES (?");
  		for (d=1; d<=MosaicVector.MAXDEPTH; d++) {
  			for (y=0; y<d; y++) {
  				for (x=0; x<d; x++) {
  					sb.append(",?");
  				}
  			}
  		}
  		sb.append(")");
  		replaceString = sb.toString();
  		if (DEBUG)
  			logger.info(replaceString);
  	}
  	/* (non-Javadoc)
  	 * @see com.buckosoft.PicMan.db.MosaicVectorsDao#getMosaicVector(java.lang.String)
  	 */
  	public MosaicVector getMosaicVector(String pic) {
  		// TODO Auto-generated method stub
  		return null;
  	}
  
  	/* (non-Javadoc)
  	 * @see com.buckosoft.PicMan.db.MosaicVectorsDao#updateMosaicVector(com.buckosoft.PicMan.domain.MosaicVector)
  	 */
  	public void updateMosaicVector(MosaicVector mv) {
  		if (sql_storeMosaicVectorINSERT == null)
  			sql_storeMosaicVectorINSERT = new MosaicVectorInsert(ds);
  		sql_storeMosaicVectorINSERT.insert(mv);
  	}
  	private	MosaicVectorInsert	sql_storeMosaicVectorINSERT = null;
  
  	
  	/* (non-Javadoc)
 	 * @see com.buckosoft.PicMan.db.MosaicVectorsDao#getMosaicVectors(java.util.List)
 	 */
 	public List<MosaicVector>	getMosaicVectors(List<Pic> picList) {
 		LinkedList<MosaicVector>	list = new LinkedList<MosaicVector>();
 		
 		return(list);
 	}
 
 	///////////////////////////////////////////////////////////////////////////
 	class MosaicVectorQuery extends MappingSqlQuery {
 		
 		MosaicVectorQuery(DataSource ds) {
 			super(ds, "SELECT * from mosaicVectors");
 			compile();
 		}
 		
 		MosaicVectorQuery(DataSource ds, int pid) {
 			super(ds, "SELECT * from mosaicVectors WHERE pid = ?");
 			declareParameter(new SqlParameter(Types.INTEGER));
 			compile();
 		}
 		
 		
 		protected Object mapRow(ResultSet rs, int rowNum) throws SQLException {
 			MosaicVector mv = new MosaicVector();
 			mv.pid = rs.getInt("pid");
 			mv.rgb = rs.getInt("c1_0_0");
 			int x,y,z;
 			z = 2;
 			for (x=0; x<z; x++) {
 				for (y=0; y<z; y++) {
 					mv.rgb2[x][y] = rs.getInt("c2_" + x + "_" + "y");
 				}
 			}
 			z = 3;
 			for (x=0; x<z; x++) {
 				for (y=0; y<z; y++) {
 					mv.rgb3[x][y] = rs.getInt("c3_" + x + "_" + "y");
 				}
 			}
 			return(mv);
 		}
 	}
 	
 	
 	/**
 	 * <code>MosaicVector</code> Insert Object.
 	 */
 	protected class MosaicVectorInsert extends SqlUpdate {
 		
 		/**
 		 * Create a new instance of MetaSetInsert.
 		 * @param ds the DataSource to use for the insert
 		 */
 		protected MosaicVectorInsert(DataSource ds) {
 			super(ds, replaceString);
 			declareParameter(new SqlParameter(Types.VARCHAR));
 			int d;
 			int x;
 			int y;
 			for (d=1; d<=MosaicVector.MAXDEPTH; d++) {
 				for (y=0; y<d; y++) {
 					for (x=0; x<d; x++) {
 						declareParameter(new SqlParameter(Types.INTEGER));
 					}
 				}
 			}
 			compile();
 		}
 
 		protected void insert(MosaicVector mv) {
 			LinkedList<Object> ll = new LinkedList<Object>();
 			ll.add(new Integer(mv.pid));
 			ll.add(new Integer(mv.rgb));
 			int	x;
 			int	y;
 			for (y=0; y<2; y++) {
 				for (x=0; x<2; x++) {
 					ll.add(new Integer(mv.rgb2[x][y]));
 				}
 			}
 			for (y=0; y<3; y++) {
 				for (x=0; x<3; x++) {
 					ll.add(new Integer(mv.rgb3[x][y]));
 				}
 			}
 			
 			
 			Object[] objs = ll.toArray();
 			super.update(objs);
 			// retrieveIdentity(owner);
 		}
 	}
 
 }