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