com.ziclix.python.sql.pipe.db

Class DBSink

java.lang.Object

com.ziclix.python.sql.pipe.db.BaseDB

com.ziclix.python.sql.pipe.db.DBSink

All Implemented Interfaces:

Sink

public class DBSink
extends BaseDB
implements Sink

A database consumer. All data transferred will be inserted into the appropriate table.

Field Summary

Fields

Modifier and Type	Field and Description
protected int	batchsize Field batchsize
protected PyObject	bindings Field bindings
protected java.util.Set	exclude Field exclude
protected PyDictionary	indexedBindings Field indexedBindings
protected PyList	rows Field rows
protected PyObject	sql Field sql

Fields inherited from class com.ziclix.python.sql.pipe.db.BaseDB

connection, cursor, dataHandler, tableName

Constructor Summary

Constructors

Constructor and Description
DBSink(PyConnection connection, java.lang.Class dataHandler, java.lang.String tableName, PyObject exclude, PyObject bindings, int batchsize) Constructor for handling the consumption of data.

Method Summary

Modifier and Type	Method and Description
protected void	createSql(PyObject row) Create the insert statement given the header row.
void	end() Handles flushing any buffers and closes the cursor.
protected boolean	excluded(PyObject key) Return true if the key (converted to lowercase) is not found in the exclude list.
void	row(PyObject row) Handle the row.
void	start() Method start

Methods inherited from class com.ziclix.python.sql.pipe.db.BaseDB

cursor

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Field Detail

sql

protected PyObject sql

Field sql

exclude

protected java.util.Set exclude

Field exclude

rows

protected PyList rows

Field rows

batchsize

protected int batchsize

Field batchsize

bindings

protected PyObject bindings

Field bindings

indexedBindings

protected PyDictionary indexedBindings

Field indexedBindings

Constructor Detail

DBSink

public DBSink(PyConnection connection,
              java.lang.Class dataHandler,
              java.lang.String tableName,
              PyObject exclude,
              PyObject bindings,
              int batchsize)

Constructor for handling the consumption of data.

Parameters:

connection - the database connection

dataHandler - a custom DataHandler for the cursor, can be None

tableName - the table to insert the data

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

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

batchsize - the optional batchsize for the inserts

Method Detail

excluded

protected boolean excluded(PyObject key)

Return true if the key (converted to lowercase) is not found in the exclude list.

createSql

protected void createSql(PyObject row)

Create the insert statement given the header row.

row

public void row(PyObject row)

Handle the row. Insert the data into the correct table and columns. No updates are done.

Specified by:

row in interface Sink

start

public void start()

Method start

Specified by:

start in interface Sink

end

public void end()

Handles flushing any buffers and closes the cursor.

Specified by:

end in interface Sink