1package io.protobase.f7.formulas.statistical;
 2
 3import io.protobase.f7.errors.NAException;
 4import io.protobase.f7.models.Grid;
 5import io.protobase.f7.testutils.TestFormula;
 6import org.junit.Test;
 7
 8import static com.google.common.truth.Truth.assertThat;
 9import static org.mockito.Mockito.verify;
10import static org.mockito.Mockito.verifyNoMoreInteractions;
11import static org.mockito.Mockito.when;
12
13public class COUNTBLANKTest extends TestFormula {
14  @Test
15  public void testApply_nonGrid() {
16    assertThat(COUNTBLANK.SELF.apply(null, 1.0, 2.0, true, false, "String")).isEqualTo(0.0);
17  }
18
19  @Test
20  public void testApply_grid() {
21    assertThat(COUNTBLANK.SELF.apply(null,
22        Grid.builder()
23            .add(0, 0, null)
24            .add(0, 1, null)
25            .add(0, 2, null)
26            .add(0, 3, null)
27            .add(0, 4, null)
28            .add(0, 5, null)
29            .add(0, 6, null)
30            .build()
31    )).isEqualTo(7.0);
32    assertThat(COUNTBLANK.SELF.apply(null,
33        Grid.builder()
34            .add(0, 0, null)
35            .add(0, 1, null)
36            .add(0, 2, null)
37            .add(0, 3, 22.1)
38            .add(0, 4, null)
39            .add(0, 5, true)
40            .add(0, 6, "Filled")
41            .build()
42    )).isEqualTo(4.0);
43    assertThat(COUNTBLANK.SELF.apply(null, Grid.builder().add(0, 0, 1.0).build())).isEqualTo(0.0);
44  }
45
46  @Test
47  public void test_lookup() {
48    Grid grid = Grid.builder()
49        .add(0, 0, null)
50        .add(0, 1, 2.0)
51        .add(0, 2, null)
52        .add(0, 3, 4.0)
53        .add(0, 4, null)
54        .build();
55    COUNTBLANK F = new COUNTBLANK(lookup, collateralLookup);
56    when(lookup.apply(D1_TO_D5_RANGE)).thenReturn(grid);
57    assertThat(F.apply(A1, D1_TO_D5_RANGE)).isEqualTo(3.0);
58    verify(lookup).apply(D1_TO_D5_RANGE);
59    verifyNoMoreInteractions(lookup);
60  }
61
62  @Test
63  public void testApply_errorFromArgumentsMismatch() {
64    assertThat(COUNTBLANK.SELF.apply(null)).isEqualTo(new NAException());
65  }
66}