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

Class TestConverter

pymysql/tests/test_converters.py:11–105  ·  view source on GitHub ↗

Source from the content-addressed store, hash-verified

9
10
11class TestConverter(TestCase):
12 def test_escape_string(self):
13 self.assertEqual(converters.escape_string("foo\nbar"), "foo\\nbar")
14
15 def test_convert_datetime(self):
16 expected = datetime.datetime(2007, 2, 24, 23, 6, 20)
17 dt = converters.convert_datetime("2007-02-24 23:06:20")
18 self.assertEqual(dt, expected)
19
20 def test_convert_datetime_with_fsp(self):
21 expected = datetime.datetime(2007, 2, 24, 23, 6, 20, 511581)
22 dt = converters.convert_datetime("2007-02-24 23:06:20.511581")
23 self.assertEqual(dt, expected)
24
25 def test_convert_datetime_rejects_non_dot_fraction(self):
26 raw = "2007-02-24 23:06:20X511581"
27 self.assertEqual(converters.convert_datetime(raw), raw)
28
29 def _test_convert_timedelta(self, with_negate=False, with_fsp=False):
30 d = {"hours": 789, "minutes": 12, "seconds": 34}
31 s = "%(hours)s:%(minutes)s:%(seconds)s" % d
32 if with_fsp:
33 d["microseconds"] = 511581
34 s += ".%(microseconds)s" % d
35
36 expected = datetime.timedelta(**d)
37 if with_negate:
38 expected = -expected
39 s = "-" + s
40
41 tdelta = converters.convert_timedelta(s)
42 self.assertEqual(tdelta, expected)
43
44 def test_convert_timedelta(self):
45 self._test_convert_timedelta(with_negate=False, with_fsp=False)
46 self._test_convert_timedelta(with_negate=True, with_fsp=False)
47
48 def test_convert_timedelta_with_fsp(self):
49 self._test_convert_timedelta(with_negate=False, with_fsp=True)
50 self._test_convert_timedelta(with_negate=False, with_fsp=True)
51
52 def test_convert_timedelta_rejects_non_dot_fraction(self):
53 raw = "25:06:17X511581"
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'",

Callers

nothing calls this directly

Calls

no outgoing calls

Tested by

no test coverage detected