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/ISNONTEXTTest.java
-rw-r--r--
2295
 1package io.protobase.f7.formulas.info;
 2
 3import io.protobase.f7.errors.DivException;
 4import io.protobase.f7.errors.NAException;
 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 ISNONTEXTTest extends TestFormula {
15  @Test
16  public void test_number() {
17    assertThat(ISNONTEXT.SELF.apply(null, 10.0)).isEqualTo(true);
18  }
19
20  @Test
21  public void test_string() {
22    assertThat(ISNONTEXT.SELF.apply(null, "String")).isEqualTo(false);
23  }
24
25  @Test
26  public void test_boolean() {
27    assertThat(ISNONTEXT.SELF.apply(null, true)).isEqualTo(true);
28    assertThat(ISNONTEXT.SELF.apply(null, false)).isEqualTo(true);
29  }
30
31  @Test
32  public void test_error() {
33    assertThat(ISNONTEXT.SELF.apply(null, new NAException())).isEqualTo(true);
34    assertThat(ISNONTEXT.SELF.apply(null, new DivException())).isEqualTo(true);
35  }
36
37  @Test
38  public void test_lookup() {
39    ISNONTEXT F = new ISNONTEXT(lookup, collateralLookup);
40    when(collateralLookup.apply(A1, M22_RANGE)).thenReturn(100.0);
41    assertThat(F.apply(A1, M22_RANGE)).isEqualTo(true);
42    verify(collateralLookup).apply(A1, M22_RANGE);
43    verifyNoMoreInteractions(collateralLookup);
44  }
45
46  @Test
47  public void test_grid() {
48    assertThat(ISNONTEXT.SELF.apply(null, Grid.builder().add(0, 0, "Yes").build())).isEqualTo(false);
49    assertThat(ISNONTEXT.SELF.apply(null, Grid.builder().add(0, 0, 22000.000).build())).isEqualTo(true);
50    assertThat(ISNONTEXT.SELF.apply(null, Grid.builder().add(0, 0, true).build())).isEqualTo(true);
51    assertThat(ISNONTEXT.SELF.apply(null,
52        Grid.builder()
53            .add(0, 0, true)
54            .add(0, 1, "Yes, because previous is logical.")
55            .build()))
56        .isEqualTo(true);
57    assertThat(ISNONTEXT.SELF.apply(null, Grid.builder().add(0, 0, new NAException()).build())).isEqualTo(true);
58  }
59
60  @Test
61  public void testApply_errorFromArgumentsMismatch() {
62    assertThat(ISNONTEXT.SELF.apply(null)).isEqualTo(new NAException());
63    assertThat(ISNONTEXT.SELF.apply(null, "A", "B")).isEqualTo(new NAException());
64  }
65}