test timedelta conversion
(self)
| 167 | self.assertEqual(("", None), c.fetchone()) |
| 168 | |
| 169 | def test_timedelta(self): |
| 170 | """test timedelta conversion""" |
| 171 | conn = self.connect() |
| 172 | c = conn.cursor() |
| 173 | c.execute( |
| 174 | "select time('12:30'), time('23:12:59'), time('23:12:59.05100')," |
| 175 | + " time('-12:30'), time('-23:12:59'), time('-23:12:59.05100'), time('-00:30')" |
| 176 | ) |
| 177 | self.assertEqual( |
| 178 | ( |
| 179 | datetime.timedelta(0, 45000), |
| 180 | datetime.timedelta(0, 83579), |
| 181 | datetime.timedelta(0, 83579, 51000), |
| 182 | -datetime.timedelta(0, 45000), |
| 183 | -datetime.timedelta(0, 83579), |
| 184 | -datetime.timedelta(0, 83579, 51000), |
| 185 | -datetime.timedelta(0, 1800), |
| 186 | ), |
| 187 | c.fetchone(), |
| 188 | ) |
| 189 | |
| 190 | def test_datetime_microseconds(self): |
| 191 | """test datetime conversion w microseconds""" |