MySQLdb.cursors.CursorStoreResultMixIn

Package MySQLdb :: Module cursors :: Class CursorStoreResultMixIn

[show private | hide private]

Type CursorStoreResultMixIn

object --+
         |
        CursorStoreResultMixIn

Known Subclasses:: Cursor, DictCursor

This is a MixIn class which causes the entire result set to be stored on the client side, i.e. it uses mysql_store_result(). If the result set can be very large, consider adding a LIMIT clause to your query, or using CursorUseResultMixIn instead.

Method Summary
	`__iter__(self)`
	`fetchall(self)` Fetchs all available rows from the cursor.
	`fetchmany(self, size)` Fetch up to size rows from the cursor.
	`fetchone(self)` Fetches a single row from the cursor.
	`scroll(self, value, mode)` Scroll the cursor in the result set to a new position according to mode.
Inherited from object
	`__init__(...)` x.__init__(...) initializes x; see x.__class__.__doc__ for signature
	`__delattr__(...)` x.__delattr__('name') <==> del x.name
	`__getattribute__(...)` x.__getattribute__('name') <==> x.name
	`__hash__(x)` x.__hash__() <==> hash(x)
	`__new__(T, S, ...)` T.__new__(S, ...) -> a new object with type S, a subtype of T
	`__reduce__(...)` helper for pickle
	`__reduce_ex__(...)` helper for pickle
	`__repr__(x)` x.__repr__() <==> repr(x)
	`__setattr__(...)` x.__setattr__('name', value) <==> x.name = value
	`__str__(x)` x.__str__() <==> str(x)

Method Details

fetchall(self)

Fetchs all available rows from the cursor.

fetchmany(self, size=None)

Fetch up to size rows from the cursor. Result set may be smaller than size. If size is not defined, cursor.arraysize is used.

fetchone(self)

Fetches a single row from the cursor. None indicates that no more rows are available.

scroll(self, value, mode='relative')

Scroll the cursor in the result set to a new position according to mode.

If mode is 'relative' (default), value is taken as offset to the current position in the result set, if set to 'absolute', value states an absolute target position.

Generated by Epydoc 2.1 on Sat Mar 3 21:14:16 2007

http://epydoc.sf.net