com.ziclix.python.sql

Class PyExtendedCursor

java.lang.Object

org.python.core.PyObject

com.ziclix.python.sql.PyCursor

com.ziclix.python.sql.PyExtendedCursor

All Implemented Interfaces:

WarningListener, java.io.Serializable, ClassDictInit, ContextManager, Traverseproc

public class PyExtendedCursor
extends PyCursor

A cursor with extensions to the DB API 2.0.

See Also:

Serialized Form

Nested Class Summary

Nested classes/interfaces inherited from class org.python.core.PyObject

PyObject.ConversionException

Field Summary

Fields

Modifier and Type	Field and Description
protected static PyList	__members__ Field __members__
protected static PyList	__methods__ Field __methods__

Fields inherited from class com.ziclix.python.sql.PyCursor

arraysize, connection, datahandler, dynamicFetch, fetch, lastrowid, rsConcur, rsType, softspace, statement, updatecount, warnings

Fields inherited from class org.python.core.PyObject

attributes, gcMonitorGlobal, objtype, TYPE

Method Summary

Modifier and Type	Method and Description
PyObject	__findattr_ex__(java.lang.String name) 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.
static void	classDictInit(PyObject dict) 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 java.lang.String	getMetaDataName(PyObject name) Method getMetaDataName
protected void	primarykeys(PyObject qualifier, PyObject owner, PyObject 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.
java.lang.String	toString() String representation of the object.
protected void	typeinfo(PyObject type) Gets a description of the type information for a given type.
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.

Methods inherited from class com.ziclix.python.sql.PyCursor

__del__, __enter__, __enter__, __exit__, __exit__, __iter__, __iternext__, __setattr__, callproc, clear, close, execute, execute, executemany, fetchall, fetchmany, fetchone, getDataHandler, getMetaData, hasParams, isSeq, isSeqSeq, next, nextset, prepare, refersDirectlyTo, scroll, traverse, warning

Methods inherited from class org.python.core.PyObject

__abs__, __add__, __and__, __call__, __call__, __call__, __call__, __call__, __call__, __call__, __call__, __call__, __call__, __call__, __call__, __call__, __call__, __call__, __call__, __cmp__, __coerce__, __coerce_ex__, __complex__, __contains__, __delattr__, __delattr__, __delete__, __delitem__, __delitem__, __delslice__, __delslice__, __dir__, __div__, __divmod__, __ensure_finalizer__, __eq__, __findattr__, __findattr__, __finditem__, __finditem__, __finditem__, __float__, __floordiv__, __format__, __ge__, __get__, __getattr__, __getattr__, __getitem__, __getitem__, __getnewargs__, __getslice__, __getslice__, __gt__, __hash__, __hex__, __iadd__, __iand__, __idiv__, __idivmod__, __ifloordiv__, __ilshift__, __imod__, __imul__, __index__, __int__, __invert__, __ior__, __ipow__, __irshift__, __isub__, __itruediv__, __ixor__, __le__, __len__, __long__, __lshift__, __lt__, __mod__, __mul__, __ne__, __neg__, __nonzero__, __not__, __oct__, __or__, __pos__, __pow__, __pow__, __radd__, __rand__, __rawdir__, __rdiv__, __rdivmod__, __reduce__, __reduce_ex__, __reduce_ex__, __repr__, __rfloordiv__, __rlshift__, __rmod__, __rmul__, __ror__, __rpow__, __rrshift__, __rshift__, __rsub__, __rtruediv__, __rxor__, __set__, __setattr__, __setitem__, __setitem__, __setitem__, __setslice__, __setslice__, __str__, __sub__, __tojava__, __truediv__, __trunc__, __unicode__, __xor__, _add, _and, _callextra, _cmp, _div, _divmod, _doget, _doget, _doset, _eq, _floordiv, _ge, _gt, _iadd, _iand, _idiv, _idivmod, _ifloordiv, _ilshift, _imod, _imul, _in, _ior, _ipow, _irshift, _is, _isnot, _isub, _itruediv, _ixor, _jcall, _jcallexc, _jthrow, _le, _lshift, _lt, _mod, _mul, _ne, _notin, _or, _pow, _rshift, _sub, _truediv, _unsupportedop, _xor, adaptToCoerceTuple, asDouble, asIndex, asIndex, asInt, asInt, asIterable, asLong, asLong, asName, asName, asString, asString, asStringOrNull, asStringOrNull, bit_length, conjugate, delDict, delType, dispatch__init__, equals, fastGetClass, fastGetDict, finalize, getDict, getJavaProxy, getType, hashCode, impAttr, implementsDescrDelete, implementsDescrGet, implementsDescrSet, invoke, invoke, invoke, invoke, invoke, invoke, isCallable, isDataDescr, isIndex, isInteger, isMappingType, isNumberType, isSequenceType, mergeClassDict, mergeDictAttr, mergeListAttr, noAttributeError, object___subclasshook__, readonlyAttributeError, runsupportedopMessage, setDict, setType, unsupportedopMessage

Methods inherited from class java.lang.Object

clone, getClass, notify, notifyAll, wait, wait, wait

Field Detail

__members__

protected static PyList __members__

Field __members__

__methods__

protected static PyList __methods__

Field __methods__

Method Detail

toString

public java.lang.String toString()

String representation of the object.

Overrides:

toString in class PyCursor

Returns:

a string representation of the object.

classDictInit

public static void classDictInit(PyObject dict)

Initializes the module.

Parameters:

dict -

__findattr_ex__

public PyObject __findattr_ex__(java.lang.String name)

Finds the attribute.

Overrides:

__findattr_ex__ in class PyCursor

Parameters:

name - the name of the attribute of interest

Returns:

the value for the attribute of the specified name

tables

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.

Parameters:

qualifier -

owner -

table -

type -

columns

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

Returns the columns for a table.

Parameters:

qualifier -

owner -

table -

column -

procedures

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

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

Parameters:

qualifier -

owner -

procedure -

procedurecolumns

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

Gets the columns for the procedure.

Parameters:

qualifier -

owner -

procedure -

column -

primarykeys

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 - a schema name

owner - an owner name

table - a table name

foreignkeys

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.

Parameters:

primaryQualifier -

primaryOwner -

primaryTable -

foreignQualifier -

foreignOwner -

foreignTable -

statistics

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.

Parameters:

qualifier -

owner -

table -

unique -

accuracy -

typeinfo

protected void typeinfo(PyObject type)

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

Parameters:

type - data type for which to provide information

tabletypeinfo

protected void tabletypeinfo()

Gets a description of possible table types.

bestrow

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.

Parameters:

qualifier -

owner -

table -

versioncolumns

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 - a schema name

owner - an owner name

table - a table name

getMetaDataName

protected java.lang.String getMetaDataName(PyObject name)

Method getMetaDataName

Parameters:

name -

Returns:

String