def test_update_rows_location_bottom(self):
self.client.as_test_scenario('Update Rows - Location - Bottom')
first_row = Row()
first_row.id = 10
first_row.to_bottom = True
response = self.client.Sheets.update_rows(1, [first_row])
assert response.result[0].row_number == 100
def test_add_rows_location_bottom(self):
self.client.as_test_scenario('Add Rows - Location - Bottom')
first_row = Row()
first_row.to_bottom = True
first_row.cells.append({"columnId": 101, "value": "Apple"})
first_row.cells.append({"columnId": 102, "value": "Red Fruit"})
response = self.client.Sheets.add_rows(1, [first_row])
assert response.result[0].row_number == 100
def test_bulk_failure_serialization(self):
self.client.as_test_scenario('Serialization - BulkFailure')
row1 = Row()
row1.to_bottom = True
row1.cells.append({
'columnId': 2,
'value': 'Some Value'
})
row2 = Row()
row2.to_bottom = True
row2.cells.append({
'columnId': 3,
'value': 'Some Value'
})
response = self.client.Sheets.add_rows_with_partial_success(1, [row1, row2])
assert response.result[0].cells[0].value == 'Some Value'
assert response.failed_items[0].error.error_code == 1036
