/**
* Copyright (C) 2008-2010, Squale Project - http://www.squale.org
*
* This file is part of Squale.
*
* Squale 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 3 of the
* License, or any later version.
*
* Squale 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 Lesser General Public License
* along with Squale. If not, see <http://www.gnu.org/licenses/>.
*/
package org.squale.squalecommon.util.database;
import java.text.SimpleDateFormat;
import java.util.Date;
/**
* Implementation of DatabaseType for hsqldb
*/
public class HsqldbType
implements DatabaseType
{
/**
* {@inheritDoc}
*/
public String dateAddDay( String date, String day )
{
StringBuffer query = new StringBuffer( " DATEDIFF( 'dd' ," );
query.append( date );
query.append( " , " );
query.append( toDate( new Date() ) );
query.append( " ) " );
query.append( " > " );
query.append( day );
query.append( " " );
return query.toString();
}
/**
* {@inheritDoc}
*/
public String toDate( Date date )
{
SimpleDateFormat dateFormat = new SimpleDateFormat( "yyyy-MM-dd HH:mm:ss" );
String dateString = dateFormat.format( date );
StringBuffer query = new StringBuffer( "'" );
query.append( dateString );
query.append( "' " );
return query.toString();
}
}