/**
* 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 MySQL
*/
public class MySQLType
implements DatabaseType
{
/**
* {@inheritDoc}
*/
public String toDate( Date date )
{
SimpleDateFormat sdf = new SimpleDateFormat( JAVADATEPATTERN );
String dateString = sdf.format( date );
StringBuffer query = new StringBuffer( " str_to_date( '" );
query.append( dateString );
query.append( "' , '%d/%m/%Y %T') " );
return query.toString();
}
/**
* {@inheritDoc}
*/
public String dateAddDay( String date, String day )
{
StringBuffer query = new StringBuffer( " ADDDATE(" );
query.append( date );
query.append( " ," );
query.append( day );
query.append( " ) " );
query.append( " < " );
query.append( toDate( new Date() ) );
query.append( " " );
return query.toString();
}
}