public Long getInteger( int index ) throws KettleValueException { return rowMeta.getInteger( data, index ); }
public long getInteger( int index, long def ) throws KettleValueException { Long number = rowMeta.getInteger( data, index ); if ( number == null ) { return def; } return number.longValue(); }
public Long getInteger( String valueName ) throws KettleValueException { int idx = rowMeta.indexOfValue( valueName ); if ( idx < 0 ) { throw new KettleValueException( "Unknown column '" + valueName + "'" ); } return rowMeta.getInteger( data, idx ); }
RowMetaInterface rowMeta = stepAttributesRowMeta; long lookID = rowMeta.getInteger( look, 0 ); String lookCode = rowMeta.getString( look, 1 ); nr = rowMeta.getInteger( look, 2 ).intValue() + 1; offset++; if ( idx + offset < stepAttributesBuffer.size() ) { look = stepAttributesBuffer.get( idx + offset ); lookID = rowMeta.getInteger( look, 0 ); lookCode = rowMeta.getString( look, 1 ); } else {
@Override public ObjectId[] call() throws Exception { ResultSet resultSet = database.openQuery( ps, parameterMeta, parameterData ); List<Object[]> rows = database.getRows( resultSet, 0, null ); if ( Utils.isEmpty( rows ) ) { return new ObjectId[ 0 ]; } RowMetaInterface rowMeta = database.getReturnRowMeta(); ObjectId[] ids = new ObjectId[ rows.size() ]; for ( int i = 0; i < ids.length; i++ ) { Object[] row = rows.get( i ); ids[ i ] = new LongObjectId( rowMeta.getInteger( row, 0 ) ); } return ids; } } );
public void run( IProgressMonitor monitor ) throws InvocationTargetException, InterruptedException { db = new Database( Spoon.loggingObject, dbMeta ); try { db.connect(); String sql = dbMeta.getDatabaseInterface().getSelectCountStatement( tableName ); RowMetaAndData row = db.getOneRow( sql ); size = row.getRowMeta().getInteger( row.getData(), 0 ); if ( monitor.isCanceled() ) { throw new InvocationTargetException( new Exception( "This operation was cancelled!" ) ); } } catch ( KettleException e ) { throw new InvocationTargetException( e, "Couldn't get a result because of an error :" + e.toString() ); } finally { db.disconnect(); } } };
break; case ValueMetaInterface.TYPE_INTEGER: Long l = rowMetaInterface.getInteger( row, i ); dataFilePrintStream.print( pad( valueMeta, l.toString() ) ); break;
public String[] getJobsWithIDList( List<Object[]> list, RowMetaInterface rowMeta ) throws KettleException { String[] jobList = new String[list.size()]; for ( int i = 0; i < list.size(); i++ ) { long id_job = rowMeta.getInteger( list.get( i ), quote( KettleDatabaseRepository.FIELD_JOB_ID_JOB ), -1L ); if ( id_job > 0 ) { RowMetaAndData jobRow = getJob( new LongObjectId( id_job ) ); if ( jobRow != null ) { String jobName = jobRow.getString( KettleDatabaseRepository.FIELD_JOB_NAME, "<name not found>" ); long id_directory = jobRow.getInteger( KettleDatabaseRepository.FIELD_JOB_ID_DIRECTORY, -1L ); RepositoryDirectoryInterface dir = repository.loadRepositoryDirectoryTree().findDirectory( new LongObjectId( id_directory ) ); // always // reload the // directory // tree! jobList[i] = dir.getPathObjectCombination( jobName ); } } } return jobList; }
public String[] getTransformationsWithIDList( List<Object[]> list, RowMetaInterface rowMeta ) throws KettleException { String[] transList = new String[list.size()]; for ( int i = 0; i < list.size(); i++ ) { long id_transformation = rowMeta.getInteger( list.get( i ), quote( KettleDatabaseRepository.FIELD_TRANSFORMATION_ID_TRANSFORMATION ), -1L ); if ( id_transformation > 0 ) { RowMetaAndData transRow = getTransformation( new LongObjectId( id_transformation ) ); if ( transRow != null ) { String transName = transRow.getString( KettleDatabaseRepository.FIELD_TRANSFORMATION_NAME, "<name not found>" ); long id_directory = transRow.getInteger( KettleDatabaseRepository.FIELD_TRANSFORMATION_ID_DIRECTORY, -1L ); RepositoryDirectoryInterface dir = repository.loadRepositoryDirectoryTree().findDirectory( new LongObjectId( id_directory ) ); transList[i] = dir.getPathObjectCombination( transName ); } } } return transList; }
public int getPartition( RowMetaInterface rowMeta, Object[] row ) throws KettleException { init( rowMeta ); if ( partitionColumnIndex < 0 ) { partitionColumnIndex = rowMeta.indexOfValue( fieldName ); if ( partitionColumnIndex < 0 ) { throw new KettleStepException( "Unable to find partitioning field name [" + fieldName + "] in the output row..." + rowMeta ); } } long value; ValueMetaInterface valueMeta = rowMeta.getValueMeta( partitionColumnIndex ); Object valueData = row[partitionColumnIndex]; switch ( valueMeta.getType() ) { case ValueMetaInterface.TYPE_INTEGER: Long longValue = rowMeta.getInteger( row, partitionColumnIndex ); if ( longValue == null ) { value = valueMeta.hashCode( valueData ); } else { value = longValue.longValue(); } break; default: value = valueMeta.hashCode( valueData ); } /* * value = rowMeta.getInteger(row, partitionColumnIndex); */ int targetLocation = (int) ( Math.abs( value ) % nrPartitions ); return targetLocation; }
long previous; try { Long tmp = rmad.getRowMeta().getInteger( rmad.getData(), 0 );
break; case ValueMetaInterface.TYPE_INTEGER: jo.put( outputField.getElementName(), data.inputRowMeta.getInteger( row, data.fieldIndexes[i] ) ); break; case ValueMetaInterface.TYPE_NUMBER:
break; case ValueMetaInterface.TYPE_INTEGER: jo.put( outputField.getElementName(), data.inputRowMeta.getInteger( row, data.fieldIndexes[i] ) ); break; case ValueMetaInterface.TYPE_NUMBER:
} else { if ( meta.isUsingIntegerPair() ) { Long value = data.longIndex.get( keyMeta.getInteger( keyData, 0 ) ); if ( value == null ) { return null;
public Long getNextBatchIdUsingAutoIncSQL( String autoIncSQL, DatabaseMeta dbm, Database ldb ) throws KettleDatabaseException { Long rtn = null; PreparedStatement stmt = ldb.prepareSQL( autoIncSQL, true ); try { stmt.executeUpdate(); RowMetaAndData rmad = ldb.getGeneratedKeys( stmt ); if ( rmad.getRowMeta().size() > 0 ) { rtn = rmad.getRowMeta().getInteger( rmad.getData(), 0 ); } else { throw new KettleDatabaseException( "Unable to retrieve value of auto-generated technical key : " + "no value found!" ); } } catch ( KettleValueException kve ) { throw new KettleDatabaseException( kve ); } catch ( SQLException sqlex ) { throw new KettleDatabaseException( sqlex ); } finally { try { stmt.close(); } catch ( SQLException ignored ) { // Ignored } } return rtn; }
@Override public List<RepositoryElementMetaInterface> call() throws Exception { List<RepositoryElementMetaInterface> repositoryObjects = new ArrayList<RepositoryElementMetaInterface>(); ResultSet rs = database.openQuery( sql, directoryIdRow.getRowMeta(), directoryIdRow.getData() ); if ( rs != null ) { List<Object[]> rows = database.getRows( rs, -1, null ); if ( rs != null ) { database.closeQuery( rs ); } RowMetaInterface rowMeta = database.getReturnRowMeta(); for ( Object[] r : rows ) { ObjectId id = new LongObjectId( rowMeta.getInteger( r, 4 ) ); repositoryObjects.add( new RepositoryObject( id, rowMeta.getString( r, 0 ), repositoryDirectory, rowMeta .getString( r, 1 ), rowMeta.getDate( r, 2 ), objectType, rowMeta.getString( r, 3 ), false ) ); } } return repositoryObjects; } } );
Long key = keyMeta.getInteger( keyData, 0 ); Long value = valueMeta.getInteger( valueData, 0 ); data.longIndex.put( key, value ); } else {
+ data.schemaTable + " WHERE " + databaseMeta.quoteField( meta.getKeyField() ) + " = " + start_tk; RowMetaAndData r = data.db.getOneRow( sql ); Long count = r.getRowMeta().getInteger( r.getData(), 0 ); if ( count.longValue() != 0 ) { return; // Can't insert below the rows already in there... + data.schemaTable + " WHERE " + databaseMeta.quoteField( meta.getKeyField() ) + " = " + start_tk; RowMetaAndData r = data.db.getOneRow( sql ); Long count = r.getRowMeta().getInteger( r.getData(), 0 ); if ( count.longValue() == 0 ) { String isql = null;
public boolean isEmptyValue( String valueName ) throws KettleValueException { int idx = rowMeta.indexOfValue( valueName ); if ( idx < 0 ) { throw new KettleValueException( "Unknown column '" + valueName + "'" ); } ValueMetaInterface metaType = rowMeta.getValueMeta( idx ); // find by source value type switch ( metaType.getType() ) { case ValueMetaInterface.TYPE_STRING: return rowMeta.getString( data, idx ) == null; case ValueMetaInterface.TYPE_BOOLEAN: return rowMeta.getBoolean( data, idx ) == null; case ValueMetaInterface.TYPE_INTEGER: return rowMeta.getInteger( data, idx ) == null; case ValueMetaInterface.TYPE_NUMBER: return rowMeta.getNumber( data, idx ) == null; case ValueMetaInterface.TYPE_BIGNUMBER: return rowMeta.getBigNumber( data, idx ) == null; case ValueMetaInterface.TYPE_BINARY: return rowMeta.getBinary( data, idx ) == null; case ValueMetaInterface.TYPE_DATE: case ValueMetaInterface.TYPE_TIMESTAMP: return rowMeta.getDate( data, idx ) == null; case ValueMetaInterface.TYPE_INET: return rowMeta.getString( data, idx ) == null; } throw new KettleValueException( "Unknown source type: " + metaType.getTypeDesc() ); }
Long value = rowMeta.getInteger( row, valueField, null ); if ( value != null ) { SlaveSequence slaveSequence =