stream.io

Class SQLWriter

java.lang.Object

stream.AbstractProcessor

stream.io.AbstractSQLProcessor

stream.io.SQLWriter

All Implemented Interfaces:

Processor, StatefulProcessor

public class SQLWriter
extends AbstractSQLProcessor

Author:

chris

Field Summary

Fields

Modifier and Type	Field and Description
(package private) List<String>	columns
(package private) Connection	connection
(package private) long	count
(package private) boolean	dropTable
(package private) String[]	keys
(package private) LinkedHashSet<String>	keysToStore
(package private) static org.slf4j.Logger	log
(package private) String	table
(package private) boolean	tableExists
(package private) Map<String,Class<?>>	tableSchema

Fields inherited from class stream.io.AbstractSQLProcessor

dialect, password, url, username

Fields inherited from class stream.AbstractProcessor

context

Constructor Summary

Constructors

Constructor and Description
SQLWriter()

Method Summary

Methods

Modifier and Type	Method and Description
void	finish()
String[]	getKeys()
String	getTable()
boolean	hasTable(String name)
private void	init()
void	init(ProcessContext ctx)
boolean	isDropTable()
Data	process(Data input)
void	setDropTable(boolean dropTable)
void	setKeys(String[] keys)
void	setTable(String table)

Methods inherited from class stream.io.AbstractSQLProcessor

close, createTable, getPassword, getUrl, getUsername, openConnection, setPassword, setUrl, setUsername

Methods inherited from class stream.AbstractProcessor

resetState

Methods inherited from class java.lang.Object

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

Field Detail

log

static org.slf4j.Logger log

dropTable

boolean dropTable

table

String table

keys

String[] keys

keysToStore

final LinkedHashSet<String> keysToStore

tableSchema

Map<String,Class<?>> tableSchema

tableExists

transient boolean tableExists

count

transient long count

connection

transient Connection connection

columns

transient List<String> columns

Constructor Detail

SQLWriter

public SQLWriter()

Method Detail

getTable

public String getTable()

Returns:

the table

setTable

@Parameter(required=true,
           description="The database table to insert items into.")
public void setTable(String table)

Parameters:

table - the table to set

getKeys

public String[] getKeys()

Returns:

the keys

setKeys

@Parameter(required=false,
           description="A list of attributes to insert (columns), empty string for all attributes.")
public void setKeys(String[] keys)

Parameters:

keys - the keys to set

isDropTable

public boolean isDropTable()

Returns:

the dropTable

setDropTable

@Parameter(required=false,
           defaultValue="false")
public void setDropTable(boolean dropTable)

Parameters:

dropTable - the dropTable to set

init

public void init(ProcessContext ctx)
          throws Exception

Specified by:

init in interface StatefulProcessor

Overrides:

init in class AbstractProcessor

Throws:

Exception

See Also:

AbstractProcessor.init(stream.ProcessContext)

init

private void init()
           throws Exception

Throws:

Exception

hasTable

public boolean hasTable(String name)

Overrides:

hasTable in class AbstractSQLProcessor

process

public Data process(Data input)

See Also:

Processor.process(stream.Data)

finish

public void finish()
            throws Exception

Specified by:

finish in interface StatefulProcessor

Overrides:

finish in class AbstractProcessor

Throws:

Exception

See Also:

AbstractProcessor.finish()