/*
* This program is free software; you can redistribute it and/or modify it under the
* terms of the GNU Lesser General Public License, version 2.1 as published by the Free Software
* Foundation.
*
* You should have received a copy of the GNU Lesser General Public License along with this
* program; if not, you can obtain a copy at http://www.gnu.org/licenses/old-licenses/lgpl-2.1.html
* or from the Free Software Foundation, Inc.,
* 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA.
*
* 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 Lesser General Public License for more details.
*
* Copyright (c) 2006 - 2017 Pentaho Corporation and Contributors. All rights reserved.
*/
package org.pentaho.reporting.libraries.formula.function.datetime;
import org.pentaho.reporting.libraries.formula.Formula;
import org.pentaho.reporting.libraries.formula.FormulaTestBase;
import java.math.BigDecimal;
import java.text.DateFormat;
import java.text.SimpleDateFormat;
import java.util.Date;
import java.util.GregorianCalendar;
import java.util.TimeZone;
/**
* @author Cedric Pronzato
*/
public class DateFunctionTest extends FormulaTestBase {
private TimeZone defaultTz;
@Override protected void setUp() throws Exception {
super.setUp();
defaultTz = TimeZone.getDefault();
TimeZone.setDefault( TimeZone.getTimeZone( "UTC" ) );
}
@Override protected void tearDown() throws Exception {
super.tearDown();
TimeZone.setDefault( defaultTz );
}
public Object[][] createDataTest() {
return new Object[][]
{
{ "DATE(2005;1;31)=[.C7]", Boolean.TRUE },
{ "DATE(2005;12;31)-DATE(1904;1;1)", new BigDecimal( 37255 ) },
{ "DATE(2004;2;29)=DATE(2004;2;28)+1", Boolean.TRUE },
{ "DATE(2000;2;29)=DATE(2000;2;28)+1", Boolean.TRUE },
{ "DATE(2005;3;1)=DATE(2005;2;28)+1", Boolean.TRUE },
{ "DATE(2017.5; 1;2)=DATE(2017; 1; 2)", Boolean.TRUE },
{ "DATE(2006; 2.5;3)=DATE(2006; 2; 3)", Boolean.TRUE },
{ "DATE(2006; 1;3.5)=DATE(2006; 1; 3)", Boolean.TRUE },
{ "DATE(2006; 13; 3)=DATE(2007;1; 3)", Boolean.TRUE },
{ "DATE(2006; 1; 32)=DATE(2006;2; 1)", Boolean.TRUE },
{ "DATE(2006; 25;34)=DATE(2008;2;3)", Boolean.TRUE },
{ "DATE(2006;-1;1)=DATE(2005;11;1)", Boolean.TRUE },
{ "DATE(2006;4;-1)=DATE(2006;3;30)", Boolean.TRUE },
{ "DATE(2006;-4;-1)=DATE(2005;7;30)", Boolean.TRUE },
{ "DATE(2003;2;29)=DATE(2003;3;1)", Boolean.TRUE },
};
}
public void testDebugDates() throws Exception {
Formula formula = null;
formula = new Formula( "DATE(2005;1;31)" );
formula.initialize( getContext() );
Date eval = (Date) formula.evaluate();
final DateFormat df = new SimpleDateFormat( "yyyy-MM-dd'T'HH:mm:ss.SSSZ" );
System.out.println( eval.getClass().getName() + ":" + df.format( eval ) + ";" + eval.getTime() );
final Date date = (Date) getContext().resolveReference( ".C7" );
System.out.println( df.format( date ) + ";" + date.getTime() );
assertEquals( date, eval );
}
public void testGregorianCalendar() {
final Date d1 = new GregorianCalendar( 2006, -1, 1 ).getTime();
final Date d2 = new GregorianCalendar( 2005, 11, 1 ).getTime();
assertEquals( d1, d2 );
}
public void testDefault() throws Exception {
runDefaultTest();
}
}