summaryrefslogtreecommitdiffstats
path: root/Doc/library/sqlite3.rst
diff options
context:
space:
mode:
authorPetri Lehtinen <petri@digip.org>2012-02-16 19:39:03 (GMT)
committerPetri Lehtinen <petri@digip.org>2012-02-16 19:39:03 (GMT)
commitb3890226b33f86d485dccac309d442b15e766270 (patch)
tree4d4afc7e5b53d7c76fe420dc6974d0eb538c64a8 /Doc/library/sqlite3.rst
parentf670ca5e70962cf7fbc5b1c5758fb70d9c2e0e00 (diff)
downloadcpython-b3890226b33f86d485dccac309d442b15e766270.zip
cpython-b3890226b33f86d485dccac309d442b15e766270.tar.gz
cpython-b3890226b33f86d485dccac309d442b15e766270.tar.bz2
sqlite3: Fix documentation errors concerning Cursor.rowcount
Closes #13995.
Diffstat (limited to 'Doc/library/sqlite3.rst')
-rw-r--r--Doc/library/sqlite3.rst11
1 files changed, 5 insertions, 6 deletions
diff --git a/Doc/library/sqlite3.rst b/Doc/library/sqlite3.rst
index 350950c..f0fd86c 100644
--- a/Doc/library/sqlite3.rst
+++ b/Doc/library/sqlite3.rst
@@ -543,18 +543,17 @@ Cursor Objects
attribute, the database engine's own support for the determination of "rows
affected"/"rows selected" is quirky.
- For ``DELETE`` statements, SQLite reports :attr:`rowcount` as 0 if you make a
- ``DELETE FROM table`` without any condition.
-
For :meth:`executemany` statements, the number of modifications are summed up
into :attr:`rowcount`.
As required by the Python DB API Spec, the :attr:`rowcount` attribute "is -1 in
case no ``executeXX()`` has been performed on the cursor or the rowcount of the
- last operation is not determinable by the interface".
+ last operation is not determinable by the interface". This includes ``SELECT``
+ statements because we cannot determine the number of rows a query produced
+ until all rows were fetched.
- This includes ``SELECT`` statements because we cannot determine the number of
- rows a query produced until all rows were fetched.
+ With SQLite versions before 3.6.5, :attr:`rowcount` is set to 0 if
+ you make a ``DELETE FROM table`` without any condition.
.. attribute:: Cursor.lastrowid