[DB-SIG] First patch to DBAPI

Federico Di Gregorio fog@mixadlive.com
Sat, 24 Mar 2001 02:34:48 +0100

Scavenging the mail folder uncovered M.-A. Lemburg's letter:
> Federico Di Gregorio wrote:
> >           Modules are free to implement this method using multiple
> >           calls to the <CODE>execute()</CODE> method or by using
> >           array operations to have the database process the
> >           ^^^^^^^^^^^^^^^^
> >           sequence as a whole in one call.
> >                    ^^^^^^^^^^
> This refers to the use of .executemany() for INSERT and UPDATE
> operations which do not return any result sets. Back when we
> introduced the API we never even thought of using it for SELECT
> and multiple result sets.

ah, ok.

> I think we should simply clarify that using SELECTs with 
> .executemany() is explicitly left undefined by the DB API spec and
> that using the API for SELECTs will result in non-portable code.

i agree. if nobody has something to add to this topic i'll add
this one to the next set of patches.


Federico Di Gregorio
MIXAD LIVE Chief of Research & Technology              fog@mixadlive.com
Debian GNU/Linux Developer & Italian Press Contact        fog@debian.org
   God is real. Unless declared integer. -- Anonymous FORTRAN programmer