MCPcopy Create free account
hub / github.com/PyMySQL/PyMySQL / convert_timedelta

Function convert_timedelta

pymysql/converters.py:199–240  ·  view source on GitHub ↗

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)

Source from the content-addressed store, hash-verified

197
198
199def 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
243TIME_RE = re.compile(r"(\d{1,2}):(\d{1,2}):(\d{1,2})(?:\.(\d{1,6}))?")

Callers

nothing calls this directly

Calls 1

_convert_second_fractionFunction · 0.85

Tested by

no test coverage detected