tests/org.eclipse.epsilon.emc.spreadsheets.test/src/org/eclipse/epsilon/emc/spreadsheets/delete/DeleteReferencedRowTest.java

/*********************************************************************
* Copyright (c) 2008 The University of York.
*
* This program and the accompanying materials are made
* available under the terms of the Eclipse Public License 2.0
* which is available at https://www.eclipse.org/legal/epl-2.0/
*
* SPDX-License-Identifier: EPL-2.0
**********************************************************************/
package org.eclipse.epsilon.emc.spreadsheets.delete;

import static org.junit.Assert.assertTrue;

import java.util.Collection;

import org.eclipse.epsilon.emc.spreadsheets.SpreadsheetColumn;
import org.eclipse.epsilon.emc.spreadsheets.SpreadsheetModel;
import org.eclipse.epsilon.emc.spreadsheets.SpreadsheetRow;
import org.eclipse.epsilon.emc.spreadsheets.test.SharedTestMethods;
import org.eclipse.epsilon.emc.spreadsheets.test.TestModelFactory;
import org.junit.Test;
import org.junit.runner.RunWith;
import org.junit.runners.Parameterized;

@RunWith(Parameterized.class)
public class DeleteReferencedRowTest {
	private SpreadsheetModel model = null;

	public DeleteReferencedRowTest(SpreadsheetModel model) {
		this.model = model;
	}

	@Parameterized.Parameters
	public static Collection<Object[]> models() throws Exception {
		String pathToFile = "resources/delete/DeleteRowTest.xlsx";
		String pathToConfig = "resources/delete/DeleteRowTestConfig.xml";
		return TestModelFactory.getModelsToTest("", pathToFile, pathToConfig, "DeleteRowTest");
	}

	@Test
	public void testDeleteReferencedRow() throws Exception {
		SharedTestMethods.clearWorksheet(model, "Sheet1");
		SharedTestMethods.clearWorksheet(model, "Sheet2");

		String col = "c_2";

		SpreadsheetColumn columnSheet1 = model.getWorksheetByType("Sheet1").getColumn(col);
		SpreadsheetColumn columnSheet2 = model.getWorksheetByType("Sheet2").getColumn(col);
		SpreadsheetColumn sheet1column0 = model.getWorksheetByType("Sheet1").getColumn("c_1");
		SpreadsheetColumn sheet2column0 = model.getWorksheetByType("Sheet2").getColumn("c_1");

		SpreadsheetRow rowSheet2_req1 = SharedTestMethods.writeRow(model, "Sheet2", "c_1", "1", col, "REQ1");
		SpreadsheetRow rowSheet2_req2 = SharedTestMethods.writeRow(model, "Sheet2", "c_1", "2", col, "REQ2");
		SpreadsheetRow rowSheet2_req3 = SharedTestMethods.writeRow(model, "Sheet2", "c_1", "3", col, "REQ1");
		assertTrue(model.getAllOfKind("Sheet2").size() == 3);

		SharedTestMethods.writeRow(model, "Sheet1", "c_1", "1", col, rowSheet2_req1);
		SharedTestMethods.writeRow(model, "Sheet1", "c_1", "2", col, rowSheet2_req2);
		SharedTestMethods.writeRow(model, "Sheet1", "c_1", "3", col, rowSheet2_req3);
		assertTrue(model.getAllOfKind("Sheet1").size() == 3);

		model.deleteElement(rowSheet2_req1);
		assertTrue(model.getAllOfKind("Sheet2").size() == 2);
		assertTrue(model.getAllOfType("Sheet2").get(0).getVisibleCellValue(columnSheet2).equals("REQ2"));
		assertTrue(model.getAllOfType("Sheet2").get(0).getVisibleCellValue(sheet2column0).equals("2"));
		assertTrue(model.getAllOfType("Sheet2").get(1).getVisibleCellValue(columnSheet2).equals("REQ1"));
		assertTrue(model.getAllOfType("Sheet2").get(1).getVisibleCellValue(sheet2column0).equals("3"));
		assertTrue(model.getAllOfKind("Sheet1").size() == 3);
		assertTrue(model.getAllOfType("Sheet1").get(0).getVisibleCellValue(columnSheet1).equals("REQ1"));
		assertTrue(model.getAllOfType("Sheet1").get(0).getVisibleCellValue(sheet1column0).equals("1"));
		assertTrue(model.getAllOfType("Sheet1").get(1).getVisibleCellValue(columnSheet1).equals("REQ2"));
		assertTrue(model.getAllOfType("Sheet1").get(1).getVisibleCellValue(sheet1column0).equals("2"));
		assertTrue(model.getAllOfType("Sheet1").get(2).getVisibleCellValue(columnSheet1).equals("REQ1"));
		assertTrue(model.getAllOfType("Sheet1").get(2).getVisibleCellValue(sheet1column0).equals("3"));

		model.deleteElement(rowSheet2_req3);
		assertTrue(model.getAllOfKind("Sheet2").size() == 1);
		assertTrue(model.getAllOfType("Sheet2").get(0).getVisibleCellValue(columnSheet2).equals("REQ2"));
		assertTrue(model.getAllOfType("Sheet2").get(0).getVisibleCellValue(sheet2column0).equals("2"));
		assertTrue(model.getAllOfKind("Sheet1").size() == 3);
		String value = model.getAllOfType("Sheet1").get(0).getVisibleCellValue(columnSheet1);
		System.err.println("Value = '" + value + "'");
		assertTrue(value.equals(""));
		assertTrue(model.getAllOfType("Sheet1").get(0).getVisibleCellValue(sheet1column0).equals("1"));
		assertTrue(model.getAllOfType("Sheet1").get(1).getVisibleCellValue(columnSheet1).equals("REQ2"));
		assertTrue(model.getAllOfType("Sheet1").get(1).getVisibleCellValue(sheet1column0).equals("2"));
		assertTrue(model.getAllOfType("Sheet1").get(2).getVisibleCellValue(columnSheet1).equals(""));
		assertTrue(model.getAllOfType("Sheet1").get(2).getVisibleCellValue(sheet1column0).equals("3"));

		model.deleteElement(rowSheet2_req2);
		assertTrue(model.getAllOfKind("Sheet2").size() == 0);
		assertTrue(model.getAllOfKind("Sheet1").size() == 3);
		assertTrue(model.getAllOfType("Sheet1").get(0).getVisibleCellValue(columnSheet1).equals(""));
		assertTrue(model.getAllOfType("Sheet1").get(0).getVisibleCellValue(sheet1column0).equals("1"));
		assertTrue(model.getAllOfType("Sheet1").get(1).getVisibleCellValue(columnSheet1).equals(""));
		assertTrue(model.getAllOfType("Sheet1").get(1).getVisibleCellValue(sheet1column0).equals("2"));
		assertTrue(model.getAllOfType("Sheet1").get(2).getVisibleCellValue(columnSheet1).equals(""));
		assertTrue(model.getAllOfType("Sheet1").get(2).getVisibleCellValue(sheet1column0).equals("3"));
	}
}