Class TableCompareMeta
- java.lang.Object
-
- org.pentaho.di.trans.step.BaseStepMeta
-
- org.pentaho.di.trans.steps.tablecompare.TableCompareMeta
-
- All Implemented Interfaces:
Cloneable,StepAttributesInterface,StepMetaInterface
public class TableCompareMeta extends BaseStepMeta implements StepMetaInterface
-
-
Field Summary
-
Fields inherited from class org.pentaho.di.trans.step.BaseStepMeta
attributes, databases, log, loggingObject, parentStepMeta, repository, STEP_ATTRIBUTES_FILE
-
-
Constructor Summary
Constructors Constructor Description TableCompareMeta()
-
Method Summary
All Methods Instance Methods Concrete Methods Modifier and Type Method Description voidcheck(List<org.pentaho.di.core.CheckResultInterface> remarks, TransMeta transMeta, StepMeta stepMeta, org.pentaho.di.core.row.RowMetaInterface prev, String[] input, String[] output, org.pentaho.di.core.row.RowMetaInterface info, org.pentaho.di.core.variables.VariableSpace space, Repository repository, org.pentaho.metastore.api.IMetaStore metaStore)Checks the settings of this step and puts the findings in a remarks List.Objectclone()Make an exact copy of this step, make sure to explicitly copy Collections etc.org.pentaho.di.core.database.DatabaseMetagetCompareConnection()StringgetCompareSchemaField()StringgetCompareTableField()StringgetExcludeFieldsField()voidgetFields(org.pentaho.di.core.row.RowMetaInterface inputRowMeta, String origin, org.pentaho.di.core.row.RowMetaInterface[] info, StepMeta nextStep, org.pentaho.di.core.variables.VariableSpace space, Repository repository, org.pentaho.metastore.api.IMetaStore metaStore)Gets the fields.StringgetKeyDescriptionField()StringgetKeyFieldsField()StringgetNrErrorsField()StringgetNrErrorsInnerJoinField()StringgetNrErrorsLeftJoinField()StringgetNrErrorsRightJoinField()StringgetNrRecordsCompareField()StringgetNrRecordsReferenceField()org.pentaho.di.core.database.DatabaseMetagetReferenceConnection()StringgetReferenceSchemaField()StringgetReferenceTableField()StepInterfacegetStep(StepMeta stepMeta, StepDataInterface stepDataInterface, int cnr, TransMeta tr, Trans trans)Get the executing step, needed by Trans to launch a step.StepDataInterfacegetStepData()Get a new instance of the appropriate data class.org.pentaho.di.core.database.DatabaseMeta[]getUsedDatabaseConnections()This method returns all the database connections that are used by the step.StringgetValueCompareField()StringgetValueReferenceField()StringgetXML()Produces the XML string that describes this step's information.voidloadXML(Node stepnode, List<org.pentaho.di.core.database.DatabaseMeta> databases, org.pentaho.metastore.api.IMetaStore metaStore)Load the values for this step from an XML NodevoidreadRep(Repository rep, org.pentaho.metastore.api.IMetaStore metaStore, org.pentaho.di.repository.ObjectId id_step, List<org.pentaho.di.core.database.DatabaseMeta> databases)Read the steps information from a Kettle repositoryvoidsaveRep(Repository rep, org.pentaho.metastore.api.IMetaStore metaStore, org.pentaho.di.repository.ObjectId id_transformation, org.pentaho.di.repository.ObjectId id_step)Save the steps data into a Kettle repositoryvoidsetCompareConnection(org.pentaho.di.core.database.DatabaseMeta compareConnection)voidsetCompareSchemaField(String compareSchemaField)voidsetCompareTableField(String compareTableField)voidsetDefault()Set default valuesvoidsetExcludeFieldsField(String excludeFieldsField)voidsetKeyDescriptionField(String keyDescriptionField)voidsetKeyFieldsField(String keyFieldsField)voidsetNrErrorsField(String nrErrorsField)voidsetNrErrorsInnerJoinField(String nrErrorsInnerJoinField)voidsetNrErrorsLeftJoinField(String nrErrorsLeftJoinField)voidsetNrErrorsRightJoinField(String nrErrorsRightJoinField)voidsetNrRecordsCompareField(String nrRecordsCompareField)voidsetNrRecordsReferenceField(String nrRecordsReferenceField)voidsetReferenceConnection(org.pentaho.di.core.database.DatabaseMeta referenceConnection)voidsetReferenceSchemaField(String referenceSchemaField)voidsetReferenceTableField(String referenceTableField)voidsetValueCompareField(String valueCompareField)voidsetValueReferenceField(String valueReferenceField)booleansupportsErrorHandling()-
Methods inherited from class org.pentaho.di.trans.step.BaseStepMeta
analyseImpact, analyseImpact, cancelQueries, check, check, createEntry, excludeFromCopyDistributeVerification, excludeFromRowLayoutVerification, exportResources, exportResources, extractStepMetadataEntries, findAttribute, findParent, findParentEntry, getActiveReferencedObjectDescription, getDescription, getDialogClassName, getFields, getLog, getLogChannelId, getName, getObjectCopy, getObjectId, getObjectRevision, getObjectType, getOptionalStreams, getParent, getParentStepMeta, getReferencedObjectDescriptions, getRepCode, getRepositoryDirectory, getRequiredFields, getRequiredFields, getResourceDependencies, getSQLStatements, getSQLStatements, getStepInjectionMetadataEntries, getStepIOMeta, getStepIOMeta, getStepMetaInjectionInterface, getSupportedTransformationTypes, getTableFields, getTooltip, getUsedArguments, getUsedLibraries, getXmlCode, handleStreamSelection, hasChanged, hasRepositoryReferences, isBasic, isDebug, isDetailed, isReferencedObjectEnabled, isRowLevel, loadReferencedObject, loadReferencedObject, loadStepAttributes, loadXML, loadXML, logBasic, logBasic, logDebug, logDebug, logDetailed, logDetailed, logError, logError, logError, logMinimal, logMinimal, logRowlevel, logRowlevel, lookupRepositoryReferences, readRep, readRep, resetStepIoMeta, saveRep, searchInfoAndTargetSteps, setChanged, setChanged, setParentStepMeta, setStepIOMeta
-
Methods inherited from class java.lang.Object
equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
-
Methods inherited from interface org.pentaho.di.trans.step.StepMetaInterface
analyseImpact, analyseImpact, cancelQueries, check, cleanAfterHopFromRemove, cleanAfterHopFromRemove, cleanAfterHopToRemove, excludeFromCopyDistributeVerification, excludeFromRowLayoutVerification, exportResources, exportResources, extractStepMetadataEntries, fetchTransMeta, getActiveReferencedObjectDescription, getDialogClassName, getFields, getOptionalStreams, getParentStepMeta, getReferencedObjectDescriptions, getRequiredFields, getResourceDependencies, getSQLStatements, getSQLStatements, getStepIOMeta, getStepMetaInjectionInterface, getSupportedTransformationTypes, getTableFields, getUsedArguments, getUsedLibraries, handleStreamSelection, hasChanged, hasRepositoryReferences, isReferencedObjectEnabled, loadReferencedObject, loadXML, lookupRepositoryReferences, passDataToServletOutput, readRep, resetStepIoMeta, saveRep, searchInfoAndTargetSteps, setChanged, setParentStepMeta
-
-
-
-
Method Detail
-
getReferenceSchemaField
public String getReferenceSchemaField()
- Returns:
- the referenceSchemaField
-
setReferenceSchemaField
public void setReferenceSchemaField(String referenceSchemaField)
- Parameters:
referenceSchemaField- the referenceSchemaField to set
-
getReferenceTableField
public String getReferenceTableField()
- Returns:
- the referenceTableField
-
setReferenceTableField
public void setReferenceTableField(String referenceTableField)
- Parameters:
referenceTableField- the referenceTableField to set
-
getCompareSchemaField
public String getCompareSchemaField()
- Returns:
- the compareSchemaField
-
setCompareSchemaField
public void setCompareSchemaField(String compareSchemaField)
- Parameters:
compareSchemaField- the compareSchemaField to set
-
getCompareTableField
public String getCompareTableField()
- Returns:
- the compareTableField
-
setCompareTableField
public void setCompareTableField(String compareTableField)
- Parameters:
compareTableField- the compareTableField to set
-
getNrErrorsField
public String getNrErrorsField()
- Returns:
- the nrErrorsField
-
setNrErrorsField
public void setNrErrorsField(String nrErrorsField)
- Parameters:
nrErrorsField- the nrErrorsField to set
-
getReferenceConnection
public org.pentaho.di.core.database.DatabaseMeta getReferenceConnection()
- Returns:
- the referenceConnection
-
setReferenceConnection
public void setReferenceConnection(org.pentaho.di.core.database.DatabaseMeta referenceConnection)
- Parameters:
referenceConnection- the referenceConnection to set
-
getCompareConnection
public org.pentaho.di.core.database.DatabaseMeta getCompareConnection()
- Returns:
- the compareConnection
-
setCompareConnection
public void setCompareConnection(org.pentaho.di.core.database.DatabaseMeta compareConnection)
- Parameters:
compareConnection- the compareConnection to set
-
getUsedDatabaseConnections
public org.pentaho.di.core.database.DatabaseMeta[] getUsedDatabaseConnections()
Description copied from class:BaseStepMetaThis method returns all the database connections that are used by the step.- Specified by:
getUsedDatabaseConnectionsin interfaceStepMetaInterface- Overrides:
getUsedDatabaseConnectionsin classBaseStepMeta- Returns:
- an array of database connections meta-data. Return an empty array if no connections are used.
-
getKeyFieldsField
public String getKeyFieldsField()
- Returns:
- the keyFieldsField
-
setKeyFieldsField
public void setKeyFieldsField(String keyFieldsField)
- Parameters:
keyFieldsField- the keyFieldsField to set
-
getExcludeFieldsField
public String getExcludeFieldsField()
- Returns:
- the excludeFieldsField
-
setExcludeFieldsField
public void setExcludeFieldsField(String excludeFieldsField)
- Parameters:
excludeFieldsField- the excludeFieldsField to set
-
getNrRecordsReferenceField
public String getNrRecordsReferenceField()
- Returns:
- the nrRecordsReferenceField
-
setNrRecordsReferenceField
public void setNrRecordsReferenceField(String nrRecordsReferenceField)
- Parameters:
nrRecordsReferenceField- the nrRecordsReferenceField to set
-
getNrRecordsCompareField
public String getNrRecordsCompareField()
- Returns:
- the nrRecordsCompareField
-
setNrRecordsCompareField
public void setNrRecordsCompareField(String nrRecordsCompareField)
- Parameters:
nrRecordsCompareField- the nrRecordsCompareField to set
-
getNrErrorsLeftJoinField
public String getNrErrorsLeftJoinField()
- Returns:
- the nrErrorsLeftJoinField
-
setNrErrorsLeftJoinField
public void setNrErrorsLeftJoinField(String nrErrorsLeftJoinField)
- Parameters:
nrErrorsLeftJoinField- the nrErrorsLeftJoinField to set
-
getNrErrorsInnerJoinField
public String getNrErrorsInnerJoinField()
- Returns:
- the nrErrorsInnerJoinField
-
setNrErrorsInnerJoinField
public void setNrErrorsInnerJoinField(String nrErrorsInnerJoinField)
- Parameters:
nrErrorsInnerJoinField- the nrErrorsInnerJoinField to set
-
getNrErrorsRightJoinField
public String getNrErrorsRightJoinField()
- Returns:
- the nrErrorsRightJoinField
-
setNrErrorsRightJoinField
public void setNrErrorsRightJoinField(String nrErrorsRightJoinField)
- Parameters:
nrErrorsRightJoinField- the nrErrorsRightJoinField to set
-
getKeyDescriptionField
public String getKeyDescriptionField()
- Returns:
- the keyDescriptionField
-
setKeyDescriptionField
public void setKeyDescriptionField(String keyDescriptionField)
- Parameters:
keyDescriptionField- the keyDescriptionField to set
-
getValueReferenceField
public String getValueReferenceField()
- Returns:
- the valueReferenceField
-
setValueReferenceField
public void setValueReferenceField(String valueReferenceField)
- Parameters:
valueReferenceField- the valueReferenceField to set
-
getValueCompareField
public String getValueCompareField()
- Returns:
- the valueCompareField
-
setValueCompareField
public void setValueCompareField(String valueCompareField)
- Parameters:
valueCompareField- the valueCompareField to set
-
loadXML
public void loadXML(Node stepnode, List<org.pentaho.di.core.database.DatabaseMeta> databases, org.pentaho.metastore.api.IMetaStore metaStore) throws org.pentaho.di.core.exception.KettleXMLException
Description copied from interface:StepMetaInterfaceLoad the values for this step from an XML Node- Specified by:
loadXMLin interfaceStepMetaInterface- Overrides:
loadXMLin classBaseStepMeta- Parameters:
stepnode- the Node to get the info fromdatabases- The available list of databases to reference tometaStore- the metastore to optionally load external reference metadata from- Throws:
org.pentaho.di.core.exception.KettleXMLException- When an unexpected XML error occurred. (malformed etc.)
-
clone
public Object clone()
Description copied from interface:StepMetaInterfaceMake an exact copy of this step, make sure to explicitly copy Collections etc.- Specified by:
clonein interfaceStepMetaInterface- Overrides:
clonein classBaseStepMeta- Returns:
- an exact copy of this step
-
getFields
public void getFields(org.pentaho.di.core.row.RowMetaInterface inputRowMeta, String origin, org.pentaho.di.core.row.RowMetaInterface[] info, StepMeta nextStep, org.pentaho.di.core.variables.VariableSpace space, Repository repository, org.pentaho.metastore.api.IMetaStore metaStore) throws org.pentaho.di.core.exception.KettleStepExceptionDescription copied from class:BaseStepMetaGets the fields.- Specified by:
getFieldsin interfaceStepMetaInterface- Overrides:
getFieldsin classBaseStepMeta- Parameters:
inputRowMeta- the input row meta that is modified in this method to reflect the output row metadata of the steporigin- Name of the step to use as input for the origin field in the valuesinfo- Fields used as extra lookup informationnextStep- the next step that is targetedspace- the space The variable space to use to replace variablesrepository- the repository to use to load Kettle metadata objects impacting the output fieldsmetaStore- the MetaStore to use to load additional external data or metadata impacting the output fields- Throws:
org.pentaho.di.core.exception.KettleStepException- the kettle step exception
-
getXML
public String getXML()
Description copied from class:BaseStepMetaProduces the XML string that describes this step's information.- Specified by:
getXMLin interfaceStepMetaInterface- Overrides:
getXMLin classBaseStepMeta- Returns:
- String containing the XML describing this step.
-
setDefault
public void setDefault()
Description copied from interface:StepMetaInterfaceSet default values- Specified by:
setDefaultin interfaceStepMetaInterface
-
readRep
public void readRep(Repository rep, org.pentaho.metastore.api.IMetaStore metaStore, org.pentaho.di.repository.ObjectId id_step, List<org.pentaho.di.core.database.DatabaseMeta> databases) throws org.pentaho.di.core.exception.KettleException
Description copied from interface:StepMetaInterfaceRead the steps information from a Kettle repository- Specified by:
readRepin interfaceStepMetaInterface- Overrides:
readRepin classBaseStepMeta- Parameters:
rep- The repository to read frommetaStore- The MetaStore to read external information fromid_step- The step IDdatabases- The databases to reference- Throws:
org.pentaho.di.core.exception.KettleException- When an unexpected error occurred (database, network, etc)
-
saveRep
public void saveRep(Repository rep, org.pentaho.metastore.api.IMetaStore metaStore, org.pentaho.di.repository.ObjectId id_transformation, org.pentaho.di.repository.ObjectId id_step) throws org.pentaho.di.core.exception.KettleException
Description copied from interface:StepMetaInterfaceSave the steps data into a Kettle repository- Specified by:
saveRepin interfaceStepMetaInterface- Overrides:
saveRepin classBaseStepMeta- Parameters:
rep- The Kettle repository to save tometaStore- the metaStore to optionally write toid_transformation- The transformation IDid_step- The step ID- Throws:
org.pentaho.di.core.exception.KettleException- When an unexpected error occurred (database, network, etc)
-
check
public void check(List<org.pentaho.di.core.CheckResultInterface> remarks, TransMeta transMeta, StepMeta stepMeta, org.pentaho.di.core.row.RowMetaInterface prev, String[] input, String[] output, org.pentaho.di.core.row.RowMetaInterface info, org.pentaho.di.core.variables.VariableSpace space, Repository repository, org.pentaho.metastore.api.IMetaStore metaStore)
Description copied from interface:StepMetaInterfaceChecks the settings of this step and puts the findings in a remarks List.- Specified by:
checkin interfaceStepMetaInterface- Overrides:
checkin classBaseStepMeta- Parameters:
remarks- The list to put the remarks in @see org.pentaho.di.core.CheckResultstepMeta- The stepMeta to help checkingprev- The fields coming from the previous stepinput- The input step namesoutput- The output step namesinfo- The fields that are used as information by the stepspace- the variable space to resolve variable expressions withrepository- the repository to use to load Kettle metadata objects impacting the output fieldsmetaStore- the MetaStore to use to load additional external data or metadata impacting the output fields
-
getStep
public StepInterface getStep(StepMeta stepMeta, StepDataInterface stepDataInterface, int cnr, TransMeta tr, Trans trans)
Description copied from interface:StepMetaInterfaceGet the executing step, needed by Trans to launch a step.- Specified by:
getStepin interfaceStepMetaInterface- Parameters:
stepMeta- The step infostepDataInterface- the step data interface linked to this step. Here the step can store temporary data, database connections, etc.cnr- The copy nr to gettr- The transformation infotrans- The launching transformation
-
getStepData
public StepDataInterface getStepData()
Description copied from interface:StepMetaInterfaceGet a new instance of the appropriate data class. This data class implements the StepDataInterface. It basically contains the persisting data that needs to live on, even if a worker thread is terminated.- Specified by:
getStepDatain interfaceStepMetaInterface- Returns:
- The appropriate StepDataInterface class.
-
supportsErrorHandling
public boolean supportsErrorHandling()
- Specified by:
supportsErrorHandlingin interfaceStepMetaInterface- Overrides:
supportsErrorHandlingin classBaseStepMeta- Returns:
- true if this step supports error "reporting" on rows: the ability to send rows to a certain target step.
-
-