[DB-SIG] Insert for Oracledb

[Bill Tutt]

M-A is correct in that is the say things should happen, but oracledb-0.1.3
doesn't do that currently.
Neither does the Win32 ODBC module either.. (All patches to fix the problem
graciouslly excepted).

Passing a tuple of tuples to an insert() should ONLY be used inside a
transaction, because if you don't
you won't know where in the #  of rows to insert, the failure occurred.. 
Wether this is a good thing or bad thing depends on your situtation.

Bill Tutt
Not speaking for Microsoft, etc..

> -----Original Message-----
> From:	M.-A. Lemburg [SMTP:lemburg@uni-duesseldorf.de]
> Sent:	Saturday, November 22, 1997 7:56 AM
> To:	db
> Subject:	Re: [DB-SIG] Insert for Oracledb
> 
> Magnus Lycka wrote:
> > I understand that you get the impression that you would be able to do
> > multiple inserts from the DBI spec though. I honestly don't know what
> > the list-of-tuples is for. Can anyone enlighten me about that? It would
> > be nice if it looped through a supplied list if it recieved several
> tuples
> > and performed the command for each of them, although it's not really
> something
> > you need, and if you have several inserts of updates, you will probably
> > want to
> > check for error conditions after each one anyway (although that might
> not be
> > a problem if exceptions are used in a proper way I guess).
> 
> There seems to be a misunderstanding here:
> 
> If you pass a list of tuples to the cursor.execute() method as
> parameter, then the command given will be executed for each tuple
> in the list. The implementation can do this either in one go, or
> a by calling the execute API for every item.
> 
> -- 
> Marc-Andre Lemburg
> 
> 
> 
> _______________
> DB-SIG  - SIG on Tabular Databases in Python
> 
> send messages to: db-sig@python.org
> administrivia to: db-sig-request@python.org
> _______________

_______________
DB-SIG  - SIG on Tabular Databases in Python

send messages to: db-sig@python.org
administrivia to: db-sig-request@python.org
_______________