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

  * SetTimestampsDaoJdbc.java - Implement the Dao Interface for the SetTimestamp table

  *

  * PicMan - The BuckoSoft Picture Manager in Java

  * Copyright(c) 2011 - Dick Balaska

  * 

  */

 package com.buckosoft.PicMan.db;

 import java.sql.ResultSet;

 import java.sql.SQLException;

 import java.sql.Types;

 import java.util.Date;

 import java.util.HashMap;

 import java.util.Iterator;

 import java.util.LinkedHashMap;

 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;

 /** Implement the Dao Interface for the SetTimestamp table

  * @author Dick Balaska

  * @since 2011/12/30

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

  */

 public class SetTimestampsDaoJdbc implements SetTimestampsDao {

         private final static boolean DEBUG = false;

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

         private DataSource ds;

         /** Set the JDBC datasource reference

      * @param ds The DataSource as generated by the Spring config/setup.

      */

         public void setDataSource(DataSource ds) {

                 this.ds = ds;

         }

         /* (non-Javadoc)

          * @see com.buckosoft.PicMan.db.FiltersDao#getFilterDates()

          */

         public HashMap<String, Date>        getSetTimestamps() {

                 HashMap<String, Date> hm = new HashMap<String, Date>();

                 if (sql_getFilterDatesQUERY == null)

                         sql_getFilterDatesQUERY = new FilterSetsTimestampQuery(ds);

                 @SuppressWarnings("unchecked")

                 List<SetsTimestamp> l = sql_getFilterDatesQUERY.execute();

                 Iterator<SetsTimestamp> it = l.iterator();

                 while (it.hasNext()) {

                         SetsTimestamp st = it.next();

                         hm.put(st.uid, st.timestamp);

                 }

                 return(hm);

         }

         private FilterSetsTimestampQuery sql_getFilterDatesQUERY = null;

         /* (non-Javadoc)

          * @see com.buckosoft.PicMan.db.FiltersDao#updateFilterDates(java.util.LinkedHashMap)

          */

         public        void        updateFilterDates(LinkedHashMap<String, String> changed) {

                 for (String s : changed.keySet())

                         updateSetTimestamp(s);

         }

         @Override

         public void updateSetTimestamp(String setName) {

                 String s = "DELETE FROM setsTimestamp WHERE uid = \"" + setName + "\"";

                 if (DEBUG)

                         logger.info(s);

                 SqlUpdate sf1 = new SqlUpdate(ds, s);

                 sf1.update();

                 if (sql_updateFilterDatesINSERT == null)

                         sql_updateFilterDatesINSERT = new FilterSetsTimestampInsert(ds);

                 sql_updateFilterDatesINSERT.insert(setName);

         }

         FilterSetsTimestampInsert sql_updateFilterDatesINSERT;

         /** Mini-domain object representing the setsTimestamp table */

         class SetsTimestamp {

                 String        uid;

                 Date        timestamp;

         }

         class FilterSetsTimestampQuery extends MappingSqlQuery {

                 FilterSetsTimestampQuery(DataSource ds) {

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

                         compile();

                 }

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

                         SetsTimestamp st = new SetsTimestamp();

                         st.uid = rs.getString("uid");

                         try {

                                 st.timestamp = rs.getTimestamp("timestamp");

                         } catch (Exception e) {}

                         return(st);

                 }

         }

         /**

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

          */

         protected class FilterSetsTimestampInsert extends SqlUpdate {

                 /**

                  * Create a new instance of FilterSetsTimestampInsert.

                  * @param ds the DataSource to use for the insert

                  */

                 protected FilterSetsTimestampInsert(DataSource ds) {

                         super(ds, "INSERT INTO setsTimestamp VALUES(?,?)");

                         declareParameter(new SqlParameter(Types.VARCHAR));

                         declareParameter(new SqlParameter(Types.TIMESTAMP));

                         compile();

                 }

                 protected void insert(SetsTimestamp st) {

                         Object[] objs = new Object[] {

                                         st.uid, st.timestamp };

                         super.update(objs);

                 }

                 protected void insert(String key) {

                         Object[] objs = new Object[] {

                                         key, new Date() };

                         super.update(objs);

                 }

         }        

 }