From 68451b990aececc780697ce8b1c7c06e2897bb17 Mon Sep 17 00:00:00 2001 From: =?utf8?q?Ga=C3=ABtan=20de=20Menten?= Date: Fri, 30 Oct 2009 11:37:26 +0000 Subject: [PATCH] get more speed out of the Time type on Mysql --- lib/sqlalchemy/dialects/mysql/base.py | 7 +++++-- 1 file changed, 5 insertions(+), 2 deletions(-) diff --git a/lib/sqlalchemy/dialects/mysql/base.py b/lib/sqlalchemy/dialects/mysql/base.py index e54b7687da..6be6934de5 100644 --- a/lib/sqlalchemy/dialects/mysql/base.py +++ b/lib/sqlalchemy/dialects/mysql/base.py @@ -553,7 +553,7 @@ class BIT(sqltypes.TypeEngine): v = 0L for i in map(ord, value): v = v << 8 | i - value = v + return v return value return process @@ -563,10 +563,13 @@ class _MSTime(sqltypes.Time): __visit_name__ = 'TIME' def result_processor(self, dialect): + time = datetime.time def process(value): # convert from a timedelta value if value is not None: - return datetime.time(value.seconds/60/60, value.seconds/60%60, value.seconds - (value.seconds/60*60)) + seconds = value.seconds + minutes = seconds / 60 + return time(minutes / 60, minutes % 60, seconds - minutes * 60) else: return None return process -- 2.47.2