From 7636e9a753e177ddecce18dc5c508bed52d6801b Mon Sep 17 00:00:00 2001 From: Mike Bayer Date: Mon, 20 Feb 2006 16:13:54 +0000 Subject: [PATCH] none check for pg1 date/time values --- lib/sqlalchemy/databases/postgres.py | 15 ++++++++++++--- 1 file changed, 12 insertions(+), 3 deletions(-) diff --git a/lib/sqlalchemy/databases/postgres.py b/lib/sqlalchemy/databases/postgres.py index 011dcfd2ab..2115f5d568 100644 --- a/lib/sqlalchemy/databases/postgres.py +++ b/lib/sqlalchemy/databases/postgres.py @@ -44,7 +44,10 @@ class PG1DateTime(sqltypes.DateTime): def convert_bind_param(self, value, engine): # TODO: perform appropriate postgres1 conversion between Python DateTime/MXDateTime # this one doesnt seem to work with the "emulation" mode - return psycopg.TimestampFromMx(value) + if value is not None: + return psycopg.TimestampFromMx(value) + else: + return None def convert_result_value(self, value, engine): # TODO: perform appropriate postgres1 conversion between Python DateTime/MXDateTime return value @@ -57,7 +60,10 @@ class PG1Date(sqltypes.Date): def convert_bind_param(self, value, engine): # TODO: perform appropriate postgres1 conversion between Python DateTime/MXDateTime # this one doesnt seem to work with the "emulation" mode - return psycopg.DateFromMx(value) + if value is not None: + return psycopg.DateFromMx(value) + else: + return None def convert_result_value(self, value, engine): # TODO: perform appropriate postgres1 conversion between Python DateTime/MXDateTime return value @@ -70,7 +76,10 @@ class PG1Time(sqltypes.Time): def convert_bind_param(self, value, engine): # TODO: perform appropriate postgres1 conversion between Python DateTime/MXDateTime # this one doesnt seem to work with the "emulation" mode - return psycopg.TimeFromMx(value) + if value is not None: + return psycopg.TimeFromMx(value) + else: + return None def convert_result_value(self, value, engine): # TODO: perform appropriate postgres1 conversion between Python DateTime/MXDateTime return value -- 2.47.2