blob: 85788bac7f8813b54608cffeac6681824748b203 [file] [log] [blame]
Ankush Menat1833f7a2021-12-18 19:37:41 +05301import unittest
2
Ankush Menataa0e1632021-12-19 17:02:04 +05303from hypothesis import given
4from hypothesis import strategies as st
5
Ankush Menat107b4042021-12-19 20:47:08 +05306from erpnext.stock.valuation import FIFOValuation, _round_off_if_near_zero
Ankush Menat1833f7a2021-12-18 19:37:41 +05307
Ankush Menataa0e1632021-12-19 17:02:04 +05308qty_gen = st.floats(min_value=-1e6, max_value=1e6)
9value_gen = st.floats(min_value=1, max_value=1e6)
10stock_queue_generator = st.lists(st.tuples(qty_gen, value_gen), min_size=10)
Ankush Menat1833f7a2021-12-18 19:37:41 +053011
Ankush Menat1833f7a2021-12-18 19:37:41 +053012
13class TestFifoValuation(unittest.TestCase):
14
15 def setUp(self):
Ankush Menat107b4042021-12-19 20:47:08 +053016 self.queue = FIFOValuation([])
Ankush Menat1833f7a2021-12-18 19:37:41 +053017
18 def tearDown(self):
19 qty, value = self.queue.get_total_stock_and_value()
20 self.assertTotalQty(qty)
21 self.assertTotalValue(value)
22
23 def assertTotalQty(self, qty):
Ankush Menataa0e1632021-12-19 17:02:04 +053024 self.assertAlmostEqual(sum(q for q, _ in self.queue), qty, msg=f"queue: {self.queue}", places=4)
Ankush Menat1833f7a2021-12-18 19:37:41 +053025
26 def assertTotalValue(self, value):
Ankush Menataa0e1632021-12-19 17:02:04 +053027 self.assertAlmostEqual(sum(q * r for q, r in self.queue), value, msg=f"queue: {self.queue}", places=2)
Ankush Menat1833f7a2021-12-18 19:37:41 +053028
29 def test_simple_addition(self):
30 self.queue.add_stock(1, 10)
31 self.assertTotalQty(1)
32
33 def test_simple_removal(self):
34 self.queue.add_stock(1, 10)
Ankush Menataa0e1632021-12-19 17:02:04 +053035 self.queue.remove_stock(1)
Ankush Menat1833f7a2021-12-18 19:37:41 +053036 self.assertTotalQty(0)
37
38 def test_merge_new_stock(self):
39 self.queue.add_stock(1, 10)
40 self.queue.add_stock(1, 10)
41 self.assertEqual(self.queue, [[2, 10]])
42
43 def test_adding_negative_stock_keeps_rate(self):
Ankush Menat107b4042021-12-19 20:47:08 +053044 self.queue = FIFOValuation([[-5.0, 100]])
Ankush Menat1833f7a2021-12-18 19:37:41 +053045 self.queue.add_stock(1, 10)
46 self.assertEqual(self.queue, [[-4, 100]])
47
48 def test_adding_negative_stock_updates_rate(self):
Ankush Menat107b4042021-12-19 20:47:08 +053049 self.queue = FIFOValuation([[-5.0, 100]])
Ankush Menat1833f7a2021-12-18 19:37:41 +053050 self.queue.add_stock(6, 10)
51 self.assertEqual(self.queue, [[1, 10]])
52
53
54 def test_negative_stock(self):
Ankush Menataa0e1632021-12-19 17:02:04 +053055 self.queue.remove_stock(1, 5)
Ankush Menat1833f7a2021-12-18 19:37:41 +053056 self.assertEqual(self.queue, [[-1, 5]])
57
58 # XXX
Ankush Menataa0e1632021-12-19 17:02:04 +053059 self.queue.remove_stock(1, 10)
Ankush Menat1833f7a2021-12-18 19:37:41 +053060 self.assertTotalQty(-2)
61
62 self.queue.add_stock(2, 10)
63 self.assertTotalQty(0)
64 self.assertTotalValue(0)
65
66 def test_removing_specified_rate(self):
67 self.queue.add_stock(1, 10)
68 self.queue.add_stock(1, 20)
69
Ankush Menataa0e1632021-12-19 17:02:04 +053070 self.queue.remove_stock(1, 20)
Ankush Menat1833f7a2021-12-18 19:37:41 +053071 self.assertEqual(self.queue, [[1, 10]])
72
73
74 def test_remove_multiple_bins(self):
75 self.queue.add_stock(1, 10)
76 self.queue.add_stock(2, 20)
77 self.queue.add_stock(1, 20)
78 self.queue.add_stock(5, 20)
79
Ankush Menataa0e1632021-12-19 17:02:04 +053080 self.queue.remove_stock(4)
Ankush Menat1833f7a2021-12-18 19:37:41 +053081 self.assertEqual(self.queue, [[5, 20]])
82
83
84 def test_remove_multiple_bins_with_rate(self):
85 self.queue.add_stock(1, 10)
86 self.queue.add_stock(2, 20)
87 self.queue.add_stock(1, 20)
88 self.queue.add_stock(5, 20)
89
Ankush Menataa0e1632021-12-19 17:02:04 +053090 self.queue.remove_stock(3, 20)
Ankush Menat1833f7a2021-12-18 19:37:41 +053091 self.assertEqual(self.queue, [[1, 10], [5, 20]])
92
93 def test_collapsing_of_queue(self):
94 self.queue.add_stock(1, 1)
95 self.queue.add_stock(1, 2)
96 self.queue.add_stock(1, 3)
97 self.queue.add_stock(1, 4)
98
99 self.assertTotalValue(10)
100
Ankush Menataa0e1632021-12-19 17:02:04 +0530101 self.queue.remove_stock(3, 1)
Ankush Menat1833f7a2021-12-18 19:37:41 +0530102 # XXX
103 self.assertEqual(self.queue, [[1, 7]])
104
105 def test_rounding_off(self):
106 self.queue.add_stock(1.0, 1.0)
Ankush Menataa0e1632021-12-19 17:02:04 +0530107 self.queue.remove_stock(1.0 - 1e-9)
Ankush Menat1833f7a2021-12-18 19:37:41 +0530108 self.assertTotalQty(0)
109
110 def test_rounding_off_near_zero(self):
111 self.assertEqual(_round_off_if_near_zero(0), 0)
112 self.assertEqual(_round_off_if_near_zero(1), 1)
113 self.assertEqual(_round_off_if_near_zero(-1), -1)
114 self.assertEqual(_round_off_if_near_zero(-1e-8), 0)
115 self.assertEqual(_round_off_if_near_zero(1e-8), 0)
116
117 def test_totals(self):
118 self.queue.add_stock(1, 10)
119 self.queue.add_stock(2, 13)
120 self.queue.add_stock(1, 17)
Ankush Menataa0e1632021-12-19 17:02:04 +0530121 self.queue.remove_stock(1)
122 self.queue.remove_stock(1)
123 self.queue.remove_stock(1)
Ankush Menat1833f7a2021-12-18 19:37:41 +0530124 self.queue.add_stock(5, 17)
125 self.queue.add_stock(8, 11)
Ankush Menataa0e1632021-12-19 17:02:04 +0530126
127 @given(stock_queue_generator)
128 def test_fifo_qty_hypothesis(self, stock_queue):
Ankush Menat107b4042021-12-19 20:47:08 +0530129 self.queue = FIFOValuation([])
Ankush Menataa0e1632021-12-19 17:02:04 +0530130 total_qty = 0
131
132 for qty, rate in stock_queue:
133 if qty == 0:
134 continue
135 if qty > 0:
136 self.queue.add_stock(qty, rate)
137 total_qty += qty
138 else:
139 qty = abs(qty)
140 consumed = self.queue.remove_stock(qty)
141 self.assertAlmostEqual(qty, sum(q for q, _ in consumed), msg=f"incorrect consumption {consumed}")
142 total_qty -= qty
143 self.assertTotalQty(total_qty)
144
145 @given(stock_queue_generator)
146 def test_fifo_qty_value_nonneg_hypothesis(self, stock_queue):
Ankush Menat107b4042021-12-19 20:47:08 +0530147 self.queue = FIFOValuation([])
Ankush Menataa0e1632021-12-19 17:02:04 +0530148 total_qty = 0.0
149 total_value = 0.0
150
151 for qty, rate in stock_queue:
152 # don't allow negative stock
153 if qty == 0 or total_qty + qty < 0 or abs(qty) < 0.1:
154 continue
155 if qty > 0:
156 self.queue.add_stock(qty, rate)
157 total_qty += qty
158 total_value += qty * rate
159 else:
160 qty = abs(qty)
161 consumed = self.queue.remove_stock(qty)
162 self.assertAlmostEqual(qty, sum(q for q, _ in consumed), msg=f"incorrect consumption {consumed}")
163 total_qty -= qty
164 total_value -= sum(q * r for q, r in consumed)
165 self.assertTotalQty(total_qty)
166 self.assertTotalValue(total_value)