public void saveRep(Repository rep, long id_transformation, long id_step) throws KettleException { try { rep.saveStepAttribute(id_transformation, id_step, "schema", schemaName); // $NON-NLS-1$ rep.saveStepAttribute(id_transformation, id_step, "table", tablename); // $NON-NLS-1$ rep.saveStepAttribute( id_transformation, id_step, "id_connection_read", databaseReadMeta == null ? -1 : databaseReadMeta.getID()); // $NON-NLS-1$ rep.saveStepAttribute( id_transformation, id_step, "id_connection_write", databaseWriteMeta == null ? -1 : databaseWriteMeta .getID()); //$NON-NLS-1$ rep.saveStepAttribute(id_transformation, id_step, // "commit", commitSize); //$NON-NLS-1$ rep.saveStepAttribute(id_transformation, id_step, "cache_size", cacheSize); // $NON-NLS-1$ rep.saveStepAttribute(id_transformation, id_step, "replace", replaceFields); // $NON-NLS-1$ rep.saveStepAttribute(id_transformation, id_step, "crc", useHash); // $NON-NLS-1$ rep.saveStepAttribute(id_transformation, id_step, "crcfield", hashField); // $NON-NLS-1$ for (int i = 0; i < keyField.length; i++) { rep.saveStepAttribute( id_transformation, id_step, i, "lookup_key_name", keyField[i]); // $NON-NLS-1$ rep.saveStepAttribute( id_transformation, id_step, i, "lookup_key_field", keyLookup[i]); // $NON-NLS-1$ } rep.saveStepAttribute( id_transformation, id_step, "return_name", Const.isEmpty(technicalKeyField) ? "" : technicalKeyField); // $NON-NLS-1$ rep.saveStepAttribute(id_transformation, id_step, "sequence", sequenceFrom); // $NON-NLS-1$ rep.saveStepAttribute( id_transformation, id_step, "creation_method", techKeyCreation); // $NON-NLS-1$ // For the moment still save 'use_autoinc' for backwards compatibility (Sven Boden). rep.saveStepAttribute(id_transformation, id_step, "use_autoinc", useAutoinc); // $NON-NLS-1$ rep.saveStepAttribute( id_transformation, id_step, "last_update_field", lastUpdateField); // $NON-NLS-1$ // Also, save the step-database relationship! if (databaseReadMeta != null) rep.insertStepDatabase(id_transformation, id_step, databaseReadMeta.getID()); if (databaseWriteMeta != null) rep.insertStepDatabase(id_transformation, id_step, databaseWriteMeta.getID()); } catch (Exception e) { throw new KettleException( Messages.getString("ConcurrentCombinationLookupMeta.Exception.UnableToSaveStepInfo") + id_step, e); //$NON-NLS-1$ } }
public void saveRep(Repository rep, long id_transformation, long id_step) throws KettleException { try { rep.saveStepAttribute( id_transformation, id_step, "id_connection", databaseMeta == null ? -1 : databaseMeta.getID()); // $NON-NLS-1$ rep.saveStepAttribute(id_transformation, id_step, "commit", commitSize); // $NON-NLS-1$ rep.saveStepAttribute(id_transformation, id_step, "schema", schemaName); // $NON-NLS-1$ rep.saveStepAttribute(id_transformation, id_step, "table", tableName); // $NON-NLS-1$ for (int i = 0; i < keyStream.length; i++) { rep.saveStepAttribute( id_transformation, id_step, i, "key_name", keyStream[i]); // $NON-NLS-1$ rep.saveStepAttribute( id_transformation, id_step, i, "key_field", keyLookup[i]); // $NON-NLS-1$ rep.saveStepAttribute( id_transformation, id_step, i, "key_condition", keyCondition[i]); // $NON-NLS-1$ rep.saveStepAttribute( id_transformation, id_step, i, "key_name2", keyStream2[i]); // $NON-NLS-1$ } // Also, save the step-database relationship! if (databaseMeta != null) rep.insertStepDatabase(id_transformation, id_step, databaseMeta.getID()); } catch (Exception e) { throw new KettleException( Messages.getString("DeleteMeta.Exception.UnableToSaveStepInfo") + id_step, e); //$NON-NLS-1$ } }
public void saveRep( Repository rep, IMetaStore metaStore, ObjectId id_transformation, ObjectId id_step) throws KettleException { try { rep.saveDatabaseMetaStepAttribute(id_transformation, id_step, "id_connection", databaseMeta); rep.saveStepAttribute(id_transformation, id_step, "commit", commitSize); rep.saveStepAttribute(id_transformation, id_step, "schema", schemaName); rep.saveStepAttribute(id_transformation, id_step, "table", tableName); rep.saveStepAttribute(id_transformation, id_step, "update_bypassed", updateBypassed); for (int i = 0; i < keyStream.length; i++) { rep.saveStepAttribute(id_transformation, id_step, i, "key_name", keyStream[i]); rep.saveStepAttribute(id_transformation, id_step, i, "key_field", keyLookup[i]); rep.saveStepAttribute(id_transformation, id_step, i, "key_condition", keyCondition[i]); rep.saveStepAttribute(id_transformation, id_step, i, "key_name2", keyStream2[i]); } for (int i = 0; i < updateLookup.length; i++) { rep.saveStepAttribute(id_transformation, id_step, i, "value_name", updateLookup[i]); rep.saveStepAttribute(id_transformation, id_step, i, "value_rename", updateStream[i]); rep.saveStepAttribute( id_transformation, id_step, i, "value_update", update[i].booleanValue()); } // Also, save the step-database relationship! if (databaseMeta != null) { rep.insertStepDatabase(id_transformation, id_step, databaseMeta.getObjectId()); } } catch (Exception e) { throw new KettleException( BaseMessages.getString(PKG, "InsertUpdateMeta.Exception.UnableToSaveStepInfoToRepository") + id_step, e); } }
public void saveRep( Repository rep, IMetaStore metaStore, ObjectId id_transformation, ObjectId id_step) throws KettleException { try { rep.saveDatabaseMetaStepAttribute(id_transformation, id_step, "id_connection", databaseMeta); rep.saveStepAttribute(id_transformation, id_step, "schema", schemaName); rep.saveStepAttribute(id_transformation, id_step, "table", tableName); rep.saveStepAttribute(id_transformation, id_step, "load_action", loadAction); rep.saveStepAttribute(id_transformation, id_step, "PsqlPath", PsqlPath); rep.saveStepAttribute(id_transformation, id_step, "dbname_override", dbNameOverride); rep.saveStepAttribute(id_transformation, id_step, "enclosure", enclosure); rep.saveStepAttribute(id_transformation, id_step, "delimiter", delimiter); rep.saveStepAttribute(id_transformation, id_step, "stop_on_error", stopOnError); for (int i = 0; i < fieldTable.length; i++) { rep.saveStepAttribute(id_transformation, id_step, i, "stream_name", fieldTable[i]); rep.saveStepAttribute(id_transformation, id_step, i, "field_name", fieldStream[i]); rep.saveStepAttribute(id_transformation, id_step, i, "date_mask", dateMask[i]); } // Also, save the step-database relationship! if (databaseMeta != null) { rep.insertStepDatabase(id_transformation, id_step, databaseMeta.getObjectId()); } } catch (Exception e) { throw new KettleException( BaseMessages.getString(PKG, "GPBulkLoaderMeta.Exception.UnableToSaveStepInfoToRepository") + id_step, e); } }
public void saveRep( Repository rep, IMetaStore metaStore, ObjectId id_transformation, ObjectId id_step) throws KettleException { try { rep.saveDatabaseMetaStepAttribute(id_transformation, id_step, "id_connection", databaseMeta); rep.saveStepAttribute(id_transformation, id_step, "commit", commitSize); rep.saveStepAttribute(id_transformation, id_step, "sql_field", sqlField); rep.saveStepAttribute(id_transformation, id_step, "insert_field", insertField); rep.saveStepAttribute(id_transformation, id_step, "update_field", updateField); rep.saveStepAttribute(id_transformation, id_step, "delete_field", deleteField); rep.saveStepAttribute(id_transformation, id_step, "read_field", readField); // Also, save the step-database relationship! if (databaseMeta != null) { rep.insertStepDatabase(id_transformation, id_step, databaseMeta.getObjectId()); } rep.saveStepAttribute(id_transformation, id_step, "sqlFromfile", sqlFromfile); rep.saveStepAttribute(id_transformation, id_step, "sendOneStatement", sendOneStatement); } catch (Exception e) { throw new KettleException( BaseMessages.getString(PKG, "ExecSQLRowMeta.Exception.UnableToSaveStepInfo") + id_step, e); } }
public void saveRep( Repository rep, IMetaStore metaStore, ObjectId id_transformation, ObjectId id_step) throws KettleException { try { rep.saveDatabaseMetaStepAttribute(id_transformation, id_step, "id_connection", databaseMeta); rep.saveStepAttribute(id_transformation, id_step, "table", tablename); rep.saveStepAttribute(id_transformation, id_step, "fifo_file_name", fifoFileName); rep.saveStepAttribute(id_transformation, id_step, "sql_path", sqlPath); rep.saveStepAttribute(id_transformation, id_step, "encoding", encoding); rep.saveStepAttribute(id_transformation, id_step, "delimiter", delimiter); rep.saveStepAttribute(id_transformation, id_step, "continue_on_error", continueOnError); rep.saveStepAttribute(id_transformation, id_step, "error_file_name", errorFileName); rep.saveStepAttribute( id_transformation, id_step, "use_standard_conversion", useStandardConversion); rep.saveStepAttribute(id_transformation, id_step, "use_authentication", useAuthentication); rep.saveStepAttribute(id_transformation, id_step, "use_dynamic_vnode", useDynamicVNode); rep.saveStepAttribute(id_transformation, id_step, "use_SSV_delimiter", useSSV); rep.saveStepAttribute( id_transformation, id_step, "escape_special_characters", escapingSpecialCharacters); rep.saveStepAttribute(id_transformation, id_step, "use_vwload", usingVwload); rep.saveStepAttribute(id_transformation, id_step, "max_errors", maxNrErrors); rep.saveStepAttribute(id_transformation, id_step, "truncate_table", truncatingTable); rep.saveStepAttribute(id_transformation, id_step, "buffer_size", bufferSize); int nrRows = (fieldDatabase.length < fieldStream.length ? fieldStream.length : fieldDatabase.length); for (int idx = 0; idx < nrRows; idx++) { String columnName = (idx < fieldDatabase.length ? fieldDatabase[idx] : ""); String streamName = (idx < fieldStream.length ? fieldStream[idx] : ""); rep.saveStepAttribute(id_transformation, id_step, idx, "column_name", columnName); rep.saveStepAttribute(id_transformation, id_step, idx, "stream_name", streamName); } // Also, save the step-database relationship! if (databaseMeta != null) { rep.insertStepDatabase(id_transformation, id_step, databaseMeta.getObjectId()); } } catch (Exception e) { throw new KettleException( "Unable to save step information to the repository for id_step=" + id_step, e); } }
public void saveRep( Repository rep, IMetaStore metaStore, ObjectId id_transformation, ObjectId id_step) throws KettleException { try { rep.saveDatabaseMetaStepAttribute(id_transformation, id_step, "id_connection", databaseMeta); rep.saveStepAttribute(id_transformation, id_step, "schema", schemaName); rep.saveStepAttribute(id_transformation, id_step, "table", tableName); rep.saveStepAttribute(id_transformation, id_step, "encoding", encoding); rep.saveStepAttribute(id_transformation, id_step, "enclosure", enclosure); rep.saveStepAttribute(id_transformation, id_step, "delimiter", delimiter); rep.saveStepAttribute(id_transformation, id_step, "escape_char", escapeChar); rep.saveStepAttribute(id_transformation, id_step, "fifo_file_name", fifoFileName); rep.saveStepAttribute(id_transformation, id_step, "replace", replacingData); rep.saveStepAttribute(id_transformation, id_step, "ignore", ignoringErrors); rep.saveStepAttribute(id_transformation, id_step, "local", localFile); rep.saveStepAttribute(id_transformation, id_step, "bulk_size", bulkSize); for (int i = 0; i < fieldTable.length; i++) { rep.saveStepAttribute(id_transformation, id_step, i, "stream_name", fieldTable[i]); rep.saveStepAttribute(id_transformation, id_step, i, "field_name", fieldStream[i]); rep.saveStepAttribute( id_transformation, id_step, i, "field_format_ok", getFieldFormatTypeCode(fieldFormatType[i])); } // Also, save the step-database relationship! if (databaseMeta != null) { rep.insertStepDatabase(id_transformation, id_step, databaseMeta.getObjectId()); } } catch (Exception e) { throw new KettleException( BaseMessages.getString( PKG, "MySQLBulkLoaderMeta.Exception.UnableToSaveStepInfoToRepository") + id_step, e); } }
public void saveRep(Repository rep, ObjectId id_transformation, ObjectId id_step) throws KettleException { try { rep.saveDatabaseMetaStepAttribute(id_transformation, id_step, "id_connection", databaseMeta); rep.saveStepAttribute(id_transformation, id_step, "errors", maxErrors); // $NON-NLS-1$ rep.saveStepAttribute(id_transformation, id_step, "schema", schemaName); // $NON-NLS-1$ rep.saveStepAttribute(id_transformation, id_step, "table", tableName); // $NON-NLS-1$ rep.saveStepAttribute(id_transformation, id_step, "load_method", loadMethod); // $NON-NLS-1$ rep.saveStepAttribute(id_transformation, id_step, "load_action", loadAction); // $NON-NLS-1$ rep.saveStepAttribute(id_transformation, id_step, "PsqlPath", PsqlPath); // $NON-NLS-1$ rep.saveStepAttribute(id_transformation, id_step, "control_file", controlFile); // $NON-NLS-1$ rep.saveStepAttribute(id_transformation, id_step, "data_file", dataFile); // $NON-NLS-1$ rep.saveStepAttribute(id_transformation, id_step, "log_file", logFile); // $NON-NLS-1$ rep.saveStepAttribute(id_transformation, id_step, "erase_files", eraseFiles); // $NON-NLS-1$ rep.saveStepAttribute(id_transformation, id_step, "encoding", encoding); // $NON-NLS-1$ rep.saveStepAttribute( id_transformation, id_step, "dbname_override", dbNameOverride); // $NON-NLS-1$ for (int i = 0; i < fieldTable.length; i++) { rep.saveStepAttribute( id_transformation, id_step, i, "stream_name", fieldTable[i]); // $NON-NLS-1$ rep.saveStepAttribute( id_transformation, id_step, i, "field_name", fieldStream[i]); // $NON-NLS-1$ rep.saveStepAttribute( id_transformation, id_step, i, "date_mask", dateMask[i]); // $NON-NLS-1$ } // Also, save the step-database relationship! if (databaseMeta != null) rep.insertStepDatabase(id_transformation, id_step, databaseMeta.getObjectId()); } catch (Exception e) { throw new KettleException( BaseMessages.getString(PKG, "GPBulkLoaderMeta.Exception.UnableToSaveStepInfoToRepository") + id_step, e); //$NON-NLS-1$ } }
public void saveRep(Repository rep, long id_transformation, long id_step) throws KettleException { try { rep.saveStepAttribute( id_transformation, id_step, "id_connection", databaseMeta == null ? -1 : databaseMeta.getID()); // $NON-NLS-1$ rep.saveStepAttribute(id_transformation, id_step, "cache", cached); // $NON-NLS-1$ rep.saveStepAttribute( id_transformation, id_step, "cache_load_all", loadingAllDataInCache); // $NON-NLS-1$ rep.saveStepAttribute(id_transformation, id_step, "cache_size", cacheSize); // $NON-NLS-1$ rep.saveStepAttribute(id_transformation, id_step, "lookup_schema", schemaName); // $NON-NLS-1$ rep.saveStepAttribute(id_transformation, id_step, "lookup_table", tablename); // $NON-NLS-1$ rep.saveStepAttribute( id_transformation, id_step, "lookup_orderby", orderByClause); // $NON-NLS-1$ rep.saveStepAttribute( id_transformation, id_step, "fail_on_multiple", failingOnMultipleResults); // $NON-NLS-1$ rep.saveStepAttribute( id_transformation, id_step, "eat_row_on_failure", eatingRowOnLookupFailure); //$NON-NLS-1$ for (int i = 0; i < streamKeyField1.length; i++) { rep.saveStepAttribute( id_transformation, id_step, i, "lookup_key_name", streamKeyField1[i]); // $NON-NLS-1$ rep.saveStepAttribute( id_transformation, id_step, i, "lookup_key_field", tableKeyField[i]); // $NON-NLS-1$ rep.saveStepAttribute( id_transformation, id_step, i, "lookup_key_condition", keyCondition[i]); // $NON-NLS-1$ rep.saveStepAttribute( id_transformation, id_step, i, "lookup_key_name2", streamKeyField2[i]); // $NON-NLS-1$ } for (int i = 0; i < returnValueField.length; i++) { rep.saveStepAttribute( id_transformation, id_step, i, "return_value_name", returnValueField[i]); // $NON-NLS-1$ rep.saveStepAttribute( id_transformation, id_step, i, "return_value_rename", returnValueNewName[i]); // $NON-NLS-1$ rep.saveStepAttribute( id_transformation, id_step, i, "return_value_default", returnValueDefault[i]); // $NON-NLS-1$ rep.saveStepAttribute( id_transformation, id_step, i, "return_value_type", ValueMeta.getTypeDesc(returnValueDefaultType[i])); // $NON-NLS-1$ } // Also, save the step-database relationship! if (databaseMeta != null) rep.insertStepDatabase(id_transformation, id_step, databaseMeta.getID()); } catch (Exception e) { throw new KettleException( Messages.getString("DatabaseLookupMeta.ERROR0003.UnableToSaveStepToRepository") + id_step, e); //$NON-NLS-1$ } }