(self)
| 1322 | |
| 1323 | @pytest.mark.vcr() |
| 1324 | def test_insert_row(self): |
| 1325 | sg = self._sequence_generator() |
| 1326 | |
| 1327 | num_rows = 6 |
| 1328 | num_cols = 4 |
| 1329 | |
| 1330 | rows = [[next(sg) for j in range(num_cols)] for i in range(num_rows)] |
| 1331 | |
| 1332 | cell_list = self.sheet.range("A1:D6") |
| 1333 | for cell, value in zip(cell_list, itertools.chain(*rows)): |
| 1334 | cell.value = value |
| 1335 | |
| 1336 | self.sheet.update_cells(cell_list) |
| 1337 | |
| 1338 | new_row_values = [next(sg) for i in range(num_cols + 4)] |
| 1339 | row_count_before = self.sheet.row_count |
| 1340 | |
| 1341 | self.sheet.insert_row(new_row_values, 2) |
| 1342 | read_values = self.sheet.row_values(2) |
| 1343 | row_count_after = self.sheet.row_count |
| 1344 | |
| 1345 | self.assertEqual(new_row_values, read_values) |
| 1346 | self.assertEqual(row_count_before + 1, row_count_after) |
| 1347 | |
| 1348 | formula = "=1+1" |
| 1349 | |
| 1350 | self.sheet.update_acell("B2", formula) |
| 1351 | |
| 1352 | values = [next(sg) for i in range(num_cols + 4)] |
| 1353 | |
| 1354 | self.sheet.insert_row(values, 1) |
| 1355 | |
| 1356 | b3 = self.sheet.acell("B3", value_render_option=utils.ValueRenderOption.formula) |
| 1357 | |
| 1358 | self.assertEqual(b3.value, formula) |
| 1359 | |
| 1360 | new_row_values = [next(sg) for i in range(num_cols + 4)] |
| 1361 | with pytest.raises(GSpreadException): |
| 1362 | self.sheet.insert_row(new_row_values, 1, inherit_from_before=True) |
| 1363 | |
| 1364 | @pytest.mark.vcr() |
| 1365 | def test_insert_cols(self): |
nothing calls this directly
no test coverage detected