/*! ******************************************************************************
*
* Pentaho Data Integration
*
* Copyright (C) 2002-2015 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.update;
import junit.framework.TestCase;
import org.junit.Test;
import org.pentaho.di.core.row.RowMeta;
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.trans.step.utils.RowMetaUtils;
public class UpdateSQLTest extends TestCase {
@Test
public void testRowsTransform() {
String[] keyLookup = new String[] { "Name" };
String[] keyStream = new String[] { "FirstName" };
String[] updateLookup = new String[] { "SecondName", "PostAddress", "ZIP" };
String[] updateStream = new String[] { "SurName", "Address", "ZIP" };
RowMetaInterface prev = new RowMeta();
prev.addValueMeta( new ValueMetaString( keyStream[0] ) );
prev.addValueMeta( new ValueMetaString( updateStream[0] ) );
prev.addValueMeta( new ValueMetaString( updateStream[1] ) );
prev.addValueMeta( new ValueMetaString( updateStream[2] ) );
try {
RowMetaInterface result =
RowMetaUtils.getRowMetaForUpdate( prev, keyLookup, keyStream, updateLookup, updateStream );
ValueMetaInterface vmi = result.getValueMeta( 0 );
assertEquals( vmi.getName(), keyLookup[0] );
assertEquals( prev.getValueMeta( 0 ).getName(), keyStream[0] );
assertEquals( result.getValueMeta( 1 ).getName(), updateLookup[0] );
assertEquals( prev.getValueMeta( 1 ).getName(), updateStream[0] );
assertEquals( result.getValueMeta( 2 ).getName(), updateLookup[1] );
assertEquals( prev.getValueMeta( 2 ).getName(), updateStream[1] );
assertEquals( result.getValueMeta( 3 ).getName(), updateStream[2] );
assertEquals( prev.getValueMeta( 3 ).getName(), updateStream[2] );
} catch ( Exception ex ) {
ex.printStackTrace();
fail();
}
}
}