Package grizzled :: Package db :: Module dbgadfly :: Class GadflyCursor
[hide private]
[frames] | no frames]

Class GadflyCursor

source code

 object --+    
          |    
base.Cursor --+
              |
             GadflyCursor

Instance Methods [hide private]
 
__init__(self, real_cursor, driver)
Create a new Cursor object, wrapping the underlying real DB API cursor.
source code
 
close(self)
Close the cursor.
source code
 
execute(self, statement, parameters=None)
Execute a SQL statement string with the given parameters.
source code
 
executemany(self, statement, *parameters)
Execute a SQL statement once for each item in the given parameters.
source code
list of tuples
fetchall(self)
Returns all remaining result rows from the last query, as a sequence of tuples.
source code
tuple
fetchone(self)
Returns the next result set row from the last query, as a sequence of tuples.
source code
list of tuples
fetchmany(self, n)
Returns up to n remaining result rows from the last query, as a sequence of tuples.
source code

Inherited from base.Cursor: executeMany, fetchAll, fetchMany, get_index_metadata, get_rdbms_metadata, get_table_metadata, get_tables

Inherited from object: __delattr__, __format__, __getattribute__, __hash__, __new__, __reduce__, __reduce_ex__, __repr__, __setattr__, __sizeof__, __str__, __subclasshook__

Properties [hide private]
int rowcount
A read-only attribute that specifies the number of rows fetched in the last query, or -1 if unknown.
tuple description
A read-only attribute that is a sequence of 7-item tuples, one per column, from the last query executed.

Inherited from object: __class__

Method Details [hide private]

__init__(self, real_cursor, driver)
(Constructor)

source code 
Create a new Cursor object, wrapping the underlying real DB API cursor.
Parameters:
  • cursor - the real DB API cursor object
  • driver - the driver that is creating this object
Overrides: object.__init__
(inherited documentation)

close(self)

source code 
Close the cursor.
Raises:
  • Warning - Non-fatal warning
  • Error - Error; unable to close
Overrides: base.Cursor.close
(inherited documentation)

execute(self, statement, parameters=None)

source code 
Execute a SQL statement string with the given parameters. 'parameters' is a sequence when the parameter style is 'format', 'numeric' or 'qmark', and a dictionary when the style is 'pyformat' or 'named'. See DB.paramstyle().
Parameters:
  • statement - the SQL statement to execute
  • parameters - parameters to use, if the statement is parameterized
Raises:
Overrides: base.Cursor.execute
(inherited documentation)

executemany(self, statement, *parameters)

source code 
Execute a SQL statement once for each item in the given parameters.
Parameters:
  • statement - the SQL statement to execute
  • parameters - a sequence of sequences when the parameter style is 'format', 'numeric' or 'qmark', and a sequence of dictionaries when the style is 'pyformat' or 'named'.
Raises:
Overrides: base.Cursor.executemany
(inherited documentation)

fetchall(self)

source code 
Returns all remaining result rows from the last query, as a sequence of tuples. Raises an exception if the last statement was not a query.
Returns: list of tuples
List of rows, each represented as a tuple
Raises:
Overrides: base.Cursor.fetchall
(inherited documentation)

fetchone(self)

source code 
Returns the next result set row from the last query, as a sequence of tuples. Raises an exception if the last statement was not a query.
Returns: tuple
Next result set row
Raises:
Overrides: base.Cursor.fetchone
(inherited documentation)

fetchmany(self, n)

source code 
Returns up to n remaining result rows from the last query, as a sequence of tuples. Raises an exception if the last statement was not a query.
Parameters:
  • n - maximum number of result rows to get
Returns: list of tuples
List of rows, each represented as a tuple
Raises:
Overrides: base.Cursor.fetchmany
(inherited documentation)

Property Details [hide private]

rowcount

A read-only attribute that specifies the number of rows fetched in the last query, or -1 if unknown. Note: It's best not to rely on the row count, because some database drivers (such as SQLite) don't report valid row counts.
Get Method:
unreachable.rowcount(self)

description

A read-only attribute that is a sequence of 7-item tuples, one per column, from the last query executed. The tuple values are: (name, typecode, displaysize, internalsize, precision, scale)
Get Method:
unreachable.description(self)