com.northconcepts.datapipeline.foundations.pipeline.action.convert.ConvertNullToValueAction

All Implemented Interfaces:: DataExceptionContributor, JsonSerializable, RecordSerializable, XmlSerializable, DataReaderAction, SqlSelectGenerator, JavaCodeGenerator, Serializable

public class ConvertNullToValueAction extends PipelineAction

A PipelineAction that replaces null values in the selected fields with a typed constant or the result of an expression.

See Also:

Nested Class Summary

Nested Classes

Modifier and Type

Class

Description

static enum

ConvertNullToValueAction.FieldType

The type a replacement value is converted to, or EXPRESSION to evaluate it; DATETIME, DATE and TIME values use the yyyy-MM-dd HH:mm:ss, yyyy-MM-dd and HH:mm:ss formats.

static class

ConvertNullToValueAction.TypeValue

A replacement value and the type it is converted to.
Field Summary

Fields inherited from class com.northconcepts.datapipeline.foundations.core.FoundationObject
internalId, internalName, log, TIMESTAMP_FORMAT

Fields inherited from interface com.northconcepts.datapipeline.core.RecordSerializable
SERIALIZED_CLASS_NAME, TYPE

Fields inherited from interface com.northconcepts.datapipeline.core.XmlSerializable
XML_SERIALIZED_CLASS_NAME
Constructor Summary

Constructors

Constructor

Description

ConvertNullToValueAction()
Method Summary

Modifier and Type

Method

Description

ConvertNullToValueAction

add(String fieldName, ConvertNullToValueAction.FieldType fieldType, String value)

Replaces nulls in the field with the value converted to the given type, or evaluated for EXPRESSION; a blank value is ignored.

DataReader

apply(DataReader reader)

Returns a reader that applies this action to the records of the given reader, usually by wrapping it.

ConvertNullToValueAction

fromRecord(Record source)

Loads this instance's state from a record and returns this (for fluid API call chaining).

ConvertNullToValueAction

fromXmlElement(Element element)

void

generateJavaCode(JavaCodeBuilder code)

Appends Java source code representing this object to the given builder.

Map<String,ConvertNullToValueAction.TypeValue>

getMapping()

Returns the replacement value and type for each field name.

ConvertNullToValueAction

setMapping(Map<String,ConvertNullToValueAction.TypeValue> mapping)

Sets the replacement value and type for each field name; null clears them.

Record

toRecord()

Converts this object's state to a record that RecordSerializable.fromRecord(Record) can load.

Element

toXmlElement(Document document)

Returns an element, created with document, describing this object; the default implementation throws a DataException.

Methods inherited from class com.northconcepts.datapipeline.foundations.pipeline.action.PipelineAction
escapeJavaString, getCode, getDescription, getDisplayText, getPipeline, setDescription, setPipeline, toString

Methods inherited from class com.northconcepts.datapipeline.foundations.core.FoundationObject
addExceptionProperties, assertValid, assertValid, clone, exception, exception, exception, getInternalId, getInternalName, resetInternalId

Methods inherited from class java.lang.Object
equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait

Methods inherited from interface com.northconcepts.datapipeline.core.DataExceptionContributor
addExceptionProperties

Methods inherited from interface com.northconcepts.datapipeline.core.RecordSerializable
fromJson, fromJson, toJson, toJson, toJson

Methods inherited from interface com.northconcepts.datapipeline.jdbc.sql.select.SqlSelectGenerator
generateSqlSelect

Methods inherited from interface com.northconcepts.datapipeline.core.XmlSerializable
fromXml, fromXml, toXml, toXml, toXml, toXml, toXml

Constructor Details
- ConvertNullToValueAction
  
  public ConvertNullToValueAction()
Method Details
- getMapping
  
  public Map<String,ConvertNullToValueAction.TypeValue> getMapping()
  
  Returns the replacement value and type for each field name.
- setMapping
  
  public ConvertNullToValueAction setMapping(Map<String,ConvertNullToValueAction.TypeValue> mapping)
  
  Sets the replacement value and type for each field name; null clears them.
- add
  
  public ConvertNullToValueAction add(String fieldName, ConvertNullToValueAction.FieldType fieldType, String value)
  
  Replaces nulls in the field with the value converted to the given type, or evaluated for EXPRESSION; a blank value is ignored.
- apply
  
  public DataReader apply(DataReader reader) throws Throwable
  
  Description copied from interface: DataReaderAction
  
  Returns a reader that applies this action to the records of the given reader, usually by wrapping it.
  
  Throws:
  
  Throwable
- toRecord
  
  public Record toRecord()
  
  Description copied from interface: RecordSerializable
  
  Converts this object's state to a record that RecordSerializable.fromRecord(Record) can load.
  
  Specified by:
  
  toRecord in interface RecordSerializable
  
  Overrides:
  
  toRecord in class PipelineAction
- fromRecord
  
  public ConvertNullToValueAction fromRecord(Record source)
  
  Description copied from interface: RecordSerializable
  
  Loads this instance's state from a record and returns this (for fluid API call chaining). For fluid API call chaining, the overridden method should change the declared return type to its class.
  
  Specified by:
  
  fromRecord in interface RecordSerializable
  
  Overrides:
  
  fromRecord in class PipelineAction
  
  Parameters:
  
  source -
  
  Returns:
  
  this instance.
- toXmlElement
  
  public Element toXmlElement(Document document)
  
  Description copied from interface: XmlSerializable
  
  Returns an element, created with document, describing this object; the default implementation throws a DataException.
  
  Specified by:
  
  toXmlElement in interface XmlSerializable
  
  Overrides:
  
  toXmlElement in class PipelineAction
- fromXmlElement
  
  public ConvertNullToValueAction fromXmlElement(Element element)
  
  Specified by:
  
  fromXmlElement in interface XmlSerializable
  
  Overrides:
  
  fromXmlElement in class PipelineAction
- generateJavaCode
  
  public void generateJavaCode(JavaCodeBuilder code)
  
  Description copied from interface: JavaCodeGenerator
  
  Appends Java source code representing this object to the given builder.
  
  Specified by:
  
  generateJavaCode in interface JavaCodeGenerator
  
  Overrides:
  
  generateJavaCode in class PipelineAction

Class ConvertNullToValueAction

Nested Class Summary

Field Summary

Fields inherited from class com.northconcepts.datapipeline.foundations.core.FoundationObject

Fields inherited from interface com.northconcepts.datapipeline.core.RecordSerializable

Fields inherited from interface com.northconcepts.datapipeline.core.XmlSerializable

Constructor Summary

Method Summary

Methods inherited from class com.northconcepts.datapipeline.foundations.pipeline.action.PipelineAction

Methods inherited from class com.northconcepts.datapipeline.foundations.core.FoundationObject

Methods inherited from class java.lang.Object

Methods inherited from interface com.northconcepts.datapipeline.core.DataExceptionContributor

Methods inherited from interface com.northconcepts.datapipeline.core.RecordSerializable

Methods inherited from interface com.northconcepts.datapipeline.jdbc.sql.select.SqlSelectGenerator

Methods inherited from interface com.northconcepts.datapipeline.core.XmlSerializable

Constructor Details

ConvertNullToValueAction

Method Details

getMapping

setMapping

add

apply

toRecord

fromRecord

toXmlElement

fromXmlElement

generateJavaCode