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

Method test_escape_timedelta

pymysql/tests/test_converters.py:56–78  ·  view source on GitHub ↗
(self)

Source from the content-addressed store, hash-verified

54 self.assertEqual(converters.convert_timedelta(raw), raw)
55
56 def test_escape_timedelta(self):
57 # MySQL TIME allows negatives, and a timedelta is the registered param
58 # encoder, so a negative value must escape to its real magnitude with a
59 # single leading sign -- not with complemented sub-hour fields.
60 cases = {
61 datetime.timedelta(hours=1, minutes=30): "'01:30:00'",
62 datetime.timedelta(days=1, hours=2): "'26:00:00'",
63 -datetime.timedelta(minutes=30): "'-00:30:00'",
64 -datetime.timedelta(hours=1, minutes=30): "'-01:30:00'",
65 datetime.timedelta(seconds=83579, microseconds=51000): "'23:12:59.051000'",
66 -datetime.timedelta(
67 seconds=83579, microseconds=51000
68 ): "'-23:12:59.051000'",
69 }
70 for tdelta, expected in cases.items():
71 self.assertEqual(converters.escape_timedelta(tdelta), expected)
72 # the escaped literal must re-parse to the same duration
73 self.assertEqual(
74 converters.convert_timedelta(
75 converters.escape_timedelta(tdelta).strip("'")
76 ),
77 tdelta,
78 )
79
80 def test_convert_time(self):
81 expected = datetime.time(23, 6, 20)

Callers

nothing calls this directly

Calls

no outgoing calls

Tested by

no test coverage detected