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": [
TemplateRow(1, RowType.PREAMBLE, ("test_date", "foo")),
TemplateRow(1, RowType.PREAMBLE, ("test_time", "10:44:61")),
TemplateRow(
2,
RowType.HEADER,
("test_property", "test_date", "test_time",
"something_unexpected"),
),
TemplateRow(3, RowType.DATA, (None, "6/11/12", "10:44:61")),
TemplateRow(4, RowType.DATA,
("foo", "6/11/12", "10:44:61", None, "10:44:61")),
]
}
errs = [
"convert .foo. to date",
"unexpected.*something_unexpected",
"is missing",
"Error in worksheet 'TEST_SHEET', row 3, field 'test_property': found empty value",
"Row 4 has 1 unexpected extra values",
]
for err in errs:
search_error_message(tiny_missing_value, tiny_template,
ValidationError, err)
def test_empty_headers(tiny_template):
"""Test that a spreadsheet with empty headers raises a validation error"""
tiny_missing_header = {
"TEST_SHEET":
[TemplateRow(1, RowType.HEADER, ("test_property", None, "test_time"))]
}
search_error_message(tiny_missing_header, tiny_template, ValidationError,
"empty header cell")
def test_wrong_number_of_headers(tiny_template):
"""Test that a spreadsheet with multiple or no headers raises an validation error"""
tiny_double = {
"TEST_SHEET": [
TemplateRow(1, RowType.HEADER,
("test_property", "test_date", "test_time")),
TemplateRow(2, RowType.HEADER,
("test_property", "test_date", "test_time")),
]
}
tiny_no_headers = {"TEST_SHEET": [TemplateRow(1, RowType.DATA, (1, 2, 3))]}
search_error_message(tiny_double, tiny_template, ValidationError,
"one header row expected")
search_error_message(tiny_no_headers, tiny_template, ValidationError,
"one header row expected")
def test_missing_schema(tiny_template):
"""Test that a spreadsheet with an unknown property raises an assertion error"""
tiny_missing = {
"TEST_SHEET":
[TemplateRow(1, RowType.PREAMBLE, ("missing_property", "foo"))]
}
search_error_message(
tiny_missing,
tiny_template,
ValidationError,
r"Found unexpected column.*missing_property",
)
def test_missing_rows_or_columns(tiny_template):
"""Test that a template with missing rows or columns raises a validation error"""
missing_rows_and_columns = {
"TEST_SHEET": [
TemplateRow(1, RowType.PREAMBLE, ("test_property", "foo")),
TemplateRow(2, RowType.PREAMBLE, ("test_date", "6/11/12")),
TemplateRow(3, RowType.HEADER, ("test_property", "test_time")),
]
}
search_error_message(
missing_rows_and_columns,
tiny_template,
ValidationError,
"expected template row: 'test_time",
)
search_error_message(
missing_rows_and_columns,
tiny_template,
ValidationError,
"expected template column: 'test_date",
)
def test_invalid(tiny_template):
"""Test that a known-invalid spreadsheet is considered invalid"""
tiny_invalid = {
"TEST_SHEET": [
TemplateRow(2, RowType.PREAMBLE, ("test_property", "foo")),
TemplateRow(2, RowType.PREAMBLE, ("test_date", "6foo")),
TemplateRow(2, RowType.PREAMBLE, ("test_time", "10:foo:61")),
TemplateRow(2, RowType.HEADER,
("test_property", "test_date", "test_time")),
TemplateRow(2, RowType.DATA, ("foo", "6/11/foo", "10::::44:61")),
TemplateRow(2, RowType.DATA, ("foo", "6//12", "10:45:61asdf")),
]
}
search_error_message(tiny_invalid, tiny_template, ValidationError, "")
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)