Package adams.flow.transformer
Class LookUpInit
-
- All Implemented Interfaces:
AdditionalInformationHandler,CleanUpHandler,Destroyable,GlobalInfoSupporter,LoggingLevelHandler,LoggingSupporter,OptionHandler,QuickInfoSupporter,ShallowCopySupporter<Actor>,SizeOfHandler,Stoppable,StoppableWithFeedback,VariablesInspectionHandler,VariableChangeListener,StorageUpdater,Actor,ErrorHandler,InputConsumer,OutputProducer,Serializable,Comparable
public class LookUpInit extends AbstractSpreadSheetTransformer implements StorageUpdater
Creates a lookup table from a spreadsheet, using one column as key and another one as value. The lookup table itself gets stored in the internal storage under the specified name.
Input/output:
- accepts:
adams.data.spreadsheet.SpreadSheet
- generates:
adams.data.spreadsheet.SpreadSheet
Valid options are:
-D <int> (property: debugLevel) The greater the number the more additional info the scheme may output to the console (0 = off). default: 0 minimum: 0
-name <java.lang.String> (property: name) The name of the actor. default: LookUpInit
-annotation <adams.core.base.BaseText> (property: annotations) The annotations to attach to this actor. default:
-skip (property: skip) If set to true, transformation is skipped and the input token is just forwarded as it is.
-stop-flow-on-error (property: stopFlowOnError) If set to true, the flow gets stopped in case this actor encounters an error; useful for critical actors.
-storage-name <adams.flow.control.StorageName> (property: storageName) The name for the lookup table in the internal storage. default: lookup
-key-column <adams.core.Index> (property: keyColumn) The index of the column in the spreadsheet to use as key; An index is a number starting with 1; the following placeholders can be used as well: first, second, third, last_2, last_1, last default: 1
-value-column <adams.core.Index> (property: valueColumn) The index of the column in the spreadsheet to use as value; An index is a number starting with 1; the following placeholders can be used as well: first, second, third, last_2, last_1, last default: 2
- Author:
- fracpete (fracpete at waikato dot ac dot nz)
- See Also:
- Serialized Form
-
-
Field Summary
Fields Modifier and Type Field Description protected SpreadSheetColumnIndexm_KeyColumnthe index of the column to use as key.protected StorageNamem_StorageNamethe name of the lookup table in the internal storage.protected booleanm_UseNativewhether to output native objects rather than strings.protected SpreadSheetColumnIndexm_ValueColumnthe index of the column to use as value.-
Fields inherited from class adams.flow.transformer.AbstractTransformer
BACKUP_INPUT, BACKUP_OUTPUT, m_InputToken, m_OutputToken
-
Fields inherited from class adams.flow.core.AbstractActor
m_Annotations, m_BackupState, m_DetectedObjectVariables, m_DetectedVariables, m_ErrorHandler, m_Executed, m_Executing, m_ExecutionListeningSupporter, m_FullName, m_LoggingPrefix, m_Name, m_Parent, m_ScopeHandler, m_Self, m_Silent, m_Skip, m_StopFlowOnError, m_StopMessage, m_Stopped, m_StorageHandler, m_VariablesUpdated
-
Fields inherited from class adams.core.option.AbstractOptionHandler
m_OptionManager
-
Fields inherited from class adams.core.logging.LoggingObject
m_Logger, m_LoggingIsEnabled, m_LoggingLevel
-
Fields inherited from interface adams.flow.core.Actor
FILE_EXTENSION, FILE_EXTENSION_GZ
-
-
Constructor Summary
Constructors Constructor Description LookUpInit()
-
Method Summary
All Methods Instance Methods Concrete Methods Modifier and Type Method Description voiddefineOptions()Adds options to the internal list of options.protected StringdoExecute()Executes the flow item.SpreadSheetColumnIndexgetKeyColumn()Returns the index of the column to act as key in the lookup table.StringgetQuickInfo()Returns a quick info about the actor, which will be displayed in the GUI.StorageNamegetStorageName()Returns the name for the lookup table in the internal storage.booleangetUseNative()Returns whether native objects are output rather than strings.SpreadSheetColumnIndexgetValueColumn()Returns the index of the column to act as value in the lookup table.StringglobalInfo()Returns a string describing the object.booleanisUpdatingStorage()Returns whether storage items are being updated.StringkeyColumnTipText()Returns the tip text for this property.voidsetKeyColumn(SpreadSheetColumnIndex value)Sets the index of the column to act as key in the lookup table.voidsetStorageName(StorageName value)Sets the name for the lookup table in the internal storage.voidsetUseNative(boolean value)Sets whether to output native objects rather than strings.voidsetValueColumn(SpreadSheetColumnIndex value)Sets the index of the column to act as value in the lookup table.StringstorageNameTipText()Returns the tip text for this property.StringuseNativeTipText()Returns the tip text for this property.StringvalueColumnTipText()Returns the tip text for this property.-
Methods inherited from class adams.flow.transformer.AbstractSpreadSheetTransformer
accepts, generates
-
Methods inherited from class adams.flow.transformer.AbstractTransformer
backupState, currentInput, execute, hasInput, hasPendingOutput, input, output, postExecute, restoreState, wrapUp
-
Methods inherited from class adams.flow.core.AbstractActor
annotationsTipText, canInspectOptions, canPerformSetUpCheck, cleanUp, compareTo, configureLogger, destroy, equals, finalUpdateVariables, findVariables, findVariables, forceVariables, forCommandLine, forName, forName, getAdditionalInformation, getAnnotations, getDefaultName, getDetectedVariables, getErrorHandler, getFlowActors, getFlowExecutionListeningSupporter, getFullName, getName, getNextSibling, getParent, getParentComponent, getPreviousSibling, getRoot, getScopeHandler, getSilent, getSkip, getStopFlowOnError, getStopMessage, getStorageHandler, getVariables, handleError, handleException, hasErrorHandler, hasStopMessage, index, initialize, isBackedUp, isExecuted, isExecuting, isFinished, isHeadless, isStopped, nameTipText, performSetUpChecks, performVariableChecks, preExecute, pruneBackup, pruneBackup, reset, setAnnotations, setErrorHandler, setName, setParent, setSilent, setSkip, setStopFlowOnError, setUp, setVariables, shallowCopy, shallowCopy, silentTipText, sizeOf, skipTipText, stopExecution, stopExecution, stopFlowOnErrorTipText, updateDetectedVariables, updatePrefix, updateVariables, variableChanged
-
Methods inherited from class adams.core.option.AbstractOptionHandler
cleanUpOptions, finishInit, getDefaultLoggingLevel, getOptionManager, loggingLevelTipText, newOptionManager, setLoggingLevel, toCommandLine, toString
-
Methods inherited from class adams.core.logging.LoggingObject
getLogger, getLoggingLevel, initializeLogging, isLoggingEnabled
-
Methods inherited from class java.lang.Object
clone, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait
-
Methods inherited from interface adams.flow.core.Actor
cleanUp, compareTo, destroy, equals, findVariables, getAnnotations, getDefaultName, getDetectedVariables, getErrorHandler, getFlowExecutionListeningSupporter, getFullName, getName, getNextSibling, getParent, getParentComponent, getPreviousSibling, getRoot, getScopeHandler, getSilent, getSkip, getStopFlowOnError, getStopMessage, getStorageHandler, getVariables, handleError, hasErrorHandler, hasStopMessage, index, isExecuted, isFinished, isHeadless, isStopped, setAnnotations, setErrorHandler, setName, setParent, setSilent, setSkip, setStopFlowOnError, setUp, setVariables, shallowCopy, shallowCopy, sizeOf, stopExecution, stopExecution, toCommandLine, variableChanged
-
Methods inherited from interface adams.core.AdditionalInformationHandler
getAdditionalInformation
-
Methods inherited from interface adams.core.logging.LoggingLevelHandler
getLoggingLevel, setLoggingLevel
-
Methods inherited from interface adams.core.logging.LoggingSupporter
getLogger, isLoggingEnabled
-
Methods inherited from interface adams.core.option.OptionHandler
cleanUpOptions, getOptionManager
-
Methods inherited from interface adams.core.VariablesInspectionHandler
canInspectOptions
-
-
-
-
Field Detail
-
m_StorageName
protected StorageName m_StorageName
the name of the lookup table in the internal storage.
-
m_KeyColumn
protected SpreadSheetColumnIndex m_KeyColumn
the index of the column to use as key.
-
m_ValueColumn
protected SpreadSheetColumnIndex m_ValueColumn
the index of the column to use as value.
-
m_UseNative
protected boolean m_UseNative
whether to output native objects rather than strings.
-
-
Method Detail
-
globalInfo
public String globalInfo()
Returns a string describing the object.- Specified by:
globalInfoin interfaceGlobalInfoSupporter- Specified by:
globalInfoin classAbstractOptionHandler- Returns:
- a description suitable for displaying in the gui
-
defineOptions
public void defineOptions()
Adds options to the internal list of options.- Specified by:
defineOptionsin interfaceOptionHandler- Overrides:
defineOptionsin classAbstractActor
-
isUpdatingStorage
public boolean isUpdatingStorage()
Returns whether storage items are being updated.- Specified by:
isUpdatingStoragein interfaceStorageUpdater- Returns:
- true if storage items are updated
-
getQuickInfo
public String getQuickInfo()
Returns a quick info about the actor, which will be displayed in the GUI.- Specified by:
getQuickInfoin interfaceActor- Specified by:
getQuickInfoin interfaceQuickInfoSupporter- Overrides:
getQuickInfoin classAbstractActor- Returns:
- null if no info available, otherwise short string
-
setStorageName
public void setStorageName(StorageName value)
Sets the name for the lookup table in the internal storage.- Parameters:
value- the name
-
getStorageName
public StorageName getStorageName()
Returns the name for the lookup table in the internal storage.- Returns:
- the name
-
storageNameTipText
public String storageNameTipText()
Returns the tip text for this property.- Returns:
- tip text for this property suitable for displaying in the GUI or for listing the options.
-
setKeyColumn
public void setKeyColumn(SpreadSheetColumnIndex value)
Sets the index of the column to act as key in the lookup table.- Parameters:
value- the index
-
getKeyColumn
public SpreadSheetColumnIndex getKeyColumn()
Returns the index of the column to act as key in the lookup table.- Returns:
- the index
-
keyColumnTipText
public String keyColumnTipText()
Returns the tip text for this property.- Returns:
- tip text for this property suitable for displaying in the GUI or for listing the options.
-
setValueColumn
public void setValueColumn(SpreadSheetColumnIndex value)
Sets the index of the column to act as value in the lookup table.- Parameters:
value- the index
-
getValueColumn
public SpreadSheetColumnIndex getValueColumn()
Returns the index of the column to act as value in the lookup table.- Returns:
- the index
-
valueColumnTipText
public String valueColumnTipText()
Returns the tip text for this property.- Returns:
- tip text for this property suitable for displaying in the GUI or for listing the options.
-
setUseNative
public void setUseNative(boolean value)
Sets whether to output native objects rather than strings.- Parameters:
value- true if to output native objects
-
getUseNative
public boolean getUseNative()
Returns whether native objects are output rather than strings.- Returns:
- true if native objects are used
-
useNativeTipText
public String useNativeTipText()
Returns the tip text for this property.- Returns:
- tip text for this property suitable for displaying in the GUI or for listing the options.
-
doExecute
protected String doExecute()
Executes the flow item.- Specified by:
doExecutein classAbstractActor- Returns:
- null if everything is fine, otherwise error message
-
-