/******************************************************************************

  * 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);

                 }

         }

 }