Nav

Top
Examples 0
See Also 0
Notes0

Data Persistence

All modules

Cursor

sqlite3

class

SQLite database cursor class.

© Python Software Foundation. PSF License Version 2 · Official docs ↗

Members of Cursor

a

arraysize: Read/write attribute that controls the number of rows returned by fetchmany().

c

close: Closes the cursor.
connection: Read-only attribute that provides the SQLite database Connection belonging to the cursor.

d

description: Read-only attribute that provides the column names of the last query.

e

execute: Executes an SQL statement.
executemany: Repeatedly executes an SQL statement.
executescript: Executes multiple SQL statements at once.

f

fetchall: Fetches all rows from the resultset.
fetchmany: Fetches several rows from the resultset.
fetchone: Fetches one row from the resultset.

l

lastrowid: Read-only attribute that provides the row id of the last inserted row.

r

row_factory: Control how a row fetched from this Cursor is represented.
rowcount: Read-only attribute that provides the number of modified rows for INSERT, UPDATE, DELETE, and REPLACE statements; is -1 for other statements, including CTE queries.

s

setinputsizes: Required by DB-API.
setoutputsize: Required by DB-API.