Re: Number of deleted rows in Python module

D'Arcy J.M. Cain <darcy(at)druid(dot)net> [2002-10-06 11:18 GMT]:
> On October 2, 2002 08:59 am, Dorian Tessore wrote:
>> Hi every body,
>> It's the first time that I post to this list, so please excuse me if the
>> question is not in the right list.
>>
>>
>> My SW: Python 1.5.2; pgsql/v7.1.3; RedHat 7.2
>>
>> My question:
>> Is there a way of knowing how many rows have been deleted or updated when
>> sending a query from a python script to pgsql.
>
> Not yet. I would like to make this available using PQcmdTuples but I can
> only do so in the classic (import pg) module as I am not sure that the DB-API
> interface (import pgdb) even allows for this to be returned.

You can return it as return value of cursor.execute. Normally this method
doesn't return anything, but IMO it's safe to return the number of changed rows
there, and some DB-API modules do so. I plan to introduce this feature in
pyPgSQL, too.

-- Gerhard