diff options
| author | Mike Bayer <mike_mp@zzzcomputing.com> | 2006-02-20 16:13:54 +0000 |
|---|---|---|
| committer | Mike Bayer <mike_mp@zzzcomputing.com> | 2006-02-20 16:13:54 +0000 |
| commit | 7636e9a753e177ddecce18dc5c508bed52d6801b (patch) | |
| tree | e8f0a8facb818b36fbe3fff5de2ce10a390c0132 /lib/sqlalchemy/databases/postgres.py | |
| parent | 36383494b512143328d3c14022d4db3ccedfdf06 (diff) | |
| download | sqlalchemy-7636e9a753e177ddecce18dc5c508bed52d6801b.tar.gz | |
none check for pg1 date/time values
Diffstat (limited to 'lib/sqlalchemy/databases/postgres.py')
| -rw-r--r-- | lib/sqlalchemy/databases/postgres.py | 15 |
1 files changed, 12 insertions, 3 deletions
diff --git a/lib/sqlalchemy/databases/postgres.py b/lib/sqlalchemy/databases/postgres.py index 011dcfd2a..2115f5d56 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 |