def test_valid(tiny_template):
"""Test that a known-valid spreadsheet is considered valid"""
tiny_valid = {
'TEST_SHEET': [
(RowType.PREAMBLE, 'test_property', 'foo'),
(RowType.PREAMBLE, 'test_date', '6/11/12'),
(RowType.PREAMBLE, 'test_time', '10:44:61'),
(RowType.HEADER, 'test_property', 'test_date', 'test_time'),
(RowType.DATA, 'foo', '6/11/12', '10:44:61'),
(RowType.DATA, 'foo', '6/12/12', '10:45:61')
]
}
reader = XlTemplateReader(tiny_valid)
assert reader.validate(tiny_template)
def test_missing_required_value(tiny_template):
"""Test that spreadsheet with a missing value marked required raises a validation error"""
tiny_missing_value = {
'TEST_SHEET': [
(RowType.HEADER, 'test_property', 'test_date', 'test_time'),
(RowType.DATA, None, '6/11/12', '10:44:61'),
]
}
# tiny_template has no required fields, so this should be valid
assert XlTemplateReader(tiny_missing_value).validate(tiny_template)
# add a required field
tiny_template.template_schema['required'] = ['test_property']
search_error_message(tiny_missing_value,
tiny_template, ValidationError, 'empty value for required field')
def test_valid(tiny_template):
"""Test that a known-valid spreadsheet is considered valid"""
tiny_valid = {
"TEST_SHEET": [
TemplateRow(1, RowType.PREAMBLE, ("test_property", "foo")),
TemplateRow(2, RowType.PREAMBLE, ("test_date", "6/11/12")),
TemplateRow(3, RowType.PREAMBLE, ("test_time", "10:45:01")),
TemplateRow(3, RowType.PREAMBLE, ("test_number", "432.1")),
TemplateRow(3, RowType.PREAMBLE, ("test_enum", "enum_val_1")),
TemplateRow(
4,
RowType.HEADER,
("test_property", "test_date", "test_time", "test_number",
"test_enum"),
),
TemplateRow(5, RowType.DATA,
("foo", "6/11/12", "10:45:01", "4.11", "enum_val_1")),
TemplateRow(6, RowType.DATA,
("foo", "6/12/12", "10:46:01", "5.11", "enum_val_2")),
]
}
reader = XlTemplateReader(tiny_valid)
assert reader.validate(tiny_template)
def search_error_message(workbook, template, error, msg_fragment):
reader = XlTemplateReader(workbook)
with pytest.raises(error, match=msg_fragment):
res = reader.validate(template)