diff options
author | adustman <adustman@9fc6cd9a-920d-0410-adcf-ac96716ed7e8> | 2001-04-10 15:19:50 +0000 |
---|---|---|
committer | adustman <adustman@9fc6cd9a-920d-0410-adcf-ac96716ed7e8> | 2001-04-10 15:19:50 +0000 |
commit | 759ef1c9873956ba6357d649b59e2951e7ae2726 (patch) | |
tree | fe764ebed61e4865dcb040ef8ca0e83682bf9529 /ZMySQLDA | |
parent | 935a34173cd396689177055ca705e3ec31a66d8b (diff) | |
download | mysqldb1-759ef1c9873956ba6357d649b59e2951e7ae2726.tar.gz |
Work around MySQL zero date conflict with DateTime.
Diffstat (limited to 'ZMySQLDA')
-rw-r--r-- | ZMySQLDA/lib/python/Products/ZMySQLDA/db.py | 9 |
1 files changed, 6 insertions, 3 deletions
diff --git a/ZMySQLDA/lib/python/Products/ZMySQLDA/db.py b/ZMySQLDA/lib/python/Products/ZMySQLDA/db.py index 929d665..d463cd5 100644 --- a/ZMySQLDA/lib/python/Products/ZMySQLDA/db.py +++ b/ZMySQLDA/lib/python/Products/ZMySQLDA/db.py @@ -105,6 +105,9 @@ def _mysql_timestamp_converter(s): s[8:10],s[10:12],s[12:14])) return DateTime("%04d-%02d-%02d %02d:%02d:%02d" % tuple(parts)) +def DateTime_or_None(s): + try: return DateTime(s) + except: return None class DB(TM): @@ -143,9 +146,9 @@ class DB(TM): FIELD_TYPE.LONGLONG: long, FIELD_TYPE.INT24: int, FIELD_TYPE.YEAR: int, - FIELD_TYPE.DATETIME: DateTime, - FIELD_TYPE.DATE: DateTime, - FIELD_TYPE.TIME: DateTime + FIELD_TYPE.DATETIME: DateTime_or_None, + FIELD_TYPE.DATE: DateTime_or_None, + FIELD_TYPE.TIME: DateTime_or_None } _p_oid=_p_changed=_registered=None |