Java InjectorMeta类代码示例

import org.pentaho.di.trans.steps.injector.InjectorMeta; //导入依赖的package包/类
private StepMeta generateInjectorStep() {
  InjectorMeta meta = new InjectorMeta();
  meta.allocate(serviceFields.size());
  for (int i=0;i<serviceFields.size();i++) {
    ValueMetaInterface valueMeta = serviceFields.getValueMeta(i);
    meta.getFieldname()[i] = valueMeta.getName();
    meta.getType()[i] = valueMeta.getType();
    meta.getLength()[i] = valueMeta.getLength();
    meta.getPrecision()[i] = valueMeta.getPrecision();
  }
  StepMeta stepMeta = new StepMeta("Injector", meta);
  stepMeta.setLocation(xLocation, 50);
  xLocation+=100;
  stepMeta.setDraw(true);
  return stepMeta;
}
 

import org.pentaho.di.trans.steps.injector.InjectorMeta; //导入依赖的package包/类
private void handleInputDataSet(LogChannelInterface log, String inputSetName, TransUnitTest unitTest, TransMeta transMeta, StepMeta stepMeta, FactoriesHierarchy factoriesHierarchy) throws KettleException {
  TransUnitTestSetLocation inputLocation = unitTest.findInputLocation( stepMeta.getName() );
  if (inputLocation!=null) {
    inputSetName = inputLocation.getDataSetName();
  }

  if (log.isDetailed()) {
    log.logDetailed("Replacing step '"+stepMeta.getName()+"' with an Injector for dataset '"+inputSetName+"'");
  }
  
  DataSet dataSet;
  try {
    dataSet = factoriesHierarchy.getSetFactory().loadElement(inputSetName);
  } catch (MetaStoreException e) {
    throw new KettleException("Unable to load data set '"+inputSetName+"'");
  }
  
  // OK, this step needs to be replaced by an Injector step...
  // Which fields do we need to use?
  //
  final RowMetaInterface stepFields = DataSetConst.getStepOutputFields(log, transMeta, stepMeta, dataSet, inputLocation);
  
  if (log.isDetailed()) {
    log.logDetailed("Input Data Set '"+inputSetName+"' Injector fields : '"+stepFields.toString());
  }
  
  InjectorMeta injectorMeta = new InjectorMeta();
  injectorMeta.allocate( stepFields.size() );
  for (int x=0;x<stepFields.size();x++) {
    injectorMeta.getFieldname()[x] = stepFields.getValueMeta( x ).getName();
    injectorMeta.getType()[x] = stepFields.getValueMeta( x ).getType();
    injectorMeta.getLength()[x] = stepFields.getValueMeta( x ).getLength();
    injectorMeta.getPrecision()[x] = stepFields.getValueMeta( x ).getPrecision();
    
    // Only the step metadata, type...
    stepMeta.setStepMetaInterface( injectorMeta );
    stepMeta.setStepID( PluginRegistry.getInstance().getPluginId( StepPluginType.class, injectorMeta) );          
  }
}
 

import org.pentaho.di.trans.steps.injector.InjectorMeta; //导入依赖的package包/类
public static TransMeta generateTestTransformation(VariableSpace parent, StepMetaInterface oneMeta, String oneStepname)
{
    StepLoader stepLoader = StepLoader.getInstance();

    TransMeta previewMeta = new TransMeta(parent);
    
    // First the injector step...
    //
    InjectorMeta zeroMeta = new InjectorMeta();
    StepMeta zero = new StepMeta(stepLoader.getStepPluginID(zeroMeta), INJECTOR_STEPNAME, zeroMeta);
    zero.setLocation(50,50);
    zero.setDraw(true);
    previewMeta.addStep(zero);
    
    // Then the middle step to test...
    //
    StepMeta one = new StepMeta(stepLoader.getStepPluginID(oneMeta), oneStepname, oneMeta);
    one.setLocation(150,50);
    one.setDraw(true);
    previewMeta.addStep(one);
    
    // Then we add the dummy step to read the results from
    //
    DummyTransMeta twoMeta = new DummyTransMeta();
    StepMeta two = new StepMeta(stepLoader.getStepPluginID(twoMeta), DUMMY_STEPNAME, twoMeta); //$NON-NLS-1$
    two.setLocation(250,50);
    two.setDraw(true);
    previewMeta.addStep(two);
    
    // Add the hops between the 3 steps.
    //
    TransHopMeta zeroOne = new TransHopMeta(zero, one);
    previewMeta.addTransHop(zeroOne);
    TransHopMeta oneTwo= new TransHopMeta(one, two);
    previewMeta.addTransHop(oneTwo);
    
    return previewMeta;
}
 

import org.pentaho.di.trans.steps.injector.InjectorMeta; //导入依赖的package包/类
public static TransMeta generateTestTransformation(VariableSpace parent, StepMetaInterface oneMeta, String oneStepname)
{
    PluginRegistry registry = PluginRegistry.getInstance();

    TransMeta previewMeta = new TransMeta(parent);
    
    // First the injector step...
    //
    InjectorMeta zeroMeta = new InjectorMeta();
    StepMeta zero = new StepMeta(registry.getPluginId(StepPluginType.class, zeroMeta), INJECTOR_STEPNAME, zeroMeta);
    zero.setLocation(50,50);
    zero.setDraw(true);
    previewMeta.addStep(zero);
    
    // Then the middle step to test...
    //
    StepMeta one = new StepMeta(registry.getPluginId(StepPluginType.class, oneMeta), oneStepname, oneMeta);
    one.setLocation(150,50);
    one.setDraw(true);
    previewMeta.addStep(one);
    
    // Then we add the dummy step to read the results from
    //
    DummyTransMeta twoMeta = new DummyTransMeta();
    StepMeta two = new StepMeta(registry.getPluginId(StepPluginType.class, twoMeta), DUMMY_STEPNAME, twoMeta); //$NON-NLS-1$
    two.setLocation(250,50);
    two.setDraw(true);
    previewMeta.addStep(two);
    
    // Add the hops between the 3 steps.
    //
    TransHopMeta zeroOne = new TransHopMeta(zero, one);
    previewMeta.addTransHop(zeroOne);
    TransHopMeta oneTwo= new TransHopMeta(one, two);
    previewMeta.addTransHop(oneTwo);
    
    return previewMeta;
}
 

import org.pentaho.di.trans.steps.injector.InjectorMeta; //导入依赖的package包/类
/**
 *  Create an injector step.
 *  
 * @param name
 * @param registry
 * @return StepMeta
 */
public static synchronized StepMeta createInjectorStep(String name, PluginRegistry pluginRegistry) {
    // create an injector step...
    InjectorMeta injectorMeta = new InjectorMeta();

    // Set the information of the injector
    String injectorPid = pluginRegistry.getPluginId(StepPluginType.class, injectorMeta);
    StepMeta injectorStep = new StepMeta(injectorPid, name, (StepMetaInterface)injectorMeta);

    return injectorStep;
}
 

import org.pentaho.di.trans.steps.injector.InjectorMeta; //导入依赖的package包/类
public StepMeta createInjectorStep( TransMeta transMeta, PluginRegistry registry ) {
  //
  // create an injector step...
  //
  String injectorStepname = "injector step";
  InjectorMeta im = new InjectorMeta();

  // Set the information of the injector.
  String injectorPid = registry.getPluginId( StepPluginType.class, im );
  StepMeta injectorStep = new StepMeta( injectorPid, injectorStepname, im );
  transMeta.addStep( injectorStep );

  return injectorStep;
}
 

import org.pentaho.di.trans.steps.injector.InjectorMeta; //导入依赖的package包/类
/**
 * Create an injector step.
 *
 * @param name
 * @param registry
 * @return StepMeta
 */
public static synchronized StepMeta createInjectorStep( String name, PluginRegistry pluginRegistry ) {
  // create an injector step...
  InjectorMeta injectorMeta = new InjectorMeta();

  // Set the information of the injector
  String injectorPid = pluginRegistry.getPluginId( StepPluginType.class, injectorMeta );
  StepMeta injectorStep = new StepMeta( injectorPid, name, injectorMeta );

  return injectorStep;
}
 

import org.pentaho.di.trans.steps.injector.InjectorMeta; //导入依赖的package包/类
static StepMeta getInjectorStepMeta( RowMetaInterface outputRowMeta ) {
  InjectorMeta zeroMeta = new InjectorMeta();

  // Sets output fields for cases when no rows are sent to the test step, but metadata is still needed
  if ( outputRowMeta != null && outputRowMeta.size() > 0 ) {
    String[] fieldName = new String[outputRowMeta.size()];
    int[] fieldLength = new int[outputRowMeta.size()];
    int[] fieldPrecision = new int[outputRowMeta.size()];
    int[] fieldType = new int[outputRowMeta.size()];
    for ( int i = 0; i < outputRowMeta.size(); i++ ) {
      ValueMetaInterface field = outputRowMeta.getValueMeta( i );
      fieldName[i] = field.getName();
      fieldLength[i] = field.getLength();
      fieldPrecision[i] = field.getPrecision();
      fieldType[i] = field.getType();
    }
    zeroMeta.setFieldname( fieldName );
    zeroMeta.setLength( fieldLength );
    zeroMeta.setPrecision( fieldPrecision );
    zeroMeta.setType( fieldType );
  }

  StepMeta zero = new StepMeta( registry.getPluginId( StepPluginType.class, zeroMeta ), INJECTOR_STEPNAME, zeroMeta );
  zero.setLocation( 50, 50 );
  zero.setDraw( true );

  return zero;
}
 

import org.pentaho.di.trans.steps.injector.InjectorMeta; //导入依赖的package包/类
/**
 * Create an injector step.
 * 
 * @param name
 * @param registry
 * @return StepMeta
 */
public static synchronized StepMeta createInjectorStep( String name, PluginRegistry pluginRegistry ) {
  // create an injector step...
  InjectorMeta injectorMeta = new InjectorMeta();

  // Set the information of the injector
  String injectorPid = pluginRegistry.getPluginId( StepPluginType.class, injectorMeta );
  StepMeta injectorStep = new StepMeta( injectorPid, name, injectorMeta );

  return injectorStep;
}
 

import org.pentaho.di.trans.steps.injector.InjectorMeta; //导入依赖的package包/类
static StepMeta getInjectorStepMeta() {
  InjectorMeta zeroMeta = new InjectorMeta();
  StepMeta zero = new StepMeta( registry.getPluginId( StepPluginType.class, zeroMeta ), INJECTOR_STEPNAME, zeroMeta );
  zero.setLocation( 50, 50 );
  zero.setDraw( true );
  return zero;
}
 

import org.pentaho.di.trans.steps.injector.InjectorMeta; //导入依赖的package包/类
public InjectorDialog(Shell parent, Object in, TransMeta transMeta, String sname)
{
	super(parent, (BaseStepMeta)in, transMeta, sname);
	input=(InjectorMeta)in;
}
 

import org.pentaho.di.trans.steps.injector.InjectorMeta; //导入依赖的package包/类
public void testCaseSensitiveNoPreviousSort() throws Exception
{
    EnvUtil.environmentInit();

    //
    // Create a new transformation...
    //
    TransMeta transMeta = new TransMeta();
    transMeta.setName("uniquerowstest");
	
    StepLoader steploader = StepLoader.getInstance();            

    // 
    // create an injector step...
    //
    String injectorStepname = "injector step";
    InjectorMeta im = new InjectorMeta();
    
    // Set the information of the injector.                
    String injectorPid = steploader.getStepPluginID(im);
    StepMeta injectorStep = new StepMeta(injectorPid, injectorStepname, (StepMetaInterface)im);
    transMeta.addStep(injectorStep);

    // 
    // Create a unique rows step
    //
    String uniqueRowsStepname = "unique rows step";            
    UniqueRowsMeta urm = new UniqueRowsMeta();
    urm.setCompareFields(new String[] {"KEY"});
    urm.setCaseInsensitive(new boolean[] {false});

    String uniqueRowsStepPid = steploader.getStepPluginID(urm);
    StepMeta uniqueRowsStep = new StepMeta(uniqueRowsStepPid, uniqueRowsStepname, (StepMetaInterface)urm);
    transMeta.addStep(uniqueRowsStep);            

    transMeta.addTransHop(new TransHopMeta(injectorStep, uniqueRowsStep));        
    
    // 
    // Create a dummy step
    //
    String dummyStepname = "dummy step";            
    DummyTransMeta dm = new DummyTransMeta();

    String dummyPid = steploader.getStepPluginID(dm);
    StepMeta dummyStep = new StepMeta(dummyPid, dummyStepname, (StepMetaInterface)dm);
    transMeta.addStep(dummyStep);                              

    transMeta.addTransHop(new TransHopMeta(uniqueRowsStep, dummyStep));        
    
    // Now execute the transformation...
    Trans trans = new Trans(transMeta);

    trans.prepareExecution(null);
            
    StepInterface si = trans.getStepInterface(dummyStepname, 0);
    RowStepCollector dummyRc = new RowStepCollector();
    si.addRowListener(dummyRc);
    
    RowProducer rp = trans.addRowProducer(injectorStepname, 0);
    trans.startThreads();
    
    // add rows
    List<RowMetaAndData> inputList = createData();
    for ( RowMetaAndData rm : inputList )
    {
    	rp.putRow(rm.getRowMeta(), rm.getData());
    }   
    rp.finished();
 
    trans.waitUntilFinished();   
                                 
    List<RowMetaAndData> resultRows = dummyRc.getRowsWritten();
    checkRows(createResultDataCaseSensitiveNoPreviousSort(), resultRows);
}
 

import org.pentaho.di.trans.steps.injector.InjectorMeta; //导入依赖的package包/类
public void testCaseInsensitiveNoPreviousSort() throws Exception
{
    EnvUtil.environmentInit();

    //
    // Create a new transformation...
    //
    TransMeta transMeta = new TransMeta();
    transMeta.setName("uniquerowstest");
    
    StepLoader steploader = StepLoader.getInstance();            

    // 
    // create an injector step...
    //
    String injectorStepname = "injector step";
    InjectorMeta im = new InjectorMeta();
    
    // Set the information of the injector.                
    String injectorPid = steploader.getStepPluginID(im);
    StepMeta injectorStep = new StepMeta(injectorPid, injectorStepname, (StepMetaInterface)im);
    transMeta.addStep(injectorStep);

    // 
    // Create a unique rows step
    //
    String uniqueRowsStepname = "unique rows step";            
    UniqueRowsMeta urm = new UniqueRowsMeta();
    urm.setCompareFields(new String[] {"KEY"});
    urm.setCaseInsensitive(new boolean[] {true});

    String uniqueRowsStepPid = steploader.getStepPluginID(urm);
    StepMeta uniqueRowsStep = new StepMeta(uniqueRowsStepPid, uniqueRowsStepname, (StepMetaInterface)urm);
    transMeta.addStep(uniqueRowsStep);            

    transMeta.addTransHop(new TransHopMeta(injectorStep, uniqueRowsStep));        
    
    // 
    // Create a dummy step
    //
    String dummyStepname = "dummy step";            
    DummyTransMeta dm = new DummyTransMeta();

    String dummyPid = steploader.getStepPluginID(dm);
    StepMeta dummyStep = new StepMeta(dummyPid, dummyStepname, (StepMetaInterface)dm);
    transMeta.addStep(dummyStep);                              

    transMeta.addTransHop(new TransHopMeta(uniqueRowsStep, dummyStep));        
    
    // Now execute the transformation...
    Trans trans = new Trans(transMeta);

    trans.prepareExecution(null);
            
    StepInterface si = trans.getStepInterface(dummyStepname, 0);
    RowStepCollector dummyRc = new RowStepCollector();
    si.addRowListener(dummyRc);
    
    RowProducer rp = trans.addRowProducer(injectorStepname, 0);
    trans.startThreads();
    
    // add rows
    List<RowMetaAndData> inputList = createData();
    for ( RowMetaAndData rm : inputList )
    {
        rp.putRow(rm.getRowMeta(), rm.getData());
    }   
    rp.finished();
 
    trans.waitUntilFinished();   
                                 
    List<RowMetaAndData> resultRows = dummyRc.getRowsWritten();
    checkRows(createResultDataCaseInsensitiveNoPreviousSort(), resultRows);
}
 

import org.pentaho.di.trans.steps.injector.InjectorMeta; //导入依赖的package包/类
@Before
public void setUp() throws Exception {

	KettleEnvironment.init();

	/* SET UP TRANSFORMATION */

	// Create a new transformation...
	TransMeta transMeta = new TransMeta();
	transMeta.setName("insert/update test");

	// Add the database connections
	for (int i = 0; i < databasesXML.length; i++) {
		DatabaseMeta databaseMeta = new DatabaseMeta(databasesXML[i]);
		transMeta.addDatabase(databaseMeta);
	}

	DatabaseMeta dbInfo = transMeta.findDatabase("db");

	/* SET UP DATABASE */
	// Create target table
	db = new Database(transMeta, dbInfo);
	db.connect();

	String source = db.getCreateTableStatement(TARGET_TABLE, getTargetTableRowMeta(), null, false, null, true);
	db.execStatement(source);

	// populate target table
	for (String sql : insertStatement) {
		db.execStatement(sql);
	}

	/* SET UP TRANSFORMATION STEPS */

	PluginRegistry registry = PluginRegistry.getInstance();

	// create an injector step...
	String injectorStepName = "injector step";
	InjectorMeta im = new InjectorMeta();

	// Set the information of the injector.
	String injectorPid = registry.getPluginId(StepPluginType.class, im);
	StepMeta injectorStep = new StepMeta(injectorPid, injectorStepName, (StepMetaInterface) im);
	transMeta.addStep(injectorStep);

	// create the update step...
	String updateStepName = "insert/update [" + TARGET_TABLE + "]";
	insupd = new InsertUpdateMeta();
	insupd.setDatabaseMeta(transMeta.findDatabase("db"));
	insupd.setTableName(TARGET_TABLE);
	
	insupd.setUpdateLookup(new String[] { "VALUE" , "ROW_ORDER"});
	insupd.setUpdateStream(new String[] { "VALUE" , "ROW_ORDER"});
	insupd.setUpdate(new Boolean[] { true, false });

	String fromid = registry.getPluginId(StepPluginType.class, insupd);
	StepMeta updateStep = new StepMeta(fromid, updateStepName, (StepMetaInterface) insupd);
	updateStep.setDescription("insert/update data in table [" + TARGET_TABLE + "] on database [" + dbInfo + "]");
	transMeta.addStep(updateStep);

	TransHopMeta hi = new TransHopMeta(injectorStep, updateStep);
	transMeta.addTransHop(hi);

	/* PREPARE TRANSFORMATION EXECUTION */

	trans = new Trans(transMeta);
	trans.prepareExecution(null);

	StepInterface si = trans.getStepInterface(updateStepName, 0);
	rc = new RowStepCollector();
	si.addRowListener(rc);

	rp = trans.addRowProducer(injectorStepName, 0);

}
 

import org.pentaho.di.trans.steps.injector.InjectorMeta; //导入依赖的package包/类
@Before
public void setUp() throws Exception {

	KettleEnvironment.init();

	/* SET UP TRANSFORMATION */

	// Create a new transformation...
	TransMeta transMeta = new TransMeta();
	transMeta.setName("update test");

	// Add the database connections
	for (int i = 0; i < databasesXML.length; i++) {
		DatabaseMeta databaseMeta = new DatabaseMeta(databasesXML[i]);
		transMeta.addDatabase(databaseMeta);
	}

	DatabaseMeta dbInfo = transMeta.findDatabase("db");

	/* SET UP DATABASE */
	// Create target table
	db = new Database(transMeta, dbInfo);
	db.connect();

	String source = db.getCreateTableStatement(TARGET_TABLE, getTargetTableRowMeta(), null, false, null, true);
	db.execStatement(source);

	// populate target table
	for (String sql : insertStatement) {
		db.execStatement(sql);
	}

	/* SET UP TRANSFORMATION STEPS */

	PluginRegistry registry = PluginRegistry.getInstance();

	// create an injector step...
	String injectorStepName = "injector step";
	InjectorMeta im = new InjectorMeta();

	// Set the information of the injector.
	String injectorPid = registry.getPluginId(StepPluginType.class, im);
	StepMeta injectorStep = new StepMeta(injectorPid, injectorStepName, (StepMetaInterface) im);
	transMeta.addStep(injectorStep);

	// create the update step...
	String updateStepName = "update [" + TARGET_TABLE + "]";
	upd = new UpdateMeta();
	upd.setDatabaseMeta(transMeta.findDatabase("db"));
	upd.setTableName(TARGET_TABLE);
	upd.setUpdateLookup(new String[] { "VALUE" });
	upd.setUpdateStream(new String[] { "VALUE" });
	upd.setErrorIgnored(true);

	String fromid = registry.getPluginId(StepPluginType.class, upd);
	StepMeta updateStep = new StepMeta(fromid, updateStepName, (StepMetaInterface) upd);
	updateStep.setDescription("update data in table [" + TARGET_TABLE + "] on database [" + dbInfo + "]");
	transMeta.addStep(updateStep);

	TransHopMeta hi = new TransHopMeta(injectorStep, updateStep);
	transMeta.addTransHop(hi);

	/* PREPARE TRANSFORMATION EXECUTION */

	trans = new Trans(transMeta);
	trans.prepareExecution(null);

	StepInterface si = trans.getStepInterface(updateStepName, 0);
	rc = new RowStepCollector();
	si.addRowListener(rc);

	rp = trans.addRowProducer(injectorStepName, 0);

}