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

M.-A. Lemburg mal at egenix.com
Thu May 2 14:16:50 CEST 2013

On 23.04.2013 16:41, Michael Bayer wrote:
> On Apr 23, 2013, at 3:29 AM, M.-A. Lemburg <mal at egenix.com> wrote:
>> A method doing the lookup via the sys.modules dictionary
>> could resolve those issues:
>> database = connection.database()
>> try:
>>    cursor = connection.cursor()
>>    cursor.execute(...)
>> except database.DataError:
>>    ...
>> Thoughts ?
> we probably want to call it "module" or "namespace" or "api" or something like that.   The method itself can be a Python @property which would cause it to behave like an attribute in any case, or if we want to keep it as a method call to make it clear that code is being executed, that's fine as well.    But the spec would need to say in either case, "don't assign the module itself to the connection".

I like the idea with a property. I'm not sure about those other name
candidates, though: "connection.database" make the code very
readable, IMO.

Is there a possible name clash with existing attributes on database
modules that we would need to take into account ?

Another readable candidate would be "connection.dbapi".

Marc-Andre Lemburg

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

More information about the DB-SIG mailing list