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}