public boolean tableItemInserted( TableItem tableItem, ValueMetaInterface v ) { if ( v.getType() == ValueMetaInterface.TYPE_STRING ) { // Only process strings return true; } else { return false; } } };
public static ValueMetaInterface cloneValueMeta( ValueMetaInterface source ) throws KettlePluginException { return cloneValueMeta( source, source.getType() ); }
/** * Copy constructor for clone * * @param rowMeta * @throws KettlePluginException */ private RowMeta( RowMeta rowMeta, Integer targetType ) throws KettlePluginException { this( new ArrayList<ValueMetaInterface>( rowMeta.valueMetaList.size() ), new RowMetaCache( rowMeta.cache ) ); for ( ValueMetaInterface valueMetaInterface : rowMeta.valueMetaList ) { valueMetaList.add( ValueMetaFactory .cloneValueMeta( valueMetaInterface, targetType == null ? valueMetaInterface.getType() : targetType ) ); } this.needRealClone = rowMeta.needRealClone; }
public boolean tableItemInserted( TableItem tableItem, ValueMetaInterface v ) { if ( v.getType() == ValueMetaInterface.TYPE_DATE ) { // The default is : format is OK for dates, see if this sticks later on... // tableItem.setText( 3, "Y" ); } else { tableItem.setText( 3, "Y" ); // default is OK too... } return true; } };
public boolean tableItemInserted( TableItem tableItem, ValueMetaInterface v ) { if ( v.getType() == ValueMetaInterface.TYPE_DATE ) { // The default is : format is OK for dates, see if this sticks later on... // tableItem.setText( 3, "Y" ); } else { tableItem.setText( 3, "Y" ); // default is OK too... } return true; } };
public static Object abs( ValueMetaInterface metaA, Object dataA ) throws KettleValueException { if ( dataA == null ) { return null; } switch ( metaA.getType() ) { case ValueMetaInterface.TYPE_NUMBER: return new Double( Math.abs( metaA.getNumber( dataA ).doubleValue() ) ); case ValueMetaInterface.TYPE_INTEGER: return metaA.getInteger( Math.abs( metaA.getNumber( dataA ).longValue() ) ); case ValueMetaInterface.TYPE_BIGNUMBER: return new BigDecimal( Math.abs( metaA.getNumber( dataA ).doubleValue() ) ); default: throw new KettleValueException( "The 'abs' function only works on numeric data" ); } }
public static String getNativeDataTypeSimpleName( ValueMetaInterface v ) { try { return v.getType() != ValueMetaInterface.TYPE_BINARY ? v.getNativeDataTypeClass().getSimpleName() : "Binary"; } catch ( KettleValueException e ) { LogChannelInterface log = new LogChannel( v ); log.logDebug( BaseMessages.getString( PKG, "FieldHelper.Log.UnknownNativeDataTypeSimpleName" ) ); return "Object"; } } }
public boolean tableItemInserted( TableItem tableItem, ValueMetaInterface v ) { if ( v.getType() == ValueMetaInterface.TYPE_DATE ) { // The default is date mask. tableItem.setText( 3, BaseMessages.getString( PKG, "PGBulkLoaderDialog.DateMask.Label" ) ); } else { tableItem.setText( 3, "" ); } return true; } };
public boolean tableItemInserted( TableItem tableItem, ValueMetaInterface v ) { if ( v.getType() == ValueMetaInterface.TYPE_DATE ) { // The default is date mask. tableItem.setText( 3, BaseMessages.getString( PKG, "OraBulkLoaderDialog.DateMask.Label" ) ); } else { tableItem.setText( 3, "" ); } return true; } };
public boolean tableItemInserted( TableItem tableItem, ValueMetaInterface v ) { if ( v.getType() == ValueMetaInterface.TYPE_DATE ) { // The default is date mask. tableItem.setText( 3, BaseMessages.getString( PKG, "GPLoadDialog.DateMask.Label" ) ); } else { tableItem.setText( 3, "" ); } return true; } };
public boolean tableItemInserted( TableItem tableItem, ValueMetaInterface v ) { if ( v.getType() == ValueMetaInterface.TYPE_DATE ) { // The default is date mask. tableItem.setText( 3, BaseMessages.getString( PKG, "GPBulkLoaderDialog.DateMask.Label" ) ); } else { tableItem.setText( 3, "" ); } return true; } };
@Override Object doCall() throws Exception { Random random = new Random(); while ( condition.get() ) { int acc = 0; for ( ValueMetaInterface meta : rowMeta.getValueMetaList() ) { // fake cycle to from eliminating this snippet by JIT acc += meta.getType() / 10; } Thread.sleep( random.nextInt( Math.max( 100, acc ) ) ); } return null; } }
void doConversions( Object[] outputRowData, int i, String value ) throws KettleValueException { ValueMetaInterface targetValueMeta = data.outputRowMeta.getValueMeta( i ); ValueMetaInterface sourceValueMeta = data.convertRowMeta.getValueMeta( i ); if ( ValueMetaInterface.TYPE_BINARY != targetValueMeta.getType() ) { outputRowData[i] = targetValueMeta.convertData( sourceValueMeta, value ); } else { // binary type of salesforce requires specific conversion if ( value != null ) { outputRowData[ i ] = Base64.decode( value ); } else { outputRowData[ i ] = null; } } }
public static ValueMetaInterface cloneValueMeta( ValueMetaInterface source, int targetType ) throws KettlePluginException { ValueMetaInterface target = null; // If we're Cloneable and not changing types, call clone() if ( source.getType() == targetType ) { target = source.clone(); } else { target = createValueMeta( source.getName(), targetType, source.getLength(), source.getPrecision() ); } cloneInfo( source, target ); return target; }
@Test public void testInsertTransNote() throws KettleException { ArgumentCaptor<String> argumentTableName = ArgumentCaptor.forClass( String.class ); ArgumentCaptor<RowMetaAndData> argumentTableData = ArgumentCaptor.forClass( RowMetaAndData.class ); doNothing().when( repo.connectionDelegate ).insertTableRow( argumentTableName.capture(), argumentTableData.capture() ); repo.insertTransNote( new LongObjectId( 456 ), new LongObjectId( 789 ) ); RowMetaAndData insertRecord = argumentTableData.getValue(); assertEquals( KettleDatabaseRepository.TABLE_R_TRANS_NOTE, argumentTableName.getValue() ); assertEquals( 2, insertRecord.size() ); assertEquals( ValueMetaInterface.TYPE_INTEGER, insertRecord.getValueMeta( 0 ).getType() ); assertEquals( KettleDatabaseRepository.FIELD_TRANS_NOTE_ID_TRANSFORMATION, insertRecord.getValueMeta( 0 ).getName() ); assertEquals( Long.valueOf( 456 ), insertRecord.getInteger( 0 ) ); assertEquals( ValueMetaInterface.TYPE_INTEGER, insertRecord.getValueMeta( 1 ).getType() ); assertEquals( KettleDatabaseRepository.FIELD_TRANS_NOTE_ID_NOTE, insertRecord.getValueMeta( 1 ).getName() ); assertEquals( Long.valueOf( 789 ), insertRecord.getInteger( 1 ) ); }
protected static Object multiplyNumeric( ValueMetaInterface metaA, Object dataA, ValueMetaInterface metaB, Object dataB ) throws KettleValueException { switch ( metaA.getType() ) { case ValueMetaInterface.TYPE_NUMBER: return multiplyDoubles( metaA.getNumber( dataA ), metaB.getNumber( dataB ) ); case ValueMetaInterface.TYPE_INTEGER: return multiplyLongs( metaA.getInteger( dataA ), metaB.getInteger( dataB ) ); case ValueMetaInterface.TYPE_BIGNUMBER: return multiplyBigDecimals( metaA.getBigNumber( dataA ), metaB.getBigNumber( dataB ), null ); default: throw new KettleValueException( "The 'multiply' function only works on numeric data optionally multiplying strings." ); } }
public boolean tableItemInserted( TableItem tableItem, ValueMetaInterface v ) { if ( v.getType() == ValueMetaInterface.TYPE_STRING ) { // Only process strings tableItem.setText( 3, BaseMessages.getString( PKG, "System.Combo.No" ) ); tableItem.setText( 6, BaseMessages.getString( PKG, "System.Combo.No" ) ); tableItem.setText( 8, BaseMessages.getString( PKG, "System.Combo.No" ) ); tableItem.setText( 9, BaseMessages.getString( PKG, "System.Combo.No" ) ); tableItem.setText( 10, BaseMessages.getString( PKG, "System.Combo.No" ) ); return true; } else { return false; } } };
public static Object divide( ValueMetaInterface metaA, Object dataA, ValueMetaInterface metaB, Object dataB ) throws KettleValueException { if ( dataA == null || dataB == null ) { return null; } switch ( metaA.getType() ) { case ValueMetaInterface.TYPE_NUMBER: return divideDoubles( metaA.getNumber( dataA ), metaB.getNumber( dataB ) ); case ValueMetaInterface.TYPE_INTEGER: return divideLongs( metaA.getInteger( dataA ), metaB.getInteger( dataB ) ); case ValueMetaInterface.TYPE_BIGNUMBER: return divideBigDecimals( metaA.getBigNumber( dataA ), metaB.getBigNumber( dataB ), null ); default: throw new KettleValueException( "The 'divide' function only works on numeric data." ); } }
@Test public void testGetFields() throws KettleStepException { DetectLastRowMeta meta = new DetectLastRowMeta(); meta.setDefault(); meta.setResultFieldName( "The Result" ); RowMeta rowMeta = new RowMeta(); meta.getFields( rowMeta, "this step", null, null, new Variables(), null, null ); assertEquals( 1, rowMeta.size() ); assertEquals( "The Result", rowMeta.getValueMeta( 0 ).getName() ); assertEquals( ValueMetaInterface.TYPE_BOOLEAN, rowMeta.getValueMeta( 0 ).getType() ); }