org.pentaho.di.core.Const#NVL

Source File: RepositoryImporterExtension.java From pentaho-kettle with Apache License 2.0

6 votes

String resolvePath( String rootPath, String entryPath, boolean check ) {
  boolean needToCheckPathForVariables = check;
  String extraPath = Const.NVL( entryPath, "/" );
  if ( needToCheckPathForVariables ) {
    if ( containsVariables( entryPath ) ) {
      return extraPath;
    }
  }
  String newPath = Const.NVL( rootPath, "/" );
  if ( newPath.endsWith( "/" ) && extraPath.startsWith( "/" ) ) {
    newPath = newPath.substring( 0, newPath.length() - 1 );
  } else if ( !newPath.endsWith( "/" ) && !extraPath.startsWith( "/" ) ) {
    newPath += "/";
  } else if ( extraPath.equals( "/" ) ) {
    extraPath = "";
  }
  return newPath + extraPath;
}

Source File: ChangeFileEncodingDialog.java From pentaho-kettle with Apache License 2.0

6 votes

private void setEncodings( ComboVar var ) {
  // Encoding of the text file:
  String encoding = Const.NVL( var.getText(), Const.getEnvironmentVariable( "file.encoding", "UTF-8" ) );
  var.removeAll();
  ArrayList<Charset> values = new ArrayList<Charset>( Charset.availableCharsets().values() );
  for ( int i = 0; i < values.size(); i++ ) {
    Charset charSet = values.get( i );
    var.add( charSet.displayName() );
  }

  // Now select the default!
  int idx = Const.indexOfString( encoding, var.getItems() );
  if ( idx >= 0 ) {
    var.select( idx );
  }
}

Source File: JobEntryWaitForSQL.java From pentaho-kettle with Apache License 2.0

6 votes

@Override
public void loadXML( Node entrynode, List<DatabaseMeta> databases, List<SlaveServer> slaveServers,
  Repository rep, IMetaStore metaStore ) throws KettleXMLException {
  try {
    super.loadXML( entrynode, databases, slaveServers );
    String dbname = XMLHandler.getTagValue( entrynode, "connection" );
    connection = DatabaseMeta.findDatabase( databases, dbname );
    schemaname = XMLHandler.getTagValue( entrynode, "schemaname" );
    tablename = XMLHandler.getTagValue( entrynode, "tablename" );
    successCondition =
      getSucessConditionByCode( Const.NVL( XMLHandler.getTagValue( entrynode, "success_condition" ), "" ) );
    rowsCountValue = Const.NVL( XMLHandler.getTagValue( entrynode, "rows_count_value" ), "0" );
    iscustomSQL = "Y".equalsIgnoreCase( XMLHandler.getTagValue( entrynode, "is_custom_sql" ) );
    isUseVars = "Y".equalsIgnoreCase( XMLHandler.getTagValue( entrynode, "is_usevars" ) );
    customSQL = XMLHandler.getTagValue( entrynode, "custom_sql" );
    isAddRowsResult = "Y".equalsIgnoreCase( XMLHandler.getTagValue( entrynode, "add_rows_result" ) );
    maximumTimeout = XMLHandler.getTagValue( entrynode, "maximum_timeout" );
    checkCycleTime = XMLHandler.getTagValue( entrynode, "check_cycle_time" );
    successOnTimeout = "Y".equalsIgnoreCase( XMLHandler.getTagValue( entrynode, "success_on_timeout" ) );
    isClearResultList = "Y".equalsIgnoreCase( XMLHandler.getTagValue( entrynode, "clear_result_rows" ) );

  } catch ( KettleException e ) {
    throw new KettleXMLException( BaseMessages.getString( PKG, "JobEntryWaitForSQL.UnableLoadXML" ), e );
  }
}

Source File: JobEntryHTTPTest.java From pentaho-kettle with Apache License 2.0

5 votes

@BeforeClass
public static void beforeClass() throws KettleException {
  PluginRegistry.addPluginType( TwoWayPasswordEncoderPluginType.getInstance() );
  PluginRegistry.init();
  String passwordEncoderPluginID =
      Const.NVL( EnvUtil.getSystemProperty( Const.KETTLE_PASSWORD_ENCODER_PLUGIN ), "Kettle" );
  Encr.init( passwordEncoderPluginID );
}

Source File: SimpleMappingDialog.java From pentaho-kettle with Apache License 2.0

5 votes

/**
 * Copy information from the meta-data input to the dialog fields.
 */
public void getData() {
  setSpecificationMethod( mappingMeta.getSpecificationMethod() );
  switch ( getSpecificationMethod() ) {
    case FILENAME:
      wPath.setText( Const.NVL( mappingMeta.getFileName(), "" ) );
      break;
    case REPOSITORY_BY_NAME:
      String fullPath = Const.NVL( mappingMeta.getDirectoryPath(), "" ) + "/" + Const
        .NVL( mappingMeta.getTransName(), "" );
      wPath.setText( fullPath );
      break;
    case REPOSITORY_BY_REFERENCE:
      referenceObjectId = mappingMeta.getTransObjectId();
      getByReferenceData( referenceObjectId );
      break;
    default:
      break;
  }

  addParametersTab( mappingParameters );
  wTabFolder.setSelection( 0 );

  addInputMappingDefinitionTab( inputMapping, 0 );
  addOutputMappingDefinitionTab( outputMapping, 1 );

  try {
    loadTransformation();
  } catch ( Throwable t ) {
    // Ignore errors
  }

  wStepname.selectAll();
  wStepname.setFocus();
}

Source File: SlaveServerTest.java From pentaho-kettle with Apache License 2.0

5 votes

@BeforeClass
public static void beforeClass() throws KettleException {
  PluginRegistry.addPluginType( TwoWayPasswordEncoderPluginType.getInstance() );
  PluginRegistry.init();
  String passwordEncoderPluginID =
      Const.NVL( EnvUtil.getSystemProperty( Const.KETTLE_PASSWORD_ENCODER_PLUGIN ), "Kettle" );
  Encr.init( passwordEncoderPluginID );
}

Source File: StringOperationsMeta.java From pentaho-kettle with Apache License 2.0

5 votes

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" ), "" );

      trimType[i] = Const.NVL( XMLHandler.getTagValue( fnode, "trim_type" ), "" );
      lowerUpper[i] = Const.NVL( XMLHandler.getTagValue( fnode, "lower_upper" ), "" );
      padding_type[i] = Const.NVL( XMLHandler.getTagValue( fnode, "padding_type" ), "" );
      padChar[i] = Const.NVL( XMLHandler.getTagValue( fnode, "pad_char" ), "" );
      padLen[i] = Const.NVL( XMLHandler.getTagValue( fnode, "pad_len" ), "" );
      initCap[i] = Const.NVL( XMLHandler.getTagValue( fnode, "init_cap" ), "" );
      maskXML[i] = Const.NVL( XMLHandler.getTagValue( fnode, "mask_xml" ), "" );
      digits[i] = Const.NVL( XMLHandler.getTagValue( fnode, "digits" ), "" );
      remove_special_characters[i] = Const.NVL( XMLHandler.getTagValue( fnode, "remove_special_characters" ), "" );

    }
  } catch ( Exception e ) {
    throw new KettleXMLException( BaseMessages.getString(
      PKG, "StringOperationsMeta.Exception.UnableToReadStepInfoFromXML" ), e );
  }
}

Source File: MetaInjectDialog.java From pentaho-kettle with Apache License 2.0

5 votes

private void getByReferenceData( RepositoryElementMetaInterface transInf  ) {
  String path =
    DialogUtils.getPath( transMeta.getRepositoryDirectory().getPath(), transInf.getRepositoryDirectory().getPath() );
  String fullPath =
    Const.NVL( path, "" ) + "/" + Const.NVL( transInf.getName(), "" );
  wPath.setText( fullPath );
}

Source File: SparkRunConfigurationExecutor.java From pentaho-kettle with Apache License 2.0

5 votes

/**
 * Installs the aries-rsa-discovery-zookeeper feature if not installed and sets the host and port for zookeeper.
 * Sets the appropriate variables on the transMeta for the spark engine
 *
 * @param runConfiguration The configuration for running on Spark
 * @param configuration    The configuration for executing a transformation
 * @param meta             Unused in this implementation
 * @param variableSpace    The variableSpace used to set the engine runtime values
 */
@Override public void execute( RunConfiguration runConfiguration, ExecutionConfiguration configuration,
                               AbstractMeta meta, VariableSpace variableSpace, Repository repository ) {

  // Check to see if the ael-security feature is installed. If it is, then install the jaas capability if it is
  // not already installed
  ICapability securityCapability = capabilityManager.getCapabilityById( AEL_SECURITY_CAPABILITY_ID );
  ICapability jaasCapability = capabilityManager.getCapabilityById( JAAS_CAPABILITY_ID );
  if ( securityCapability != null && securityCapability.isInstalled() ) {
    if ( jaasCapability != null && !jaasCapability.isInstalled() ) {
      jaasCapability.install();
    }
  }

  SparkRunConfiguration sparkRunConfiguration = (SparkRunConfiguration) runConfiguration;

  String runConfigSchema = Const.NVL( sparkRunConfiguration.getSchema(), "" );
  String runConfigURL = Const.NVL( sparkRunConfiguration.getUrl(), "" );


  // Variables for Websocket spark engine version
  String engineScheme = Const.NVL( runConfigSchema, DEFAULT_SCHEMA ).trim();
  String engineUrl = Const.NVL( runConfigURL, DEFAULT_URL ).trim();

  variableSpace.setVariable( "engine.scheme", engineScheme );
  variableSpace.setVariable( "engine.url", engineUrl );

  // Sets the appropriate variables on the transformation for the spark engine
  variableSpace.setVariable( "engine", "remote" );
  variableSpace.setVariable( "engine.remote", "spark" );
}

Source File: SalesforceConnectionIT.java From pentaho-kettle with Apache License 2.0

5 votes

@BeforeClass
public static void setUpClass() throws KettleException {
  PluginRegistry.addPluginType( TwoWayPasswordEncoderPluginType.getInstance() );
  PluginRegistry.init();
  String passwordEncoderPluginID =
      Const.NVL( EnvUtil.getSystemProperty( Const.KETTLE_PASSWORD_ENCODER_PLUGIN ), "Kettle" );
  Encr.init( passwordEncoderPluginID );
}

Source File: SalesforceDeleteMetaTest.java From pentaho-kettle with Apache License 2.0

5 votes

@BeforeClass
public static void setUpBeforeClass() throws KettleException {
  PluginRegistry.addPluginType( ValueMetaPluginType.getInstance() );
  PluginRegistry.addPluginType( TwoWayPasswordEncoderPluginType.getInstance() );
  PluginRegistry.init( true );
  String passwordEncoderPluginID =
    Const.NVL( EnvUtil.getSystemProperty( Const.KETTLE_PASSWORD_ENCODER_PLUGIN ), "Kettle" );
  Encr.init( passwordEncoderPluginID );
}

Source File: TableOutputDialog.java From pentaho-kettle with Apache License 2.0

5 votes

private void getInfo( TableOutputMeta info ) {
  info.setSchemaName( wSchema.getText() );
  info.setTableName( wTable.getText() );
  info.setDatabaseMeta( transMeta.findDatabase( wConnection.getText() ) );
  info.setCommitSize( wCommit.getText() );
  info.setTruncateTable( wTruncate.getSelection() );
  info.setIgnoreErrors( wIgnore.getSelection() );
  info.setUseBatchUpdate( wBatch.getSelection() );
  info.setPartitioningEnabled( wUsePart.getSelection() );
  info.setPartitioningField( wPartField.getText() );
  info.setPartitioningDaily( wPartDaily.getSelection() );
  info.setPartitioningMonthly( wPartMonthly.getSelection() );
  info.setTableNameInField( wNameInField.getSelection() );
  info.setTableNameField( wNameField.getText() );
  info.setTableNameInTable( wNameInTable.getSelection() );
  info.setReturningGeneratedKeys( wReturnKeys.getSelection() );
  info.setGeneratedKeyField( wReturnField.getText() );
  info.setSpecifyFields( wSpecifyFields.getSelection() );

  int nrRows = wFields.nrNonEmpty();
  info.allocate( nrRows );
  //CHECKSTYLE:Indentation:OFF
  for ( int i = 0; i < nrRows; i++ ) {
    TableItem item = wFields.getNonEmpty( i );
    info.getFieldDatabase()[i] = Const.NVL( item.getText( 1 ), "" );
    info.getFieldStream()[i] = Const.NVL( item.getText( 2 ), "" );
  }
}

Source File: SalesforceUpdateMetaTest.java From pentaho-kettle with Apache License 2.0

5 votes

@BeforeClass
public static void setUpBeforeClass() throws KettleException {
  PluginRegistry.addPluginType( ValueMetaPluginType.getInstance() );
  PluginRegistry.addPluginType( TwoWayPasswordEncoderPluginType.getInstance() );
  PluginRegistry.init( true );
  String passwordEncoderPluginID =
    Const.NVL( EnvUtil.getSystemProperty( Const.KETTLE_PASSWORD_ENCODER_PLUGIN ), "Kettle" );
  Encr.init( passwordEncoderPluginID );
}

Source File: SalesforceConnectionTest.java From pentaho-kettle with Apache License 2.0

5 votes

@BeforeClass
public static void setUpClass() throws KettleException {
  PluginRegistry.addPluginType( TwoWayPasswordEncoderPluginType.getInstance() );
  PluginRegistry.init();
  String passwordEncoderPluginID = Const.NVL( EnvUtil.getSystemProperty( Const.KETTLE_PASSWORD_ENCODER_PLUGIN ), "Kettle" );
  Encr.init( passwordEncoderPluginID );
}

Source File: KettleFileTableModel.java From pentaho-kettle with Apache License 2.0

5 votes

public static String getModification( ReportSubjectLocation filename ) throws KettleException {
  Date date = null;
  String user = null;
  if ( filename.isTransformation() ) {
    date = TransformationInformation.getInstance().getTransMeta( filename ).getModifiedDate();
    user = TransformationInformation.getInstance().getTransMeta( filename ).getModifiedUser();
  } else {
    date = JobInformation.getInstance().getJobMeta( filename ).getModifiedDate();
    user = JobInformation.getInstance().getJobMeta( filename ).getModifiedUser();
  }
  return Const.NVL( XMLHandler.date2string( date ), "-" ) + " by " + Const.NVL( user, "-" );
}

Source File: CypherMeta.java From knowbi-pentaho-pdi-neo4j-output with Apache License 2.0

5 votes

@Override public void getFields( RowMetaInterface rowMeta, String name, RowMetaInterface[] info, StepMeta nextStep, VariableSpace space,
                                 Repository repository, IMetaStore metaStore ) throws KettleStepException {

  if ( usingUnwind ) {
    // Unwind only outputs results, not input
    //
    rowMeta.clear();
  }

  if (returningGraph) {
    // We send out a single Graph value per input row
    //
    ValueMetaInterface valueMetaGraph = new ValueMetaGraph( Const.NVL(returnGraphField, "graph") );
    valueMetaGraph.setOrigin( name );
    rowMeta.addValueMeta( valueMetaGraph );
  } else {
    // Check return values in the metadata...
    //
    for ( ReturnValue returnValue : returnValues ) {
      try {
        int type = ValueMetaFactory.getIdForValueMeta( returnValue.getType() );
        ValueMetaInterface valueMeta = ValueMetaFactory.createValueMeta( returnValue.getName(), type );
        valueMeta.setOrigin( name );
        rowMeta.addValueMeta( valueMeta );
      } catch ( KettlePluginException e ) {
        throw new KettleStepException( "Unknown data type '" + returnValue.getType() + "' for value named '" + returnValue.getName() + "'" );
      }
    }
  }
}

Source File: DrawGoldenDataSetOnStepExtensionPoint.java From pentaho-pdi-dataset with Apache License 2.0

4 votes

protected void drawGoldenSetMarker( TransPainterExtension ext, StepMeta stepMeta, TransUnitTest unitTest, List<AreaOwner> areaOwners ) {

    TransUnitTestSetLocation location = unitTest.findGoldenLocation( stepMeta.getName() );
    if ( location == null ) {
      return;
    }
    String dataSetName = Const.NVL( location.getDataSetName(), "" );

    // Now we're here, draw a marker and indicate the name of the unit test
    //
    GCInterface gc = ext.gc;
    int iconsize = ext.iconsize;
    int x = ext.x1;
    int y = ext.y1;

    gc.setLineWidth( stepMeta.isSelected() ? 2 : 1 );
    gc.setForeground( EColor.CRYSTAL );
    gc.setBackground( EColor.LIGHTGRAY );
    gc.setFont( EFont.GRAPH );
    Point textExtent = gc.textExtent( dataSetName );
    textExtent.x += 6; // add a tiny bit of a margin
    textExtent.y += 6;

    // Draw it at the right hand side
    //
    int arrowSize = textExtent.y;
    Point point = new Point( x + iconsize, y + ( iconsize - textExtent.y ) / 2 );

    int[] arrow = new int[] {
      point.x, point.y + textExtent.y / 2,
      point.x + arrowSize, point.y,
      point.x + textExtent.x + arrowSize, point.y,
      point.x + textExtent.x + arrowSize, point.y + textExtent.y,
      point.x + arrowSize, point.y + textExtent.y,
    };

    gc.fillPolygon( arrow );
    gc.drawPolygon( arrow );
    gc.drawText( dataSetName, point.x + arrowSize + 3, point.y + 3 );

    // Leave a trace of what we drew, for memory reasons, just the name of the data set here.
    //
    areaOwners.add( new AreaOwner( AreaOwner.AreaType.CUSTOM, point.x, point.y, textExtent.x, textExtent.y, new Point( 0, 0 ), DataSetConst.AREA_DRAWN_GOLDEN_DATA_SET, stepMeta.getName() ) );

  }

Source File: JobEntryGetPOP.java From pentaho-kettle with Apache License 2.0

4 votes

public void loadRep( Repository rep, IMetaStore metaStore, ObjectId id_jobentry, List<DatabaseMeta> databases,
  List<SlaveServer> slaveServers ) throws KettleException {
  try {
    servername = rep.getJobEntryAttributeString( id_jobentry, "servername" );
    username = rep.getJobEntryAttributeString( id_jobentry, "username" );
    password =
      Encr.decryptPasswordOptionallyEncrypted( rep.getJobEntryAttributeString( id_jobentry, "password" ) );
    usessl = rep.getJobEntryAttributeBoolean( id_jobentry, "usessl" );
    sslport = rep.getJobEntryAttributeString( id_jobentry, "sslport" ); // backward compatible.
    outputdirectory = rep.getJobEntryAttributeString( id_jobentry, "outputdirectory" );
    filenamepattern = rep.getJobEntryAttributeString( id_jobentry, "filenamepattern" );
    if ( Utils.isEmpty( filenamepattern ) ) {
      filenamepattern = DEFAULT_FILE_NAME_PATTERN;
    }
    retrievemails = (int) rep.getJobEntryAttributeInteger( id_jobentry, "retrievemails" );
    firstmails = rep.getJobEntryAttributeString( id_jobentry, "firstmails" );
    delete = rep.getJobEntryAttributeBoolean( id_jobentry, "delete" );

    protocol =
      Const.NVL(
        rep.getJobEntryAttributeString( id_jobentry, "protocol" ), MailConnectionMeta.PROTOCOL_STRING_POP3 );

    String sv = rep.getJobEntryAttributeString( id_jobentry, "savemessage" );
    if ( Utils.isEmpty( sv ) ) {
      savemessage = true;
    } else {
      savemessage = rep.getJobEntryAttributeBoolean( id_jobentry, "savemessage" );
    }

    String sa = rep.getJobEntryAttributeString( id_jobentry, "saveattachment" );
    if ( Utils.isEmpty( sa ) ) {
      saveattachment = true;
    } else {
      saveattachment = rep.getJobEntryAttributeBoolean( id_jobentry, "saveattachment" );
    }

    usedifferentfolderforattachment =
      rep.getJobEntryAttributeBoolean( id_jobentry, "usedifferentfolderforattachment" );
    attachmentfolder = rep.getJobEntryAttributeString( id_jobentry, "attachmentfolder" );
    attachmentwildcard = rep.getJobEntryAttributeString( id_jobentry, "attachmentwildcard" );
    valueimaplist =
      MailConnectionMeta.getValueListImapListByCode( Const.NVL( rep.getJobEntryAttributeString(
        id_jobentry, "valueimaplist" ), "" ) );
    imapfirstmails = rep.getJobEntryAttributeString( id_jobentry, "imapfirstmails" );
    imapfolder = rep.getJobEntryAttributeString( id_jobentry, "imapfolder" );
    // search term
    senderSearch = rep.getJobEntryAttributeString( id_jobentry, "sendersearch" );
    notTermSenderSearch = rep.getJobEntryAttributeBoolean( id_jobentry, "nottermsendersearch" );
    receipientSearch = rep.getJobEntryAttributeString( id_jobentry, "receipientsearch" );
    notTermReceipientSearch = rep.getJobEntryAttributeBoolean( id_jobentry, "nottermreceipientsearch" );
    subjectSearch = rep.getJobEntryAttributeString( id_jobentry, "subjectsearch" );
    notTermSubjectSearch = rep.getJobEntryAttributeBoolean( id_jobentry, "nottermsubjectsearch" );
    bodySearch = rep.getJobEntryAttributeString( id_jobentry, "bodysearch" );
    notTermBodySearch = rep.getJobEntryAttributeBoolean( id_jobentry, "nottermbodysearch" );
    conditionReceivedDate =
      MailConnectionMeta.getConditionByCode( Const.NVL( rep.getJobEntryAttributeString(
        id_jobentry, "conditionreceiveddate" ), "" ) );
    notTermReceivedDateSearch = rep.getJobEntryAttributeBoolean( id_jobentry, "nottermreceiveddatesearch" );
    receivedDate1 = rep.getJobEntryAttributeString( id_jobentry, "receiveddate1" );
    receivedDate2 = rep.getJobEntryAttributeString( id_jobentry, "receiveddate2" );
    actiontype =
      MailConnectionMeta.getActionTypeByCode( Const.NVL( rep.getJobEntryAttributeString(
        id_jobentry, "actiontype" ), "" ) );
    moveToIMAPFolder = rep.getJobEntryAttributeString( id_jobentry, "movetoimapfolder" );
    createmovetofolder = rep.getJobEntryAttributeBoolean( id_jobentry, "createmovetofolder" );
    createlocalfolder = rep.getJobEntryAttributeBoolean( id_jobentry, "createlocalfolder" );
    aftergetimap =
      MailConnectionMeta.getAfterGetIMAPByCode( Const.NVL( rep.getJobEntryAttributeString(
        id_jobentry, "aftergetimap" ), "" ) );
    includesubfolders = rep.getJobEntryAttributeBoolean( id_jobentry, "includesubfolders" );
    useproxy = rep.getJobEntryAttributeBoolean( id_jobentry, "useproxy" );
    proxyusername = rep.getJobEntryAttributeString( id_jobentry, "proxyusername" );
  } catch ( KettleException dbe ) {
    throw new KettleException(
      "Unable to load job entry of type 'get pop' exists from the repository for id_jobentry=" + id_jobentry,
      dbe );
  }
}

Source File: KettleTwoWayPasswordEncoder.java From pentaho-kettle with Apache License 2.0

4 votes

public KettleTwoWayPasswordEncoder() {
  String envSeed = Const.NVL( EnvUtil.getSystemProperty( Const.KETTLE_TWO_WAY_PASSWORD_ENCODER_SEED ), "0933910847463829827159347601486730416058" ); // Solve for PDI-16512
  Seed = envSeed;
}

Source File: JobEntryHTTP.java From pentaho-kettle with Apache License 2.0

4 votes

@Override
public void loadRep( Repository rep, IMetaStore metaStore, ObjectId id_jobentry, List<DatabaseMeta> databases,
                     List<SlaveServer> slaveServers ) throws KettleException {
  try {
    url = rep.getJobEntryAttributeString( id_jobentry, "url" );
    targetFilename = rep.getJobEntryAttributeString( id_jobentry, "targetfilename" );
    fileAppended = rep.getJobEntryAttributeBoolean( id_jobentry, "file_appended" );
    dateTimeAdded = rep.getJobEntryAttributeBoolean( id_jobentry, "date_time_added" );
    targetFilenameExtension = Const.NVL( rep.getJobEntryAttributeString( id_jobentry, "targetfilename_extension" ),
      rep.getJobEntryAttributeString( id_jobentry, "targetfilename_extention" ) );

    uploadFilename = rep.getJobEntryAttributeString( id_jobentry, "uploadfilename" );

    urlFieldname = rep.getJobEntryAttributeString( id_jobentry, "url_fieldname" );
    uploadFieldname = rep.getJobEntryAttributeString( id_jobentry, "upload_fieldname" );
    destinationFieldname = rep.getJobEntryAttributeString( id_jobentry, "dest_fieldname" );
    runForEveryRow = rep.getJobEntryAttributeBoolean( id_jobentry, "run_every_row" );

    username = rep.getJobEntryAttributeString( id_jobentry, "username" );
    password =
      Encr.decryptPasswordOptionallyEncrypted( rep.getJobEntryAttributeString( id_jobentry, "password" ) );

    proxyHostname = rep.getJobEntryAttributeString( id_jobentry, "proxy_host" );
    proxyPort = rep.getJobEntryAttributeString( id_jobentry, "proxy_port" ); // backward compatible.

    nonProxyHosts = rep.getJobEntryAttributeString( id_jobentry, "non_proxy_hosts" );
    addfilenameresult =
      "Y".equalsIgnoreCase( Const
        .NVL( rep.getJobEntryAttributeString( id_jobentry, "addfilenameresult" ), "Y" ) );

    // How many headerName?
    int argnr = rep.countNrJobEntryAttributes( id_jobentry, "header_name" );
    allocate( argnr );

    for ( int a = 0; a < argnr; a++ ) {
      headerName[ a ] = rep.getJobEntryAttributeString( id_jobentry, a, "header_name" );
      headerValue[ a ] = rep.getJobEntryAttributeString( id_jobentry, a, "header_value" );
    }
  } catch ( KettleException dbe ) {
    throw new KettleException( "Unable to load job entry of type 'HTTP' from the repository for id_jobentry="
      + id_jobentry, dbe );
  }
}

Java Code Examples for org.pentaho.di.core.Const#NVL