public HostStats mapRow(Row rs) { HostStats stats = new HostStats(); stats.setNodeId(rs.getString("node_id")); stats.setHostName(rs.getString("host_name")); stats.setStartTime(truncateToMinutes(rs.getDateTime("start_time"))); stats.setEndTime(truncateToMinutes(rs.getDateTime("end_time"))); stats.setRestarted(rs.getLong("restarted")); stats.setNodesPulled(rs.getLong("nodes_pulled")); stats.setNodesPushed(rs.getLong("nodes_pushed")); stats.setNodesRejected(rs.getLong("nodes_rejected")); stats.setNodesRegistered(rs.getLong("nodes_registered")); stats.setNodesLoaded(rs.getLong("nodes_loaded")); stats.setNodesDisabled(rs.getLong("nodes_disabled")); stats.setPurgedDataRows(rs.getLong("purged_data_rows")); stats.setPurgedDataEventRows(rs.getLong("purged_data_event_rows")); stats.setPurgedBatchOutgoingRows(rs.getLong("purged_batch_outgoing_rows")); stats.setPurgedBatchIncomingRows(rs.getLong("purged_batch_incoming_rows")); stats.setTriggersCreatedCount(rs.getLong("triggers_created_count")); stats.setTriggersRebuiltCount(rs.getLong("triggers_rebuilt_count")); stats.setTriggersRemovedCount(rs.getLong("triggers_removed_count")); stats.setTotalNodesPullTime(rs.getLong("total_nodes_pull_time")); stats.setTotalNodesPushTime(rs.getLong("total_nodes_push_time")); return stats; } }
public ChannelStats mapRow(Row rs) { ChannelStats stats = new ChannelStats(); stats.setNodeId(rs.getString("node_id")); stats.setHostName(rs.getString("host_name")); stats.setChannelId(rs.getString("channel_id")); stats.setStartTime(truncateToMinutes(rs.getDateTime("start_time"))); stats.setEndTime(truncateToMinutes(rs.getDateTime("end_time"))); stats.setDataRouted(rs.getLong("data_routed")); stats.setDataUnRouted(rs.getLong("data_unrouted")); stats.setDataEventInserted(rs.getLong("data_event_inserted")); stats.setDataExtracted(rs.getLong("data_extracted")); stats.setDataBytesExtracted(rs.getLong("data_bytes_extracted")); stats.setDataExtractedErrors(rs.getLong("data_extracted_errors")); stats.setDataSent(rs.getLong("data_sent")); stats.setDataBytesSent(rs.getLong("data_bytes_sent")); stats.setDataSentErrors(rs.getLong("data_sent_errors")); stats.setDataLoaded(rs.getLong("data_loaded")); stats.setDataBytesLoaded(rs.getLong("data_bytes_loaded")); stats.setDataLoadedErrors(rs.getLong("data_loaded_errors")); return stats; } }
public NodeCommunication mapRow(Row rs) { NodeCommunication nodeCommuncation = new NodeCommunication(); nodeCommuncation.setCommunicationType(CommunicationType.valueOf(rs.getString( "communication_type").toUpperCase())); nodeCommuncation.setNodeId(rs.getString("node_id")); nodeCommuncation.setLockTime(rs.getDateTime("lock_time")); nodeCommuncation.setLastLockMillis(rs.getLong("last_lock_millis")); nodeCommuncation.setLockingServerId(rs.getString("locking_server_id")); nodeCommuncation.setSuccessCount(rs.getLong("success_count")); nodeCommuncation.setTotalSuccessCount(rs.getLong("total_success_count")); nodeCommuncation.setTotalSuccessMillis(rs.getLong("total_success_millis")); nodeCommuncation.setFailCount(rs.getLong("fail_count")); nodeCommuncation.setTotalFailCount(rs.getLong("total_fail_count")); nodeCommuncation.setTotalFailMillis(rs.getLong("total_fail_millis")); nodeCommuncation.setLastLockTime(rs.getDateTime("last_lock_time")); return nodeCommuncation; } }
public IncomingBatch mapRow(Row rs) { IncomingBatch batch = new IncomingBatch(); batch.setBatchId(rs.getLong("batch_id")); batch.setNodeId(rs.getString("node_id")); batch.setChannelId(rs.getString("channel_id")); batch.setStatus(IncomingBatch.Status.valueOf(rs.getString("status"))); batch.setNetworkMillis(rs.getLong("network_millis")); batch.setFilterMillis(rs.getLong("filter_millis")); batch.setDatabaseMillis(rs.getLong("database_millis")); batch.setFailedRowNumber(rs.getLong("failed_row_number")); batch.setFailedLineNumber(rs.getLong("failed_line_number")); batch.setByteCount(rs.getLong("byte_count")); batch.setStatementCount(rs.getLong("statement_count")); batch.setFallbackInsertCount(rs.getLong("fallback_insert_count")); batch.setFallbackUpdateCount(rs.getLong("fallback_update_count")); batch.setIgnoreCount(rs.getLong("ignore_count")); batch.setMissingDeleteCount(rs.getLong("missing_delete_count")); batch.setSkipCount(rs.getLong("skip_count")); batch.setSqlState(rs.getString("sql_state")); batch.setSqlCode(rs.getInt("sql_code")); batch.setSqlMessage(rs.getString("sql_message")); batch.setLastUpdatedHostName(rs.getString("last_update_hostname")); batch.setLastUpdatedTime(rs.getDateTime("last_update_time")); batch.setCreateTime(rs.getDateTime("create_time")); batch.setErrorFlag(rs.getBoolean("error_flag")); return batch; } }
batch.setNodeId(rs.getString("node_id")); batch.setStatus(rs.getString("status")); batch.setByteCount(rs.getLong("byte_count")); batch.setExtractCount(rs.getLong("extract_count")); batch.setSentCount(rs.getLong("sent_count")); batch.setLoadCount(rs.getLong("load_count")); batch.setDataEventCount(rs.getLong("data_event_count")); batch.setReloadEventCount(rs.getLong("reload_event_count")); batch.setInsertEventCount(rs.getLong("insert_event_count")); batch.setUpdateEventCount(rs.getLong("update_event_count")); batch.setDeleteEventCount(rs.getLong("delete_event_count")); batch.setOtherEventCount(rs.getLong("other_event_count")); batch.setIgnoreCount(rs.getLong("ignore_count")); batch.setRouterMillis(rs.getLong("router_millis")); batch.setNetworkMillis(rs.getLong("network_millis")); batch.setFilterMillis(rs.getLong("filter_millis")); batch.setLoadMillis(rs.getLong("load_millis")); batch.setExtractMillis(rs.getLong("extract_millis")); batch.setSqlState(rs.getString("sql_state")); batch.setSqlCode(rs.getInt("sql_code")); batch.setSqlMessage(rs.getString("sql_message")); batch.setFailedDataId(rs.getLong("failed_data_id")); batch.setLastUpdatedHostName(rs.getString("last_update_hostname")); batch.setLastUpdatedTime(rs.getDateTime("last_update_time")); batch.setCreateTime(rs.getDateTime("create_time")); batch.setBatchId(rs.getLong("batch_id")); batch.setLoadFlag(rs.getBoolean("load_flag")); batch.setErrorFlag(rs.getBoolean("error_flag")); batch.setCommonFlag(rs.getBoolean("common_flag"));
public ExtractRequest mapRow(Row row) { ExtractRequest request = new ExtractRequest(); request.setNodeId(row.getString("node_id")); request.setRequestId(row.getLong("request_id")); request.setStartBatchId(row.getLong("start_batch_id")); request.setEndBatchId(row.getLong("end_batch_id")); request.setStatus(ExtractStatus.valueOf(row.getString("status").toUpperCase())); request.setCreateTime(row.getDateTime("create_time")); request.setLastUpdateTime(row.getDateTime("last_update_time")); request.setTriggerRouter(triggerRouterService.findTriggerRouterById( row.getString("trigger_id"), row.getString("router_id"))); return request; } }
public Sequence mapRow(Row rs) { Sequence sequence = new Sequence(); sequence.setCreateTime(rs.getDateTime("create_time")); sequence.setCurrentValue(rs.getLong("current_value")); sequence.setIncrementBy(rs.getInt("increment_by")); sequence.setLastUpdateBy(rs.getString("last_update_by")); sequence.setLastUpdateTime(rs.getDateTime("last_update_time")); sequence.setMaxValue(rs.getLong("max_value")); sequence.setMinValue(rs.getLong("min_value")); sequence.setSequenceName(rs.getString("sequence_name")); sequence.setCycle(rs.getBoolean("cycle")); return sequence; } }
public FileSnapshot mapRow(Row rs) { FileSnapshot fileSnapshot = new FileSnapshot(); fileSnapshot.setCrc32Checksum(rs.getLong("crc32_checksum")); fileSnapshot.setCreateTime(rs.getDateTime("create_time")); fileSnapshot.setLastUpdateBy(rs.getString("last_update_by")); fileSnapshot.setLastUpdateTime(rs.getDateTime("last_update_time")); fileSnapshot.setFileModifiedTime(rs.getLong("file_modified_time")); fileSnapshot.setFileName(rs.getString("file_name")); fileSnapshot.setRelativeDir(rs.getString("relative_dir")==null?null:rs.getString("relative_dir").replace('\\', '/')); fileSnapshot.setFileSize(rs.getLong("file_size")); fileSnapshot.setLastEventType(LastEventType.fromCode(rs.getString("last_event_type"))); fileSnapshot.setTriggerId(rs.getString("trigger_id")); fileSnapshot.setRouterId(rs.getString("router_id")); return fileSnapshot; } }
public JobStats mapRow(Row rs) { JobStats stats = new JobStats(); stats.setNodeId(rs.getString("node_id")); stats.setHostName(rs.getString("host_name")); stats.setJobName(rs.getString("job_name")); stats.setStartTime(truncateToMinutes(rs.getDateTime("start_time"))); stats.setEndTime(truncateToMinutes(rs.getDateTime("end_time"))); stats.setProcessedCount(rs.getLong("processed_count")); return stats; } }
public NodeSecurity mapRow(Row rs) { NodeSecurity nodeSecurity = new NodeSecurity(); nodeSecurity.setNodeId(rs.getString("node_id")); nodeSecurity.setNodePassword(filterPasswordOnRenderIfNeeded(rs .getString("node_password"))); nodeSecurity.setRegistrationEnabled(rs.getBoolean("registration_enabled")); nodeSecurity.setRegistrationTime(rs.getDateTime("registration_time")); nodeSecurity.setInitialLoadEnabled(rs.getBoolean("initial_load_enabled")); nodeSecurity.setInitialLoadTime(rs.getDateTime("initial_load_time")); nodeSecurity.setCreatedAtNodeId(rs.getString("created_at_node_id")); nodeSecurity.setRevInitialLoadEnabled(rs.getBoolean("rev_initial_load_enabled")); nodeSecurity.setRevInitialLoadTime(rs.getDateTime("rev_initial_load_time")); nodeSecurity.setInitialLoadId(rs.getLong("initial_load_id")); nodeSecurity.setInitialLoadCreateBy(rs.getString("initial_load_create_by")); nodeSecurity.setRevInitialLoadId(rs.getLong("rev_initial_load_id")); nodeSecurity.setRevInitialLoadCreateBy(rs.getString("rev_initial_load_create_by")); return nodeSecurity; } }
public NodeHost mapRow(Row rs) { NodeHost nodeHost = new NodeHost(); nodeHost.setNodeId(rs.getString("node_id")); nodeHost.setHostName(rs.getString("host_name")); nodeHost.setIpAddress(rs.getString("ip_address")); nodeHost.setOsUser(rs.getString("os_user")); nodeHost.setOsName(rs.getString("os_name")); nodeHost.setOsArch(rs.getString("os_arch")); nodeHost.setOsVersion(rs.getString("os_version")); nodeHost.setAvailableProcessors(rs.getInt("available_processors")); nodeHost.setFreeMemoryBytes(rs.getLong("free_memory_bytes")); nodeHost.setTotalMemoryBytes(rs.getLong("total_memory_bytes")); nodeHost.setMaxMemoryBytes(rs.getLong("max_memory_bytes")); nodeHost.setJavaVersion(rs.getString("java_version")); nodeHost.setJavaVendor(rs.getString("java_vendor")); nodeHost.setSymmetricVersion(rs.getString("symmetric_version")); nodeHost.setTimezoneOffset(rs.getString("timezone_offset")); nodeHost.setHeartbeatTime(rs.getDateTime("heartbeat_time")); nodeHost.setLastRestartTime(rs.getDateTime("last_restart_time")); nodeHost.setCreateTime(rs.getDateTime("create_time")); return nodeHost; } }
public TriggerHistory mapRow(Row rs) { TriggerHistory hist = new TriggerHistory(); hist.setTriggerHistoryId(rs.getInt("trigger_hist_id")); hist.setTriggerId(rs.getString("trigger_id")); hist.setSourceTableName(rs.getString("source_table_name")); hist.setTableHash(rs.getInt("table_hash")); hist.setCreateTime(rs.getDateTime("create_time")); hist.setPkColumnNames(rs.getString("pk_column_names")); hist.setColumnNames(rs.getString("column_names")); hist.setLastTriggerBuildReason(TriggerReBuildReason.fromCode(rs .getString("last_trigger_build_reason"))); hist.setNameForDeleteTrigger(rs.getString("name_for_delete_trigger")); hist.setNameForInsertTrigger(rs.getString("name_for_insert_trigger")); hist.setNameForUpdateTrigger(rs.getString("name_for_update_trigger")); hist.setSourceSchemaName(rs.getString("source_schema_name")); hist.setSourceCatalogName(rs.getString("source_catalog_name")); hist.setTriggerRowHash(rs.getLong("trigger_row_hash")); hist.setTriggerTemplateHash(rs.getLong("trigger_template_hash")); hist.setErrorMessage(rs.getString("error_message")); if (this.retMap != null) { this.retMap.put((long) hist.getTriggerHistoryId(), hist); } return hist; } }
public IncomingError mapRow(Row rs) { IncomingError incomingError = new IncomingError(); incomingError.setBatchId(rs.getLong("batch_id")); incomingError.setNodeId(rs.getString("node_id")); incomingError.setFailedRowNumber(rs.getLong("failed_row_number")); incomingError.setFailedLineNumber(rs.getLong("failed_line_number")); incomingError.setTargetCatalogName(rs.getString("target_catalog_name")); incomingError.setTargetSchemaName(rs.getString("target_schema_name")); incomingError.setTargetTableName(rs.getString("target_table_name")); incomingError.setEventType(DataEventType.getEventType(rs.getString("event_type"))); incomingError .setBinaryEncoding(BinaryEncoding.valueOf(rs.getString("binary_encoding"))); incomingError.setColumnNames(rs.getString("column_names")); incomingError.setPrimaryKeyColumnNames(rs.getString("pk_column_names")); incomingError.setRowData(rs.getString("row_data")); incomingError.setOldData(rs.getString("old_data")); incomingError.setCurData(rs.getString("cur_data")); incomingError.setResolveData(rs.getString("resolve_data")); incomingError.setResolveIgnore(rs.getBoolean("resolve_ignore")); incomingError.setConflictId(rs.getString("conflict_id")); incomingError.setCreateTime(rs.getDateTime("create_time")); incomingError.setLastUpdateBy(rs.getString("last_update_by")); incomingError.setLastUpdateTime(rs.getDateTime("last_update_time")); return incomingError; } }
data.putAttribute(CsvData.ATTRIBUTE_EXTERNAL_DATA, row.getString("EXTERNAL_DATA")); data.putAttribute(CsvData.ATTRIBUTE_NODE_LIST, row.getString("NODE_LIST")); data.putAttribute(CsvData.ATTRIBUTE_DATA_ID, row.getLong("DATA_ID")); data.putAttribute(CsvData.ATTRIBUTE_CREATE_TIME, row.getDateTime("CREATE_TIME")); data.putAttribute(CsvData.ATTRIBUTE_ROUTER_ID, row.getString("ROUTER_ID", false));
public RegistrationRequest mapRow(Row rs) { RegistrationRequest request = new RegistrationRequest(); request.setNodeGroupId(rs.getString("node_group_id")); request.setExternalId(rs.getString("external_id")); request.setStatus(RegistrationStatus.valueOf(RegistrationStatus.class, rs.getString("status"))); request.setHostName(rs.getString("host_name")); request.setIpAddress(rs.getString("ip_address")); request.setAttemptCount(rs.getLong("attempt_count")); request.setRegisteredNodeId(rs.getString("registered_node_id")); request.setCreateTime(rs.getDateTime("create_time")); request.setLastUpdateBy(rs.getString("last_update_by")); request.setLastUpdateTime(rs.getDateTime("last_update_time")); request.setErrorMessage(rs.getString("error_message")); return request; } }
public Channel mapRow(Row row) { Channel channel = new Channel(); channel.setChannelId(row.getString("channel_id")); channel.setProcessingOrder(row.getInt("processing_order")); channel.setMaxBatchSize(row.getInt("max_batch_size")); channel.setEnabled(row.getBoolean("enabled")); channel.setMaxBatchToSend(row.getInt("max_batch_to_send")); channel.setMaxDataToRoute(row.getInt("max_data_to_route")); channel.setUseOldDataToRoute(row .getBoolean("use_old_data_to_route")); channel.setUseRowDataToRoute(row .getBoolean("use_row_data_to_route")); channel.setUsePkDataToRoute(row .getBoolean("use_pk_data_to_route")); channel.setContainsBigLob(row.getBoolean("contains_big_lob")); channel.setBatchAlgorithm(row.getString("batch_algorithm")); channel.setExtractPeriodMillis(row .getLong("extract_period_millis")); channel.setDataLoaderType(row.getString("data_loader_type")); channel.setCreateTime(row.getDateTime("create_time")); channel.setLastUpdateBy(row.getString("last_update_by")); channel.setLastUpdateTime(row.getDateTime("last_update_time")); return channel; } });
.getDateTime("last_extract_time")); nodeChannel.setExtractPeriodMillis(row .getLong("extract_period_millis")); nodeChannel.setDataLoaderType(row .getString("data_loader_type"));