Cursor object provides
number of methods to execute stored procedure, get records from database,
execute sql statements, skip records etc.,
Following table
summarizes the methods provided by Cursor class.
Method
|
Description
|
.callproc ( procname
[, parameters ] )
|
Call a database
stored procedure.
|
.close()
|
Close the cursor.
|
.execute ( operation
[, parameters ])
|
Prepare and execute a
database query.
|
.executemany (
operation , seq_of_parameters )
|
Prepare a database
operation and then execute it against all parameter sequences or mappings
found in the sequence seq_of_parameters .
|
.fetchone ()
|
Fetch next row of the
result set
|
.fetchmany ([
size=cursor.arraysize ])
|
Fetch size number of
rows of result set.
|
.fetchall ()
|
Fetch all the rows of
query result
|
.nextset ()
|
This method will make
the cursor skip to the next available set, discarding any remaining rows from
the current set.
|
.arraysize
|
This read/write
attribute specifies the number of rows to fetch at a time with .fetchmany() .
It defaults to 1 meaning to fetch a single row at a time.
|
.setoutputsize ( size
[, column ])
|
Set a column buffer
size for fetches of large columns.
|
No comments:
Post a Comment