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

  * MosaicTileDaoJdbc.java - Implement the Dao interface for the MosaicTiles

  * 

  * PicMan - The BuckoSoft Picture Manager in Java

  * Copyright(c) 2008 - Dick Balaska

  * 

  */

 package com.buckosoft.PicMan.db;

 import java.sql.ResultSet;

 import java.sql.SQLException;

 import java.sql.Types;

 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.SqlFunction;

 import org.springframework.jdbc.object.SqlUpdate;

 import com.buckosoft.PicMan.domain.MosaicTile;

 /** Implement the Dao Interface for the {@link com.buckosoft.PicMan.domain.MosaicTile}s.

  * @author Dick Balaska

  * @since 2008/01/21

  * @see <a href="http://cvs.buckosoft.com/Projects/java/PicMan/PicMan/src/com/buckosoft/PicMan/db/MosaicTilesDaoJdbc.java">MosaicTilesDaoJdbc.java</a>

  */

 public class MosaicTilesDaoJdbc implements MosaicTilesDao {

         private static final boolean DEBUG = false;

         protected final Log logger = LogFactory.getLog(getClass());

         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;

         }

         /* (non-Javadoc)

          * @see com.buckosoft.PicMan.db.MosaicTilesDao#deleteMosaicTiles(int)

          */

         public void deleteMosaicTiles(int mid) {

                 if (DEBUG)

                         logger.info("deleteMosaicTile: " + mid);

                 MosaicTileDelete mtd = new MosaicTileDelete(ds);

                 mtd.delete(mid);

         }

         /* (non-Javadoc)

          * @see com.buckosoft.PicMan.db.MosaicTilesDao#getMosaicTiles(int)

          */

         @SuppressWarnings("unchecked")

         public List<MosaicTile> getMosaicTiles(int mid) {

                 if (sql_getMosaicTilesQUERY == null)

                         sql_getMosaicTilesQUERY = new MosaicTilesQuery(ds, mid);

                 if (DEBUG)

                         logger.info("getMosaicTiles: " + mid);

         return(sql_getMosaicTilesQUERY.execute(mid));

          }

         private        MosaicTilesQuery        sql_getMosaicTilesQUERY = null;

         /* (non-Javadoc)

          * @see com.buckosoft.PicMan.db.MosaicTilesDao#getTileCount(int)

          */

         public int getTileCount(int mid) {

                 if (DEBUG)

                         logger.info("getTileCount:");

                 if (sql_getTileCountQUERYr == null)

                         sql_getTileCountQUERYr = new MosaicTilesCount(ds);

                 return(sql_getTileCountQUERYr.run(mid));

         }

                 private MosaicTilesCount        sql_getTileCountQUERYr;

         /* (non-Javadoc)

          * @see com.buckosoft.PicMan.db.MosaicTilesDao#storeMosaicTile(com.buckosoft.PicMan.domain.MosaicTile)

          */

         public void storeMosaicTile(MosaicTile tile) {

                 MosaicTileInsert mti = new MosaicTileInsert(ds);

                 mti.insert(tile);

         }

         /////////////////////////////////////////////////////////////////////////////////////

         /**

          * <code>MosaicTiles</code> Count Object.

          */

         class MosaicTilesCount extends SqlFunction {

                 MosaicTilesCount(DataSource ds) {

                         super(ds, "SELECT COUNT(*) from mosaicTiles where mid=?");

                         declareParameter(new SqlParameter(Types.INTEGER));

                         compile();

                 }                

         }

         /////////////////////////////////////////////////////////////////////////////////////

         /**

          * <code>MosaicTiles</code> Query object.

          */

         class MosaicTilesQuery extends MappingSqlQuery {

 /*                MosaicTilesQuery(DataSource ds) {

             super(ds, "SELECT * from MosaicTiles");

             compile();

         }

 */

                 MosaicTilesQuery(DataSource ds, int mid) {

             super(ds, "SELECT * from mosaicTiles where mid = ?");

                         declareParameter(new SqlParameter(Types.INTEGER));

             compile();

         }

         protected Object mapRow(ResultSet rs, int rowNum) throws SQLException {

                 MosaicTile mt = new MosaicTile();

                 mt.setMid(rs.getInt("mid"));

                 mt.setPid(rs.getInt("pid"));

                 mt.setX(rs.getInt("x"));

                 mt.setY(rs.getInt("y"));

                 mt.setWidth(rs.getInt("width"));

                 mt.setHeight(rs.getInt("height"));

                 return(mt);

         }

         }

         /////////////////////////////////////////////////////////////////////////////////////

         /**

          * <code>MosaicTile</code> Delete Object.

          */

         protected class MosaicTileDelete extends SqlUpdate {

                 /**

                  * Create a new instance of MosaicTileRemove.

                  * @param ds the DataSource to use for the delete

                  */

                 protected MosaicTileDelete(DataSource ds) {

                         super(ds, "DELETE FROM mosaicTiles WHERE mid = (?)");

                         declareParameter(new SqlParameter(Types.INTEGER));

                         compile();

                 }

                 protected void delete(int mid) {

                         super.update(mid);

                 }

         }

         /////////////////////////////////////////////////////////////////////////////////////

         /**

          * <code>MosaicTile</code> Insert Object.

          */

         protected class MosaicTileInsert extends SqlUpdate {

                 /**

                  * Create a new instance of MosaicTileInsert.

                  * @param ds the DataSource to use for the insert

                  */

                 protected MosaicTileInsert(DataSource ds) {

                         super(ds, "REPLACE INTO mosaicTiles VALUES(?,?,?,?,?,?)");

                         declareParameter(new SqlParameter(Types.INTEGER));

                         declareParameter(new SqlParameter(Types.INTEGER));

                         declareParameter(new SqlParameter(Types.INTEGER));

                         declareParameter(new SqlParameter(Types.INTEGER));

                         declareParameter(new SqlParameter(Types.INTEGER));

                         declareParameter(new SqlParameter(Types.INTEGER));

                         compile();

                 }

                 protected void insert(MosaicTile mt) {

                         Object[] objs = new Object[] {

                                         new Integer(mt.getMid()),

                                         new Integer(mt.getPid()),

                                         new Integer(mt.getX()),

                                         new Integer(mt.getY()),

                                         new Integer(mt.getWidth()),

                                         new Integer(mt.getHeight()),

                         };

                         super.update(objs);

                         // retrieveIdentity(owner);

                 }

         }

 }