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/ROUNDTest.java
-rw-r--r--
3902
 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 ROUNDTest extends TestFormula {
15  @Test
16  public void testApply_alreadyRounded() {
17    assertThat(ROUND.SELF.apply(null, 10.0)).isEqualTo(10.0);
18    assertThat(ROUND.SELF.apply(null, -10.0)).isEqualTo(-10.0);
19    assertThat(ROUND.SELF.apply(null, 0.0)).isEqualTo(0.0);
20  }
21
22  @Test
23  public void testApply_roundingFullInteger() {
24    assertThat(ROUND.SELF.apply(null, 3.218639128)).isEqualTo(3.0);
25    assertThat(ROUND.SELF.apply(null, 7.99)).isEqualTo(8.0);
26    assertThat(ROUND.SELF.apply(null, 7.0000000001)).isEqualTo(7.0);
27  }
28
29  @Test
30  public void testApply_toPlace() {
31    assertThat(ROUND.SELF.apply(null, 3.218639128, 4.0)).isEqualTo(3.2186);
32    assertThat(ROUND.SELF.apply(null, 3.218639128, 5.0)).isEqualTo(3.21864);
33    assertThat(ROUND.SELF.apply(null, 9.12, 0.0)).isEqualTo(9.0);
34    assertThat(ROUND.SELF.apply(null, 9.12, 1.0)).isEqualTo(9.1);
35    assertThat(ROUND.SELF.apply(null, 9.12, 2.0)).isEqualTo(9.12);
36    assertThat(ROUND.SELF.apply(null, 9.12, 3.0)).isEqualTo(9.12);
37    assertThat(ROUND.SELF.apply(null, 9.12, 8.0)).isEqualTo(9.12);
38  }
39
40  @Test
41  public void testApply_toNegativePlace() {
42    assertThat(ROUND.SELF.apply(null, 3341.218639128, -4.0)).isEqualTo(0.0);
43    assertThat(ROUND.SELF.apply(null, 3341.218639128, -3.0)).isEqualTo(3000.0);
44    assertThat(ROUND.SELF.apply(null, 3341.218639128, -2.0)).isEqualTo(3300.0);
45    assertThat(ROUND.SELF.apply(null, 3341.218639128, -1.0)).isEqualTo(3340.0);
46    assertThat(ROUND.SELF.apply(null, 3341.218639128, 0.0)).isEqualTo(3341.0);
47  }
48
49  @Test
50  public void testApply_withNonIntegerPlaces() {
51    assertThat(ROUND.SELF.apply(null, 3341.218639128, -4.99)).isEqualTo(0.0);
52    assertThat(ROUND.SELF.apply(null, 3341.218639128, -3.999999)).isEqualTo(3000.0);
53    assertThat(ROUND.SELF.apply(null, 3341.218639128, -2.1)).isEqualTo(3300.0);
54    assertThat(ROUND.SELF.apply(null, 3341.218639128, -1.1982371982)).isEqualTo(3340.0);
55    assertThat(ROUND.SELF.apply(null, 3341.218639128, 0.0)).isEqualTo(3341.0);
56    assertThat(ROUND.SELF.apply(null, 3341.218639128, 0.999)).isEqualTo(3341.0);
57    assertThat(ROUND.SELF.apply(null, 3341.218639128, -0.999)).isEqualTo(3341.0);
58    assertThat(ROUND.SELF.apply(null, 3341.218639128, 1.111)).isEqualTo(3341.2);
59    assertThat(ROUND.SELF.apply(null, 3341.218639128, -1.111)).isEqualTo(3340.0);
60  }
61
62  @Test
63  public void testApply_stringConversion() {
64    assertThat(ROUND.SELF.apply(null, "10.4")).isEqualTo(10.0);
65  }
66
67  @Test
68  public void testApply_grid() {
69    assertThat(ROUND.SELF.apply(null,
70        Grid.builder().add(0, 0, -4.4444444).add(0, 1, "Don't mind me.").build()
71    )).isEqualTo(-4.0);
72  }
73
74  @Test
75  public void test_lookup() {
76    ROUND F = new ROUND(lookup, collateralLookup);
77    when(collateralLookup.apply(A1, M22_RANGE)).thenReturn(3.218639128);
78    when(collateralLookup.apply(A1, G19_RANGE)).thenReturn(4.0);
79    assertThat(F.apply(A1, M22_RANGE, G19_RANGE)).isEqualTo(3.2186);
80    verify(collateralLookup).apply(A1, M22_RANGE);
81    verify(collateralLookup).apply(A1, G19_RANGE);
82    verifyNoMoreInteractions(collateralLookup);
83  }
84
85  @Test
86  public void testApply_errorsPassThrough() {
87    assertThat(ROUND.SELF.apply(null, new ValueException())).isEqualTo(new ValueException());
88  }
89
90  @Test
91  public void testApply_argumentsMismatch() {
92    assertThat(ROUND.SELF.apply(null)).isEqualTo(new NAException());
93    assertThat(ROUND.SELF.apply(null, "A", "B", "Too many")).isEqualTo(new NAException());
94  }
95}