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