## com.ziclix.python.sql
Class PyConnection

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

All Implemented Interfaces:
  Serializable, ClassDictInit, ContextManager

    public class PyConnection

extends PyObject
implements ClassDictInit, ContextManager

A connection to the database.

Version:
  $Revision: 6784 $
Author:
  brian zimmer, last revised by $Author: zyasoft $
See Also:
  Serialized Form

Nested Class Summary

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

Field Summary

Fields inherited from class org.python.core.PyObject
`TYPE`

Constructor Summary
`PyConnection(Connection connection)` Create a PyConnection with the open connection.

Method Summary
`PyObject` `__enter__()`
`PyObject` `__enter__(ThreadState ts)`
`boolean` `__exit__(PyObject type, PyObject value, PyObject traceback)`
`boolean` `__exit__(ThreadState ts, PyException exception)`
`PyObject` `__findattr_ex__(String name)` Finds the attribute.
`void` `__setattr__(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.
`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__, __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__, __findattr__, __finditem__, __finditem__, __finditem__, __float__, __floordiv__, __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__, __iter__, __iternext__, __itruediv__, __ixor__, __le__, __len__, __long__, __lshift__, __lt__, __mod__, __mul__, __ne__, __neg__, __nonzero__, __not__, __oct__, __or__, __pos__, __pow__, __pow__, __radd__, __rand__, __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__, __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, _xor, asDouble, asIndex, asIndex, asInt, asInt, asIterable, asLong, asName, asName, asString, asString, asStringOrNull, asStringOrNull, delDict, delType, dispatch__init__, equals, fastGetClass, fastGetDict, getDict, getDoc, getType, hashCode, implementsDescrDelete, implementsDescrSet, invoke, invoke, invoke, invoke, invoke, invoke, isCallable, isDataDescr, isIndex, isMappingType, isNumberType, isSequenceType, noAttributeError, readonlyAttributeError, setDict, setType`

Methods inherited from class java.lang.Object
`getClass, notify, notifyAll, wait, wait, wait`

Constructor Detail

### PyConnection

    public PyConnection(Connection connection)
                 throws SQLException

  Create a PyConnection with the open connection.

  Parameters:
    `connection` -
  Throws:
    `SQLException`

Method Detail

### toString

    public 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__(String name,
                            PyObject value)

  Sets the attribute.

  Overrides:
    `__setattr__` in class `PyObject`
  Parameters:
    `name` -
    `value` -
  See Also:
    `PyObject.__setattr__(PyString, PyObject)`

### __findattr_ex__

    public PyObject __findattr_ex__(String name)

  Finds the attribute.

  Overrides:
    `__findattr_ex__` in class `PyObject`
  Parameters:
    `name` - the name of the attribute of interest
  Returns:
    the value for the attribute of the specified name

### 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

### __enter__

    public PyObject __enter__(ThreadState ts)

  Specified by:
    `__enter__` in interface `ContextManager`

### __enter__

    public PyObject __enter__()

### __exit__

    public boolean __exit__(ThreadState ts,
                            PyException exception)

  Specified by:
    `__exit__` in interface `ContextManager`

### __exit__

    public boolean __exit__(PyObject type,
                            PyObject value,
                            PyObject traceback)

Jython homepage