Database experiences in Python: Good or Bad?
daniel.dittmar at sap.com
Wed Aug 14 15:52:01 CEST 2002
Brad Clements wrote:
> What's killing me today is that sapdbapi doesn't represent
> times/dates as class objects, like I got with gvibDA.. I have a lot
> of XSLT code that uses xml_pickle objects.. and a pickled timestamp
> from gvib doesn't look anything like that from SAP.
> In fact, SAP timestamps are 20 character strings.. really ugly.
It is easy to register conversion callbacks with sapdbapi.
- write conversion functions from the SAP DB values to any
object/representation you like
- create a dictionary which maps the SAP DB type names 'Date', 'Time',
'Timestamp' to those functions
- connection.setTypeTranslation (conversionMapping)
see the end of sapdbapi.py for examples like converting to module time
SAP DB, SAP Labs Berlin
More information about the Python-list