package kernel.test;
  

  import kernel.Cell;

  import kernel.Grid;
  import kernel.LanguageEnum;

  import kernel.exception.CreateCycleException;

  import kernel.exception.InvalidIntervalException;

  import kernel.function.Average;

  import kernel.function.Sum;
  import kernel.operation.Addition;

  import org.junit.Before;
  import org.junit.Test;

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

  import static org.junit.Assert.*;

  public class CellTest {

  	@Before
  	public void initData() {
  		Grid.language = LanguageEnum.EN;
  	}
  	
  	@Test
  	public void CreateCellValueTest() {
  		Cell A1 = new Cell("A", 1, 25.);
  		assertEquals(A1.getValue(), 25., 0);
  		assertFalse(A1.containFormula());
  		assertEquals(A1.getUsedIn().size(), 0);
  		assertEquals(A1.getId(), "A1");
  	}
  	
  	@Test
  	public void CreateCellBinaryOperationTest() throws CreateCycleException {
  		Cell A1 = new Cell("A", 1, 25.);
  		Cell A2 = new Cell("A", 2, 35.);
  		Cell A3 = new Cell("A", 3, new Addition(A1, A2));

  		assertEquals(A3.getValue(), 60., 0);
  		assertTrue(A3.containFormula());
  		assertEquals(A3.getUsedIn().size(), 0);
  		assertEquals(A3.getId(), "A3");

  		assertEquals(A3.toString(), "(A1+A2)");
  		assertEquals(A1.getUsedIn().size(), 1);
  		assertEquals(A2.getUsedIn().size(), 1);

  	}

  	@Test
  	public void CreateCellFunctionTest() throws CreateCycleException {
  		Cell A1 = new Cell("A", 1, 25.);
  		Cell A2 = new Cell("A", 2, 35.);
  		Cell A3 = new Cell("A", 3, new Addition(A1, A2));
  		Cell A5 = new Cell("A", 5, 45.);

  		List<Cell> sumList = new ArrayList<>();

  		sumList.add(A1);
  		sumList.add(A2);
  		sumList.add(A3);
  		sumList.add(A5);
  		Cell A4 = new Cell("A", 4, new Sum(sumList));

  		assertEquals(A4.getValue(), 165., 0);
  		assertTrue(A4.containFormula());
  		assertEquals(A4.getUsedIn().size(), 0);

  		assertEquals(A4.toString(), "SUM(A1,A2,A3,A5)");
  		assertEquals(A4.getDevelopedFormula(), "SUM(A1,A2,(A1+A2),A5)");
  		assertEquals(A1.getUsedIn().size(), 2);
  		assertEquals(A2.getUsedIn().size(), 2);
  		assertEquals(A3.getUsedIn().size(), 1);
  		assertEquals(A5.getUsedIn().size(), 1);

  	}

  	@Test
  	public void ModifyCellValueTest() throws CreateCycleException {
  		Cell A1 = new Cell("A", 1, 25.);
  		Cell A2 = new Cell("A", 2, 35.);
  		Cell A3 = new Cell("A", 3, new Addition(A1, A2));
  		assertEquals(A1.getValue(), 25., 0);
  		assertEquals(A2.getValue(), 35., 0);
  		assertEquals(A3.getValue(), 60., 0);

  		A1.setValue(45.);

  		assertEquals(A1.getValue(), 45., 0);
  		assertEquals(A3.getValue(), 80., 0);

  	}

  	
  	@Test
  	public void ModifyCellFormulaTest() throws CreateCycleException {
  		Cell A1 = new Cell("A", 1, 25.);
  		Cell A2 = new Cell("A", 2, 35.);
  		Cell A3 = new Cell("A", 3, new Addition(A1, A2));
  		Cell A5 = new Cell("A", 5, 45.);

  		List<Cell> sumList = new ArrayList<>();

  		sumList.add(A1);
  		sumList.add(A2);
  		sumList.add(A3);
  		sumList.add(A5);
  		Cell A4 = new Cell("A", 4, new Sum(sumList));

  		assertEquals(A4.getValue(), 165., 0);
  		assertTrue(A4.containFormula());
  		assertEquals(A4.getUsedIn().size(), 0);

  		assertEquals(A1.getUsedIn().size(), 2);
  		assertEquals(A2.getUsedIn().size(), 2);
  		assertEquals(A3.getUsedIn().size(), 1);
  		assertEquals(A5.getUsedIn().size(), 1);

  		assertFalse(A1.containFormula());
  		A1.setFormula(new Addition(A2, A5));
  		assertTrue(A1.containFormula());

  		assertEquals(A1.getValue(), 80., 0);
  		assertEquals(A3.getValue(), 115., 0);
  		assertEquals(A4.getValue(), 275., 0);

  		assertEquals(A1.toString(), "(A2+A5)");
  		assertEquals(A1.getDevelopedFormula(), "(A2+A5)");
  		assertEquals(A4.toString(), "SUM(A1,A2,A3,A5)");
  		assertEquals(A4.getDevelopedFormula(), "SUM((A2+A5),A2,((A2+A5)+A2),A5)");

  		assertEquals(A1.getUsedIn().size(), 2);
  		assertEquals(A2.getUsedIn().size(), 3);
  		assertEquals(A3.getUsedIn().size(), 1);
  		assertEquals(A5.getUsedIn().size(), 2);

  	}
  	

  	@Test(expected = CreateCycleException.class)
  	public void DirectCycleBynaryOperation() throws CreateCycleException {
  		Cell A1 = new Cell("A", 1, 25.);
  		Cell A2 = new Cell("A", 2, 35.);
  		A1.setFormula(new Addition(A1, A2));

  	}
  	
  	

  	@Test(expected = CreateCycleException.class)
  	public void DirectCycleFunction() throws CreateCycleException {
  		Cell A2 = new Cell("A", 2, 25.);
  		Cell B2 = new Cell("B", 2, 35.);
  		Cell A3 = new Cell("A", 3, 0.5);

  		List<Cell> sumList = new ArrayList<>();

  		sumList.add(A2);
  		sumList.add(B2);
  		sumList.add(A3);
  		
  		B2.setFormula(new Sum(sumList));

  	}
  	

  	@Test(expected = CreateCycleException.class)
  	public void IndirectCycle() throws CreateCycleException {
  		Cell A1 = new Cell("A", 1, 25.);
  		Cell A2 = new Cell("A", 2, 5.);
  		Cell B4 = new Cell("B", 4, new Addition(A1, A2));
  		Cell A4 = new Cell("A", 4, 0.);
  		Cell A3 = new Cell("A", 3, 0.5);
  		Cell B2 = new Cell("B", 2, 12.);

  		
  		List<Cell> sumList = new ArrayList<>();

  		sumList.add(A2);
  		sumList.add(B2);
  		sumList.add(A3);
  		Cell B6 = new Cell("B", 6, new Sum(sumList));
  		

  		List<Cell> averageList = new ArrayList<>();
  		averageList.add(B6);
  		averageList.add(B4);
  		averageList.add(A4);

  		Cell C6 = new Cell("C", 6, new Average(averageList));
  		
  		B2.setFormula(new Addition(A1, C6));

  	}

  }