def test_validate_required_if_other_empty_invalid(self):
sheet = OPWorkbook(self.required_values_workbook,
self.requirements_config).description
sheet.validate_requirement('required_if_field_1_empty_invalid')
self.assertEqual(len(sheet.errors), 1)
self.assertRegexpMatches(
sheet.errors[0], r'Required if field 1.* cannot be empty.*Field 1')
def test_required_if_other_nonempty(self):
sheet = OPWorkbook(self.pages_invalid_workbook,
self.pages_config).pages
sheet.validate_requirement('serial_num')
self.assertEqual(len(sheet.errors), 1)
self.assertRegexpMatches(
sheet.errors[0], r"'SERIAL_NUM' cannot be empty.* 'FILE_NAME'")
def test_validate_required_if_other_in_list_repeating(self):
sheet = OPWorkbook(self.required_values_workbook,
self.requirements_config).description
sheet.validate_requirement('required_if_9_is_CAT')
self.assertEqual(len(sheet.errors), 1)
self.assertRegexpMatches(sheet.errors[0],
r'Required.* cannot be empty.*if.*CAT')
def test_required_based_on_value_list_tag3_value3(self):
sheet = OPWorkbook(self.pages_invalid_workbook,
self.pages_config).pages
sheet.validate_requirement('value3')
self.assertEqual(len(sheet.errors), 1)
self.assertRegexpMatches(sheet.errors[0],
r"'VALUE3' cannot be empty.* 'TAG3'.*'TOC3'")
def test_validate_required_if_other_in_list_differing_case(self):
sheet = OPWorkbook(self.required_values_workbook,
self.requirements_config).description
sheet.validate_requirement('require_if_field_8_is_CAT_valid')
self.assertEqual(len(sheet.errors), 0)
def test_validate_requirement_not_required_with_value(self):
sheet = OPWorkbook(self.required_values_workbook,
self.requirements_config).description
sheet.validate_requirement('field_6_not_required_value')
self.assertEqual(len(sheet.errors), 0)
def test_validate_requirement_invalid(self):
sheet = OPWorkbook(self.required_values_workbook,
self.requirements_config).description
sheet.validate_requirement('field_3_required_invalid')
self.assertEqual(len(sheet.errors), 1)
self.assertRegexpMatches(sheet.errors[0], r'Field 3.* cannot be empty')
def test_validate_required_if_other_empty_valid_repeating(self):
sheet = OPWorkbook(self.required_values_workbook,
self.requirements_config).description
sheet.validate_requirement(
'required_if_field_2_nonempty_first_and_third_missing')
self.assertEqual(len(sheet.errors), 2)
def test_validate_required_if_other_empty_valid(self):
sheet = OPWorkbook(self.required_values_workbook,
self.requirements_config).description
sheet.validate_requirement('required_if_field_1_empty_valid')
self.assertEqual(len(sheet.errors), 0)
def test_notrequired_based_on_value_list_tag4_value4(self):
sheet = OPWorkbook(self.pages_invalid_workbook,
self.pages_config).pages
sheet.validate_requirement('value4')
self.assertEqual(len(sheet.errors), 0)