diff options
author | Sandrine Ribeau <sandrine.ribeau@logilab.fr> | 2009-05-06 03:30:43 -0700 |
---|---|---|
committer | Sandrine Ribeau <sandrine.ribeau@logilab.fr> | 2009-05-06 03:30:43 -0700 |
commit | ec40d40d45fc7f862155ca976aac7d9d83f14295 (patch) | |
tree | 7d4b3f47204c92184e464170093190432635b46f | |
parent | 7d2f8b5e22a164738983e4f2eda1741aa793fcea (diff) | |
download | logilab-common-ec40d40d45fc7f862155ca976aac7d9d83f14295.tar.gz |
Add adaptater for datetime.
-rw-r--r-- | db.py | 14 |
1 files changed, 12 insertions, 2 deletions
@@ -410,8 +410,18 @@ class _PySqlite2Adapter(DBAPIAdapter): # DateTime used as Time? return strptime(ustr, '%Y-%m-%d %H:%M:%S') sqlite.register_converter('time', convert_mxtime) - # XXX else use datetime.datetime - + # else use datetime.datetime + else: + from datetime import time + def adapt_time(data): + return data.strftime('%H:%M:%S') + sqlite.register_adapter(time, adapt_time) + def convert_time(data): + return time(*[int(i) for i in data.split(':')]) + sqlite.register_converter('time', convert_time) + + + def connect(self, host='', database='', user='', password='', port=None): """Handles sqlite connexion format""" |