[prev in list] [next in list] [prev in thread] [next in thread] 

List:       python-list
Subject:    Re: Possible to determine number of rows affected by a SQLite update
From:       Kushal Kumaran <kushal.kumaran+python () gmail ! com>
Date:       2010-11-30 9:33:14
Message-ID: AANLkTiktN7CMmhDenNw73h-zxRraO6gT0r2f-e1uEjQc () mail ! gmail ! com
[Download RAW message or body]

On Tue, Nov 30, 2010 at 2:29 PM,  <python@bdurham.com> wrote:
> Is there a cursor or connection property that returns the number of rows
> affected by a SQLite update or delete command?
>

The cursor has a rowcount attribute.  The documentation of the sqlite3
module says the implementation is "quirky".  You might take a look at
it and see if it fits your needs.

> Or, if we want this information, do we have to pre-query our database for a
> count of records that will be affected by an operation?
>

-- 
regards,
kushal
-- 
http://mail.python.org/mailman/listinfo/python-list
[prev in list] [next in list] [prev in thread] [next in thread]