From f8d89434386202034d85cdc50b16b30f25d27d76 Mon Sep 17 00:00:00 2001 From: Mike Bayer Date: Wed, 25 Jun 2014 14:23:27 -0400 Subject: [PATCH] - add a test to confirm #3096, we definitely get a timedelta --- test/dialect/mysql/test_types.py | 10 ++++++++++ 1 file changed, 10 insertions(+) diff --git a/test/dialect/mysql/test_types.py b/test/dialect/mysql/test_types.py index 5837504221..b7d261a886 100644 --- a/test/dialect/mysql/test_types.py +++ b/test/dialect/mysql/test_types.py @@ -514,6 +514,16 @@ class TypesTest(fixtures.TestBase, AssertsExecutionResults, AssertsCompiledSQL): datetime.time(8, 37, 35, 450) ) + @testing.only_if('mysql') + @testing.provide_metadata + def test_time_roundtrip(self): + t = Table('mysql_time', self.metadata, + Column('t1', mysql.TIME()) + ) + t.create() + t.insert().values(t1=datetime.time(8, 37, 35)).execute() + eq_(select([t.c.t1]).scalar(), datetime.time(8, 37, 35)) + @testing.only_if('mysql') @testing.provide_metadata def test_year(self): -- 2.47.3