[DB-SIG] Insert for Oracledb
Sat, 22 Nov 1997 17:13:13 -0800
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
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.
Not speaking for Microsoft, etc..
> -----Original Message-----
> From: M.-A. Lemburg [SMTP:firstname.lastname@example.org]
> 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
> > and performed the command for each of them, although it's not really
> > 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: email@example.com
> administrivia to: firstname.lastname@example.org
DB-SIG - SIG on Tabular Databases in Python
send messages to: email@example.com
administrivia to: firstname.lastname@example.org