taverna-spreadsheet-import-activity/src/test/java/net/sf/taverna/t2/activities/spreadsheet/SpreadsheetUtilsTest.java

/*******************************************************************************
 * Copyright (C) 2009 The University of Manchester
 *
 *  Modifications to the initial code base are copyright of their
 *  respective authors, or their employers as appropriate.
 *
 *  This program 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 2.1 of
 *  the License, or (at your option) any later version.
 *
 *  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.
 *
 *  You should have received a copy of the GNU Lesser General Public
 *  License along with this program; if not, write to the Free Software
 *  Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307
 ******************************************************************************/
package net.sf.taverna.t2.activities.spreadsheet;

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

import org.junit.Test;

import com.fasterxml.jackson.databind.node.ArrayNode;
import com.fasterxml.jackson.databind.node.JsonNodeFactory;
import com.fasterxml.jackson.databind.node.ObjectNode;

/**
 * Unit tests for {@link net.sf.taverna.t2.activities.spreadsheet.SpreadsheetUtils}.
 *
 * @author David Withers
 */
public class SpreadsheetUtilsTest {

	@Test
	public void testSpreadsheetUtils() {
		assertNotNull(new SpreadsheetUtils());
	}

	/**
	 * Test method for {@link net.sf.taverna.t2.activities.spreadsheet.SpreadsheetUtils#getColumnIndex(java.lang.String)}.
	 */
	@Test
	public void testGetColumnIndex() {
		assertEquals(0, SpreadsheetUtils.getColumnIndex("A"));
		assertEquals(4, SpreadsheetUtils.getColumnIndex("E"));
		assertEquals(25, SpreadsheetUtils.getColumnIndex("Z"));
		assertEquals(26, SpreadsheetUtils.getColumnIndex("AA"));
		assertEquals(457833, SpreadsheetUtils.getColumnIndex("ZAFZ"));
	}

	/**
	 * Test method for {@link net.sf.taverna.t2.activities.spreadsheet.SpreadsheetUtils#getColumnLabel(int)}.
	 */
	@Test
	public void testGetColumnLabel() {
		assertEquals("A", SpreadsheetUtils.getColumnLabel(0));
		assertEquals("E", SpreadsheetUtils.getColumnLabel(4));
		assertEquals("Z", SpreadsheetUtils.getColumnLabel(25));
		assertEquals("AA", SpreadsheetUtils.getColumnLabel(26));
		assertEquals("ZAFZ", SpreadsheetUtils.getColumnLabel(457833));
	}

	/**
	 * Test method for {@link net.sf.taverna.t2.activities.spreadsheet.SpreadsheetUtils#getPortName(java.lang.String, java.util.Map)}.
	 */
	@Test
	public void testGetPortNameStringMapOfStringString() {
		assertEquals("A", SpreadsheetUtils.getPortName("A", null));
		assertEquals("AABR", SpreadsheetUtils.getPortName("AABR", null));
		ObjectNode configuration = JsonNodeFactory.instance.objectNode();
		ArrayNode columnNames = configuration.arrayNode();
		columnNames.addObject().put("column", "B").put("port", "beta");
		configuration.put("columnNames", columnNames);
		assertEquals("beta", SpreadsheetUtils.getPortName("B", configuration));
		assertEquals("T", SpreadsheetUtils.getPortName("T", configuration));
	}

	/**
	 * Test method for {@link net.sf.taverna.t2.activities.spreadsheet.SpreadsheetUtils#getPortName(int, java.util.Map)}.
	 */
	@Test
	public void testGetPortNameIntMapOfStringString() {
		assertEquals("A", SpreadsheetUtils.getPortName(0, null));
		assertEquals("AA", SpreadsheetUtils.getPortName(26, null));
		ObjectNode configuration = JsonNodeFactory.instance.objectNode();
		ArrayNode columnNames = configuration.arrayNode();
		columnNames.addObject().put("column", "D").put("port", "delta");
		configuration.put("columnNames", columnNames);
		assertEquals("delta", SpreadsheetUtils.getPortName(3, configuration));
		assertEquals("AB", SpreadsheetUtils.getPortName(27, configuration));
	}

}