Returns a TIME column as a timedelta object: >>> convert_timedelta('25:06:17') datetime.timedelta(days=1, seconds=3977) >>> convert_timedelta('-25:06:17') datetime.timedelta(days=-2, seconds=82423) Illegal values are returned as string: >>> convert_timedelta('ran
(obj)
| 197 | |
| 198 | |
| 199 | def convert_timedelta(obj): |
| 200 | """Returns a TIME column as a timedelta object: |
| 201 | |
| 202 | >>> convert_timedelta('25:06:17') |
| 203 | datetime.timedelta(days=1, seconds=3977) |
| 204 | >>> convert_timedelta('-25:06:17') |
| 205 | datetime.timedelta(days=-2, seconds=82423) |
| 206 | |
| 207 | Illegal values are returned as string: |
| 208 | |
| 209 | >>> convert_timedelta('random crap') |
| 210 | 'random crap' |
| 211 | |
| 212 | Note that MySQL always returns TIME columns as (+|-)HH:MM:SS, but |
| 213 | can accept values as (+|-)DD HH:MM:SS. The latter format will not |
| 214 | be parsed correctly by this function. |
| 215 | """ |
| 216 | if isinstance(obj, (bytes, bytearray)): |
| 217 | obj = obj.decode("ascii") |
| 218 | |
| 219 | m = TIMEDELTA_RE.fullmatch(obj) |
| 220 | if not m: |
| 221 | return obj |
| 222 | |
| 223 | try: |
| 224 | groups = list(m.groups()) |
| 225 | groups[-1] = _convert_second_fraction(groups[-1]) |
| 226 | negate = -1 if groups[0] else 1 |
| 227 | hours, minutes, seconds, microseconds = groups[1:] |
| 228 | |
| 229 | tdelta = ( |
| 230 | datetime.timedelta( |
| 231 | hours=int(hours), |
| 232 | minutes=int(minutes), |
| 233 | seconds=int(seconds), |
| 234 | microseconds=int(microseconds), |
| 235 | ) |
| 236 | * negate |
| 237 | ) |
| 238 | return tdelta |
| 239 | except ValueError: |
| 240 | return obj |
| 241 | |
| 242 | |
| 243 | TIME_RE = re.compile(r"(\d{1,2}):(\d{1,2}):(\d{1,2})(?:\.(\d{1,6}))?") |
nothing calls this directly
no test coverage detected