[DB-SIG] Positioned Update/Delete
Thu, 23 Apr 1998 09:08:54 -0700 (PDT)
On Thu, 23 Apr 1998 email@example.com wrote:
> On Thu, 23 Apr 1998, Dr. Dieter Maurer wrote:
> > How should positioned update/delete be best used with the DB-API:
> > 1. cursor.execute("update set ... where CURRENT")
> > 2. cursor.execute("update set ... where CURRENT of SELF")
> > 3. cursor.execute("update set ... where CURRENT of %s" % str(cursor))
> > 4. cursor.execute("update set ... where CURRENT of ?",(cursor,))
> 4a. cursor.execute("update TABLE set CURRENT = ?", (current,))
> Assuming you are using an SQL-89 or so database; the API doesn't really
> specify the query language syntax.
Just as a note of interest, Sybase's client library (ct) supports
client-side cursors, which means that I will have to superset DBAPI a
little to support them. I think it will be just a matter of adding update
and delete methods to the cursor type. Do any of the other APIs support
client-side cursors? In Sybase parlance, the above discussion
would be about "Language cursors".
So I guess there will be
5. cursor.update("set ...")
for Sybase. What do
people feel about making this feature a part of basic DBAPI?