com.ziclix.python.sql
Class PyConnection
public
class
PyConnection
extends PyObject
implements ClassDictInit
A connection to the database.
Version: $Revision: 3248 $
Author: brian zimmer last revised by $Author: cgroves $
Method Summary |
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.
In case a database does provide transactions this method causes the database
to roll back to the start of any pending transaction. |
String | toString()
Produces a string representation of the object.
|
PyObject | __findattr__(String name)
Finds the attribute.
|
void | __setattr__(String name, PyObject value)
Sets the attribute.
|
Field __class__
public PyConnection(Connection connection)
Create a PyConnection with the open connection.
Parameters: connection
Throws: SQLException
public static void classDictInit(
PyObject dict)
Method classDictInit
Parameters: dict
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.
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.
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
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
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
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
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.
public String toString()
Produces a string representation of the object.
Returns: string representation of the object.
public
PyObject __findattr__(String name)
Finds the attribute.
Parameters: name the name of the attribute of interest
Returns: the value for the attribute of the specified name
public void __setattr__(String name,
PyObject value)
Sets the attribute.
Parameters: name value