(self)
| 140 | |
| 141 | @pytest.mark.vcr() |
| 142 | def test_values_batch_get(self): |
| 143 | sg = self._sequence_generator() |
| 144 | |
| 145 | worksheet1_name = "{} {}".format("🌵", next(sg)) |
| 146 | |
| 147 | worksheet = self.spreadsheet.add_worksheet(worksheet1_name, 10, 10) |
| 148 | |
| 149 | range_label = "{}!{}".format(worksheet1_name, "A1") |
| 150 | |
| 151 | values = [["🍇", "🍉", "🍋"], ["🍐", "🍎", "🍓"]] |
| 152 | |
| 153 | self.spreadsheet.values_update( |
| 154 | range_label, params={"valueInputOption": "RAW"}, body={"values": values} |
| 155 | ) |
| 156 | ranges = [ |
| 157 | "{}!{}:{}".format(worksheet1_name, col, col) for col in ["A", "B", "C"] |
| 158 | ] |
| 159 | |
| 160 | read_data = self.spreadsheet.values_batch_get(ranges) |
| 161 | |
| 162 | for colix, rng in enumerate(read_data["valueRanges"]): |
| 163 | for rowix, ele in enumerate(rng["values"]): |
| 164 | self.assertEqual(values[rowix][colix], ele[0]) |
| 165 | self.spreadsheet.del_worksheet(worksheet) |
| 166 | |
| 167 | @pytest.mark.vcr() |
| 168 | def test_timezone_and_locale(self): |
nothing calls this directly
no test coverage detected