|
|||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||
SUMMARY: INNER | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
java.lang.Object | +--org.python.core.PyObject | +--com.ziclix.python.sql.PyCursor
These objects represent a database cursor, which is used to manage the context of a fetch operation.
Field Summary | |
static org.python.core.PyClass |
__class__
|
protected static org.python.core.PyList |
__members__
|
protected static org.python.core.PyList |
__methods__
|
protected int |
arraysize
|
protected java.util.Hashtable |
cache
|
protected java.sql.Connection |
connection
|
protected int |
counter
|
protected DataHandler |
datahandler
|
protected org.python.core.PyObject |
description
|
protected org.python.core.PyObject |
results
|
protected int |
rowcount
|
Constructor Summary | |
PyCursor()
InitModule requires there be an empty constructor, but I really want the Statement to be passed in the constructor. |
Method Summary | |
void |
__del__()
Delete the cursor. |
org.python.core.PyObject |
__findattr__(java.lang.String name)
Gets the value of the attribute name. |
void |
__setattr__(java.lang.String name,
org.python.core.PyObject value)
Sets the attribute name to value. |
protected java.sql.CallableStatement |
callableStatement(java.lang.String sqlString)
Call a stored procedure. |
void |
callproc(java.lang.String procName,
org.python.core.PyObject params)
This method is optional since not all databases provide stored procedures. |
protected void |
clear()
Reset the cursor. |
void |
close()
Close the cursor now (rather than whenever __del__ is called). |
protected void |
create(java.sql.ResultSet rs)
Create the results after a successful execution. |
protected org.python.core.PyList |
createDescription(java.sql.ResultSetMetaData meta)
(name, type_code, display_size, internal_size, precision, scale, null_ok) |
protected org.python.core.PyList |
createResults(java.sql.ResultSet set)
Creates the results of a query. |
void |
execute(java.lang.String sqlString,
org.python.core.PyObject params,
org.python.core.PyObject bindings)
Prepare and execute a database operation (query or command). |
void |
executemany(java.lang.String sqlString,
org.python.core.PyObject params,
org.python.core.PyObject bindings)
Prepare a database operation (query or command) and then execute it against all parameter sequences or mappings found in the sequence seq_of_parameters. |
org.python.core.PyObject |
fetchall()
Fetch all (remaining) rows of a query result, returning them as a sequence of sequences (e.g. |
org.python.core.PyObject |
fetchmany(int size)
Fetch the next set of rows of a query result, returning a sequence of sequences (e.g. |
org.python.core.PyObject |
fetchone()
Fetch the next row of a query result set, returning a single sequence, or None when no more data is available. |
protected org.python.core.PyClass |
getPyClass()
$METHOD_DESCRIPTION$ |
void |
initModule(org.python.core.PyObject dict)
Initializes the object's namespace. |
org.python.core.PyObject |
nextset()
Returns the next set, else None if no more sets exist. |
protected java.sql.PreparedStatement |
prepareStatement(java.lang.String sqlString)
Prepare a statement ready for executing. |
protected java.sql.Statement |
statement()
Create a Statement. |
java.lang.String |
toString()
String representation of the object. |
Methods inherited from class org.python.core.PyObject |
__abs__, __add__, __and__, __call__, __call__, __call__, __call__, __call__, __call__, __call__, __call__, __cmp__, __coerce__, __coerce_ex__, __complex__, __contains__, __delattr__, __delattr__, __delitem__, __delitem__, __delslice__, __delslice__, __dir__, __div__, __divmod__, __findattr__, __finditem__, __finditem__, __finditem__, __float__, __getattr__, __getattr__, __getitem__, __getitem__, __getslice__, __getslice__, __hash__, __hex__, __int__, __invert__, __len__, __long__, __lshift__, __mod__, __mul__, __neg__, __nonzero__, __not__, __oct__, __or__, __pos__, __pow__, __pow__, __radd__, __rand__, __rdiv__, __rdivmod__, __repr__, __rlshift__, __rmod__, __rmul__, __ror__, __rpow__, __rrshift__, __rshift__, __rsub__, __rxor__, __setattr__, __setitem__, __setitem__, __setitem__, __setslice__, __setslice__, __str__, __sub__, __tojava__, __xor__, _add, _and, _callextra, _cmp, _div, _divmod, _dodel, _doget, _doget, _doset, _eq, _ge, _gt, _in, _is, _isnot, _jcall, _jcallexc, _jthrow, _le, _lshift, _lt, _mod, _mul, _ne, _notin, _or, _pow, _rshift, _sub, _xor, addKeys, equals, hashCode, invoke, invoke, invoke, invoke, invoke, isCallable, isMappingType, isNumberType, isSequenceType, safeRepr |
Methods inherited from class java.lang.Object |
clone, finalize, getClass, notify, notifyAll, wait, wait, wait |
Field Detail |
protected java.sql.Connection connection
protected org.python.core.PyObject results
protected int counter
protected int rowcount
protected org.python.core.PyObject description
protected int arraysize
protected java.util.Hashtable cache
protected DataHandler datahandler
public static org.python.core.PyClass __class__
protected static org.python.core.PyList __methods__
protected static org.python.core.PyList __members__
Constructor Detail |
public PyCursor()
Method Detail |
protected org.python.core.PyClass getPyClass()
getPyClass
in class org.python.core.PyObject
public java.lang.String toString()
toString
in class java.lang.Object
public void __setattr__(java.lang.String name, org.python.core.PyObject value)
__setattr__
in class org.python.core.PyObject
name
- value
- public org.python.core.PyObject __findattr__(java.lang.String name)
__findattr__
in class org.python.core.PyObject
name
- public void initModule(org.python.core.PyObject dict)
initModule
in interface org.python.core.InitModule
dict
- public void __del__()
public void close()
protected java.sql.Statement statement() throws java.sql.SQLException
protected java.sql.CallableStatement callableStatement(java.lang.String sqlString) throws java.sql.SQLException
sqlString
- java.sql.SQLException
- protected java.sql.PreparedStatement prepareStatement(java.lang.String sqlString) throws java.sql.SQLException
sqlString
- java.sql.SQLException
- public void callproc(java.lang.String procName, org.python.core.PyObject params)
public void executemany(java.lang.String sqlString, org.python.core.PyObject params, org.python.core.PyObject bindings)
public void execute(java.lang.String sqlString, org.python.core.PyObject params, org.python.core.PyObject bindings)
sqlString
- sql stringparams
- params for a prepared statementbindings
- dictionary of (param index : SQLType binding)public org.python.core.PyObject fetchone()
public org.python.core.PyObject fetchall()
public org.python.core.PyObject fetchmany(int size)
public org.python.core.PyObject nextset()
protected void create(java.sql.ResultSet rs)
rs
- A ResultSet.protected org.python.core.PyList createDescription(java.sql.ResultSetMetaData meta) throws java.sql.SQLException
protected org.python.core.PyList createResults(java.sql.ResultSet set) throws java.sql.SQLException
set
- java.lang.Exception
- protected void clear()
|
|||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||
SUMMARY: INNER | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |