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 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)
Checks the settings of this step and puts the findings in a remarks List.Object
clone()
Make an exact copy of this step, make sure to explicitly copy Collections etc.org.pentaho.di.core.database.DatabaseMeta
getCompareConnection()
String
getCompareSchemaField()
String
getCompareTableField()
String
getExcludeFieldsField()
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)
Gets the fields.String
getKeyDescriptionField()
String
getKeyFieldsField()
String
getNrErrorsField()
String
getNrErrorsInnerJoinField()
String
getNrErrorsLeftJoinField()
String
getNrErrorsRightJoinField()
String
getNrRecordsCompareField()
String
getNrRecordsReferenceField()
org.pentaho.di.core.database.DatabaseMeta
getReferenceConnection()
String
getReferenceSchemaField()
String
getReferenceTableField()
StepInterface
getStep(StepMeta stepMeta, StepDataInterface stepDataInterface, int cnr, TransMeta tr, Trans trans)
Get the executing step, needed by Trans to launch a step.StepDataInterface
getStepData()
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.String
getValueCompareField()
String
getValueReferenceField()
String
getXML()
Produces the XML string that describes this step's information.void
loadXML(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 Nodevoid
readRep(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 repositoryvoid
saveRep(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 repositoryvoid
setCompareConnection(org.pentaho.di.core.database.DatabaseMeta compareConnection)
void
setCompareSchemaField(String compareSchemaField)
void
setCompareTableField(String compareTableField)
void
setDefault()
Set default valuesvoid
setExcludeFieldsField(String excludeFieldsField)
void
setKeyDescriptionField(String keyDescriptionField)
void
setKeyFieldsField(String keyFieldsField)
void
setNrErrorsField(String nrErrorsField)
void
setNrErrorsInnerJoinField(String nrErrorsInnerJoinField)
void
setNrErrorsLeftJoinField(String nrErrorsLeftJoinField)
void
setNrErrorsRightJoinField(String nrErrorsRightJoinField)
void
setNrRecordsCompareField(String nrRecordsCompareField)
void
setNrRecordsReferenceField(String nrRecordsReferenceField)
void
setReferenceConnection(org.pentaho.di.core.database.DatabaseMeta referenceConnection)
void
setReferenceSchemaField(String referenceSchemaField)
void
setReferenceTableField(String referenceTableField)
void
setValueCompareField(String valueCompareField)
void
setValueReferenceField(String valueReferenceField)
boolean
supportsErrorHandling()
-
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:BaseStepMeta
This method returns all the database connections that are used by the step.- Specified by:
getUsedDatabaseConnections
in interfaceStepMetaInterface
- Overrides:
getUsedDatabaseConnections
in 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:StepMetaInterface
Load the values for this step from an XML Node- Specified by:
loadXML
in interfaceStepMetaInterface
- Overrides:
loadXML
in 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:StepMetaInterface
Make an exact copy of this step, make sure to explicitly copy Collections etc.- Specified by:
clone
in interfaceStepMetaInterface
- Overrides:
clone
in 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.KettleStepException
Description copied from class:BaseStepMeta
Gets the fields.- Specified by:
getFields
in interfaceStepMetaInterface
- Overrides:
getFields
in 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:BaseStepMeta
Produces the XML string that describes this step's information.- Specified by:
getXML
in interfaceStepMetaInterface
- Overrides:
getXML
in classBaseStepMeta
- Returns:
- String containing the XML describing this step.
-
setDefault
public void setDefault()
Description copied from interface:StepMetaInterface
Set default values- Specified by:
setDefault
in 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:StepMetaInterface
Read the steps information from a Kettle repository- Specified by:
readRep
in interfaceStepMetaInterface
- Overrides:
readRep
in 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:StepMetaInterface
Save the steps data into a Kettle repository- Specified by:
saveRep
in interfaceStepMetaInterface
- Overrides:
saveRep
in 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:StepMetaInterface
Checks the settings of this step and puts the findings in a remarks List.- Specified by:
check
in interfaceStepMetaInterface
- Overrides:
check
in 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:StepMetaInterface
Get the executing step, needed by Trans to launch a step.- Specified by:
getStep
in 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:StepMetaInterface
Get 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:
getStepData
in interfaceStepMetaInterface
- Returns:
- The appropriate StepDataInterface class.
-
supportsErrorHandling
public boolean supportsErrorHandling()
- Specified by:
supportsErrorHandling
in interfaceStepMetaInterface
- Overrides:
supportsErrorHandling
in classBaseStepMeta
- Returns:
- true if this step supports error "reporting" on rows: the ability to send rows to a certain target step.
-
-