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/info/ISNATest.java
-rw-r--r--
2753
 1package io.protobase.f7.formulas.info;
 2
 3import io.protobase.f7.errors.DivException;
 4import io.protobase.f7.errors.NAException;
 5import io.protobase.f7.errors.NameException;
 6import io.protobase.f7.errors.NullException;
 7import io.protobase.f7.errors.NumException;
 8import io.protobase.f7.errors.ParseException;
 9import io.protobase.f7.errors.RefException;
10import io.protobase.f7.errors.ValueException;
11import io.protobase.f7.models.Grid;
12import io.protobase.f7.testutils.TestFormula;
13import org.junit.Test;
14
15import static com.google.common.truth.Truth.assertThat;
16import static org.mockito.Mockito.verify;
17import static org.mockito.Mockito.verifyNoMoreInteractions;
18import static org.mockito.Mockito.when;
19
20public class ISNATest extends TestFormula {
21  @Test
22  public void test_number() {
23    assertThat(ISNA.SELF.apply(null, 10.0)).isEqualTo(false);
24  }
25
26  @Test
27  public void test_string() {
28    assertThat(ISNA.SELF.apply(null, "String")).isEqualTo(false);
29  }
30
31  @Test
32  public void test_boolean() {
33    assertThat(ISNA.SELF.apply(null, true)).isEqualTo(false);
34    assertThat(ISNA.SELF.apply(null, false)).isEqualTo(false);
35  }
36
37  @Test
38  public void test_error() {
39    assertThat(ISNA.SELF.apply(null, new NullException())).isEqualTo(false);
40    assertThat(ISNA.SELF.apply(null, new DivException())).isEqualTo(false);
41    assertThat(ISNA.SELF.apply(null, new ValueException())).isEqualTo(false);
42    assertThat(ISNA.SELF.apply(null, new RefException())).isEqualTo(false);
43    assertThat(ISNA.SELF.apply(null, new NameException())).isEqualTo(false);
44    assertThat(ISNA.SELF.apply(null, new NumException())).isEqualTo(false);
45    assertThat(ISNA.SELF.apply(null, new NAException())).isEqualTo(true);
46    assertThat(ISNA.SELF.apply(null, new ParseException())).isEqualTo(false);
47  }
48
49  @Test
50  public void test_lookup() {
51    ISNA F = new ISNA(lookup, collateralLookup);
52    when(collateralLookup.apply(A1, M22_RANGE)).thenReturn(new NAException());
53    assertThat(F.apply(A1, M22_RANGE)).isEqualTo(true);
54    verify(collateralLookup).apply(A1, M22_RANGE);
55    verifyNoMoreInteractions(collateralLookup);
56  }
57
58  @Test
59  public void test_grid() {
60    assertThat(ISNA.SELF.apply(null, Grid.builder().add(0, 0, "Still no.").build())).isEqualTo(false);
61    assertThat(ISNA.SELF.apply(null, Grid.builder().add(0, 0, new NAException()).build())).isEqualTo(true);
62    assertThat(ISNA.SELF.apply(null, Grid.builder()
63        .add(0, 0, new NAException())
64        .add(0, 1, "Previous one is, this isn't.")
65        .build())).isEqualTo(true);
66  }
67
68  @Test
69  public void testApply_errorFromArgumentsMismatch() {
70    assertThat(ISNA.SELF.apply(null)).isEqualTo(new NAException());
71    assertThat(ISNA.SELF.apply(null, "A", "B")).isEqualTo(new NAException());
72  }
73}