Top Description Fields Constructors Methods
com.ziclix.python.sql

public Class PyExtendedCursor

Additional top-level class in compilation unit: ExtendedCursorFunc.

extends PyCursor
Class Inheritance
Imports
java.sql.DatabaseMetaData, .SQLException, java.util.HashSet, .Set, org.python.core.Py, .PyBuiltinMethodSet, .PyList, .PyObject, .PyString
A cursor with extensions to the DB API 2.0.
Author
brian zimmer

Field Summary

Modifier and TypeField and Description
protected static PyList
__members__

Hides com.ziclix.python.sql.PyCursor.__members__.

Field __members__
protected static PyList
__methods__

Hides com.ziclix.python.sql.PyCursor.__methods__.

Field __methods__
Inherited from com.ziclix.python.sql.PyCursor:
arraysizeconnectiondatahandlerdynamicFetchfetchlastrowidrsConcurrsTypesoftspacestatementupdatecountwarnings

Constructor Summary

AccessConstructor and Description
pack-priv
PyExtendedCursor(PyConnection connection)

Constructor PyExtendedCursor

pack-priv
PyExtendedCursor(PyConnection connection, boolean dynamicFetch)

Constructor PyExtendedCursor

pack-priv
PyExtendedCursor(PyConnection connection, boolean dynamicFetch, PyObject rsType, PyObject rsConcur)

Constructor PyExtendedCursor

Method Summary

Modifier and TypeMethod and Description
public PyObject

Returns:

the value for the attribute of the specified name
__findattr_ex__(String
the name of the attribute of interest
name)

Overrides com.ziclix.python.sql.PyCursor.__findattr_ex__.

Finds the attribute.

protected void
bestrow(PyObject qualifier, PyObject owner, PyObject table)

Gets a description of a table's optimal set of columns that uniquely identifies a row.

public static void
classDictInit(PyObject dict)

Hides com.ziclix.python.sql.PyCursor.classDictInit.

Initializes the module.

protected void
columns(PyObject qualifier, PyObject owner, PyObject table, PyObject column)

Returns the columns for a table.

protected void
foreignkeys(PyObject primaryQualifier, PyObject primaryOwner, PyObject primaryTable, PyObject foreignQualifier, PyObject foreignOwner, PyObject foreignTable)

Gets a description of the foreign key columns in the foreign key table that reference the primary key columns of the primary key table (describe how one table imports another's key.) This should normally return a single foreign key/primary key pair (most tables only import a foreign key from a table once.) They are ordered by FKTABLE_CAT, FKTABLE_SCHEM, FKTABLE_NAME, and KEY_SEQ.

protected String

Returns:

String
getMetaDataName(PyObject name)

Method getMetaDataName

protected void
primarykeys(PyObject
a schema name
qualifier, PyObject
an owner name
owner, PyObject
a table name
table)

Gets a description of a table's primary key columns.

protected void
procedurecolumns(PyObject qualifier, PyObject owner, PyObject procedure, PyObject column)

Gets the columns for the procedure.

protected void
procedures(PyObject qualifier, PyObject owner, PyObject procedure)

Gets a description of the stored procedures available for the qualifier and owner.

protected void
statistics(PyObject qualifier, PyObject owner, PyObject table, PyObject unique, PyObject accuracy)

Gets a description of a table's indices and statistics.

protected void
tables(PyObject qualifier, PyObject owner, PyObject table, PyObject type)

Only table descriptions matching the catalog, schema, table name and type criteria are returned.

protected void
tabletypeinfo()

Gets a description of possible table types.

public String

Returns:

a string representation of the object.
toString()

Overrides com.ziclix.python.sql.PyCursor.toString.

String representation of the object.

protected void
typeinfo(PyObject
data type for which to provide information
type)

Gets a description of the type information for a given type.

protected void
versioncolumns(PyObject
a schema name
qualifier, PyObject
an owner name
owner, PyObject
a table name
table)

Gets a description of a table's columns that are automatically updated when any value in a row is updated.

Inherited from com.ziclix.python.sql.PyCursor:
__del____enter____enter____exit____exit____iter____iternext____setattr__callprocclearcloseexecuteexecuteexecutemanyfetchallfetchmanyfetchonegetDataHandlergetMetaDatahasParamsisSeqisSeqSeqnextnextsetpreparerefersDirectlyToscrolltraversewarning

Field Detail

__members__back to summary
protected static PyList __members__

Hides com.ziclix.python.sql.PyCursor.__members__.

Field __members__

__methods__back to summary
protected static PyList __methods__

Hides com.ziclix.python.sql.PyCursor.__methods__.

Field __methods__

Constructor Detail

PyExtendedCursorback to summary
pack-priv PyExtendedCursor(PyConnection connection)

Constructor PyExtendedCursor

PyExtendedCursorback to summary
pack-priv PyExtendedCursor(PyConnection connection, boolean dynamicFetch)

Constructor PyExtendedCursor

PyExtendedCursorback to summary
pack-priv PyExtendedCursor(PyConnection connection, boolean dynamicFetch, PyObject rsType, PyObject rsConcur)

Constructor PyExtendedCursor

Method Detail

__findattr_ex__back to summary
public PyObject __findattr_ex__(String name)

Overrides com.ziclix.python.sql.PyCursor.__findattr_ex__.

Finds the attribute.

Parameters
name:String

the name of the attribute of interest

Returns:PyObject

the value for the attribute of the specified name

Annotations
@Override

bestrowback to summary
protected void bestrow(PyObject qualifier, PyObject owner, PyObject table)

Gets a description of a table's optimal set of columns that uniquely identifies a row. They are ordered by SCOPE.

classDictInitback to summary
public static void classDictInit(PyObject dict)

Hides com.ziclix.python.sql.PyCursor.classDictInit.

Initializes the module.

columnsback to summary
protected void columns(PyObject qualifier, PyObject owner, PyObject table, PyObject column)

Returns the columns for a table.

foreignkeysback to summary
protected void foreignkeys(PyObject primaryQualifier, PyObject primaryOwner, PyObject primaryTable, PyObject foreignQualifier, PyObject foreignOwner, PyObject foreignTable)

Gets a description of the foreign key columns in the foreign key table that reference the primary key columns of the primary key table (describe how one table imports another's key.) This should normally return a single foreign key/primary key pair (most tables only import a foreign key from a table once.) They are ordered by FKTABLE_CAT, FKTABLE_SCHEM, FKTABLE_NAME, and KEY_SEQ.

getMetaDataNameback to summary
protected String getMetaDataName(PyObject name)

Method getMetaDataName

Returns:String

String

primarykeysback to summary
protected void primarykeys(PyObject qualifier, PyObject owner, PyObject table)

Gets a description of a table's primary key columns. They are ordered by COLUMN_NAME.

Parameters
qualifier:PyObject

a schema name

owner:PyObject

an owner name

table:PyObject

a table name

procedurecolumnsback to summary
protected void procedurecolumns(PyObject qualifier, PyObject owner, PyObject procedure, PyObject column)

Gets the columns for the procedure.

proceduresback to summary
protected void procedures(PyObject qualifier, PyObject owner, PyObject procedure)

Gets a description of the stored procedures available for the qualifier and owner.

statisticsback to summary
protected void statistics(PyObject qualifier, PyObject owner, PyObject table, PyObject unique, PyObject accuracy)

Gets a description of a table's indices and statistics. They are ordered by NON_UNIQUE, TYPE, INDEX_NAME, and ORDINAL_POSITION.

tablesback to summary
protected void tables(PyObject qualifier, PyObject owner, PyObject table, PyObject type)

Only table descriptions matching the catalog, schema, table name and type criteria are returned. They are ordered by TABLE_TYPE, TABLE_SCHEM and TABLE_NAME.

tabletypeinfoback to summary
protected void tabletypeinfo()

Gets a description of possible table types.

toStringback to summary
public String toString()

Overrides com.ziclix.python.sql.PyCursor.toString.

String representation of the object.

Returns:String

a string representation of the object.

Annotations
@Override

typeinfoback to summary
protected void typeinfo(PyObject type)

Gets a description of the type information for a given type.

Parameters
type:PyObject

data type for which to provide information

versioncolumnsback to summary
protected void versioncolumns(PyObject qualifier, PyObject owner, PyObject table)

Gets a description of a table's columns that are automatically updated when any value in a row is updated. They are unordered.

Parameters
qualifier:PyObject

a schema name

owner:PyObject

an owner name

table:PyObject

a table name