/*
* JBoss, Home of Professional Open Source.
* See the COPYRIGHT.txt file distributed with this work for information
* regarding copyright ownership. Some portions may be licensed
* to Red Hat, Inc. under one or more contributor license agreements.
*
* 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., 51 Franklin Street, Fifth Floor, Boston, MA
* 02110-1301 USA.
*/
package org.teiid.core.util;
import java.sql.Date;
import java.sql.Time;
import java.sql.Timestamp;
import java.util.Calendar;
import java.util.TimeZone;
import org.teiid.core.types.DataTypeManager;
/**
* Utility methods for SQL Timestamps, Time, and Dates with time zones as UTC
*
* This is intended to take incoming Strings or Dates that have accurate
* Calendar fields and give the UTC time by interpretting those fields
* in the target time zone.
*
* Use of the Calendar object passed in will not be thread safe, but
* it will not alter the contents of the Calendar.
*
* Note that normalization occurs only for the transition from one type to another.
*
*/
public class TimestampWithTimezone {
public static final String ISO8601_WEEK_PROP = "org.teiid.iso8601Week"; //$NON-NLS-1$
public static boolean ISO8601_WEEK = PropertiesUtils.getBooleanProperty(System.getProperties(), ISO8601_WEEK_PROP, true);
private static ThreadLocal<Calendar> CALENDAR = new ThreadLocal<Calendar>() {
protected Calendar initialValue() {
return initialCalendar();
}
};
public static Calendar getCalendar() {
return CALENDAR.get();
}
public static void resetCalendar(TimeZone tz) {
TimeZone.setDefault(tz);
CALENDAR.set(initialCalendar());
}
static Calendar initialCalendar() {
Calendar result = Calendar.getInstance();
if (ISO8601_WEEK) {
result.setMinimalDaysInFirstWeek(4);
result.setFirstDayOfWeek(Calendar.MONDAY);
}
return result;
}
public static Object create(java.util.Date date, TimeZone initial, Calendar target, Class<?> type) {
if (type.equals(DataTypeManager.DefaultDataClasses.TIME)) {
return type.cast(createTime(date, initial, target));
}
if (type.equals(DataTypeManager.DefaultDataClasses.DATE)) {
return type.cast(createDate(date, initial, target));
}
return type.cast(createTimestamp(date, initial, target));
}
public static Timestamp createTimestamp(java.util.Date date, TimeZone initial, Calendar target) {
if (target == null) {
target = getCalendar();
}
long time = target.getTimeInMillis();
adjustCalendar(date, initial, target);
target.set(Calendar.MILLISECOND, 0);
Timestamp tsInTz = new Timestamp(target.getTimeInMillis());
if(date instanceof Timestamp) {
tsInTz.setNanos(((Timestamp)date).getNanos());
}
target.setTimeInMillis(time);
return tsInTz;
}
public static Time createTime(java.util.Date date, TimeZone initial, Calendar target) {
if (target == null) {
target = getCalendar();
}
long time = target.getTimeInMillis();
adjustCalendar(date, initial, target);
Time result = normalizeTime(date, target);
target.setTimeInMillis(time);
return result;
}
public static Date createDate(java.util.Date date, TimeZone initial, Calendar target) {
if (target == null) {
target = getCalendar();
}
long time = target.getTimeInMillis();
adjustCalendar(date, initial, target);
Date result = normalizeDate(date, target);
target.setTimeInMillis(time);
return result;
}
/**
* Creates normalized SQL Time Object
*
* @return Time
* @since 4.3
*/
public static Time createTime(java.util.Date date) {
if (date instanceof Time) {
return (Time)date;
}
Calendar cal = getCalendar();
cal.setTime(date);
return normalizeTime(date, cal);
}
/**
* Creates normalized SQL Date Object
*
* @return Date
* @since 4.3
*/
public static Date createDate(java.util.Date date) {
if (date instanceof Date) {
return (Date)date;
}
Calendar cal = getCalendar();
cal.setTime(date);
return normalizeDate(date, cal);
}
public static Timestamp createTimestamp(java.util.Date date) {
if (date instanceof Timestamp) {
return (Timestamp)date;
}
return new Timestamp(date.getTime());
}
private static Date normalizeDate(java.util.Date date, Calendar target) {
if (!(date instanceof Date)) {
target.set(Calendar.HOUR_OF_DAY, 0);
target.set(Calendar.MINUTE, 0);
target.set(Calendar.SECOND, 0);
target.set(Calendar.MILLISECOND, 0);
}
Date result = new Date(target.getTimeInMillis());
return result;
}
private static Time normalizeTime(java.util.Date date, Calendar target) {
if (!(date instanceof Time)) {
target.set(Calendar.YEAR, 1970);
target.set(Calendar.MONTH, Calendar.JANUARY);
target.set(Calendar.DAY_OF_MONTH, 1);
target.set(Calendar.MILLISECOND, 0);
}
Time result = new Time(target.getTimeInMillis());
return result;
}
private static void adjustCalendar(java.util.Date date,
TimeZone initial,
Calendar target) {
assert initial != null;
if (initial.hasSameRules(target.getTimeZone())) {
target.setTime(date);
return;
}
//start with base time
long time = date.getTime();
Calendar cal = Calendar.getInstance(initial);
cal.setTimeInMillis(time);
target.clear();
for (int i = 0; i <= Calendar.MILLISECOND; i++) {
target.set(i, cal.get(i));
}
}
}