| 9 | |
| 10 | |
| 11 | class 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'", |
nothing calls this directly
no outgoing calls
no test coverage detected