/*
 * The contents of this file are subject to the Mozilla Public License
 * Version 1.1 (the "License");  you may not use this file except in 
 * compliance with the License.  You may obtain a copy of the License at
 * http://www.mozilla.org/MPL/
 *
 * Software distributed under the License is distributed on an "AS IS" basis,
 * WITHOUT WARRANTY OF ANY KIND, either express or implied. See the License for
 * the specific language governing rights and limitations under the License.
 *
 * The Original Code is Protege-2000.
 *
 * The Initial Developer of the Original Code is Stanford University. Portions
 * created by Stanford University are Copyright (C) 2007.  All Rights Reserved.
 *
 * Protege was developed by Stanford Medical Informatics
 * (http://www.smi.stanford.edu) at the Stanford University School of Medicine
 * with support from the National Library of Medicine, the National Science
 * Foundation, and the Defense Advanced Research Projects Agency.  Current
 * information about Protege can be obtained at http://protege.stanford.edu.
 *
 */


package edu.stanford.smi.protegex.owl.swrl.bridge.builtins.temporal;

import edu.stanford.smi.protegex.owl.swrl.bridge.builtins.temporal.exceptions.*;

import java.text.SimpleDateFormat;
import java.sql.*;

/**
 **  A class supporting processing of datetime strings represented in the standard JDBC format 'y-M-d h:m:s.S'.
 */
public class JDBCDatetimeStringProcessor extends DatetimeStringProcessor
{
  private static SimpleDateFormat _dateFormat = new SimpleDateFormat("y-M-d h:m:s.S");
  private static String _delimiters = " -:."; // Note the space.

  // The number of tokens (including delimeters) necessary to strip a datetime to a specified granularity.
  private static int[] _gTokenIndex = { 1, 3, 5, 7, 9, 11, 13 }; // 1=YEARS, 3=MONTHS etc.

  // Strings to pad a partially specified datetime.
  private static String _datetimeRoundDownPadding[] = {"-01-01 00:00:00.000","-01 00:00:00.000"," 00:00:00.000",":00:00.000",":00.000",".000", ""};

  /** .997 is used for the millisecond value instead of .999 because SQL Server appears to have a resolution of .003 milliseconds and will
   ** round to the next second if a value greater than .997 is used. Day-in-month is dealt with separately.
   */
  private static String _datetimeRoundUpPadding[] = { "-12-31 23:59:59.997", "", " 23:59:59.997", ":59:59.997", ":59.997", ".997", "" };

  public JDBCDatetimeStringProcessor()
  {
    super(_dateFormat, _delimiters, _gTokenIndex, _datetimeRoundDownPadding, _datetimeRoundUpPadding);
  } // JDBCDatetimeStringProcessor

  protected String constructDatetimeString(long milliseconds) throws TemporalException
  {
    Timestamp timestamp = new Timestamp(milliseconds);

    return timestamp.toString(); // Returns in JDBC format.
  } // constructDatetimeString

} // JDBCDatetimeStringProcessor

