def test_sum_range_with_less_indexes(self):
self.assertEqual(sumif([1, 2, 3, 4, 5], ">=3", [100, 123, 12, 23]), 35)
def test_regular_with_number_criteria(self):
self.assertEqual(sumif([1, 1, 2, 2, 2], 2), 6)
def test_sum_range(self):
self.assertEqual(
sumif([1, 2, 3, 4, 5], ">=3", [100, 123, 12, 23, 633]), 668)
def test_sumif(result, criteria, values):
assert sumif(values, criteria) == result
assert sumif(values, criteria, values) == result
def test_sum_range_is_a_list(self):
with self.assertRaises(TypeError):
sumif(12, 12, 12)
def test_regular_with_string_criteria(self):
assert 12 == sumif(((1, 2, 3, 4, 5), ), ">=3")
def test_sum_range_with_less_indexes(self):
with pytest.raises(AssertionError):
sumif(((1, 2, 3, 4, 5), ), ">=3", ((100, 123, 12, 23), ))
def test_sum_range(self):
self.assertEqual(sumif([1, 2, 3, 4, 5], ">=3", [100, 123, 12, 23, 633]), 668)
def test_sum_range_with_more_indexes(self):
self.assertEqual(sumif([1, 2, 3, 4, 5], ">=3", [100, 123, 12, 23, 633, 1]), 668)
def test_regular_with_number_criteria(self):
self.assertEqual(sumif([1, 1, 2, 2, 2], 2), 6)
def test_regular_with_string_criteria(self):
self.assertEqual(sumif([1, 2, 3, 4, 5], ">=3"), 12)
def test_criteria_is_number_string_boolean(self):
self.assertEqual(sumif([1, 2, 3], [1, 2]), 0)
def test_sum_range_is_a_list(self):
with self.assertRaises(TypeError):
sumif(12, 12, 12)
def test_sum_range_with_less_indexes(self):
with pytest.raises(AssertionError):
sumif(((1, 2, 3, 4, 5), ), ">=3", ((100, 123, 12, 23), ))
def test_sum_range(self):
assert 668 == sumif(((1, 2, 3, 4, 5), ), ">=3",
((100, 123, 12, 23, 633), ))
def test_sum_range_with_less_indexes(self):
self.assertEqual(sumif([1, 2, 3, 4, 5], ">=3", [100, 123, 12, 23]), 35)
def test_regular_with_number_criteria(self):
assert 6 == sumif(((1, 1, 2, 2, 2), ), 2)
def test_regular_with_number_criteria(self):
assert 6 == sumif([1, 1, 2, 2, 2], 2)
def test_sum_range(self):
assert 668 == sumif(((1, 2, 3, 4, 5), ), ">=3",
((100, 123, 12, 23, 633), ))
def test_regular_with_string_criteria(self):
assert 12 == sumif([1, 2, 3, 4, 5], ">=3")
def test_sum_range_not_list(self):
with pytest.raises(TypeError):
sumif([], [], 'JUNK')
def test_sum_range(self):
assert 668 == sumif([1, 2, 3, 4, 5], ">=3", [100, 123, 12, 23, 633])
def test_sumif(data, result):
if isinstance(result, type(Exception)):
with pytest.raises(result):
sumif(*data)
else:
assert sumif(*data) == result
def test_sum_range_with_more_indexes(self):
assert 668 == sumif([1, 2, 3, 4, 5], ">=3", [100, 123, 12, 23, 633, 1])
def test_criteria_is_number_string_boolean(self):
self.assertEqual(sumif([1, 2, 3], [1, 2]), 0)
def test_sum_range_with_less_indexes(self):
assert 35 == sumif([1, 2, 3, 4, 5], ">=3", [100, 123, 12, 23])
def test_regular_with_string_criteria(self):
self.assertEqual(sumif([1, 2, 3, 4, 5], ">=3"), 12)
def test_sum_range_not_list(self):
with pytest.raises(TypeError):
sumif([], [], 'JUNK')
def test_sum_range_with_more_indexes(self):
self.assertEqual(
sumif([1, 2, 3, 4, 5], ">=3", [100, 123, 12, 23, 633, 1]), 668)
def test_sum_range_is_a_list(self):
with pytest.raises(TypeError):
sumif(12, 12, 12)
def test_sum_range_is_a_list(self):
with pytest.raises(TypeError):
sumif(12, 12, 12)
def test_sumif(expected, criteria, values):
assert sumif(values, criteria) == expected
assert sumif(values, criteria, values) == expected
