com.ergotech.vib.manipulators.string

Class SQLSelectStatement

java.lang.Object

com.ergotech.vib.servers.DataSource

com.ergotech.vib.servers.SimpleDataSource

com.ergotech.vib.manipulators.Manipulator

com.ergotech.vib.manipulators.SimpleManipulator

com.ergotech.vib.manipulators.string.SQLSelectStatement

public class SQLSelectStatement
extends SimpleManipulator

This manipulator creates a SELECT SQL Statement when triggered. The trigger value is never used. Specification
The input String will contain a specific tokens that will be replaced to create a SQL statement. The tokens to be replaced are each paramters of this bean:

Nested Class Summary

Nested classes/interfaces inherited from class com.ergotech.vib.servers.SimpleDataSource

SimpleDataSource.NameEditorData

Nested classes/interfaces inherited from class com.ergotech.vib.servers.DataSource

DataSource.Writable

Field Summary

Fields

Modifier and Type	Field and Description
static java.lang.String	cvsRev

Fields inherited from class com.ergotech.vib.manipulators.Manipulator

UPDATE_DISPLAYED_VALUE, VALUE_INPUT

Fields inherited from class com.ergotech.vib.servers.SimpleDataSource

customTimer, EXPORT_READ_ONLY, EXPORT_READ_WRITE, NO_EXPORT, requiresSyncWrite, sharedTimer, syncWriteTimeout, timebase

Fields inherited from class com.ergotech.vib.servers.DataSource

autoSuspend, AUTOSUSPEND_DEFAULT, AUTOSUSPEND_NEVER, AUTOSUSPEND_NO_LISTENERS, AUTOSUSPEND_NO_LISTENERS_AND_NO_SOURCES, colorHi, colorHiHi, colorLo, colorLoLo, colorNormal, connectors, consoleLogger, currentColor, currentValue, debugLevel, DEFAULT_AUTOSUSPEND, dontConnect, gwtLog, hardSuspended, popupLogger, PRIMARYOUTPORTNAME, sendColors, stopped, suspended, timedPopupLogger, traceLogger, valueHi, valueHiHi, valueLo, valueLoLo

Constructor Summary

Constructors

Constructor and Description
SQLSelectStatement()

Method Summary

Modifier and Type	Method and Description
java.lang.String	getAdditionalWhere() Returns the additional where part of the SQL statement
java.lang.String	getEndTime() Returns the end time for the WHERE
int	getOptionalLimit() Returns the optional limit.
java.lang.String	getOrderBy() Returns the ORDER BY part of the SQL statement
java.lang.String	getSelectColumnList() Returns the comma separated column list for the SELECT.
java.lang.String	getStartTime() Returns the start time for the WHERE
java.lang.String	getTableName() Returns the table name.
java.lang.String	getTimestampColumn() Returns the name of the timestamp column in the table.
void	setAdditionalWhere(java.lang.String additionalWhere) Set the String for the additional items in the WHERE (will be prepended with " and ".
void	setEndTime(java.lang.String endTime) Set the end date for the WHERE in the SELECT.
void	setOptionalLimit(int limit) Set limit for the select.
void	setOrderBy(java.lang.String orderBy) Set the String for the ORDER BY
void	setSelectColumnList(java.lang.String selectColumnList) Set the comma separated column list or "*" for the SELECT
void	setStartTime(java.lang.String startTime) Set the start date for the WHERE in the SELECT.
void	setTableName(java.lang.String tableName) Set the tableName
void	setTimestampColumn(java.lang.String timestampColumn) Sets the timestamp column name.
void	setValueObject(ValueObjectInterface v) This sets the value of the new StringValueObject.
java.lang.String	toString() Provides the description and status of the server as a String.

Methods inherited from class com.ergotech.vib.manipulators.SimpleManipulator

getDefaultQualityForLocation

Methods inherited from class com.ergotech.vib.manipulators.Manipulator

getInPortNames, getStaticLocationFor, setBooleanValue, setBoolValue, setByteValue, setDoubleValue, setFloatValue, setIntValue, setLongValue, setShortValue, setStringValue, valueChanged, valueInput

Methods inherited from class com.ergotech.vib.servers.SimpleDataSource

addConnector, addConnector, addDataSource, addPropertyChangeListener, addValueChangedListener, addVetoableChangeListener, authenticatedClientRequest, clientRequest, clientResponse, destroy, determineSuspendedStatus, getClassLicenseManager, getContainer, getCustomTimer, getDataSource, getDataSources, getDisplayName, getExportCriteria, getExposeComponentConnections, getName, getOutPortNames, getPullFromServers, getPushData, getPushName, getPushToServers, getServerListData, getTimebase, getTrace, isActive, isScreenLocal, refreshCurrentValue, removeConnector, removeDataSource, removePropertyChangeListener, removeValueChangedListener, removeVetoableChangeListener, requestSyncWrite, setAutoSuspend, setClassLicenseManager, setContainer, setCustomTimer, setDataSourceName, setExportCriteria, setExposeComponentConnections, setName, setPullFromServers, setPushData, setPushName, setPushToServers, setScreenLocal, setServerListData, setTimebase, setTrace, start, stop, tick, VIBEvent

Methods inherited from class com.ergotech.vib.servers.DataSource

addVIBEventListener, checkScript, executeInScriptInternal, executeScript, executeScriptInternal, executeScriptInternal, getAutoSuspend, getBooleanValue, getBoolValue, getColorHi, getColorHiHi, getColorLo, getColorLoLo, getColorNormal, getConnectors, getConsoleLogger, getCurrentColor, getDataSourceName, getDoubleValue, getFloatValue, getGWTLogger, getIncomingValueObject, getInScript, getIntValue, getLongValue, getParent, getPopupLogger, getScript, getScriptEngine, getSendColors, getSources, getStringValue, getSyncWriteTimeout, getTimedPopupLogger, getTraceLogger, getValueHi, getValueHiHi, getValueLo, getValueLoLo, getValueObject, init, isHardSuspended, isRunning, isSendOnlyChangedValuesDefault, isSuspended, logException, logGWT, logGWT, logMessage, logTrace, n2sortConnectors, performScriptSubstitutions, popupMessage, post, removeConnector, removeVIBEventListener, replaceConnectors, scriptExtensionSubstition, setColorHi, setColorHiHi, setColorLo, setColorLoLo, setColorNormal, setConsoleLogger, setGWTLogger, setHardSuspended, setInScript, setParent, setPopupLogger, setScript, setSendColors, setSendOnlyChangedValuesDefault, setSyncWriteTimeout, setTimedPopupLogger, setTraceLogger, setValueHi, setValueHiHi, setValueLo, setValueLoLo, updateColor, updateListeners, updateListeners, updateListeners, whoAmI

Methods inherited from class java.lang.Object

equals, getClass, hashCode, notify, notifyAll, wait, wait, wait

Field Detail

cvsRev

public static final java.lang.String cvsRev

See Also:

Constant Field Values

Constructor Detail

SQLSelectStatement

public SQLSelectStatement()

Method Detail

getAdditionalWhere

public java.lang.String getAdditionalWhere()

Returns the additional where part of the SQL statement

Returns:

the String additionalWhere.

getEndTime

public java.lang.String getEndTime()

Returns the end time for the WHERE

Returns:

the String endTime

getOptionalLimit

public int getOptionalLimit()

Returns the optional limit. This defaults to 0 which means no limit. Any other integer will limit the select result to that many rows.

Returns:

the int limit.

getOrderBy

public java.lang.String getOrderBy()

Returns the ORDER BY part of the SQL statement

Returns:

the String orderBy.

getSelectColumnList

public java.lang.String getSelectColumnList()

Returns the comma separated column list for the SELECT.

Returns:

the String selectColumnList

getStartTime

public java.lang.String getStartTime()

Returns the start time for the WHERE

Returns:

the String startTime

getTableName

public java.lang.String getTableName()

Returns the table name.

Returns:

the String tableName.

getTimestampColumn

public java.lang.String getTimestampColumn()

Returns the name of the timestamp column in the table.

Returns:

the String timestampColumn.

setAdditionalWhere

public void setAdditionalWhere(java.lang.String additionalWhere)

Set the String for the additional items in the WHERE (will be prepended with " and ".

Parameters:

the - additionalWhere

setEndTime

public void setEndTime(java.lang.String endTime)

Set the end date for the WHERE in the SELECT. Format must be YYYY-MM-DD hh:mm:ss.ms or YYYY-MM-DD or YYYY-MM-DD hh:mm:ss

Parameters:

the - endTime

setOptionalLimit

public void setOptionalLimit(int limit)

Set limit for the select. If set to 0 (the default) there is no limit.

Parameters:

the - optional limit

setOrderBy

public void setOrderBy(java.lang.String orderBy)

Set the String for the ORDER BY

Parameters:

the - orderBy

setSelectColumnList

public void setSelectColumnList(java.lang.String selectColumnList)

Set the comma separated column list or "*" for the SELECT

Parameters:

the - selectColumnList

setStartTime

public void setStartTime(java.lang.String startTime)

Set the start date for the WHERE in the SELECT. Format must be YYYY-MM-DD hh:mm:ss.ms or YYYY-MM-DD or YYYY-MM-DD hh:mm:ss

Parameters:

the - startTime

setTableName

public void setTableName(java.lang.String tableName)

Set the tableName

Parameters:

the - table name

setTimestampColumn

public void setTimestampColumn(java.lang.String timestampColumn)

Sets the timestamp column name.

Parameters:

the - timestamp column name.

setValueObject

public void setValueObject(ValueObjectInterface v)
                    throws VIBUpdateFailedException

This sets the value of the new StringValueObject.

Overrides:

setValueObject in class SimpleDataSource

Parameters:

v - the new ValueObject value for the server

Throws:

VIBUpdateFailedException

See Also:

ValueObject

toString

public java.lang.String toString()

Provides the description and status of the server as a String.

Overrides:

toString in class Manipulator

Returns:

a string description of this server