arraysize | R/W: Number of rows fetched with fetchmany() (and also fetchall() ?) |
callproc() | Calls a stored procedure. If the procedure produces a resultset, it must be iterated over using fetch() |
connection | Optional, v2 |
description | A sequence where each element describes a column of (select) result set. |
execute() | Prepare and execute a statement. An optional second argument specifies the values that will be bound to variables in the statement (sequence or mapping). |
executemany() | See also arraysize |
fetchall() | Returns a list of tuples containing the query result set's remaining rows. Performance may be affected by value of arraysize property. See also fetchmany(). |
fetchmany() | Fetches a given amount or arraysize records. See also fetchall() |
fetchone() | Returns one record as a tuple (see these SQLite examples) |
lastrowid | Returns the last inserted rowid. |
next() | Optional, v2 |
nextset() | Skip to the next available set. (Optional as not all databases support multiple result sets) |
messages | Optional, v2 |
rowcount | |
rownumber | Optional, v2 |
scroll() | Optional, v2 |
setinputsizes(s) | |
setoutputsize(s[, col]) | |
__iter__ | Optional, v2: Make cursors compatible with the iterable protocol. |
description
The description property is a sequence where each element describes the column (name, datatype, etc.) of a (select) result set.
Each element stores up to seven elements of which the two first are mandatory:
| name | |
| type_code | Note that the implementation for sqlite3 seems to fill this value with None. |
| display_size | |
| internal_size | |
| precision | |
| scale | |
| null_ok | |