public DataLoadStatus mapRow(Row rs) { DataLoadStatus status = new DataLoadStatus(); status.initialLoadEnabled = rs.getInt("initial_load_enabled"); status.initialLoadTime = rs.getDateTime("initial_load_time"); return status; } });
public OutgoingBatchSummary mapRow(Row rs) { OutgoingBatchSummary summary = new OutgoingBatchSummary(); summary.setBatchCount(rs.getInt("batches")); summary.setDataCount(rs.getInt("data")); summary.setStatus(Status.valueOf(rs.getString("status"))); summary.setNodeId(rs.getString("node_id")); summary.setOldestBatchCreateTime(rs.getDateTime("oldest_batch_time")); return summary; } }
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; } });
public TriggerRouter mapRow(Row rs) { TriggerRouter triggerRouter = new TriggerRouter(); triggerRouter.setTrigger(triggerMapper.mapRow(rs)); triggerRouter.setRouter(routerMapper.mapRow(rs)); triggerRouter.setCreateTime(rs.getDateTime("create_time")); triggerRouter.setLastUpdateTime(rs.getDateTime("last_update_time")); triggerRouter.setLastUpdateBy(rs.getString("last_update_by")); triggerRouter.setInitialLoadOrder(rs.getInt("initial_load_order")); triggerRouter.setInitialLoadSelect(rs.getString("initial_load_select")); triggerRouter.setInitialLoadBatchCount(rs.getInt("initial_load_batch_count")); triggerRouter.setEnabled(rs.getBoolean("enabled")); triggerRouter.setInitialLoadDeleteStmt(rs.getString("initial_load_delete_stmt")); triggerRouter.setPingBackEnabled(rs.getBoolean("ping_back_enabled")); return triggerRouter; } }
public Node mapRow(Row rs) { Node node = new Node(); node.setNodeId(rs.getString("node_id")); node.setNodeGroupId(rs.getString("node_group_id")); node.setExternalId(rs.getString("external_id")); node.setSyncEnabled(rs.getBoolean("sync_enabled")); node.setSyncUrl(rs.getString("sync_url")); node.setSchemaVersion(rs.getString("schema_version")); node.setDatabaseType(rs.getString("database_type")); node.setDatabaseVersion(rs.getString("database_version")); node.setSymmetricVersion(rs.getString("symmetric_version")); node.setCreatedAtNodeId(rs.getString("created_at_node_id")); node.setBatchToSendCount(rs.getInt("batch_to_send_count")); node.setBatchInErrorCount(rs.getInt("batch_in_error_count")); node.setDeploymentType(rs.getString("deployment_type")); return node; } }
.getBoolean("suspend_enabled")); nodeChannel.setProcessingOrder(row .getInt("processing_order")); nodeChannel.setMaxBatchSize(row.getInt("max_batch_size")); nodeChannel.setEnabled(row.getBoolean("enabled")); nodeChannel.setMaxBatchToSend(row .getInt("max_batch_to_send")); nodeChannel.setMaxDataToRoute(row .getInt("max_data_to_route")); nodeChannel.setUseOldDataToRoute(row .getBoolean("use_old_data_to_route"));
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; } }
int count = rs.getInt("cnt");
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; } }
data.putAttribute(CsvData.ATTRIBUTE_CREATE_TIME, row.getDateTime("CREATE_TIME")); data.putAttribute(CsvData.ATTRIBUTE_ROUTER_ID, row.getString("ROUTER_ID", false)); int triggerHistId = row.getInt("TRIGGER_HIST_ID"); data.putAttribute(CsvData.ATTRIBUTE_TABLE_ID, triggerHistId); TriggerHistory triggerHistory = engine.getTriggerRouterService().getTriggerHistory(triggerHistId);
public TransformTableNodeGroupLink mapRow(Row rs) { TransformTableNodeGroupLink table = new TransformTableNodeGroupLink(); table.setTransformId(rs.getString("transform_id")); table.setNodeGroupLink(configurationService.getNodeGroupLinkFor( rs.getString("source_node_group_id"), rs.getString("target_node_group_id"))); table.setSourceCatalogName(rs.getString("source_catalog_name")); table.setSourceSchemaName(rs.getString("source_schema_name")); table.setSourceTableName(rs.getString("source_table_name")); table.setTargetCatalogName(rs.getString("target_catalog_name")); table.setTargetSchemaName(rs.getString("target_schema_name")); table.setTargetTableName(rs.getString("target_table_name")); try { table.setTransformPoint(TransformPoint.valueOf(rs.getString("transform_point") .toUpperCase())); } catch (RuntimeException ex) { log.warn( "Invalid value provided for transform_point of '{}.' Valid values are: {}", rs.getString("transform_point"), Arrays.toString(TransformPoint.values())); throw ex; } table.setTransformOrder(rs.getInt("transform_order")); table.setUpdateFirst(rs.getBoolean("update_first")); table.setColumnPolicy(ColumnPolicy.valueOf(rs.getString("column_policy"))); table.setDeleteAction(DeleteAction.valueOf(rs.getString("delete_action"))); table.setCreateTime(rs.getDateTime("create_time")); table.setLastUpdateBy(rs.getString("last_update_by")); table.setLastUpdateTime(rs.getDateTime("last_update_time")); return table; } }
public TransformColumn mapRow(Row rs) { TransformColumn col = new TransformColumn(); col.setTransformId(rs.getString("transform_id")); col.setIncludeOn(IncludeOnType.decode(rs.getString("include_on"))); col.setTargetColumnName(rs.getString("target_column_name")); col.setSourceColumnName(rs.getString("source_column_name")); col.setPk(rs.getBoolean("pk")); col.setTransformType(rs.getString("transform_type")); col.setTransformExpression(rs.getString("transform_expression")); col.setTransformOrder(rs.getInt("transform_order")); col.setCreateTime(rs.getDateTime("create_time")); col.setLastUpdateBy(rs.getString("last_update_by")); col.setLastUpdateTime(rs.getDateTime("last_update_time")); return col; } }
loadFilter.setLastUpdateBy(rs.getString("last_update_by")); loadFilter.setLastUpdateTime(rs.getDateTime("last_update_time")); loadFilter.setLoadFilterOrder(rs.getInt("load_filter_order")); loadFilter.setFailOnError(rs.getBoolean("fail_on_error"));
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 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.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"));