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 int
prorityvalue
-
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 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)
Allows JobEntry objects to check themselves for consistencyObject
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.org.pentaho.di.core.Result
execute(org.pentaho.di.core.Result previousResult, int nr)
Execute the job entry.org.pentaho.di.core.database.DatabaseMeta
getDatabase()
String
getEnclosed()
String
getEscaped()
String
getFilename()
Gets the filename of the job entry.String
getIgnorelines()
String
getLinestarted()
String
getLineterminated()
String
getListattribut()
String
getRealEnclosed()
String
getRealEscaped()
String
getRealIgnorelines()
String
getRealLinestarted()
String
getRealLineterminated()
String
getRealListattribut()
String
getRealSeparator()
List<ResourceReference>
getResourceDependencies(JobMeta jobMeta)
Gets a list of all the resource dependencies that the step is depending on.String
getSchemaname()
String
getSeparator()
String
getTablename()
org.pentaho.di.core.database.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
isAddFileToResult()
boolean
isLocalInfile()
boolean
isReplacedata()
boolean
isUnconditional()
This method must return true if the job entry supports the unconditional outgoing hop.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)
This method is called by PDI whenever a job entry needs to read its configuration from a PDI repository.void
loadXML(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.void
saveRep(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.void
setAddFileToResult(boolean addfiletoresultin)
void
setDatabase(org.pentaho.di.core.database.DatabaseMeta database)
void
setEnclosed(String enclosed)
void
setEscaped(String escaped)
void
setFilename(String filename)
void
setIgnorelines(String ignorelines)
void
setLinestarted(String linestarted)
void
setLineterminated(String lineterminated)
void
setListattribut(String listattribut)
void
setLocalInfile(boolean localinfile)
void
setReplacedata(boolean replacedata)
void
setSchemaname(String schemaname)
void
setSeparator(String separator)
void
setTablename(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: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 interfaceJobEntryInterface
- Overrides:
clone
in classJobEntryBase
- Returns:
- a clone of the object
-
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 interfaceJobEntryInterface
- Overrides:
getXML
in 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: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 interfaceJobEntryInterface
- Overrides:
loadXML
in 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:JobEntryInterface
This 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:
loadRep
in interfaceJobEntryInterface
- Overrides:
loadRep
in 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:JobEntryInterface
This 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:
saveRep
in interfaceJobEntryInterface
- Overrides:
saveRep
in 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: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 interfaceJobEntryInterface
- Overrides:
evaluates
in classJobEntryBase
- 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 interfaceJobEntryInterface
- Overrides:
isUnconditional
in classJobEntryBase
- Returns:
- true
-
execute
public org.pentaho.di.core.Result execute(org.pentaho.di.core.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 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: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 interfaceJobEntryInterface
- Overrides:
getUsedDatabaseConnections
in 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:JobEntryBase
Gets the filename of the job entry. For JobEntryBase, this method always returns null- Specified by:
getFilename
in interfaceJobEntryInterface
- Specified by:
getFilename
in interfaceorg.pentaho.di.core.logging.LoggingObjectInterface
- Overrides:
getFilename
in 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: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 interfaceJobEntryInterface
- Overrides:
getResourceDependencies
in 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:JobEntryBase
Allows JobEntry objects to check themselves for consistency- Specified by:
check
in interfaceJobEntryInterface
- Overrides:
check
in 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
-
-