TimestampTypeFormatter.java
/*
* GovWay - A customizable API Gateway
* https://govway.org
*
* Copyright (c) 2005-2024 Link.it srl (https://link.it).
*
* This program is free software: you can redistribute it and/or modify
* it under the terms of the GNU General Public License version 3, as published by
* the Free Software Foundation.
*
* This program 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 for more details.
*
* You should have received a copy of the GNU General Public License
* along with this program. If not, see <http://www.gnu.org/licenses/>.
*
*/
package org.openspcoop2.generic_project.expression.impl.formatter;
import java.text.SimpleDateFormat;
import java.util.Date;
import java.sql.Timestamp;
import org.openspcoop2.generic_project.exception.ExpressionException;
import org.openspcoop2.utils.TipiDatabase;
import org.openspcoop2.utils.date.DateUtils;
import org.openspcoop2.utils.sql.ISQLQueryObject;
import org.openspcoop2.utils.sql.SQLObjectFactory;
/**
* TimestampTypeFormatter
*
* @author Poli Andrea (apoli@link.it)
* @author $Author$
* @version $Rev$, $Date$
*/
public class TimestampTypeFormatter implements ITypeFormatter<Timestamp> {
private SimpleDateFormat dateformat = DateUtils.getDefaultDateTimeFormatter("yyyy-MM-dd HH:mm:ss.SSS");
@Override
public String toString(Timestamp o) throws ExpressionException {
if(o == null){
throw new ExpressionException("Object parameter is null");
}
return this.dateformat.format(o);
}
@Override
public String toSQLString(Timestamp o) throws ExpressionException {
return this.toSQLString(o, TipiDatabase.DEFAULT);
}
@Override
public String toSQLString(Timestamp o, TipiDatabase databaseType) throws ExpressionException {
return TimestampTypeFormatter.toSQLString(o, o, databaseType, this);
}
public static <T> String toSQLString(T rawDate, Date date, TipiDatabase databaseType, ITypeFormatter<T> formatter) throws ExpressionException {
if(databaseType!=null) {
switch (databaseType) {
case POSTGRESQL:
case ORACLE:
case MYSQL:
case HSQL:
case SQLSERVER:
case DB2:
case DERBY:
try {
ISQLQueryObject sqlQueryObjectCore = SQLObjectFactory.createSQLQueryObject(databaseType);
return sqlQueryObjectCore.getSelectTimestampConstantField(date);
}catch(Exception e) {
throw new ExpressionException(e.getMessage(),e);
}
case DEFAULT:
return "'"+formatter.toString(rawDate)+"'";
}
}
return "'"+formatter.toString(rawDate)+"'";
}
@Override
public Timestamp toObject(String o, Class<?> c) throws ExpressionException {
if(o == null){
throw new ExpressionException("Object parameter is null");
}
try{
return new Timestamp(this.dateformat.parse(o).getTime());
}catch(Exception e){
throw new ExpressionException("Conversion failure: "+e.getMessage(),e);
}
}
@Override
public Class<Timestamp> getTypeSupported() {
return Timestamp.class;
}
}