Home | Trees | Index | Help |
---|
|
object
--+
|
cursor
cursor
,
DictCursor
A database cursor.
Method Summary | |
---|---|
x.__init__(...) initializes x; see x.__class__.__doc__ for signature | |
__iter__(x)
Return iter(x)... | |
__new__(T,
S,
...)
Return a new object with type S, a subtype of T... | |
__repr__(x)
Return repr(x)... | |
__str__(x)
Return str(x)... | |
Execute stored procedure. | |
Close the cursor. | |
Copy table from file. | |
Copy table to file. | |
Execute query with bound vars. | |
Execute many queries with bound vars. | |
list of tuple |
Return all the remaining rows of a query result set. |
list of tuple |
Return the next size rows of a query result set in the form of a list
of tuples (by default) or using the sequence factory previously set in
the row_factory attribute. |
tuple or None |
Return the next row of a query result set in the form of a tuple (by default) or using the sequence factory previously set in the row_factory attribute. |
int |
Return file descriptor associated to database connection. |
bool |
Return True if data is ready after an async query. |
str |
Return query after vars binding. |
next(x)
Return the next value, or raise StopIteration... | |
Skip to next set of data. | |
Scroll to new position according to mode. | |
Set memory areas before execute. | |
Set column buffer size. | |
Inherited from object | |
x.__delattr__('name') <==> del x.name | |
x.__getattribute__('name') <==> x.name | |
Return hash(x)... | |
helper for pickle | |
helper for pickle | |
x.__setattr__('name', value) <==> x.name = value |
Property Summary | |
---|---|
arraysize : Number of records fetchmany() must fetch if not explicitely specified. | |
binary_types | |
connection : The connection where the cursor comes from. | |
description : Cursor description as defined in DBAPI-2.0. | |
lastrowid : The oid of the last row inserted by the cursor. | |
name | |
query : The last query text sent to the backend. | |
row_factory | |
rowcount : Number of rows read from the backend in the last command. | |
rownumber : The current row position. | |
statusmessage : The return message of the last command. | |
string_types | |
typecaster | |
tzinfo_factory |
Method Details |
---|
__init__(...)
|
__iter__(x)
|
__new__(T, S, ...)
|
__repr__(x)
|
__str__(x)
|
callproc(procname, parameters=None, async=0)Execute stored procedure. |
close()Close the cursor. |
copy_from(file, table, sep='\t', null='\N')Copy table from file. |
copy_to(file, table, sep='\t', null='\N')Copy table to file. |
execute(query, vars=None, async=0)Execute query with bound vars. |
executemany(query, vars_list=(), async=0)Execute many queries with bound vars. |
fetchall()Return all the remaining rows of a query result set. Rows are returned in the form of a list of tuples (by default) or using
the sequence factory previously set in the
|
fetchmany(size=self.arraysize)Return the next
|
fetchone()Return the next row of a query result set in the form of a tuple (by
default) or using the sequence factory previously set in the
|
fileno()Return file descriptor associated to database connection.
|
isready()Return True if data is ready after an async query.
|
mogrify(query, vars=None)Return query after vars binding.
|
next(x)
|
nextset()Skip to next set of data. This method is not supported (PostgreSQL does not have multiple data sets) and will raise a NotSupportedError exception. |
scroll(value, mode='relative')Scroll to new position according to mode. |
setinputsizes(sizes)Set memory areas before execute. This method currently does nothing but it is safe to call it. |
setoutputsize(size, column=None)Set column buffer size. This method currently does nothing but it is safe to call it. |
Property Details |
---|
arraysizeNumber of records |
connectionThe connection where the cursor comes from. |
descriptionCursor description as defined in DBAPI-2.0. |
lastrowidThe oid of the last row inserted by the cursor. |
queryThe last query text sent to the backend. |
rowcountNumber of rows read from the backend in the last command. |
rownumberThe current row position. |
statusmessageThe return message of the last command. |
Home | Trees | Index | Help |
---|
Generated by Epydoc 2.1 on Sat Jan 14 01:42:34 2006 | http://epydoc.sf.net |