Class JobEntryMysqlBulkLoad
- java.lang.Object
-
- org.pentaho.di.job.entry.JobEntryBase
-
- org.pentaho.di.job.entries.mysqlbulkload.JobEntryMysqlBulkLoad
-
- All Implemented Interfaces:
Cloneable,org.pentaho.di.core.AttributesInterface,org.pentaho.di.core.CheckResultSourceInterface,org.pentaho.di.core.ExtensionDataInterface,org.pentaho.di.core.logging.LoggingObjectInterface,org.pentaho.di.core.logging.LoggingObjectLifecycleInterface,org.pentaho.di.core.variables.VariableSpace,JobEntryInterface,ResourceHolderInterface
public class JobEntryMysqlBulkLoad extends JobEntryBase implements Cloneable, JobEntryInterface
This defines a MySQL job entry.- Since:
- Jan-2007
- Author:
- Samatar Hassan
-
-
Field Summary
Fields Modifier and Type Field Description intprorityvalue-
Fields inherited from class org.pentaho.di.job.entry.JobEntryBase
attributesMap, containerObjectId, entryStepSetVariablesMap, extensionDataMap, log, metaStore, parentJob, parentJobMeta, rep, variables
-
-
Constructor Summary
Constructors Constructor Description JobEntryMysqlBulkLoad()JobEntryMysqlBulkLoad(String n)
-
Method Summary
All Methods Instance Methods Concrete Methods Modifier and Type Method Description voidcheck(List<org.pentaho.di.core.CheckResultInterface> remarks, JobMeta jobMeta, org.pentaho.di.core.variables.VariableSpace space, Repository repository, org.pentaho.metastore.api.IMetaStore metaStore)Allows JobEntry objects to check themselves for consistencyObjectclone()This method is called when a job entry is duplicated in Spoon.booleanevaluates()This method must return true if the job entry supports the true/false outgoing hops.org.pentaho.di.core.Resultexecute(org.pentaho.di.core.Result previousResult, int nr)Execute the job entry.org.pentaho.di.core.database.DatabaseMetagetDatabase()StringgetEnclosed()StringgetEscaped()StringgetFilename()Gets the filename of the job entry.StringgetIgnorelines()StringgetLinestarted()StringgetLineterminated()StringgetListattribut()StringgetRealEnclosed()StringgetRealEscaped()StringgetRealIgnorelines()StringgetRealLinestarted()StringgetRealLineterminated()StringgetRealListattribut()StringgetRealSeparator()List<ResourceReference>getResourceDependencies(JobMeta jobMeta)Gets a list of all the resource dependencies that the step is depending on.StringgetSchemaname()StringgetSeparator()StringgetTablename()org.pentaho.di.core.database.DatabaseMeta[]getUsedDatabaseConnections()Gets all the database connections that are used by the job entry.StringgetXML()This method is called by PDI whenever a job entry needs to serialize its settings to XML.booleanisAddFileToResult()booleanisLocalInfile()booleanisReplacedata()booleanisUnconditional()This method must return true if the job entry supports the unconditional outgoing hop.voidloadRep(Repository rep, org.pentaho.metastore.api.IMetaStore metaStore, org.pentaho.di.repository.ObjectId id_jobentry, List<org.pentaho.di.core.database.DatabaseMeta> databases, List<SlaveServer> slaveServers)This method is called by PDI whenever a job entry needs to read its configuration from a PDI repository.voidloadXML(Node entrynode, List<org.pentaho.di.core.database.DatabaseMeta> databases, List<SlaveServer> slaveServers, Repository rep, org.pentaho.metastore.api.IMetaStore metaStore)This method is called by PDI whenever a job entry needs to read its settings from XML.voidsaveRep(Repository rep, org.pentaho.metastore.api.IMetaStore metaStore, org.pentaho.di.repository.ObjectId id_job)This method is called by PDI whenever a job entry needs to save its settings to a PDI repository.voidsetAddFileToResult(boolean addfiletoresultin)voidsetDatabase(org.pentaho.di.core.database.DatabaseMeta database)voidsetEnclosed(String enclosed)voidsetEscaped(String escaped)voidsetFilename(String filename)voidsetIgnorelines(String ignorelines)voidsetLinestarted(String linestarted)voidsetLineterminated(String lineterminated)voidsetListattribut(String listattribut)voidsetLocalInfile(boolean localinfile)voidsetReplacedata(boolean replacedata)voidsetSchemaname(String schemaname)voidsetSeparator(String separator)voidsetTablename(String tablename)-
Methods inherited from class org.pentaho.di.job.entry.JobEntryBase
addDatetimeToFilename, check, clear, copyVariablesFrom, environmentSubstitute, environmentSubstitute, equals, exportResources, exportResources, fieldSubstitute, getAttribute, getAttributes, getAttributesMap, getBooleanValueOfVariable, getContainerObjectId, getDescription, getDialogClassName, getEntryStepSetVariable, getEntryStepSetVariablesMap, getExtensionDataMap, getHolderType, getLogChannel, getLogChannelId, getLogLevel, getMetaStore, getName, getObjectCopy, getObjectId, getObjectName, getObjectRevision, getObjectType, getParent, getParentJob, getParentJobMeta, getParentVariableSpace, getPluginId, getRealFilename, getReferencedObjectDescriptions, getRegistrationDate, getRepository, getRepositoryDirectory, getSQLStatements, getSQLStatements, getSQLStatements, getTypeDesc, getTypeId, getVariable, getVariable, getVariables, hasChanged, hashCode, hasRepositoryReferences, initializeVariablesFrom, injectVariables, isBasic, isDebug, isDetailed, isDummy, isEvaluation, isForcingSeparateLogging, isFTP, isGatheringMetrics, isHTTP, isJob, isMail, isReferencedObjectEnabled, isRowlevel, isSFTP, isShell, isSpecial, isStart, isTransformation, listVariables, loadReferencedObject, loadReferencedObject, loadRep, loadXML, loadXML, logBasic, logBasic, logDebug, logDebug, logDetailed, logDetailed, logError, logError, logError, logMinimal, logMinimal, logRowlevel, logRowlevel, lookupRepositoryReferences, parseRepositoryObjects, resetErrorsBeforeExecution, saveRep, setAttribute, setAttributes, setAttributesMap, setChanged, setChanged, setContainerObjectId, setDescription, setEntryStepSetVariable, setForcingSeparateLogging, setGatheringMetrics, setID, setLogLevel, setMetaStore, setName, setObjectId, setParentJob, setParentJobMeta, setParentVariableSpace, setPluginId, setRepository, setTypeId, setVariable, shareVariablesWith, toString
-
Methods inherited from class java.lang.Object
finalize, getClass, notify, notifyAll, wait, wait, wait
-
Methods inherited from interface org.pentaho.di.job.entry.JobEntryInterface
check, clear, exportResources, exportResources, getDescription, getDialogClassName, getLogChannel, getName, getObjectId, getParentJob, getParentJobMeta, getPluginId, getRealFilename, getReferencedObjectDescriptions, getSQLStatements, getSQLStatements, getSQLStatements, getTypeId, hasChanged, hasRepositoryReferences, isDummy, isEvaluation, isJob, isMail, isReferencedObjectEnabled, isShell, isSpecial, isStart, isTransformation, loadReferencedObject, loadReferencedObject, loadRep, loadXML, lookupRepositoryReferences, resetErrorsBeforeExecution, saveRep, setChanged, setChanged, setDescription, setMetaStore, setName, setObjectId, setParentJob, setParentJobMeta, setPluginId, setRepository
-
-
-
-
Constructor Detail
-
JobEntryMysqlBulkLoad
public JobEntryMysqlBulkLoad(String n)
-
JobEntryMysqlBulkLoad
public JobEntryMysqlBulkLoad()
-
-
Method Detail
-
clone
public Object clone()
Description copied from class:JobEntryBaseThis 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:
clonein interfaceJobEntryInterface- Overrides:
clonein classJobEntryBase- Returns:
- a clone of the object
-
getXML
public String getXML()
Description copied from class:JobEntryBaseThis 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:
getXMLin interfaceJobEntryInterface- Overrides:
getXMLin classJobEntryBase- Returns:
- the xml representation of the job entry
-
loadXML
public void loadXML(Node entrynode, List<org.pentaho.di.core.database.DatabaseMeta> databases, List<SlaveServer> slaveServers, Repository rep, org.pentaho.metastore.api.IMetaStore metaStore) throws org.pentaho.di.core.exception.KettleXMLException
Description copied from interface:JobEntryInterfaceThis 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:
loadXMLin interfaceJobEntryInterface- Overrides:
loadXMLin classJobEntryBase- Parameters:
entrynode- the top-level XML nodedatabases- the list of databasesslaveServers- the list of slave serversrep- the repository objectmetaStore- The metaStore to optionally load from.- Throws:
org.pentaho.di.core.exception.KettleXMLException- if any errors occur during the loading of the XML
-
loadRep
public void loadRep(Repository rep, org.pentaho.metastore.api.IMetaStore metaStore, org.pentaho.di.repository.ObjectId id_jobentry, List<org.pentaho.di.core.database.DatabaseMeta> databases, List<SlaveServer> slaveServers) throws org.pentaho.di.core.exception.KettleException
Description copied from interface:JobEntryInterfaceThis method is called by PDI whenever a job entry needs to read its configuration from a PDI repository. The job entry id given in the arguments should be used as the identifier when using the repository's serialization methods.- Specified by:
loadRepin interfaceJobEntryInterface- Overrides:
loadRepin classJobEntryBase- Parameters:
rep- the repository objectmetaStore- the MetaStore to useid_jobentry- the id of the job entrydatabases- the list of databasesslaveServers- the list of slave servers- Throws:
org.pentaho.di.core.exception.KettleException- if any errors occur during the load
-
saveRep
public void saveRep(Repository rep, org.pentaho.metastore.api.IMetaStore metaStore, org.pentaho.di.repository.ObjectId id_job) throws org.pentaho.di.core.exception.KettleException
Description copied from interface:JobEntryInterfaceThis method is called by PDI whenever a job entry needs to save its settings to a PDI repository. The repository object passed in as the first argument provides a convenient set of methods for serializing job entry settings. When calling repository serialization methods, job id and job entry id are required. The job id is passed in to saveRep() as an argument, and the job entry id can be obtained by a call to getObjectId() inherited from the base class.- Specified by:
saveRepin interfaceJobEntryInterface- Overrides:
saveRepin classJobEntryBase- Parameters:
rep- the repositorymetaStore- the MetaStore to useid_job- the id_job- Throws:
org.pentaho.di.core.exception.KettleException- if any errors occur during the save
-
setTablename
public void setTablename(String tablename)
-
setSchemaname
public void setSchemaname(String schemaname)
-
getSchemaname
public String getSchemaname()
-
getTablename
public String getTablename()
-
setDatabase
public void setDatabase(org.pentaho.di.core.database.DatabaseMeta database)
-
getDatabase
public org.pentaho.di.core.database.DatabaseMeta getDatabase()
-
evaluates
public boolean evaluates()
Description copied from class:JobEntryBaseThis method must return true if the job entry supports the true/false outgoing hops. For JobEntryBase, this method always returns false- Specified by:
evaluatesin interfaceJobEntryInterface- Overrides:
evaluatesin classJobEntryBase- Returns:
- false
-
isUnconditional
public boolean isUnconditional()
Description copied from class:JobEntryBaseThis method must return true if the job entry supports the unconditional outgoing hop. For JobEntryBase, this method always returns true- Specified by:
isUnconditionalin interfaceJobEntryInterface- Overrides:
isUnconditionalin classJobEntryBase- Returns:
- true
-
execute
public org.pentaho.di.core.Result execute(org.pentaho.di.core.Result previousResult, int nr)Description copied from interface:JobEntryInterfaceExecute 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:
executein interfaceJobEntryInterface- Parameters:
previousResult- the previous resultnr- the number of rows- Returns:
- the Result object from execution of this job entry
-
getUsedDatabaseConnections
public org.pentaho.di.core.database.DatabaseMeta[] getUsedDatabaseConnections()
Description copied from class:JobEntryBaseGets all the database connections that are used by the job entry. For JobEntryBase, this method returns an empty (non-null) array- Specified by:
getUsedDatabaseConnectionsin interfaceJobEntryInterface- Overrides:
getUsedDatabaseConnectionsin classJobEntryBase- Returns:
- an empty (non-null) array
-
isReplacedata
public boolean isReplacedata()
-
setReplacedata
public void setReplacedata(boolean replacedata)
-
setLocalInfile
public void setLocalInfile(boolean localinfile)
-
isLocalInfile
public boolean isLocalInfile()
-
setFilename
public void setFilename(String filename)
-
getFilename
public String getFilename()
Description copied from class:JobEntryBaseGets the filename of the job entry. For JobEntryBase, this method always returns null- Specified by:
getFilenamein interfaceJobEntryInterface- Specified by:
getFilenamein interfaceorg.pentaho.di.core.logging.LoggingObjectInterface- Overrides:
getFilenamein classJobEntryBase- Returns:
- null
- See Also:
LoggingObjectInterface.getFilename()
-
setSeparator
public void setSeparator(String separator)
-
setLineterminated
public void setLineterminated(String lineterminated)
-
setLinestarted
public void setLinestarted(String linestarted)
-
getEnclosed
public String getEnclosed()
-
getRealEnclosed
public String getRealEnclosed()
-
setEnclosed
public void setEnclosed(String enclosed)
-
getEscaped
public String getEscaped()
-
getRealEscaped
public String getRealEscaped()
-
setEscaped
public void setEscaped(String escaped)
-
getSeparator
public String getSeparator()
-
getLineterminated
public String getLineterminated()
-
getLinestarted
public String getLinestarted()
-
getRealLinestarted
public String getRealLinestarted()
-
getRealLineterminated
public String getRealLineterminated()
-
getRealSeparator
public String getRealSeparator()
-
setIgnorelines
public void setIgnorelines(String ignorelines)
-
getIgnorelines
public String getIgnorelines()
-
getRealIgnorelines
public String getRealIgnorelines()
-
setListattribut
public void setListattribut(String listattribut)
-
getListattribut
public String getListattribut()
-
getRealListattribut
public String getRealListattribut()
-
setAddFileToResult
public void setAddFileToResult(boolean addfiletoresultin)
-
isAddFileToResult
public boolean isAddFileToResult()
-
getResourceDependencies
public List<ResourceReference> getResourceDependencies(JobMeta jobMeta)
Description copied from class:JobEntryBaseGets 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:
getResourceDependenciesin interfaceJobEntryInterface- Overrides:
getResourceDependenciesin classJobEntryBase- Returns:
- an empty list of ResourceReferences
- See Also:
ResourceReference
-
check
public void check(List<org.pentaho.di.core.CheckResultInterface> remarks, JobMeta jobMeta, org.pentaho.di.core.variables.VariableSpace space, Repository repository, org.pentaho.metastore.api.IMetaStore metaStore)
Description copied from class:JobEntryBaseAllows JobEntry objects to check themselves for consistency- Specified by:
checkin interfaceJobEntryInterface- Overrides:
checkin classJobEntryBase- Parameters:
remarks- List of CheckResult objects indicating consistency statusjobMeta- the metadata object for the job entryspace- the variable space to resolve string expressions with variables withrepository- the repository to load Kettle objects frommetaStore- the MetaStore to load common elements from
-
-