/*! ****************************************************************************** * * Pentaho Data Integration * * Copyright (C) 2002-2016 by Pentaho : http://www.pentaho.com * ******************************************************************************* * * Licensed under the Apache License, Version 2.0 (the "License"); * you may not use this file except in compliance with * the License. You may obtain a copy of the License at * * http://www.apache.org/licenses/LICENSE-2.0 * * Unless required by applicable law or agreed to in writing, software * distributed under the License is distributed on an "AS IS" BASIS, * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. * See the License for the specific language governing permissions and * limitations under the License. * ******************************************************************************/ package org.pentaho.di.trans.steps.stringcut; import java.util.List; import org.pentaho.di.core.CheckResult; import org.pentaho.di.core.CheckResultInterface; import org.pentaho.di.core.Const; import org.pentaho.di.core.util.Utils; import org.pentaho.di.core.database.DatabaseMeta; import org.pentaho.di.core.exception.KettleException; import org.pentaho.di.core.exception.KettleStepException; import org.pentaho.di.core.exception.KettleXMLException; import org.pentaho.di.core.row.RowMetaInterface; import org.pentaho.di.core.row.ValueMetaInterface; import org.pentaho.di.core.row.value.ValueMetaString; import org.pentaho.di.core.variables.VariableSpace; import org.pentaho.di.core.xml.XMLHandler; import org.pentaho.di.i18n.BaseMessages; import org.pentaho.di.repository.ObjectId; import org.pentaho.di.repository.Repository; import org.pentaho.di.trans.Trans; import org.pentaho.di.trans.TransMeta; import org.pentaho.di.trans.step.BaseStepMeta; import org.pentaho.di.trans.step.StepDataInterface; import org.pentaho.di.trans.step.StepInterface; import org.pentaho.di.trans.step.StepMeta; import org.pentaho.di.trans.step.StepMetaInterface; import org.pentaho.metastore.api.IMetaStore; import org.w3c.dom.Node; /** * @author Samatar Hassan * @since 30 September 2008 */ public class StringCutMeta extends BaseStepMeta implements StepMetaInterface { private static Class<?> PKG = StringCutMeta.class; // for i18n purposes, needed by Translator2!! private String[] fieldInStream; private String[] fieldOutStream; private String[] cutFrom; private String[] cutTo; public StringCutMeta() { super(); // allocate BaseStepMeta } /** * @return Returns the fieldInStream. */ public String[] getFieldInStream() { return fieldInStream; } /** * @param keyStream * The fieldInStream to set. */ public void setFieldInStream( String[] keyStream ) { this.fieldInStream = keyStream; } /** * @return Returns the fieldOutStream. */ public String[] getFieldOutStream() { return fieldOutStream; } /** * @param keyStream * The fieldOutStream to set. */ public void setFieldOutStream( String[] keyStream ) { this.fieldOutStream = keyStream; } public String[] getCutFrom() { return cutFrom; } public void setCutFrom( String[] cutFrom ) { this.cutFrom = cutFrom; } public String[] getCutTo() { return cutTo; } public void setCutTo( String[] cutTo ) { this.cutTo = cutTo; } public void loadXML( Node stepnode, List<DatabaseMeta> databases, IMetaStore metaStore ) throws KettleXMLException { readData( stepnode ); } public void allocate( int nrkeys ) { fieldInStream = new String[nrkeys]; fieldOutStream = new String[nrkeys]; cutTo = new String[nrkeys]; cutFrom = new String[nrkeys]; } public Object clone() { StringCutMeta retval = (StringCutMeta) super.clone(); int nrkeys = fieldInStream.length; retval.allocate( nrkeys ); System.arraycopy( fieldInStream, 0, retval.fieldInStream, 0, nrkeys ); System.arraycopy( fieldOutStream, 0, retval.fieldOutStream, 0, nrkeys ); System.arraycopy( cutTo, 0, retval.cutTo, 0, nrkeys ); System.arraycopy( cutFrom, 0, retval.cutFrom, 0, nrkeys ); return retval; } private void readData( Node stepnode ) throws KettleXMLException { try { int nrkeys; Node lookup = XMLHandler.getSubNode( stepnode, "fields" ); nrkeys = XMLHandler.countNodes( lookup, "field" ); allocate( nrkeys ); for ( int i = 0; i < nrkeys; i++ ) { Node fnode = XMLHandler.getSubNodeByNr( lookup, "field", i ); fieldInStream[i] = Const.NVL( XMLHandler.getTagValue( fnode, "in_stream_name" ), "" ); fieldOutStream[i] = Const.NVL( XMLHandler.getTagValue( fnode, "out_stream_name" ), "" ); cutFrom[i] = Const.NVL( XMLHandler.getTagValue( fnode, "cut_from" ), "" ); cutTo[i] = Const.NVL( XMLHandler.getTagValue( fnode, "cut_to" ), "" ); } } catch ( Exception e ) { throw new KettleXMLException( BaseMessages.getString( PKG, "StringCutMeta.Exception.UnableToReadStepInfoFromXML" ), e ); } } public void setDefault() { fieldInStream = null; fieldOutStream = null; int nrkeys = 0; allocate( nrkeys ); } public String getXML() { StringBuilder retval = new StringBuilder( 500 ); retval.append( " <fields>" ).append( Const.CR ); for ( int i = 0; i < fieldInStream.length; i++ ) { retval.append( " <field>" ).append( Const.CR ); retval.append( " " ).append( XMLHandler.addTagValue( "in_stream_name", fieldInStream[i] ) ); retval.append( " " ).append( XMLHandler.addTagValue( "out_stream_name", fieldOutStream[i] ) ); retval.append( " " ).append( XMLHandler.addTagValue( "cut_from", cutFrom[i] ) ); retval.append( " " ).append( XMLHandler.addTagValue( "cut_to", cutTo[i] ) ); retval.append( " </field>" ).append( Const.CR ); } retval.append( " </fields>" ).append( Const.CR ); return retval.toString(); } public void readRep( Repository rep, IMetaStore metaStore, ObjectId id_step, List<DatabaseMeta> databases ) throws KettleException { try { int nrkeys = rep.countNrStepAttributes( id_step, "in_stream_name" ); allocate( nrkeys ); for ( int i = 0; i < nrkeys; i++ ) { fieldInStream[i] = Const.NVL( rep.getStepAttributeString( id_step, i, "in_stream_name" ), "" ); fieldOutStream[i] = Const.NVL( rep.getStepAttributeString( id_step, i, "out_stream_name" ), "" ); cutFrom[i] = Const.NVL( rep.getStepAttributeString( id_step, i, "cut_from" ), "" ); cutTo[i] = Const.NVL( rep.getStepAttributeString( id_step, i, "cut_to" ), "" ); } } catch ( Exception e ) { throw new KettleException( BaseMessages.getString( PKG, "StringCutMeta.Exception.UnexpectedErrorInReadingStepInfo" ), e ); } } public void saveRep( Repository rep, IMetaStore metaStore, ObjectId id_transformation, ObjectId id_step ) throws KettleException { try { for ( int i = 0; i < fieldInStream.length; i++ ) { rep.saveStepAttribute( id_transformation, id_step, i, "in_stream_name", fieldInStream[i] ); rep.saveStepAttribute( id_transformation, id_step, i, "out_stream_name", fieldOutStream[i] ); rep.saveStepAttribute( id_transformation, id_step, i, "cut_from", cutFrom[i] ); rep.saveStepAttribute( id_transformation, id_step, i, "cut_to", cutTo[i] ); } } catch ( Exception e ) { throw new KettleException( BaseMessages.getString( PKG, "StringCutMeta.Exception.UnableToSaveStepInfo" ) + id_step, e ); } } public void getFields( RowMetaInterface inputRowMeta, String name, RowMetaInterface[] info, StepMeta nextStep, VariableSpace space, Repository repository, IMetaStore metaStore ) throws KettleStepException { for ( int i = 0; i < fieldOutStream.length; i++ ) { ValueMetaInterface v; if ( !Utils.isEmpty( fieldOutStream[i] ) ) { v = new ValueMetaString( space.environmentSubstitute( fieldOutStream[i] ) ); v.setLength( 100, -1 ); v.setOrigin( name ); inputRowMeta.addValueMeta( v ); } else { v = inputRowMeta.searchValueMeta( fieldInStream[i] ); if ( v == null ) { continue; } v.setStorageType( ValueMetaInterface.STORAGE_TYPE_NORMAL ); } } } public void check( List<CheckResultInterface> remarks, TransMeta transMeta, StepMeta stepinfo, RowMetaInterface prev, String[] input, String[] output, RowMetaInterface info, VariableSpace space, Repository repository, IMetaStore metaStore ) { CheckResult cr; String error_message = ""; boolean first = true; boolean error_found = false; if ( prev == null ) { error_message += BaseMessages.getString( PKG, "StringCutMeta.CheckResult.NoInputReceived" ) + Const.CR; cr = new CheckResult( CheckResult.TYPE_RESULT_ERROR, error_message, stepinfo ); remarks.add( cr ); } else { for ( int i = 0; i < fieldInStream.length; i++ ) { String field = fieldInStream[i]; ValueMetaInterface v = prev.searchValueMeta( field ); if ( v == null ) { if ( first ) { first = false; error_message += BaseMessages.getString( PKG, "StringCutMeta.CheckResult.MissingInStreamFields" ) + Const.CR; } error_found = true; error_message += "\t\t" + field + Const.CR; } } if ( error_found ) { cr = new CheckResult( CheckResult.TYPE_RESULT_ERROR, error_message, stepinfo ); } else { cr = new CheckResult( CheckResult.TYPE_RESULT_OK, BaseMessages.getString( PKG, "StringCutMeta.CheckResult.FoundInStreamFields" ), stepinfo ); } remarks.add( cr ); // Check whether all are strings first = true; error_found = false; for ( int i = 0; i < fieldInStream.length; i++ ) { String field = fieldInStream[i]; ValueMetaInterface v = prev.searchValueMeta( field ); if ( v != null ) { if ( v.getType() != ValueMetaInterface.TYPE_STRING ) { if ( first ) { first = false; error_message += BaseMessages.getString( PKG, "StringCutMeta.CheckResult.OperationOnNonStringFields" ) + Const.CR; } error_found = true; error_message += "\t\t" + field + Const.CR; } } } if ( error_found ) { cr = new CheckResult( CheckResult.TYPE_RESULT_ERROR, error_message, stepinfo ); } else { cr = new CheckResult( CheckResult.TYPE_RESULT_OK, BaseMessages.getString( PKG, "StringCutMeta.CheckResult.AllOperationsOnStringFields" ), stepinfo ); } remarks.add( cr ); if ( fieldInStream.length > 0 ) { for ( int idx = 0; idx < fieldInStream.length; idx++ ) { if ( Utils.isEmpty( fieldInStream[idx] ) ) { cr = new CheckResult( CheckResult.TYPE_RESULT_ERROR, BaseMessages.getString( PKG, "StringCutMeta.CheckResult.InStreamFieldMissing", new Integer( idx + 1 ).toString() ), stepinfo ); remarks.add( cr ); } } } } } public StepInterface getStep( StepMeta stepMeta, StepDataInterface stepDataInterface, int cnr, TransMeta transMeta, Trans trans ) { return new StringCut( stepMeta, stepDataInterface, cnr, transMeta, trans ); } public StepDataInterface getStepData() { return new StringCutData(); } public boolean supportsErrorHandling() { return true; } }