SQLHelperTest.java

/////////////////////////////////////////////////////////////////////////////
//
// Project ProjectForge Community Edition
//         www.projectforge.org
//
// Copyright (C) 2001-2014 Kai Reinhard (k.reinhard@micromata.de)
//
// ProjectForge is dual-licensed.
//
// This community edition is free software; you can redistribute it and/or
// modify it under the terms of the GNU General Public License as published
// by the Free Software Foundation; version 3 of the License.
//
// This community edition 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.projectforge.database;

import static org.junit.Assert.assertEquals;
import static org.junit.Assert.fail;

import java.util.ArrayList;
import java.util.Calendar;
import java.util.List;

import org.junit.Test;


public class SQLHelperTest
{
  @Test
  public void getYears()
  {
    try {
      SQLHelper.getYears(null);
      fail("Validate exception should be thrown.");
    } catch (IllegalArgumentException ex) {
      // OK
    } catch (Throwable ex) {
      fail("Unexpected exception was thrown: " + ex.getMessage());
    }
    List<Object[]> list = new ArrayList<Object[]>();
    int[] years = SQLHelper.getYears(list);
    assertEquals(1, years.length);
    assertEquals(Calendar.getInstance().get(Calendar.YEAR), years[0]);
    java.sql.Date[] tupel = new java.sql.Date[2];
    list.add(tupel);
    tupel[0] = createDate(2008);
    tupel[1] = createDate(2008);
    years = SQLHelper.getYears(list);
    assertEquals(1, years.length);
    assertEquals(2008, years[0]);
    tupel[0] = createDate(2001);
    years = SQLHelper.getYears(list);
    assertEquals(8, years.length);
    assertEquals(2008, years[0]);
    assertEquals(2007, years[1]);
    assertEquals(2001, years[7]);
  }

  private java.sql.Date createDate(int year)
  {
    Calendar cal = Calendar.getInstance();
    cal.set(Calendar.YEAR, year);
    return new java.sql.Date(cal.getTimeInMillis());
  }
}