Example #1
0
 def test_sum_range_with_less_indexes(self):
     self.assertEqual(sumif([1, 2, 3, 4, 5], ">=3", [100, 123, 12, 23]), 35)
Example #2
0
 def test_regular_with_number_criteria(self):
     self.assertEqual(sumif([1, 1, 2, 2, 2], 2), 6)
Example #3
0
 def test_sum_range(self):
     self.assertEqual(
         sumif([1, 2, 3, 4, 5], ">=3", [100, 123, 12, 23, 633]), 668)
Example #4
0
 def test_sumif(result, criteria, values):
     assert sumif(values, criteria) == result
     assert sumif(values, criteria, values) == result
Example #5
0
 def test_sum_range_is_a_list(self):
     with self.assertRaises(TypeError):
         sumif(12, 12, 12)
Example #6
0
 def test_regular_with_string_criteria(self):
     assert 12 == sumif(((1, 2, 3, 4, 5), ), ">=3")
Example #7
0
 def test_sum_range_with_less_indexes(self):
     with pytest.raises(AssertionError):
         sumif(((1, 2, 3, 4, 5), ), ">=3", ((100, 123, 12, 23), ))
Example #8
0
 def test_sum_range(self):
     self.assertEqual(sumif([1, 2, 3, 4, 5], ">=3", [100, 123, 12, 23, 633]), 668)
Example #9
0
 def test_sum_range_with_more_indexes(self):
     self.assertEqual(sumif([1, 2, 3, 4, 5], ">=3", [100, 123, 12, 23, 633, 1]), 668)
Example #10
0
 def test_regular_with_number_criteria(self):
     self.assertEqual(sumif([1, 1, 2, 2, 2], 2), 6)
Example #11
0
 def test_regular_with_string_criteria(self):
     self.assertEqual(sumif([1, 2, 3, 4, 5], ">=3"), 12)
Example #12
0
 def test_criteria_is_number_string_boolean(self):
     self.assertEqual(sumif([1, 2, 3], [1, 2]), 0)
Example #13
0
 def test_sum_range_is_a_list(self):
     with self.assertRaises(TypeError):
         sumif(12, 12, 12)
Example #14
0
 def test_sum_range_with_less_indexes(self):
     with pytest.raises(AssertionError):
         sumif(((1, 2, 3, 4, 5), ), ">=3", ((100, 123, 12, 23), ))
Example #15
0
 def test_sum_range(self):
     assert 668 == sumif(((1, 2, 3, 4, 5), ), ">=3",
                         ((100, 123, 12, 23, 633), ))
Example #16
0
 def test_sum_range_with_less_indexes(self):
     self.assertEqual(sumif([1, 2, 3, 4, 5], ">=3", [100, 123, 12, 23]), 35)
Example #17
0
 def test_regular_with_number_criteria(self):
     assert 6 == sumif(((1, 1, 2, 2, 2), ), 2)
Example #18
0
 def test_regular_with_number_criteria(self):
     assert 6 == sumif([1, 1, 2, 2, 2], 2)
Example #19
0
 def test_sum_range(self):
     assert 668 == sumif(((1, 2, 3, 4, 5), ), ">=3",
                         ((100, 123, 12, 23, 633), ))
Example #20
0
 def test_regular_with_string_criteria(self):
     assert 12 == sumif([1, 2, 3, 4, 5], ">=3")
Example #21
0
 def test_sum_range_not_list(self):
     with pytest.raises(TypeError):
         sumif([], [], 'JUNK')
Example #22
0
 def test_sum_range(self):
     assert 668 == sumif([1, 2, 3, 4, 5], ">=3", [100, 123, 12, 23, 633])
Example #23
0
def test_sumif(data, result):
    if isinstance(result, type(Exception)):
        with pytest.raises(result):
            sumif(*data)
    else:
        assert sumif(*data) == result
Example #24
0
 def test_sum_range_with_more_indexes(self):
     assert 668 == sumif([1, 2, 3, 4, 5], ">=3", [100, 123, 12, 23, 633, 1])
Example #25
0
 def test_criteria_is_number_string_boolean(self):
     self.assertEqual(sumif([1, 2, 3], [1, 2]), 0)
Example #26
0
 def test_sum_range_with_less_indexes(self):
     assert 35 == sumif([1, 2, 3, 4, 5], ">=3", [100, 123, 12, 23])
Example #27
0
 def test_regular_with_string_criteria(self):
     self.assertEqual(sumif([1, 2, 3, 4, 5], ">=3"), 12)
Example #28
0
 def test_sum_range_not_list(self):
     with pytest.raises(TypeError):
         sumif([], [], 'JUNK')
Example #29
0
 def test_sum_range_with_more_indexes(self):
     self.assertEqual(
         sumif([1, 2, 3, 4, 5], ">=3", [100, 123, 12, 23, 633, 1]), 668)
Example #30
0
 def test_sum_range_is_a_list(self):
     with pytest.raises(TypeError):
         sumif(12, 12, 12)
Example #31
0
 def test_sum_range_is_a_list(self):
     with pytest.raises(TypeError):
         sumif(12, 12, 12)
Example #32
0
 def test_sumif(expected, criteria, values):
     assert sumif(values, criteria) == expected
     assert sumif(values, criteria, values) == expected