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/math/ODDTest.java
-rw-r--r--
2562
 1package io.protobase.f7.formulas.math;
 2
 3import io.protobase.f7.errors.NAException;
 4import io.protobase.f7.errors.ValueException;
 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 ODDTest extends TestFormula {
15  @Test
16  public void testApply() {
17    assertThat(ODD.SELF.apply(null, 2.0)).isEqualTo(3.0);
18    assertThat(ODD.SELF.apply(null, 1.0)).isEqualTo(1.0);
19    assertThat(ODD.SELF.apply(null, 1.1)).isEqualTo(3.0);
20    assertThat(ODD.SELF.apply(null, 2.1)).isEqualTo(3.0);
21    assertThat(ODD.SELF.apply(null, 3.0)).isEqualTo(3.0);
22    assertThat(ODD.SELF.apply(null, 0.0)).isEqualTo(1.0);
23    assertThat(ODD.SELF.apply(null, -0.0)).isEqualTo(1.0);
24    assertThat(ODD.SELF.apply(null, 0.1298738912)).isEqualTo(1.0);
25    assertThat(ODD.SELF.apply(null, 1.1298738912)).isEqualTo(3.0);
26    assertThat(ODD.SELF.apply(null, 2.1298738912)).isEqualTo(3.0);
27    assertThat(ODD.SELF.apply(null, true)).isEqualTo(1.0);
28    assertThat(ODD.SELF.apply(null, false)).isEqualTo(1.0);
29  }
30
31  @Test
32  public void testApply_negativeValue() {
33    assertThat(ODD.SELF.apply(null, -2.0)).isEqualTo(-3.0);
34    assertThat(ODD.SELF.apply(null, -1.0)).isEqualTo(-1.0);
35    assertThat(ODD.SELF.apply(null, -1.1)).isEqualTo(-3.0);
36    assertThat(ODD.SELF.apply(null, -2.1)).isEqualTo(-3.0);
37    assertThat(ODD.SELF.apply(null, -3.0)).isEqualTo(-3.0);
38    assertThat(ODD.SELF.apply(null, 0.0)).isEqualTo(1.0);
39  }
40
41  @Test
42  public void testApply_stringConversion() {
43    assertThat(ODD.SELF.apply(null, "9.9")).isEqualTo(11.0);
44  }
45
46  @Test
47  public void testApply_grid() {
48    assertThat(ODD.SELF.apply(null,
49        Grid.builder().add(0, 0, -4.4).add(0, 1, "Don't mind me.").build()
50    )).isEqualTo(-5.0);
51  }
52
53  @Test
54  public void test_lookup() {
55    ODD F = new ODD(lookup, collateralLookup);
56    when(collateralLookup.apply(A1, M22_RANGE)).thenReturn(2.0);
57    assertThat(F.apply(A1, M22_RANGE)).isEqualTo(3.0);
58    verify(collateralLookup).apply(A1, M22_RANGE);
59    verifyNoMoreInteractions(collateralLookup);
60  }
61
62  @Test
63  public void testApply_errorsPassThrough() {
64    assertThat(ODD.SELF.apply(null, new ValueException())).isEqualTo(new ValueException());
65  }
66
67  @Test
68  public void testApply_argumentsMismatch() {
69    assertThat(ODD.SELF.apply(null, "A", "Too many")).isEqualTo(new NAException());
70  }
71}