com.ziclix.python.sql
Class PyConnection

java.lang.Object
  org.python.core.PyObject
      com.ziclix.python.sql.PyConnection

All Implemented Interfaces:

ClassDictInit, java.io.Serializable

public class PyConnection

extends PyObject

implements ClassDictInit

A connection to the database.

Version:

$Revision: 1.14 $

Author:

brian zimmer, last revised by $Author: bzimmer $

See Also:

Serialized Form

Nested Class Summary

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

PyObject.ConversionException

Field Summary

static PyClass

__class__ Field __class__

Fields inherited from class org.python.core.PyObject

exposed_name

Constructor Summary

PyConnection(java.sql.Connection connection)
Create a PyConnection with the open connection.

Method Summary

PyObject	__findattr__(java.lang.String name) Finds the attribute.
void	__setattr__(java.lang.String name, PyObject value) Sets the attribute.
static void	classDictInit(PyObject dict) Method classDictInit
void	close() Close the connection now (rather than whenever __del__ is called).
void	commit() Commit any pending transaction to the database.
PyCursor	cursor() Return a new Cursor Object using the connection.
PyCursor	cursor(boolean dynamicFetch) Return a new Cursor Object using the connection.
PyCursor	cursor(boolean dynamicFetch, PyObject rsType, PyObject rsConcur) Return a new Cursor Object using the connection.
PyObject	nativesql(PyObject nativeSQL) Converts the given SQL statement into the system's native SQL grammar.
void	rollback() This method is optional since not all databases provide transaction support.
java.lang.String	toString() Produces a 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__, __delete__, __delitem__, __delitem__, __delslice__, __delslice__, __dir__, __div__, __divmod__, __eq__, __findattr__, __finditem__, __finditem__, __finditem__, __float__, __floordiv__, __ge__, __get__, __getattr__, __getattr__, __getitem__, __getitem__, __getslice__, __getslice__, __gt__, __hash__, __hex__, __iadd__, __iand__, __idiv__, __idivmod__, __ifloordiv__, __ilshift__, __imod__, __imul__, __int__, __invert__, __ior__, __ipow__, __irshift__, __isub__, __iter__, __iternext__, __itruediv__, __ixor__, __le__, __len__, __long__, __lshift__, __lt__, __mod__, __mul__, __ne__, __neg__, __nonzero__, __not__, __oct__, __or__, __pos__, __pow__, __pow__, __radd__, __rand__, __rdiv__, __rdivmod__, __repr__, __rfloordiv__, __rlshift__, __rmod__, __rmul__, __ror__, __rpow__, __rrshift__, __rshift__, __rsub__, __rtruediv__, __rxor__, __set__, __setattr__, __setitem__, __setitem__, __setitem__, __setslice__, __setslice__, __str__, __sub__, __tojava__, __truediv__, __xor__, _add, _and, _callextra, _cmp, _div, _divmod, _doget, _doget, _doset, _eq, _floordiv, _ge, _gt, _in, _is, _isnot, _jcall, _jcallexc, _jthrow, _le, _lshift, _lt, _mod, _mul, _ne, _notin, _or, _pow, _rshift, _sub, _truediv, _xor, asInt, asLong, asName, asString, asStringOrNull, dispatch__init__, equals, fastGetClass, fastGetDict, getDict, getDoc, getType, hashCode, implementsDescrDelete, implementsDescrSet, invoke, invoke, invoke, invoke, invoke, isCallable, isDataDescr, isMappingType, isNumberType, isSequenceType, noAttributeError, readonlyAttributeError, safeRepr, typeSetup

Methods inherited from class java.lang.Object

getClass, notify, notifyAll, wait, wait, wait

Field Detail

__class__

public static PyClass __class__

Field __class__

Constructor Detail

PyConnection

public PyConnection(java.sql.Connection connection)
             throws java.sql.SQLException

Create a PyConnection with the open connection.

Parameters:

connection -

Throws:

java.sql.SQLException

Method Detail

toString

public java.lang.String toString()

Produces a string representation of the object.

Overrides:

toString in class PyObject

Returns:

string representation of the object.

classDictInit

public static void classDictInit(PyObject dict)

Method classDictInit

Parameters:

dict -

__setattr__

public void __setattr__(java.lang.String name,
                        PyObject value)

Sets the attribute.

Overrides:

__setattr__ in class PyObject

Parameters:

name -

value -

See Also:

PyObject.__setattr__(PyString, PyObject)

__findattr__

public PyObject __findattr__(java.lang.String name)

Finds the attribute.

Overrides:

__findattr__ in class PyObject

Parameters:

name - the name of the attribute of interest

Returns:

the value for the attribute of the specified name

See Also:

PyObject.__findattr__(PyString)

close

public void close()

Close the connection now (rather than whenever __del__ is called). The connection will be unusable from this point forward; an Error (or subclass) exception will be raised if any operation is attempted with the connection. The same applies to all cursor objects trying to use the connection.

commit

public void commit()

Commit any pending transaction to the database. Note that if the database supports an auto-commit feature, this must be initially off. An interface method may be provided to turn it back on.

Database modules that do not support transactions should implement this method with void functionality.

rollback

public void rollback()

This method is optional since not all databases provide transaction support.

In case a database does provide transactions this method causes the database to roll back to the start of any pending transaction. Closing a connection without committing the changes first will cause an implicit rollback to be performed.

nativesql

public PyObject nativesql(PyObject nativeSQL)

Converts the given SQL statement into the system's native SQL grammar. A driver may convert the JDBC sql grammar into its system's native SQL grammar prior to sending it; this method returns the native form of the statement that the driver would have sent.

Parameters:

nativeSQL -

Returns:

the native form of this statement

cursor

public PyCursor cursor()

Return a new Cursor Object using the connection. If the database does not provide a direct cursor concept, the module will have to emulate cursors using other means to the extent needed by this specification.

Returns:

a new cursor using this connection

cursor

public PyCursor cursor(boolean dynamicFetch)

Return a new Cursor Object using the connection. If the database does not provide a direct cursor concept, the module will have to emulate cursors using other means to the extent needed by this specification.

Parameters:

dynamicFetch - if true, dynamically iterate the result

Returns:

a new cursor using this connection

cursor

public PyCursor cursor(boolean dynamicFetch,
                       PyObject rsType,
                       PyObject rsConcur)

Return a new Cursor Object using the connection. If the database does not provide a direct cursor concept, the module will have to emulate cursors using other means to the extent needed by this specification.

Parameters:

dynamicFetch - if true, dynamically iterate the result

rsType - the type of the underlying ResultSet

rsConcur - the concurrency of the underlying ResultSet

Returns:

a new cursor using this connection