Package org.pentaho.di.job.entries.mysqlbulkfile

Class JobEntryMysqlBulkFile

java.lang.Object

org.pentaho.di.job.entry.JobEntryBase

org.pentaho.di.job.entries.mysqlbulkfile.JobEntryMysqlBulkFile

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 JobEntryMysqlBulkFile
extends JobEntryBase
implements Cloneable, JobEntryInterface

This defines an MYSQL Bulk file job entry.

Since:

05-03-2006

Author:

Samatar

Field Summary

Fields

Modifier and Type	Field	Description
int	iffileexists
int	outdumpvalue

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
JobEntryMysqlBulkFile()
JobEntryMysqlBulkFile(String n)

Method Summary

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 consistency
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.
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	getFilename()	Gets the filename of the job entry.
String	getLimitlines()
String	getLineterminated()
String	getListColumn()
String	getRealEnclosed()
String	getRealFilename()	Gets the real filename of the job entry, by substituting any environment variables present in the filename.
String	getRealLimitlines()
String	getRealLineterminated()
String	getRealListColumn()
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	isHighPriority()
boolean	isOptionEnclosed()
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	setFilename(String filename)
void	setHighPriority(boolean highpriority)
void	setLimitlines(String limitlines)
void	setLineterminated(String lineterminated)
void	setListColumn(String listcolumn)
void	setOptionEnclosed(boolean optionenclosed)
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, 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, 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

Methods inherited from interface org.pentaho.di.core.logging.LoggingObjectLifecycleInterface

callAfterLog, callBeforeLog

Methods inherited from interface org.pentaho.di.core.variables.VariableSpace

environmentSubstitute

Field Details

outdumpvalue

public int outdumpvalue

iffileexists

public int iffileexists

Constructor Details

JobEntryMysqlBulkFile

public JobEntryMysqlBulkFile(String n)

JobEntryMysqlBulkFile

public JobEntryMysqlBulkFile()

Method Details

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

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

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 interface JobEntryInterface

Overrides:

loadXML in class JobEntryBase

Parameters:

entrynode - the top-level XML node

databases - the list of databases

slaveServers - the list of slave servers

rep - the repository object

metaStore - 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 interface JobEntryInterface

Overrides:

loadRep in class JobEntryBase

Parameters:

rep - the repository object

metaStore - the MetaStore to use

id_jobentry - the id of the job entry

databases - the list of databases

slaveServers - 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 interface JobEntryInterface

Overrides:

saveRep in class JobEntryBase

Parameters:

rep - the repository

metaStore - the MetaStore to use

id_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)

getTablename

public String getTablename()

getSchemaname

public String getSchemaname()

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 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 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 interface JobEntryInterface

Parameters:

previousResult - the previous result

nr - 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 interface JobEntryInterface

Overrides:

getUsedDatabaseConnections in class JobEntryBase

Returns:

an empty (non-null) array

setHighPriority

public void setHighPriority(boolean highpriority)

setOptionEnclosed

public void setOptionEnclosed(boolean optionenclosed)

isHighPriority

public boolean isHighPriority()

isOptionEnclosed

public boolean isOptionEnclosed()

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 interface JobEntryInterface

Specified by:

getFilename in interface org.pentaho.di.core.logging.LoggingObjectInterface

Overrides:

getFilename in class JobEntryBase

Returns:

null

See Also:

• LoggingObjectInterface.getFilename()

getRealFilename

public String getRealFilename()

Description copied from class: JobEntryBase

Gets the real filename of the job entry, by substituting any environment variables present in the filename. For JobEntryBase, this method always returns null

Specified by:

getRealFilename in interface JobEntryInterface

Overrides:

getRealFilename in class JobEntryBase

Returns:

null

setSeparator

public void setSeparator(String separator)

setEnclosed

public void setEnclosed(String enclosed)

setLineterminated

public void setLineterminated(String lineterminated)

getLineterminated

public String getLineterminated()

getRealLineterminated

public String getRealLineterminated()

getSeparator

public String getSeparator()

getEnclosed

public String getEnclosed()

getRealSeparator

public String getRealSeparator()

getRealEnclosed

public String getRealEnclosed()

setLimitlines

public void setLimitlines(String limitlines)

getLimitlines

public String getLimitlines()

getRealLimitlines

public String getRealLimitlines()

setListColumn

public void setListColumn(String listcolumn)

getListColumn

public String getListColumn()

getRealListColumn

public String getRealListColumn()

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 interface JobEntryInterface

Overrides:

getResourceDependencies in class JobEntryBase

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 interface JobEntryInterface

Overrides:

check in class JobEntryBase

Parameters:

remarks - List of CheckResult objects indicating consistency status

jobMeta - the metadata object for the job entry

space - the variable space to resolve string expressions with variables with

repository - the repository to load Kettle objects from

metaStore - the MetaStore to load common elements from