com.hfg.sql.table.field.DatabaseDateField Maven / Gradle / Ivy

Go to download
Show more of this group Show more artifacts with this name
Show all versions of com_hfg Show documentation
com.hfg xml, html, svg, and bioinformatics utility library
There is a newer version: 20240423
package com.hfg.sql.table.field;

import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Timestamp;
import java.sql.Types;
import java.time.Instant;
import java.time.ZonedDateTime;
import java.time.format.DateTimeFormatter;
import java.util.Date;

import com.hfg.datetime.DateUtil;
import com.hfg.sql.SQLUtil;
import com.hfg.sql.jdbc.JDBCException;
import com.hfg.sql.table.DatabaseCol;
import com.hfg.sql.table.DatabaseTable;
import com.hfg.xml.XMLTag;

//------------------------------------------------------------------------------
/**
 Database field that manages a date value.
 
 @author J. Alex Taylor, hairyfatguy.com
 
 */
//------------------------------------------------------------------------------
// com.hfg XML/HTML Coding Library
//
// This library is free software; you can redistribute it and/or
// modify it under the terms of the GNU Lesser General Public
// License as published by the Free Software Foundation; either
// version 2.1 of the License, or (at your option) any later version.
//
// This library is distributed in the hope that it will be useful,
// but WITHOUT ANY WARRANTY; without even the implied warranty of
// MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the GNU
// Lesser General Public License for more details.
//
// You should have received a copy of the GNU Lesser General Public
// License along with this library; if not, write to the Free Software
// Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA  02111-1307  USA
//
// J. Alex Taylor, President, Founder, CEO, COO, CFO, OOPS hairyfatguy.com
// [email protected]
//------------------------------------------------------------------------------

public class DatabaseDateField extends DatabaseField
{
   //###########################################################################
   // CONSTRUCTORS
   //###########################################################################

   //---------------------------------------------------------------------------
   public DatabaseDateField(DatabaseCol inCol)
   {
      this(inCol, (Object) null);
   }
   
   //---------------------------------------------------------------------------
   public DatabaseDateField(DatabaseCol inCol, Date inValue)
   {
      super(inCol, inValue != null ? inValue.toInstant() : null);
   }

   //---------------------------------------------------------------------------
   public DatabaseDateField(DatabaseCol inCol, Instant inValue)
   {
      super(inCol, inValue);
   }

   //---------------------------------------------------------------------------
   public DatabaseDateField(DatabaseCol inCol, Object inValue)
   {
      super(inCol, convertToInstant(inValue));
   }

   //---------------------------------------------------------------------------
   public DatabaseDateField(DatabaseCol inCol, ResultSet inResultSet)
   {
      super(inCol, inResultSet);
   }

   //---------------------------------------------------------------------------
   public DatabaseDateField(XMLTag inXMLTag, DatabaseTable inTable)
   {
      super(inXMLTag, inTable);
   }

   //###########################################################################
   // PUBLIC METHODS
   //###########################################################################

   //---------------------------------------------------------------------------
   protected void setValueFromResultSet(ResultSet inResultSet)
   {
      // Retrieve the index for the ResultSet column with the matching name.
      // If no column with the proper name is present in the ResultSet, don't do anything.
      Integer index = getColIndex(inResultSet);
      if (index != null)
      {
         try
         {
            Timestamp timestamp = inResultSet.getTimestamp(index);
            setInitialValue(null == timestamp ? null : Instant.ofEpochMilli(timestamp.getTime()));
         }
         catch (SQLException e)
         {
            try
            {
               throw new JDBCException("Problem mapping " + getCol().name() + " value: " + inResultSet.getString(getCol().name()) + "!", e);
            }
            catch (SQLException e2)
            {
               throw new JDBCException("Problem mapping " + getCol().name() + " value!", e);
            }
         }
      }
   }

   //---------------------------------------------------------------------------
   public void setValueInPreparedStatement(PreparedStatement inPreparedStatement, int inIndex)
   {
      try
      {
         if (isNull())
         {
            inPreparedStatement.setNull(inIndex, Types.TIMESTAMP_WITH_TIMEZONE);
         }
         else
         {
            inPreparedStatement.setTimestamp(inIndex, new Timestamp(getValue().toEpochMilli()));
         }
      }
      catch (SQLException e)
      {
         throw new JDBCException("Problem setting column " + getCol().name() + " value into PreparedStatement!", e);
      }
   }

   //---------------------------------------------------------------------------
   public void setValueFromString(String inValue)
   {
      setValue(convertToInstant(inValue, getCol()));
   }

   //---------------------------------------------------------------------------
   @Override
   public String getSQLValue()
   {
      String valueString = null;

      if (getValue() != null)
      {
         DateTimeFormatter formatter = getCol().getTable().getRDBMS().getSQLDateFormatter(getCol().getType());

         valueString = formatter.format(DateUtil.convertToUTCZonedDateTime(getValue()));
      }

      return SQLUtil.sqlString(valueString);
   }

   //###########################################################################
   // PRIVATE METHODS
   //###########################################################################

   //---------------------------------------------------------------------------
   private Instant convertToInstant(Object inValue, DatabaseCol inCol)
   {
      Instant dateValue = null;
      if (inValue != null)
      {
         dateValue = convertToInstant(inValue);
         if (null == dateValue
               && inValue instanceof String)
         {
            DateTimeFormatter formatter = inCol.getTable().getRDBMS().getSQLDateFormatter(getCol().getType());
            try
            {
               dateValue = ZonedDateTime.parse((String) inValue, formatter).toInstant();
            }
            catch (Exception e)
            {
               try
               {
                  dateValue = ZonedDateTime.parse((String) inValue, DateTimeFormatter.ISO_OFFSET_DATE_TIME).toInstant();
               }
               catch (Exception e2)
               {
                   // Ignore
               }
            }
         }
      }

      return dateValue;
   }

   //---------------------------------------------------------------------------
   private static Instant convertToInstant(Object inValue)
   {
      Instant instantValue = null;
      if (inValue != null)
      {
         if (inValue instanceof Date)
         {
            instantValue = ((Date) inValue).toInstant();
         }
         else if (inValue instanceof java.sql.Date)
         {
            instantValue = ((java.sql.Date) inValue).toInstant();
         }
         else if (inValue instanceof String)
         {
            try
            {
               instantValue = ZonedDateTime.parse((String) inValue, DateTimeFormatter.ISO_OFFSET_DATE_TIME).toInstant();
            }
            catch (Exception e2)
            {
               // Ignore
            }
         }
      }

      return instantValue;
   }
}