Class TestConverter

pymysql/tests/test_converters.py:11–93

class TestConverter(TestCase):
    def test_escape_string(self):
        self.assertEqual(converters.escape_string("foo\nbar"), "foo\\nbar")

    def test_convert_datetime(self):
        expected = datetime.datetime(2007, 2, 24, 23, 6, 20)
        dt = converters.convert_datetime("2007-02-24 23:06:20")
        self.assertEqual(dt, expected)

    def test_convert_datetime_with_fsp(self):
        expected = datetime.datetime(2007, 2, 24, 23, 6, 20, 511581)
        dt = converters.convert_datetime("2007-02-24 23:06:20.511581")
        self.assertEqual(dt, expected)

    def _test_convert_timedelta(self, with_negate=False, with_fsp=False):
        d = {"hours": 789, "minutes": 12, "seconds": 34}
        s = "%(hours)s:%(minutes)s:%(seconds)s" % d
        if with_fsp:
            d["microseconds"] = 511581
            s += ".%(microseconds)s" % d

        expected = datetime.timedelta(**d)
        if with_negate:
            expected = -expected
            s = "-" + s

        tdelta = converters.convert_timedelta(s)
        self.assertEqual(tdelta, expected)

    def test_convert_timedelta(self):
        self._test_convert_timedelta(with_negate=False, with_fsp=False)
        self._test_convert_timedelta(with_negate=True, with_fsp=False)

    def test_convert_timedelta_with_fsp(self):
        self._test_convert_timedelta(with_negate=False, with_fsp=True)
        self._test_convert_timedelta(with_negate=False, with_fsp=True)

    def test_escape_timedelta(self):
        # MySQL TIME allows negatives, and a timedelta is the registered param
        # encoder, so a negative value must escape to its real magnitude with a
        # single leading sign -- not with complemented sub-hour fields.
        cases = {
            datetime.timedelta(hours=1, minutes=30): "'01:30:00'",
            datetime.timedelta(days=1, hours=2): "'26:00:00'",
            -datetime.timedelta(minutes=30): "'-00:30:00'",
            -datetime.timedelta(hours=1, minutes=30): "'-01:30:00'",
            datetime.timedelta(seconds=83579, microseconds=51000): "'23:12:59.051000'",
            -datetime.timedelta(
                seconds=83579, microseconds=51000
            ): "'-23:12:59.051000'",
        }
        for tdelta, expected in cases.items():
            self.assertEqual(converters.escape_timedelta(tdelta), expected)
            # the escaped literal must re-parse to the same duration
            self.assertEqual(
                converters.convert_timedelta(
                    converters.escape_timedelta(tdelta).strip("'")
                ),