psycopg2.psycopg1.cursor

Package psycopg2 :: Module psycopg1 :: Class cursor

[show private | hide private]

Type cursor

object --+    
         |    
    cursor --+
             |
            cursor

psycopg 1.1.x cursor.

Note that this cursor implements the exact procedure used by psycopg 1 to build dictionaries out of result rows. The DictCursor in the psycopg.extras modules implements a much better and faster algorithm.

Method Summary
	`dictfetchall(self)`
	`dictfetchmany(self, size)`
	`dictfetchone(self)`
	`__build_dict(self, row)`
Inherited from cursor
	`__init__(...)` 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)...
	`callproc(procname, parameters, async)` Execute stored procedure.
	`close()` Close the cursor.
	`copy_from(file, table, sep, null)` Copy table from file.
	`copy_to(file, table, sep, null)` Copy table to file.
	`execute(query, vars, async)` Execute query with bound vars.
	`executemany(query, vars_list, async)` Execute many queries with bound vars.
list of tuple	`fetchall()` Return all the remaining rows of a query result set.
list of tuple	`fetchmany(size)` 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	`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 `row_factory` attribute.
int	`fileno()` Return file descriptor associated to database connection.
bool	`isready()` Return True if data is ready after an async query.
str	`mogrify(query, vars)` Return query after vars binding.
	`next(x)` Return the next value, or raise StopIteration...
	`nextset()` Skip to next set of data.
	`scroll(value, mode)` Scroll to new position according to mode.
	`setinputsizes(sizes)` Set memory areas before execute.
	`setoutputsize(size, column)` Set column buffer size.
Inherited from object
	`__delattr__(...)` x.__delattr__('name') <==> del x.name
	`__getattribute__(...)` x.__getattribute__('name') <==> x.name
	`__hash__(x)` Return hash(x)...
	`__reduce__(...)` helper for pickle
	`__reduce_ex__(...)` helper for pickle
	`__setattr__(...)` x.__setattr__('name', value) <==> x.name = value

Property Summary
Inherited from cursor
	`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

dictfetchall(self)

dictfetchmany(self, size)

dictfetchone(self)

__build_dict(self, row)