Обсуждение: Number of deleted rows in Python module

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.
Normally I use :
db = pg.connect( ...)
res=db.query("delete from mytable")

But now I don't know how many rows have been deleted.
(The function res.ntuples() works only for a select statement)

Can anybody help me?
Thank you
Dorian

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.

-- 
D'Arcy J.M. Cain <darcy@{druid|vex}.net>   |  Democracy is three wolves
http://www.druid.net/darcy/                |  and a sheep voting on
+1 416 425 1212     (DoD#0082)    (eNTP)   |  what's for dinner.

D'Arcy J.M. Cain <darcy@druid.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