Trees | Indices | Help |
---|
|
object --+ | BaseCursor
A base for Cursor classes. Useful attributes:
description:
A tuple of DB API 7-tuples describing the columns in the last executed query; see PEP-249 for details.
arraysize:
default number of rows fetchmany() will fetch
|
|||
|
|||
|
|||
|
|||
|
|||
|
|||
|
|||
|
|||
|
|||
|
|||
|
|||
|
|||
|
|||
|
|||
|
|||
|
|||
|
|||
|
|||
|
|||
|
|||
Inherited from |
|
|||
Inherited from |
|
x.__init__(...) initializes x; see help(type(x)) for signature
|
Close the cursor. No further queries will be possible. |
Execute a query. query -- string, query to execute on server args -- optional sequence or mapping, parameters to use with query. Returns long integer rows affected, if any |
Execute a multi-row query. query -- string, query to execute on server args -- Sequence of sequences or mappings, parameters to use with query Returns long integer rows affected, if any. This method improves performance on multiple-row INSERT and REPLACE. Otherwise it is equivalent to looping over args with execute(). |
Fetch the next set of rows of a query result, returning a sequence of sequences (e.g. a list of tuples). An empty sequence is returned when no more rows are available. The number of rows to fetch per call is specified by the parameter. If it is not given, the cursor's arraysize determines the number of rows to be fetched. The method should try to fetch as many rows as indicated by the size parameter. If this is not possible due to the specified number of rows not being available, fewer rows may be returned. |
Fetch all (remaining) rows of a query result, returning them as a sequence of sequences (e.g. a list of tuples). Note that the cursor's arraysize attribute can affect the performance of this operation. |
Advance to the next result set. Returns None if there are no more result sets. |
Execute stored procedure procname with args procname -- string, name of procedure to execute on server args -- Sequence of parameters to use with procedure Returns the original args. |
Return the next row from the currently executing SQL statement using the same semantics as fetchone(). A StopIteration exception is raised when the result set is exhausted for Python versions 2.2 and later. |
Trees | Indices | Help |
---|
Generated by Epydoc 3.0.1 on Fri Mar 28 11:21:57 2014 | http://epydoc.sourceforge.net |