1package io.protobase.f7.formulas.logic;
 2
 3import io.protobase.f7.errors.DivException;
 4import io.protobase.f7.errors.NAException;
 5import io.protobase.f7.errors.NumException;
 6import io.protobase.f7.errors.ValueException;
 7import io.protobase.f7.models.Grid;
 8import io.protobase.f7.testutils.TestFormula;
 9import org.junit.Test;
10
11import static com.google.common.truth.Truth.assertThat;
12import static org.mockito.Mockito.verify;
13import static org.mockito.Mockito.verifyNoMoreInteractions;
14import static org.mockito.Mockito.when;
15
16public class IFERRORTest extends TestFormula {
17  @Test
18  public void testApply() {
19    assertThat(IFERROR.SELF.apply(null, "Not error.", "Not returned.")).isEqualTo("Not error.");
20    assertThat(IFERROR.SELF.apply(null, 10.1, "Not returned.")).isEqualTo(10.1);
21    assertThat(IFERROR.SELF.apply(null, true, "Not returned.")).isEqualTo(true);
22    assertThat(IFERROR.SELF.apply(null, false, "Not returned.")).isEqualTo(false);
23    assertThat(IFERROR.SELF.apply(null, 99.1, new ValueException())).isEqualTo(99.1);
24  }
25
26  @Test
27  public void testApply_error() {
28    assertThat(IFERROR.SELF.apply(null, new DivException(), "Hello")).isEqualTo("Hello");
29    assertThat(IFERROR.SELF.apply(null, new NumException(), "Hello")).isEqualTo("Hello");
30    assertThat(IFERROR.SELF.apply(null, new ValueException(), 10.11)).isEqualTo(10.11);
31  }
32
33  @Test
34  public void test_lookup_first() {
35    IFERROR F = new IFERROR(lookup, collateralLookup);
36    when(collateralLookup.apply(A1, M22_RANGE)).thenReturn(2.0);
37    assertThat(F.apply(A1, M22_RANGE, G19_RANGE)).isEqualTo(2.0);
38    verify(collateralLookup).apply(A1, M22_RANGE);
39    verifyNoMoreInteractions(collateralLookup);
40  }
41
42  @Test
43  public void test_lookup_second() {
44    IFERROR F = new IFERROR(lookup, collateralLookup);
45    when(collateralLookup.apply(A1, M22_RANGE)).thenReturn(new DivException());
46    when(collateralLookup.apply(A1, G19_RANGE)).thenReturn(2.0);
47    assertThat(F.apply(A1, M22_RANGE, G19_RANGE)).isEqualTo(2.0);
48    verify(collateralLookup).apply(A1, M22_RANGE);
49    verify(collateralLookup).apply(A1, G19_RANGE);
50    verifyNoMoreInteractions(collateralLookup);
51  }
52
53  @Test
54  public void testApply_gird() {
55    Grid<Object> grid = Grid.builder()
56        .add(0, 0, new ValueException())
57        .add(0, 1, 1.0)
58        .add(0, 2, 2.0)
59        .add(0, 3, 3.0)
60        .build();
61    assertThat(IFERROR.SELF.apply(null, grid, "Yes error.")).isEqualTo("Yes error.");
62  }
63
64  @Test
65  public void test_errorFromArgumentsMismatch() {
66    assertThat(IFERROR.SELF.apply(null, 1.0)).isEqualTo(new NAException());
67    assertThat(IFERROR.SELF.apply(null, 1.0, 2.0, 3.0)).isEqualTo(new NAException());
68  }
69}