def test_validate_blank_if_other_in_list_case_insensitive_invalid(self):
sheet = OPWorkbook(self.empty_if_workbook,
self.empty_if_config).description
sheet.validate_blank('empty_if_field_4_is_cat_invalid')
self.assertEqual(len(sheet.errors), 1)
self.assertRegexpMatches(sheet.errors[0],
r'.* must be empty if.*is.*cat.*; found:')
def test_validate_blank_if_other_empty_invalid(self):
sheet = OPWorkbook(self.empty_if_workbook,
self.empty_if_config).description
sheet.validate_blank('empty_if_field_1_empty_invalid')
self.assertEqual(len(sheet.errors), 1)
self.assertRegexpMatches(sheet.errors[0],
r'.* must be empty if.*is empty; found.*')
def test_empty_if_other_nonempty(self):
sheet = OPWorkbook(self.pages_invalid_workbook,
self.pages_config).pages
sheet.validate_blank('serial_num')
self.assertEqual(len(sheet.errors), 1)
self.assertRegexpMatches(sheet.errors[0],
r"'SERIAL_NUM' must be empty.* 'FILE_NAME'")
def test_value4_blank_if_toc4_empty(self):
sheet = OPWorkbook(self.pages_invalid_workbook,
self.pages_config).pages
sheet.validate_blank('value4')
self.assertEqual(len(sheet.errors), 1)
self.assertRegexpMatches(sheet.errors[0],
r"'VALUE4' must be empty.* 'TAG4'.*'Car'")
def test_value3_blank_if_toc3_empty(self):
sheet = OPWorkbook(self.pages_invalid_workbook,
self.pages_config).pages
sheet.validate_blank('value3')
self.assertEqual(len(sheet.errors), 1)
self.assertRegexpMatches(
sheet.errors[0], r"'VALUE3' must be empty.* 'TAG3'.*'March 15'")
def test_validate_blank_if_other_in_list_repeating(self):
sheet = OPWorkbook(self.empty_if_workbook,
self.empty_if_config).description
sheet.validate_blank('empty_if_5_is_cat')
self.assertEqual(len(sheet.errors), 1)
self.assertRegexpMatches(
sheet.errors[0],
r'.* must be empty if.*is.*CAT.*; found:.*value 2.*')
def test_value2_blank_if_toc2_empty(self):
sheet = OPWorkbook(self.pages_invalid_workbook,
self.pages_config).pages
sheet.validate_blank('value2')
self.assertEqual(len(sheet.errors), 1)
self.assertRegexpMatches(
sheet.errors[0],
r"'VALUE2' must be empty.* 'TAG2'.*'September 27'")
def test_validate_blank_if_other_nonempty_invalid(self):
sheet = OPWorkbook(self.empty_if_workbook,
self.empty_if_config).description
sheet.validate_blank(
'empty_if_field_2_nonempty_first_and_third_present')
self.assertEqual(len(sheet.errors), 2)
self.assertRegexpMatches(sheet.errors[0],
r'.* must be empty if.*has a value; found')
self.assertRegexpMatches(sheet.errors[1],
r'.* must be empty if.*has a value; found')
def test_validate_blank_if_other_in_list_valid(self):
sheet = OPWorkbook(self.empty_if_workbook,
self.empty_if_config).description
sheet.validate_blank('empty_if_3_is_cat_valid')
self.assertEqual(len(sheet.errors), 0)