/*
* Copyright (c) 2013, OpenCloudDB/MyCAT and/or its affiliates. All rights reserved.
* DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER.
*
* This code is free software;Designed and Developed mainly by many Chinese
* opensource volunteers. you can redistribute it and/or modify it under the
* terms of the GNU General Public License version 2 only, as published by the
* Free Software Foundation.
*
* This code 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 General Public License
* version 2 for more details (a copy is included in the LICENSE file that
* accompanied this code).
*
* You should have received a copy of the GNU General Public License version
* 2 along with this work; if not, write to the Free Software Foundation,
* Inc., 51 Franklin St, Fifth Floor, Boston, MA 02110-1301 USA.
*
* Any questions about this component can be directed to it's project Web address
* https://code.google.com/p/opencloudb/.
*
*/
package com.akiban.sql.compiler;
import com.akiban.sql.parser.*;
import com.akiban.sql.StandardException;
import com.akiban.sql.types.DataTypeDescriptor;
import com.akiban.sql.types.TypeId;
import java.sql.Types;
public class TimeTypeCompiler extends TypeCompiler
{
protected TimeTypeCompiler(TypeId typeId) {
super(typeId);
}
/**
* User types are convertible to other user types only if
* (for now) they are the same type and are being used to
* implement some JDBC type. This is sufficient for
* date/time types; it may be generalized later for e.g.
* comparison of any user type with one of its subtypes.
*
* @see TypeCompiler#convertible
*/
public boolean convertible(TypeId otherType, boolean forDataTypeFunction) {
if (otherType.isStringTypeId() &&
(!otherType.isLOBTypeId()) &&
!otherType.isLongVarcharTypeId()) {
return true;
}
// If same type, convert always ok.
return (getStoredFormatIdFromTypeId() == otherType.getTypeFormatId());
}
/** @see TypeCompiler#compatible */
public boolean compatible(TypeId otherType) {
return convertible(otherType, false);
}
/**
* @see TypeCompiler#getCorrespondingPrimitiveTypeName
*/
public String getCorrespondingPrimitiveTypeName() {
return "java.sql.Time";
}
/**
* Get the method name for getting out the corresponding primitive
* Java type.
*
* @return String The method call name for getting the
* corresponding primitive Java type.
*/
public String getPrimitiveMethodName() {
return "getTime";
}
/**
* @see TypeCompiler#getCastToCharWidth
*/
public int getCastToCharWidth(DataTypeDescriptor dts) {
return TypeId.TIME_MAXWIDTH;
}
/**
* @see TypeCompiler#resolveArithmeticOperation
*
* @exception StandardException Thrown on error
*/
public DataTypeDescriptor resolveArithmeticOperation(DataTypeDescriptor leftType,
DataTypeDescriptor rightType,
String operator)
throws StandardException {
TypeId rightTypeId = rightType.getTypeId();
boolean nullable = leftType.isNullable() || rightType.isNullable();
if (rightTypeId.isDateTimeTimeStampTypeId()) {
if (operator.equals(TypeCompiler.MINUS_OP)) {
switch (rightTypeId.getTypeFormatId()) {
case TypeId.FormatIds.TIME_TYPE_ID:
// TIME - TIME is INTERVAL HOUR TO SECOND
return new DataTypeDescriptor(TypeId.INTERVAL_HOUR_SECOND_ID, nullable);
}
// TIME - other datetime is INTERVAL DAY TO SECOND
return new DataTypeDescriptor(TypeId.INTERVAL_DAY_SECOND_ID, nullable);
}
}
else if (rightTypeId.isIntervalTypeId()) {
if (operator.equals(TypeCompiler.PLUS_OP) ||
operator.equals(TypeCompiler.MINUS_OP)) {
switch (rightTypeId.getTypeFormatId()) {
case TypeId.FormatIds.INTERVAL_DAY_SECOND_ID:
if ((rightTypeId == TypeId.INTERVAL_HOUR_ID) ||
(rightTypeId == TypeId.INTERVAL_MINUTE_ID) ||
(rightTypeId == TypeId.INTERVAL_SECOND_ID) ||
(rightTypeId == TypeId.INTERVAL_HOUR_MINUTE_ID) ||
(rightTypeId == TypeId.INTERVAL_HOUR_SECOND_ID) ||
(rightTypeId == TypeId.INTERVAL_MINUTE_SECOND_ID))
// TIME +/- sub day interval is TIME
return leftType.getNullabilityType(nullable);
}
// TIME +/- other interval is TIMESTAMP
return new DataTypeDescriptor(TypeId.TIMESTAMP_ID, nullable);
}
}
// Unsupported
return super.resolveArithmeticOperation(leftType, rightType, operator);
}
}