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/PRODUCTTest.java
-rw-r--r--
2500
 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 PRODUCTTest extends TestFormula {
15  @Test
16  public void testApply_cleanDivision() {
17    assertThat(PRODUCT.SELF.apply(null, 10.0, 10.0)).isEqualTo(100.0);
18    assertThat(PRODUCT.SELF.apply(null, 10.0, 2.0)).isEqualTo(20.0);
19    assertThat(PRODUCT.SELF.apply(null, 10.0, 3.0)).isEqualTo(30.0);
20    assertThat(PRODUCT.SELF.apply(null, 0.0, 1628736813.2)).isEqualTo(0.0);
21    assertThat(PRODUCT.SELF.apply(null, 21.22, 2876.111)).isEqualTo(61031.075419999994);
22    assertThat(PRODUCT.SELF.apply(null, 1.0, 2.0, 3.0, 4.0, 5.0, 6.0, 7.0, 8.0)).isEqualTo(40320.0);
23    assertThat(PRODUCT.SELF.apply(null, 1.0, 2.0, 3.0, 4.0, 5.0, 6.0, 7.0, 8.0, -1.0)).isEqualTo(-40320.0);
24  }
25
26  @Test
27  public void testApply_stringConversion() {
28    assertThat(PRODUCT.SELF.apply(null, "10.0", "10.0")).isEqualTo(100.0);
29    assertThat(PRODUCT.SELF.apply(null, "10.0", "10.0", "No sir!")).isEqualTo(new ValueException());
30  }
31
32  @Test
33  public void testApply_grid() {
34    assertThat(PRODUCT.SELF.apply(null,
35        Grid.builder().add(0, 0, 6.0).add(0, 1, 2.3).build(),
36        Grid.builder().add(0, 0, 2.0).add(0, 1, 1.11).build()
37    )).isEqualTo(30.636);
38  }
39
40  @Test
41  public void test_lookup() {
42    Grid grid = Grid.builder()
43        .add(0, 0, 6.0)
44        .add(0, 1, 2.3)
45        .add(0, 2, 44.1)
46        .build();
47    PRODUCT F = new PRODUCT(lookup, collateralLookup);
48    when(lookup.apply(M22_RANGE)).thenReturn(grid);
49    when(lookup.apply(G19_RANGE)).thenReturn(grid);
50    assertThat(F.apply(A1, M22_RANGE, G19_RANGE)).isEqualTo(370369.61639999994);
51    verify(lookup).apply(M22_RANGE);
52    verify(lookup).apply(G19_RANGE);
53    verifyNoMoreInteractions(lookup);
54  }
55
56  @Test
57  public void testApply_errorsPassThrough() {
58    assertThat(PRODUCT.SELF.apply(null, 10.0, new ValueException())).isEqualTo(new ValueException());
59    assertThat(PRODUCT.SELF.apply(null, new ValueException(), 10.0)).isEqualTo(new ValueException());
60  }
61
62  @Test
63  public void testApply_argumentsMismatch() {
64    assertThat(PRODUCT.SELF.apply(null)).isEqualTo(new NAException());
65  }
66}