Re: [DB-SIG] Proposed improvements to DBAPI 2.0 Cursor.execute() method.

2006-11-13 Thread Carsten Haese
On Mon, 2006-11-13 at 11:28 -0500, Art Protin wrote: > I just looked at Martin's suggestions and I find some theoretical > problems. I had been left with the impression that the "operation" > given as an argument to the .execute() method was SQL but on rereading > the specification (PEP 249) I d

Re: [DB-SIG] Proposed improvements to DBAPI 2.0 Cursor.execute() method.

2006-11-13 Thread Ricardo Bugalho
On Mon, 2006-11-13 at 02:17 -0500, Martin Blais wrote: > > "Martin Blais" writes: > > > > > I want to propose a few improvements on the DBAPI 2.0 Cursor.execute() > > > method interface. You can find the details of my proposed changes > > > here: > > > http://furius.ca/pubcode/pub/conf/common/lib

Re: [DB-SIG] Proposed improvements to DBAPI 2.0 Cursor.execute() method.

2006-11-13 Thread Art Protin
Dear folks,     Martin Blais wrote: [snipped attribution to Paul Moore restored] > Paul Moore wrote: "Martin Blais" writes: I want to propose a few improvements on the DBAPI 2.0 Cursor.execute() method interface. You can find the details of my proposed changes

Re: [DB-SIG] Proposed improvements to DBAPI 2.0 Cursor.execute() method.

2006-11-13 Thread Carsten Haese
On Mon, 2006-11-13 at 02:17 -0500, Martin Blais wrote: [snipped attribution to Paul Moore restored] > Paul Moore wrote: > > "Martin Blais" writes: > > > > > I want to propose a few improvements on the DBAPI 2.0 Cursor.execute() > > > method interface. You can find the details of my proposed chang

Re: [DB-SIG] Proposed improvements to DBAPI 2.0 Cursor.execute() method.

2006-08-18 Thread Nicolas Grilly
On 8/17/06, Paul Moore <[EMAIL PROTECTED]> wrote: > However, you assume that the "second stage", of adding variable > bindings supplied in the cursor.execute call, is also a string > formatting exercise (just with automatic escaping). This is most > certainly not the case in Oracle - the query is s

Re: [DB-SIG] Proposed improvements to DBAPI 2.0 Cursor.execute() method.

2006-08-17 Thread Paul Moore
"Martin Blais" <[EMAIL PROTECTED]> writes: > I want to propose a few improvements on the DBAPI 2.0 Cursor.execute() > method interface. You can find the details of my proposed changes > here: > http://furius.ca/pubcode/pub/conf/common/lib/python/dbapiext.html The model of query execution you are

Re: [DB-SIG] Proposed improvements to DBAPI 2.0 Cursor.execute() method.

2006-08-16 Thread M.-A. Lemburg
Ian Bicking wrote: >> Martin Blais wrote: >>> I want to propose a few improvements on the DBAPI 2.0 Cursor.execute() >>> method interface. You can find the details of my proposed changes >>> here: >>> http://furius.ca/pubcode/pub/conf/common/lib/python/dbapiext.html >>> >>> And a pure-Python preli

Re: [DB-SIG] Proposed improvements to DBAPI 2.0 Cursor.execute() method.

2006-08-16 Thread Ian Bicking
> Martin Blais wrote: >> I want to propose a few improvements on the DBAPI 2.0 Cursor.execute() >> method interface. You can find the details of my proposed changes >> here: >> http://furius.ca/pubcode/pub/conf/common/lib/python/dbapiext.html >> >> And a pure-Python preliminary implementation of t

Re: [DB-SIG] Proposed improvements to DBAPI 2.0 Cursor.execute() method.

2006-08-16 Thread M.-A. Lemburg
Harald Armin Massa wrote: > I skimmed them, and in my eyes these changes involve a bit too much > magic to > be helpfull in the full range of database accesses. > > "Since columns is a sequence, and sequences in SQL are always joined by > ,, " > That is clearly wrong. With the SQL engine I use (Po

Re: [DB-SIG] Proposed improvements to DBAPI 2.0 Cursor.execute() method.

2006-08-16 Thread Harald Armin Massa
I skimmed them, and in my eyes these changes involve a bit too much magic to be helpfull in the full range of database accesses."Since columns is a sequence, and sequences in SQL are always joined by ,, "That is clearly wrong. With the SQL engine I use (PostgreSQL); there is the data type of "ARRAY

Re: [DB-SIG] Proposed improvements to DBAPI 2.0 Cursor.execute() method.

2006-08-15 Thread Eric Brunson
Martin Blais wrote: > Hi > > I want to propose a few improvements on the DBAPI 2.0 Cursor.execute() > method interface. You can find the details of my proposed changes > here: > http://furius.ca/pubcode/pub/conf/common/lib/python/dbapiext.html > > And a pure-Python preliminary implementation of th