com.ziclix.python.sql.util

Class BCP

java.lang.Object

org.python.core.PyObject

com.ziclix.python.sql.util.BCP

All Implemented Interfaces:

java.io.Serializable, ClassDictInit, Traverseproc

public class BCP
extends PyObject
implements ClassDictInit, Traverseproc

A class to perform efficient Bulk CoPy of database tables.

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__
protected int	batchsize Field batchsize, queuesize
protected java.lang.Class	destDH Field sourceDH, destDH
protected PyConnection	destination Field source, destination
protected int	queuesize Field batchsize, queuesize
protected PyConnection	source Field source, destination
protected java.lang.Class	sourceDH Field sourceDH, destDH

Fields inherited from class org.python.core.PyObject

attributes, gcMonitorGlobal, objtype, TYPE

Constructor Summary

Constructors

Constructor and Description
BCP(PyConnection source, PyConnection destination) The source connection will produce the rows while the destination connection will consume the rows and coerce as necessary for the destination database.
BCP(PyConnection source, PyConnection destination, int batchsize) The source connection will produce the rows while the destination connection will consume the rows and coerce as necessary for the destination database.

Method Summary

Modifier and Type	Method and Description
PyObject	__findattr_ex__(java.lang.String name) Gets the value of the attribute name.
void	__setattr__(java.lang.String name, PyObject value) Sets the attribute name to value.
protected PyObject	bcp(java.lang.String fromTable, java.lang.String where, PyObject params, PyObject include, PyObject exclude, java.lang.String toTable, PyObject bindings) Bulkcopy data from one database to another.
static void	classDictInit(PyObject dict) Initializes the object's namespace.
boolean	refersDirectlyTo(PyObject ob) Optional operation.
java.lang.String	toString() String representation of the object.
int	traverse(Visitproc visit, java.lang.Object arg) Traverses all directly contained PyObjects.

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__, __iter__, __iternext__, __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

sourceDH

protected java.lang.Class sourceDH

Field sourceDH, destDH

destDH

protected java.lang.Class destDH

Field sourceDH, destDH

batchsize

protected int batchsize

Field batchsize, queuesize

queuesize

protected int queuesize

Field batchsize, queuesize

source

protected PyConnection source

Field source, destination

destination

protected PyConnection destination

Field source, destination

__methods__

protected static PyList __methods__

Field __methods__

__members__

protected static PyList __members__

Field __members__

Constructor Detail

BCP

public BCP(PyConnection source,
           PyConnection destination)

The source connection will produce the rows while the destination connection will consume the rows and coerce as necessary for the destination database.

BCP

public BCP(PyConnection source,
           PyConnection destination,
           int batchsize)

The source connection will produce the rows while the destination connection will consume the rows and coerce as necessary for the destination database.

Parameters:

batchsize - used to batch the inserts on the destination

Method Detail

toString

public java.lang.String toString()

String representation of the object.

Overrides:

toString in class PyObject

Returns:

a string representation of the object.

__setattr__

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

Sets the attribute name to value.

Overrides:

__setattr__ in class PyObject

Parameters:

name -

value -

See Also:

PyObject.__setattr__(PyString, PyObject)

__findattr_ex__

public PyObject __findattr_ex__(java.lang.String name)

Gets the value of the attribute name.

Overrides:

__findattr_ex__ in class PyObject

Parameters:

name -

Returns:

the attribute for the given name

classDictInit

public static void classDictInit(PyObject dict)

Initializes the object's namespace.

Parameters:

dict -

bcp

protected PyObject bcp(java.lang.String fromTable,
                       java.lang.String where,
                       PyObject params,
                       PyObject include,
                       PyObject exclude,
                       java.lang.String toTable,
                       PyObject bindings)

Bulkcopy data from one database to another.

Parameters:

fromTable - the table in question on the source database

where - an optional where clause, defaults to '(1=1)' if null

params - optional params to substituted in the where clause

include - the columns to be queried from the source, '*' if None

exclude - the columns to be excluded from insertion on the destination, all if None

toTable - if non-null, the table in the destination db, otherwise the same table name as the source

bindings - the optional bindings for the destination, this allows morphing of types during the copy

Returns:

the count of the total number of rows bulk copied, -1 if the query returned no rows

traverse

public int traverse(Visitproc visit,
                    java.lang.Object arg)

Description copied from interface: Traverseproc

Traverses all directly contained PyObjects. Like in CPython, arg must be passed unmodified to visit as its second parameter. If Visitproc.visit(PyObject, Object) returns nonzero, this return value must be returned immediately by traverse. Visitproc.visit(PyObject, Object) must not be called with a null PyObject-argument.

Specified by:

traverse in interface Traverseproc

refersDirectlyTo

public boolean refersDirectlyTo(PyObject ob)

Description copied from interface: Traverseproc

Optional operation. Should only be implemented if it is more efficient than calling Traverseproc.traverse(Visitproc, Object) with a visitproc that just watches out for ob. Must return false if ob is null.

Specified by:

refersDirectlyTo in interface Traverseproc