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

2013-05-02 Thread Vernon D. Cole
I forgot: pywin32 just dropped support for Python 2.3 so I can use decorators now. Michael, you have just contributed four lines of code to the next version of adodbapi. -- Vernon On Thu, May 2, 2013 at 11:30 AM, Michael Bayer wrote: > > On May 2, 2013, at 1:12 PM, Vernon D. Cole wrote: > > S

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

2013-05-02 Thread Michael Bayer
On May 2, 2013, at 1:12 PM, Vernon D. Cole wrote: > So -- here is a prototype... > > >>> import adodbapi > >>> c = adodbapi.connect("provider=Microsoft.ACE.OLEDB.12.0;data > >>> source=../examples/test.mdb") > >>> c > > >>> c.dbapi > 'C:\Python27\lib\site-packages\adodbapi\apibase. > pyc'>

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

2013-05-02 Thread 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 > > > > >>> c.dbapi > > > 'C:\Python27\lib\site-packages\adodbapi\apibase. > > pyc'> > > >>> c.dbapi.NUMBER > > > > My implementatio

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

2013-05-02 Thread M.-A. Lemburg
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 Project

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

2013-05-02 Thread Michael Bayer
On May 2, 2013, at 8:16 AM, M.-A. Lemburg wrote: > > 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 wo

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

2013-05-02 Thread M.-A. Lemburg
On 23.04.2013 17:00, Daniel Lenski wrote: > On Tue, Apr 23, 2013 at 12:29 AM, M.-A. Lemburg wrote: >> >> I don't think we should clutter up the connection objects with >> module scope attributes that hardly ever get used. >> >> The exceptions are used a lot, so it makes sense to have them >> easil

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

2013-05-02 Thread Vernon D. Cole
I think that "database" as the property identifier carries too much baggage -- there are too many meanings of, and too much use of the term, therefore it is not immediately obvious what the property might be used for. It reads well, but does not have an "ahha!" factor. connection.dbapi does. I t

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

2013-05-02 Thread M.-A. Lemburg
On 23.04.2013 16:41, Michael Bayer wrote: > > On Apr 23, 2013, at 3:29 AM, M.-A. Lemburg wrote: > >> >> >> A method doing the lookup via the sys.modules dictionary >> could resolve those issues: >> >> database = connection.database() >> try: >>cursor = connection.cursor() >>cursor.execut