Java Code Examples for org.pentaho.di.repository.Repository#loadDatabaseMetaFromJobEntryAttribute()

public void loadRep( Repository rep, IMetaStore metaStore, ObjectId id_jobentry, List<DatabaseMeta> databases,
  List<SlaveServer> slaveServers ) throws KettleException {
  try {
    schemaname = rep.getJobEntryAttributeString( id_jobentry, "schemaname" );
    tablename = rep.getJobEntryAttributeString( id_jobentry, "tablename" );
    filename = rep.getJobEntryAttributeString( id_jobentry, "filename" );
    separator = rep.getJobEntryAttributeString( id_jobentry, "separator" );
    enclosed = rep.getJobEntryAttributeString( id_jobentry, "enclosed" );
    escaped = rep.getJobEntryAttributeString( id_jobentry, "escaped" );
    linestarted = rep.getJobEntryAttributeString( id_jobentry, "linestarted" );
    lineterminated = rep.getJobEntryAttributeString( id_jobentry, "lineterminated" );
    replacedata = rep.getJobEntryAttributeBoolean( id_jobentry, "replacedata" );
    ignorelines = rep.getJobEntryAttributeString( id_jobentry, "ignorelines" );
    listattribut = rep.getJobEntryAttributeString( id_jobentry, "listattribut" );
    localinfile = rep.getJobEntryAttributeBoolean( id_jobentry, "localinfile" );
    prorityvalue = (int) rep.getJobEntryAttributeInteger( id_jobentry, "prorityvalue" );
    addfiletoresult = rep.getJobEntryAttributeBoolean( id_jobentry, "addfiletoresult" );

    connection = rep.loadDatabaseMetaFromJobEntryAttribute( id_jobentry, "connection", "id_database", databases );
  } catch ( KettleDatabaseException dbe ) {
    throw new KettleException(
      "Unable to load job entry of type 'Mysql bulk load' from the repository for id_jobentry=" + id_jobentry,
      dbe );
  }
}
 

@Override
public void loadRep( Repository rep, IMetaStore metaStore, ObjectId id_jobentry, List<DatabaseMeta> databases,
  List<SlaveServer> slaveServers ) throws KettleException {
  try {
    connection = rep.loadDatabaseMetaFromJobEntryAttribute( id_jobentry, "connection", "id_database", databases );

    schemaname = rep.getJobEntryAttributeString( id_jobentry, "schemaname" );
    tablename = rep.getJobEntryAttributeString( id_jobentry, "tablename" );
    successCondition =
      getSuccessConditionByCode( Const.NVL(
        rep.getJobEntryAttributeString( id_jobentry, "success_condition" ), "" ) );
    rowsCountValue = rep.getJobEntryAttributeString( id_jobentry, "rows_count_value" );
    iscustomSQL = rep.getJobEntryAttributeBoolean( id_jobentry, "is_custom_sql" );
    isUseVars = rep.getJobEntryAttributeBoolean( id_jobentry, "is_usevars" );
    isAddRowsResult = rep.getJobEntryAttributeBoolean( id_jobentry, "add_rows_result" );
    customSQL = rep.getJobEntryAttributeString( id_jobentry, "custom_sql" );
    maximumTimeout = rep.getJobEntryAttributeString( id_jobentry, "maximum_timeout" );
    checkCycleTime = rep.getJobEntryAttributeString( id_jobentry, "check_cycle_time" );
    successOnTimeout = rep.getJobEntryAttributeBoolean( id_jobentry, "success_on_timeout" );
    isClearResultList = rep.getJobEntryAttributeBoolean( id_jobentry, "clear_result_rows" );
  } catch ( KettleDatabaseException dbe ) {
    throw new KettleException( BaseMessages
      .getString( PKG, "JobEntryWaitForSQL.UnableLoadRep", "" + id_jobentry ), dbe );
  }
}
 

public void loadRep( Repository rep, IMetaStore metaStore, ObjectId id_jobentry, List<DatabaseMeta> databases,
  List<SlaveServer> slaveServers ) throws KettleException {
  try {
    connection = rep.loadDatabaseMetaFromJobEntryAttribute( id_jobentry, "connection", "id_database", databases );

    schemaname = rep.getJobEntryAttributeString( id_jobentry, "schemaname" );
    tablename = rep.getJobEntryAttributeString( id_jobentry, "tablename" );
    successCondition =
      getSuccessConditionByCode( Const.NVL(
        rep.getJobEntryAttributeString( id_jobentry, "success_condition" ), "" ) );
    limit = rep.getJobEntryAttributeString( id_jobentry, "limit" );
    useCustomSQL = rep.getJobEntryAttributeBoolean( id_jobentry, "is_custom_sql" );
    useVars = rep.getJobEntryAttributeBoolean( id_jobentry, "is_usevars" );
    addRowsResult = rep.getJobEntryAttributeBoolean( id_jobentry, "add_rows_result" );
    clearResultList = rep.getJobEntryAttributeBoolean( id_jobentry, "clear_result_rows" );

    customSQL = rep.getJobEntryAttributeString( id_jobentry, "custom_sql" );
  } catch ( KettleDatabaseException dbe ) {
    throw new KettleException( BaseMessages.getString( PKG, "JobEntryEvalTableContent.UnableLoadRep", ""
      + id_jobentry ), dbe );
  }
}
 

public void loadRep( Repository rep, IMetaStore metaStore, ObjectId id_jobentry, List<DatabaseMeta> databases,
  List<SlaveServer> slaveServers ) throws KettleException {
  try {
    connection = rep.loadDatabaseMetaFromJobEntryAttribute( id_jobentry, "connection", "id_database", databases );

    this.argFromPrevious = rep.getJobEntryAttributeBoolean( id_jobentry, "arg_from_previous" );
    // How many arguments?
    int argnr = rep.countNrJobEntryAttributes( id_jobentry, "name" );
    allocate( argnr );

    // Read them all...
    for ( int a = 0; a < argnr; a++ ) {
      this.arguments[a] = rep.getJobEntryAttributeString( id_jobentry, a, "name" );
      this.schemaname[a] = rep.getJobEntryAttributeString( id_jobentry, a, "schemaname" );
    }

  } catch ( KettleDatabaseException dbe ) {
    throw new KettleException( BaseMessages.getString( PKG, "JobEntryTruncateTables.UnableLoadRep", ""
      + id_jobentry ), dbe );
  }
}
 

public void loadRep( Repository rep, IMetaStore metaStore, ObjectId id_jobentry, List<DatabaseMeta> databases,
  List<SlaveServer> slaveServers ) throws KettleException {
  try {
    tablename = rep.getJobEntryAttributeString( id_jobentry, "tablename" );
    schemaname = rep.getJobEntryAttributeString( id_jobentry, "schemaname" );

    connection = rep.loadDatabaseMetaFromJobEntryAttribute( id_jobentry, "connection", "id_database", databases );

    // How many arguments?
    int argnr = rep.countNrJobEntryAttributes( id_jobentry, "name" );
    arguments = new String[argnr];

    // Read them all...
    for ( int a = 0; a < argnr; a++ ) {
      arguments[a] = rep.getJobEntryAttributeString( id_jobentry, a, "name" );
    }

  } catch ( KettleDatabaseException dbe ) {
    throw new KettleException( BaseMessages.getString( PKG, "JobEntryColumnsExist.Meta.UnableLoadRep", ""
      + id_jobentry ), dbe );
  }
}
 

public void loadRep( Repository rep, IMetaStore metaStore, ObjectId id_jobentry, List<DatabaseMeta> databases,
  List<SlaveServer> slaveServers ) throws KettleException {
  try {
    // How many connections?
    int argnr = rep.countNrJobEntryAttributes( id_jobentry, "id_database" );
    connections = new DatabaseMeta[argnr];
    waitfors = new String[argnr];
    waittimes = new int[argnr];
    // Read them all...
    for ( int a = 0; a < argnr; a++ ) {
      connections[a] =
        rep.loadDatabaseMetaFromJobEntryAttribute( id_jobentry, "connection", a, "id_database", databases );
      waitfors[a] = rep.getJobEntryAttributeString( id_jobentry, a, "waitfor" );
      waittimes[a] =
        getWaitByCode( Const.NVL( rep.getJobEntryAttributeString( id_jobentry, a, "waittime" ), "" ) );
    }
  } catch ( KettleException dbe ) {
    throw new KettleException( BaseMessages.getString(
      PKG, "JobEntryCheckDbConnections.ERROR_0002_Cannot_Load_Job_From_Repository", "" + id_jobentry, dbe
        .getMessage() ) );
  }
}
 

public void loadRep( Repository rep, IMetaStore metaStore, ObjectId id_jobentry, List<DatabaseMeta> databases,
    List<SlaveServer> slaveServers ) throws KettleException {
  try {
    this.databaseMeta =
        rep.loadDatabaseMetaFromJobEntryAttribute( id_jobentry, "connection", "id_database", databases );
    this.setCubeName( rep.getStepAttributeString( id_jobentry, "cubeName" ) );

    int nrFields = rep.countNrStepAttributes( id_jobentry, "dimensionname" );

    for ( int i = 0; i < nrFields; i++ ) {
      String dimensionName = rep.getStepAttributeString( id_jobentry, i, "dimensionname" );
      this.dimensionNames.add( dimensionName );
    }
  } catch ( KettleException dbe ) {
    throw new KettleException( "Unable to load job entry for type file exists from the repository for id_jobentry="
        + id_jobentry, dbe );
  }
}
 

public void loadRep( Repository rep, IMetaStore metaStore, ObjectId id_jobentry, List<DatabaseMeta> databases,
  List<SlaveServer> slaveServers ) throws KettleException {
  try {
    schemaname = rep.getJobEntryAttributeString( id_jobentry, "schemaname" );
    tablename = rep.getJobEntryAttributeString( id_jobentry, "tablename" );
    filename = rep.getJobEntryAttributeString( id_jobentry, "filename" );
    separator = rep.getJobEntryAttributeString( id_jobentry, "separator" );
    enclosed = rep.getJobEntryAttributeString( id_jobentry, "enclosed" );
    lineterminated = rep.getJobEntryAttributeString( id_jobentry, "lineterminated" );
    limitlines = rep.getJobEntryAttributeString( id_jobentry, "limitlines" );
    listcolumn = rep.getJobEntryAttributeString( id_jobentry, "listcolumn" );
    highpriority = rep.getJobEntryAttributeBoolean( id_jobentry, "highpriority" );
    optionenclosed = rep.getJobEntryAttributeBoolean( id_jobentry, "optionenclosed" );

    outdumpvalue = (int) rep.getJobEntryAttributeInteger( id_jobentry, "outdumpvalue" );

    iffileexists = (int) rep.getJobEntryAttributeInteger( id_jobentry, "iffileexists" );

    addfiletoresult = rep.getJobEntryAttributeBoolean( id_jobentry, "addfiletoresult" );

    connection = rep.loadDatabaseMetaFromJobEntryAttribute( id_jobentry, "connection", "id_database", databases );
  } catch ( KettleDatabaseException dbe ) {
    throw new KettleException(
      "Unable to load job entry of type 'table exists' from the repository for id_jobentry=" + id_jobentry,
      dbe );
  }
}
 

public void loadRep( Repository rep, IMetaStore metaStore, ObjectId idJobentry, List<DatabaseMeta> databases,
  List<SlaveServer> slaveServers ) throws KettleException {
  try {
    sql = rep.getJobEntryAttributeString( idJobentry, SQL_TAG );
    String sSubs = rep.getJobEntryAttributeString( idJobentry, USE_VARIABLE_SUBSTITUTION_TAG );
    if ( sSubs != null && sSubs.equalsIgnoreCase( "T" ) ) {
      useVariableSubstitution = true;
    }

    String ssql = rep.getJobEntryAttributeString( idJobentry, SQLFROMFILE_TAG );
    if ( ssql != null && ssql.equalsIgnoreCase( "T" ) ) {
      sqlFromFile = true;
    }

    String ssendOneStatement = rep.getJobEntryAttributeString( idJobentry, SEND_ONE_STATEMENT_TAG );
    if ( ssendOneStatement != null && ssendOneStatement.equalsIgnoreCase( "T" ) ) {
      sendOneStatement = true;
    }

    sqlFilename = rep.getJobEntryAttributeString( idJobentry, SQLFILENAME_TAG );

    databaseMeta = rep.loadDatabaseMetaFromJobEntryAttribute( idJobentry, CONNECTION_TAG, ID_DATABASE, databases );
  } catch ( KettleDatabaseException dbe ) {
    throw new KettleException( "Unable to load job entry of type 'sql' from the repository with idJobentry="
      + idJobentry, dbe );
  }
}
 

public void loadRep( Repository rep, IMetaStore metaStore, ObjectId id_jobentry, List<DatabaseMeta> databases,
  List<SlaveServer> slaveServers ) throws KettleException {
  try {
    tablename = rep.getJobEntryAttributeString( id_jobentry, "tablename" );
    schemaname = rep.getJobEntryAttributeString( id_jobentry, "schemaname" );

    connection = rep.loadDatabaseMetaFromJobEntryAttribute( id_jobentry, "connection", "id_database", databases );
  } catch ( KettleDatabaseException dbe ) {
    throw new KettleException(
      BaseMessages.getString( PKG, "TableExists.Meta.UnableLoadRep", "" + id_jobentry ), dbe );
  }
}
 

public void loadRep( Repository rep, IMetaStore metaStore, ObjectId id_jobentry, List<DatabaseMeta> databases,
    List<SlaveServer> slaveServers ) throws KettleException {
  try {
    this.databaseMeta =
        rep.loadDatabaseMetaFromJobEntryAttribute( id_jobentry, "connection", "id_database", databases );
    this.setCubeName( rep.getStepAttributeString( id_jobentry, "cubeName" ) );

  } catch ( KettleException dbe ) {
    throw new KettleException( "Unable to load job entry for type file exists from the repository for id_jobentry="
        + id_jobentry, dbe );
  }
}
 

public void loadRep( Repository rep, IMetaStore metaStore, ObjectId id_jobentry, List<DatabaseMeta> databases,
  List<SlaveServer> slaveServers ) throws KettleException {
  try {
    schemaname = rep.getJobEntryAttributeString( id_jobentry, "schemaname" );
    tablename = rep.getJobEntryAttributeString( id_jobentry, "tablename" );
    filename = rep.getJobEntryAttributeString( id_jobentry, "filename" );

    datafiletype = rep.getJobEntryAttributeString( id_jobentry, "datafiletype" );
    fieldterminator = rep.getJobEntryAttributeString( id_jobentry, "fieldterminator" );

    lineterminated = rep.getJobEntryAttributeString( id_jobentry, "lineterminated" );
    codepage = rep.getJobEntryAttributeString( id_jobentry, "codepage" );
    specificcodepage = rep.getJobEntryAttributeString( id_jobentry, "specificcodepage" );
    formatfilename = rep.getJobEntryAttributeString( id_jobentry, "formatfilename" );
    firetriggers = rep.getJobEntryAttributeBoolean( id_jobentry, "firetriggers" );
    checkconstraints = rep.getJobEntryAttributeBoolean( id_jobentry, "checkconstraints" );
    keepnulls = rep.getJobEntryAttributeBoolean( id_jobentry, "keepnulls" );
    keepidentity = rep.getJobEntryAttributeBoolean( id_jobentry, "keepidentity" );

    tablock = rep.getJobEntryAttributeBoolean( id_jobentry, "tablock" );

    startfile = (int) rep.getJobEntryAttributeInteger( id_jobentry, "startfile" );
    endfile = (int) rep.getJobEntryAttributeInteger( id_jobentry, "endfile" );

    orderby = rep.getJobEntryAttributeString( id_jobentry, "orderby" );
    orderdirection = rep.getJobEntryAttributeString( id_jobentry, "orderdirection" );

    errorfilename = rep.getJobEntryAttributeString( id_jobentry, "errorfilename" );
    maxerrors = (int) rep.getJobEntryAttributeInteger( id_jobentry, "maxerrors" );
    batchsize = (int) rep.getJobEntryAttributeInteger( id_jobentry, "batchsize" );
    rowsperbatch = (int) rep.getJobEntryAttributeInteger( id_jobentry, "rowsperbatch" );
    adddatetime = rep.getJobEntryAttributeBoolean( id_jobentry, "adddatetime" );

    addfiletoresult = rep.getJobEntryAttributeBoolean( id_jobentry, "addfiletoresult" );
    truncate = rep.getJobEntryAttributeBoolean( id_jobentry, "truncate" );

    connection = rep.loadDatabaseMetaFromJobEntryAttribute( id_jobentry, "connection", "id_database", databases );
  } catch ( KettleDatabaseException dbe ) {
    throw new KettleException(
      "Unable to load job entry of type 'MSsql bulk load' from the repository for id_jobentry=" + id_jobentry,
      dbe );
  }
}