[DB-SIG] RE: column type casting

Dittmar, Daniel daniel.dittmar@sap.com
Fri, 23 Mar 2001 10:32:10 +0100

> Data handlers are one way to do this. In mxODBC I chose the positional
> approach for the converter function. Still missing is some sort
> of generic data input/output handler device. I remember that 
> Andy's MySQL
> module has a nice way to this -- it's easy for him though, because
> most of his code is in Python which is simple to extend by 
> subclassing.
> One way to implement this would be by using callbacks which are
> triggered by certain type mappings. They are cumbersome to use
> though...

In sapdbapi, you can
- install data handler for each column of a cursor
- use the connection to specify data handlers for specific types which are
then used for every cursor

In addition, there are some default handler for date/time types: conversion
from the internal format to either <module time> tuples or to strings using
a time.strftime format.

Yet another thing we could standardize on (although maybe we should ask a
few users what they found useful).


Daniel Dittmar
SAP DB, SAP Labs Berlin