def test_formatter_by_named_row2(self): """Test a list of string as index""" s = Sheet(self.data, "test") s.name_rows_by_column(0) s.row.format(["Row 1", "Row 2"], str) assert s.row["Row 1"] == ["1", "2", "3"] assert s.row["Row 2"] == ["4", "5", "6"]
def test_add(self): s = Sheet(self.data, "test") s.name_rows_by_column(0) data = OrderedDict({ "Row 5": [10, 11, 12] } ) s = s.row + data assert s.row["Row 5"] == [10, 11, 12]
def test_set_named_row(self): s = Sheet(self.data, "test") s.name_rows_by_column(0) s.row["Row 2"] = [11, 11, 11] assert s.row["Row 2"] == [11, 11, 11]
def test_delete_indexed_row2(self): s = Sheet(self.data, "test") s.name_rows_by_column(0) s.delete_named_row_at(2) assert s.number_of_rows() == 3 s.row["Row 2"] # already deleted
def test_delete_named_row(self): s = Sheet(self.data, "test") s.name_rows_by_column(0) del s.row["Row 2"] assert s.number_of_rows() == 3 s.row["Row 2"] # already deleted
def test_add_wrong_type(self): s = Sheet(self.data, "test") s.name_rows_by_column(0) s = s.row + "string type" # bang
def test_extend_rows_using_wrong_data_type(self): s = Sheet(self.data, "test") s.name_rows_by_column(0) s.extend_rows([1, 2])
def test_row_series_to_dict(self): s = Sheet(self.data, "test") s.name_rows_by_column(0) content = s.to_dict(True) keys = ["Row 0", "Row 1", "Row 2", "Row 3"] assert keys == list(content.keys())
def test_formatter_by_named_row_2(self): s = Sheet(self.data, "test") s.name_rows_by_column(0) s.row.format("Row 1", str) assert s.row["Row 1"] == ["1", "2", "3"]
def test_formatter_by_named_row(self): s = Sheet(self.data, "test") s.name_rows_by_column(0) f = NamedRowFormatter("Row 1", str) s.apply_formatter(f) assert s.row["Row 1"] == ["1", "2", "3"]
def test_delete_indexed_row3(self): s = Sheet(self.data, "test") s.name_rows_by_column(0) del s.row["Row 0", "Row 1"] assert s.number_of_rows() == 2 s.row["Row 1"] # already deleted