[DB-SIG] checking column types from cursor object in a database-independent way?

[Vernon D. Cole]

So -- here is a prototype...


> >>> import adodbapi
>
> >>> c = adodbapi.connect("provider=Microsoft.ACE.OLEDB.12.0;data
>> source=../examples/test.mdb")
>
> >>> c
>
> <adodbapi.adodbapi.Connection object at 0x0000000001ECDF60>
>
> >>> c.dbapi
>
> <module 'adodbapi.apibase' from
>> 'C:\Python27\lib\site-packages\adodbapi\apibase.
>
> pyc'>
>
> >>> c.dbapi.NUMBER
>
> <adodbapi.apibase.DBAPITypeObject object at 0x00000000025E8358>
>
>
My implementation is:


> import apibase as api

class Connection(object):

    # include connection attributes as class attributes required by api
> definition.

    dbapi = property(lambda cls: api)

    Warning = api.Warning

 ... (etc.)
>

Is that what we want to see?
--
Vernon Cole



On Thu, May 2, 2013 at 8:54 AM, M.-A. Lemburg <mal at egenix.com> wrote:

> On 02.05.2013 15:53, Michael Bayer wrote:
> >> Another readable candidate would be "connection.dbapi".
> >
> > +1 for connection.dbapi
>
> Sounds like we're reaching consensus :-)
>
> --
> Marc-Andre Lemburg
> eGenix.com
>
> Professional Python Services directly from the Source  (#1, May 02 2013)
> >>> Python Projects, Consulting and Support ...   http://www.egenix.com/
> >>> mxODBC.Zope/Plone.Database.Adapter ...       http://zope.egenix.com/
> >>> mxODBC, mxDateTime, mxTextTools ...        http://python.egenix.com/
> ________________________________________________________________________
> 2013-04-30: Released eGenix PyRun 1.2.0 ...       http://egenix.com/go44
>
> ::::: Try our mxODBC.Connect Python Database Interface for free ! ::::::
>
>    eGenix.com Software, Skills and Services GmbH  Pastor-Loeh-Str.48
>     D-40764 Langenfeld, Germany. CEO Dipl.-Math. Marc-Andre Lemburg
>            Registered at Amtsgericht Duesseldorf: HRB 46611
>                http://www.egenix.com/company/contact/
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.python.org/pipermail/db-sig/attachments/20130502/3bef9f91/attachment.html>