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/ADDTest.java
-rw-r--r--
2272
 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 ADDTest extends TestFormula {
15  @Test
16  public void testApply_cleanDivision() {
17    assertThat(ADD.SELF.apply(null, 10.0, 10.0)).isEqualTo(20.0);
18    assertThat(ADD.SELF.apply(null, 10.0, 2.0)).isEqualTo(12.0);
19    assertThat(ADD.SELF.apply(null, 0.0, 1628736813.2)).isEqualTo(1628736813.2);
20    assertThat(ADD.SELF.apply(null, 218637221.22, 2876.111)).isEqualTo(218640097.331);
21  }
22
23  @Test
24  public void testApply_stringConversion() {
25    assertThat(ADD.SELF.apply(null, "10.0", "10.0")).isEqualTo(20.0);
26    assertThat(ADD.SELF.apply(null, "10.0", "2.0")).isEqualTo(12.0);
27    assertThat(ADD.SELF.apply(null, "10.0", "3.0")).isEqualTo(13.0);
28  }
29
30  @Test
31  public void testApply_grid() {
32    assertThat(ADD.SELF.apply(null,
33        Grid.builder().add(0, 0, 6.0).add(0, 1, "Don't mind me.").build(),
34        Grid.builder().add(0, 0, 2.0).add(0, 1, "Don't mind me.").build()
35    )).isEqualTo(8.0);
36  }
37
38  @Test
39  public void testApply_errorsPassThrough() {
40    assertThat(ADD.SELF.apply(null, 10.0, new ValueException())).isEqualTo(new ValueException());
41    assertThat(ADD.SELF.apply(null, new ValueException(), 10.0)).isEqualTo(new ValueException());
42  }
43
44  @Test
45  public void test_lookup() {
46    ADD F = new ADD(lookup, collateralLookup);
47    when(collateralLookup.apply(A1, M22_RANGE)).thenReturn(10.0);
48    when(collateralLookup.apply(A1, G19_RANGE)).thenReturn(10.0);
49    assertThat(F.apply(A1, M22_RANGE, G19_RANGE)).isEqualTo(20.0);
50    verify(collateralLookup).apply(A1, M22_RANGE);
51    verify(collateralLookup).apply(A1, G19_RANGE);
52    verifyNoMoreInteractions(collateralLookup);
53  }
54
55  @Test
56  public void testApply_argumentsMismatch() {
57    assertThat(ADD.SELF.apply(null, "Too few")).isEqualTo(new NAException());
58    assertThat(ADD.SELF.apply(null, "A", "B", "Too many")).isEqualTo(new NAException());
59  }
60}