def test_table_ods_sheet_by_index_not_existent(): dialect = OdsDialect(sheet=3) table = Table("data/table.ods", dialect=dialect) with pytest.raises(exceptions.FrictionlessException) as excinfo: table.open() error = excinfo.value.error assert error.code == "format-error" assert error.note == 'OpenOffice document "data/table.ods" does not have a sheet "3"'
def test_ods_parser_sheet_by_name_not_existent(): dialect = OdsDialect(sheet="bad") table = Resource("data/table.ods", dialect=dialect) with pytest.raises(FrictionlessException) as excinfo: table.open() error = excinfo.value.error assert error.code == "format-error" assert (error.note == 'OpenOffice document "data/table.ods" does not have a sheet "bad"')
def test_ods_parser_sheet_by_name(): dialect = OdsDialect(sheet="Лист1") with Resource("data/table.ods", dialect=dialect) as resource: assert resource.header == ["id", "name"] assert resource.read_rows() == [ { "id": 1, "name": "english" }, { "id": 2, "name": "中国人" }, ]
def test_table_ods_sheet_by_name(): dialect = OdsDialect(sheet="Лист1") with Table("data/table.ods", dialect=dialect) as table: assert table.header == ["id", "name"] assert table.read_data() == [[1, "english"], [2, "中国人"]]
def test_ods_parser_sheet_by_index(): dialect = OdsDialect(sheet=1) with Table("data/table.ods", dialect=dialect) as table: assert table.header == ["id", "name"] assert table.read_data() == [[1, "english"], [2, "中国人"]]