org.pentaho.di.job.entries.evaluatetablecontent
Class JobEntryEvalTableContent

java.lang.Object
  extended by org.pentaho.di.job.entry.JobEntryBase
      extended by org.pentaho.di.job.entries.evaluatetablecontent.JobEntryEvalTableContent
All Implemented Interfaces:
Cloneable, CheckResultSourceInterface, LoggingObjectInterface, VariableSpace, JobEntryInterface, ResourceHolderInterface

public class JobEntryEvalTableContent
extends JobEntryBase
implements Cloneable, JobEntryInterface

This defines a Table content evaluation job entry

Since:
22-07-2008
Author:
Samatar

Field Summary
 String customSQL
           
 boolean isAddRowsResult
           
 boolean isClearResultList
           
 boolean iscustomSQL
           
 boolean isUseVars
           
 String limit
           
 String schemaname
           
static int SUCCESS_CONDITION_ROWS_COUNT_DIFFERENT
           
static int SUCCESS_CONDITION_ROWS_COUNT_EQUAL
           
static int SUCCESS_CONDITION_ROWS_COUNT_GREATER
           
static int SUCCESS_CONDITION_ROWS_COUNT_GREATER_EQUAL
           
static int SUCCESS_CONDITION_ROWS_COUNT_SMALLER
           
static int SUCCESS_CONDITION_ROWS_COUNT_SMALLER_EQUAL
           
 int successCondition
           
static String[] successConditionsCode
           
static String[] successConditionsDesc
           
 String tablename
           
 
Constructor Summary
JobEntryEvalTableContent()
           
JobEntryEvalTableContent(String n)
           
 
Method Summary
 void check(List<CheckResultInterface> remarks, JobMeta jobMeta)
          Support for overrides not having to put in a check method.
 Object clone()
          This method is called when a job entry is duplicated in Spoon.
 boolean evaluates()
          This method must return true if the job entry supports the true/false outgoing hops.
 Result execute(Result previousResult, int nr)
          Execute the job entry.
 DatabaseMeta getDatabase()
           
 List<ResourceReference> getResourceDependencies(JobMeta jobMeta)
          Gets a list of all the resource dependencies that the step is depending on.
 int getSuccessCobdition()
           
static int getSuccessConditionByDesc(String tt)
           
static String getSuccessConditionDesc(int i)
           
 DatabaseMeta[] getUsedDatabaseConnections()
          Gets all the database connections that are used by the job entry.
 String getXML()
          This method is called by PDI whenever a job entry needs to serialize its settings to XML.
 boolean isUnconditional()
          This method must return true if the job entry supports the unconditional outgoing hop.
 void loadRep(Repository rep, ObjectId id_jobentry, List<DatabaseMeta> databases, List<SlaveServer> slaveServers)
          This method is called by PDI whenever a job entry needs to read its configuration from a PDI repository.
 void loadXML(Node entrynode, List<DatabaseMeta> databases, List<SlaveServer> slaveServers, Repository rep)
          This method is called by PDI whenever a job entry needs to read its settings from XML.
 void saveRep(Repository rep, ObjectId id_job)
          This method is called by PDI whenever a job entry needs to save its settings to a PDI repository.
 void setDatabase(DatabaseMeta database)
           
 
Methods inherited from class org.pentaho.di.job.entry.JobEntryBase
clear, copyVariablesFrom, environmentSubstitute, environmentSubstitute, equals, exportResources, getBooleanValueOfVariable, getContainerObjectId, getDescription, getDialogClassName, getFilename, getHolderType, getLogChannel, getLogChannelId, getLogLevel, getName, getObjectCopy, getObjectId, getObjectName, getObjectRevision, getObjectType, getParent, getParentJob, getParentVariableSpace, getPluginId, getRealFilename, getRegistrationDate, getRepository, getRepositoryDirectory, getSQLStatements, getSQLStatements, getTypeDesc, getTypeId, getVariable, getVariable, hasChanged, hasRepositoryReferences, initializeVariablesFrom, injectVariables, isBasic, isDebug, isDetailed, isDummy, isEvaluation, isFTP, isHTTP, isJob, isMail, isRowlevel, isSFTP, isShell, isSpecial, isStart, isTransformation, listVariables, loadXML, logBasic, logBasic, logDebug, logDebug, logDetailed, logDetailed, logError, logError, logError, logMinimal, logMinimal, logRowlevel, logRowlevel, lookupRepositoryReferences, parseRepositoryObjects, resetErrorsBeforeExecution, setChanged, setChanged, setContainerObjectId, setDescription, setID, setLogLevel, setName, setObjectId, setParentJob, setParentVariableSpace, setPluginId, setRepository, setTypeId, setVariable, shareVariablesWith, toString
 
Methods inherited from class java.lang.Object
getClass, hashCode, notify, notifyAll, wait, wait, wait
 
Methods inherited from interface org.pentaho.di.job.entry.JobEntryInterface
clear, exportResources, getDescription, getDialogClassName, getFilename, getLogChannel, getName, getObjectId, getParentJob, getPluginId, getRealFilename, getSQLStatements, getSQLStatements, getTypeId, hasChanged, hasRepositoryReferences, isDummy, isEvaluation, isJob, isMail, isShell, isSpecial, isStart, isTransformation, lookupRepositoryReferences, resetErrorsBeforeExecution, setChanged, setChanged, setDescription, setName, setObjectId, setParentJob, setPluginId, setRepository
 

Field Detail

isAddRowsResult

public boolean isAddRowsResult

isClearResultList

public boolean isClearResultList

isUseVars

public boolean isUseVars

iscustomSQL

public boolean iscustomSQL

customSQL

public String customSQL

tablename

public String tablename

schemaname

public String schemaname

successConditionsDesc

public static final String[] successConditionsDesc

successConditionsCode

public static final String[] successConditionsCode

SUCCESS_CONDITION_ROWS_COUNT_EQUAL

public static final int SUCCESS_CONDITION_ROWS_COUNT_EQUAL
See Also:
Constant Field Values

SUCCESS_CONDITION_ROWS_COUNT_DIFFERENT

public static final int SUCCESS_CONDITION_ROWS_COUNT_DIFFERENT
See Also:
Constant Field Values

SUCCESS_CONDITION_ROWS_COUNT_SMALLER

public static final int SUCCESS_CONDITION_ROWS_COUNT_SMALLER
See Also:
Constant Field Values

SUCCESS_CONDITION_ROWS_COUNT_SMALLER_EQUAL

public static final int SUCCESS_CONDITION_ROWS_COUNT_SMALLER_EQUAL
See Also:
Constant Field Values

SUCCESS_CONDITION_ROWS_COUNT_GREATER

public static final int SUCCESS_CONDITION_ROWS_COUNT_GREATER
See Also:
Constant Field Values

SUCCESS_CONDITION_ROWS_COUNT_GREATER_EQUAL

public static final int SUCCESS_CONDITION_ROWS_COUNT_GREATER_EQUAL
See Also:
Constant Field Values

limit

public String limit

successCondition

public int successCondition
Constructor Detail

JobEntryEvalTableContent

public JobEntryEvalTableContent(String n)

JobEntryEvalTableContent

public JobEntryEvalTableContent()
Method Detail

clone

public Object clone()
Description copied from class: JobEntryBase
This method is called when a job entry is duplicated in Spoon. It needs to return a deep copy of this job entry object. It is essential that the implementing class creates proper deep copies if the job entry configuration is stored in modifiable objects, such as lists or custom helper objects.

Specified by:
clone in interface JobEntryInterface
Overrides:
clone in class JobEntryBase
Returns:
a clone of the object

getSuccessCobdition

public int getSuccessCobdition()

getSuccessConditionByDesc

public static int getSuccessConditionByDesc(String tt)

getXML

public String getXML()
Description copied from class: JobEntryBase
This method is called by PDI whenever a job entry needs to serialize its settings to XML. It is called when saving a job in Spoon. The method returns an XML string, containing the serialized settings. The string contains a series of XML tags, typically one tag per setting. The helper class org.pentaho.di.core.xml.XMLHandler is typically used to construct the XML string.

Specified by:
getXML in interface JobEntryInterface
Overrides:
getXML in class JobEntryBase
Returns:
the xml representation of the job entry

getSuccessConditionDesc

public static String getSuccessConditionDesc(int i)

loadXML

public void loadXML(Node entrynode,
                    List<DatabaseMeta> databases,
                    List<SlaveServer> slaveServers,
                    Repository rep)
             throws KettleXMLException
Description copied from interface: JobEntryInterface
This method is called by PDI whenever a job entry needs to read its settings from XML. The XML node containing the job entry�s settings is passed in as an argument. Again, the helper class org.pentaho.di.core.xml.XMLHandler is typically used to conveniently read the settings from the XML node.

Specified by:
loadXML in interface JobEntryInterface
Parameters:
entrynode - the top-level XML node
databases - the list of databases
slaveServers - the list of slave servers
rep - the repository object
Throws:
KettleXMLException - if any errors occur during the loading of the XML

loadRep

public void loadRep(Repository rep,
                    ObjectId id_jobentry,
                    List<DatabaseMeta> databases,
                    List<SlaveServer> slaveServers)
             throws KettleException
Description copied from class: JobEntryBase
This method is called by PDI whenever a job entry needs to read its configuration from a PDI repository. For JobEntryBase, this method performs no operations.

Specified by:
loadRep in interface JobEntryInterface
Overrides:
loadRep in class JobEntryBase
Parameters:
rep - the repository object
id_jobentry - the id of the job entry
databases - the list of databases
slaveServers - the list of slave servers
Throws:
KettleException - if any errors occur during the load

saveRep

public void saveRep(Repository rep,
                    ObjectId id_job)
             throws KettleException
Description copied from class: JobEntryBase
This method is called by PDI whenever a job entry needs to save its settings to a PDI repository. For JobEntryBase, this method performs no operations

Specified by:
saveRep in interface JobEntryInterface
Overrides:
saveRep in class JobEntryBase
Parameters:
rep - the repository object
id_job - the id_job
Throws:
KettleException - if any errors occur during the save

setDatabase

public void setDatabase(DatabaseMeta database)

getDatabase

public DatabaseMeta getDatabase()

evaluates

public boolean evaluates()
Description copied from class: JobEntryBase
This method must return true if the job entry supports the true/false outgoing hops. For JobEntryBase, this method always returns false

Specified by:
evaluates in interface JobEntryInterface
Overrides:
evaluates in class JobEntryBase
Returns:
false

isUnconditional

public boolean isUnconditional()
Description copied from class: JobEntryBase
This method must return true if the job entry supports the unconditional outgoing hop. For JobEntryBase, this method always returns true

Specified by:
isUnconditional in interface JobEntryInterface
Overrides:
isUnconditional in class JobEntryBase
Returns:
true

execute

public Result execute(Result previousResult,
                      int nr)
Description copied from interface: JobEntryInterface
Execute the job entry. The previous result and number of rows are provided to the method for the purpose of chaining job entries, transformations, etc.

Specified by:
execute in interface JobEntryInterface
Parameters:
previousResult - the previous result
nr - the number of rows
Returns:
the Result object from execution of this job entry

getUsedDatabaseConnections

public DatabaseMeta[] getUsedDatabaseConnections()
Description copied from class: JobEntryBase
Gets all the database connections that are used by the job entry. For JobEntryBase, this method returns an empty (non-null) array

Specified by:
getUsedDatabaseConnections in interface JobEntryInterface
Overrides:
getUsedDatabaseConnections in class JobEntryBase
Returns:
an empty (non-null) array

getResourceDependencies

public List<ResourceReference> getResourceDependencies(JobMeta jobMeta)
Description copied from class: JobEntryBase
Gets a list of all the resource dependencies that the step is depending on. In JobEntryBase, this method returns an empty resource dependency list.

Specified by:
getResourceDependencies in interface JobEntryInterface
Overrides:
getResourceDependencies in class JobEntryBase
Returns:
an empty list of ResourceReferences
See Also:
ResourceReference

check

public void check(List<CheckResultInterface> remarks,
                  JobMeta jobMeta)
Description copied from class: JobEntryBase
Support for overrides not having to put in a check method. For JobEntryBase, this method performs no operations.

Specified by:
check in interface JobEntryInterface
Overrides:
check in class JobEntryBase
Parameters:
remarks - CheckResults from checking the job entry
jobMeta - JobMeta information letting threading back to the JobMeta possible