Postgres Pro
Downloads
Home   >   mailing lists

Thread: Number of deleted rows in Python module

Number of deleted rows in Python module

From
Dorian Tessore
Date:
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

Re: Number of deleted rows in Python module

From
"D'Arcy J.M. Cain"
Date:
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.

Re: Number of deleted rows in Python module

From
Gerhard Häring
Date:
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