f7
f7 is a spreadsheet formula execution library
git clone https://git.vogt.world/f7.git
Log | Files | README.md | LICENSE.md
← All files
name: src/test/java/io/protobase/f7/formulas/statistical/MAXTest.java
-rw-r--r--
2207
 1package io.protobase.f7.formulas.statistical;
 2
 3import io.protobase.f7.errors.NAException;
 4import io.protobase.f7.errors.ValueException;
 5import io.protobase.f7.models.Grid;
 6import io.protobase.f7.testutils.TestFormula;
 7import org.junit.Test;
 8
 9import static com.google.common.truth.Truth.assertThat;
10import static org.mockito.Mockito.verify;
11import static org.mockito.Mockito.verifyNoMoreInteractions;
12import static org.mockito.Mockito.when;
13
14public class MAXTest extends TestFormula {
15  @Test
16  public void testApply_normal() {
17    assertThat(MAX.SELF.apply(null, 1.0, 2.0, 3.0)).isEqualTo(3.0);
18    assertThat(MAX.SELF.apply(null, 3.0, 1.0, 2.0)).isEqualTo(3.0);
19    assertThat(MAX.SELF.apply(null, 3.0, 2.0, 1.0)).isEqualTo(3.0);
20    assertThat(MAX.SELF.apply(null, 0.0)).isEqualTo(0.0);
21    assertThat(MAX.SELF.apply(null, 0.0, -1000.0, -0.0111)).isEqualTo(0.0);
22    assertThat(MAX.SELF.apply(null, 261822.0, 991741987.1, 1991.0e2)).isEqualTo(991741987.1);
23  }
24
25  @Test
26  public void testApply_numberLike() {
27    assertThat(MAX.SELF.apply(null, 1.0, 2.0, "3.0")).isEqualTo(3.0);
28    assertThat(MAX.SELF.apply(null, -1.0, -2.0, true)).isEqualTo(1.0);
29    assertThat(MAX.SELF.apply(null, -1.0, -2.0, false)).isEqualTo(0.0);
30  }
31
32  @Test
33  public void testApply_grid() {
34    assertThat(MAX.SELF.apply(null, Grid.builder().add(0, 0, 1.0).add(0, 1, "Bad").build(), 44.0)).isEqualTo(44.0);
35  }
36
37  @Test
38  public void test_lookup() {
39    Grid grid = Grid.builder()
40        .add(0, 0, 1.0)
41        .add(0, 1, 2.0)
42        .add(0, 2, 3.0)
43        .add(0, 3, 4.0)
44        .add(0, 4, 5.0)
45        .build();
46    MAX F = new MAX(lookup, collateralLookup);
47    when(lookup.apply(D1_TO_D5_RANGE)).thenReturn(grid);
48    assertThat(F.apply(A1, D1_TO_D5_RANGE)).isEqualTo(5.0);
49    verify(lookup).apply(D1_TO_D5_RANGE);
50    verifyNoMoreInteractions(lookup);
51  }
52
53  @Test
54  public void testApply_nonCoercableValuesInGridShouldBeIgnoreButNotInArgs() {
55    assertThat(MAX.SELF.apply(null, Grid.builder().add(0, 0, 1.0).add(0, 1, "Bad").build(), "Bad")).isEqualTo(new ValueException());
56  }
57
58  @Test
59  public void testApply_errorFromArgumentsMismatch() {
60    assertThat(MAX.SELF.apply(null)).isEqualTo(new NAException());
61  }
62}