public FileTrigger mapRow(Row rs) { FileTrigger fileTrigger = new FileTrigger(); fileTrigger.setBaseDir(rs.getString("base_dir")==null?null:rs.getString("base_dir").replace('\\', '/')); fileTrigger.setCreateTime(rs.getDateTime("create_time")); fileTrigger.setExcludesFiles(rs.getString("excludes_files")); fileTrigger.setIncludesFiles(rs.getString("includes_files")); fileTrigger.setLastUpdateBy(rs.getString("last_update_by")); fileTrigger.setLastUpdateTime(rs.getDateTime("last_update_time")); fileTrigger.setRecurse(rs.getBoolean("recurse")); fileTrigger.setSyncOnCreate(rs.getBoolean("sync_on_create")); fileTrigger.setSyncOnDelete(rs.getBoolean("sync_on_delete")); fileTrigger.setAfterCopyScript(rs.getString("after_copy_script")); fileTrigger.setBeforeCopyScript(rs.getString("before_copy_script")); fileTrigger.setSyncOnModified(rs.getBoolean("sync_on_modified")); fileTrigger.setTriggerId(rs.getString("trigger_id")); return fileTrigger; } }
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; } });
nodeChannel.setNodeId(nodeId); nodeChannel.setIgnoreEnabled(row .getBoolean("ignore_enabled")); nodeChannel.setSuspendEnabled(row .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")); .getInt("max_data_to_route")); nodeChannel.setUseOldDataToRoute(row .getBoolean("use_old_data_to_route")); nodeChannel.setUseRowDataToRoute(row .getBoolean("use_row_data_to_route")); nodeChannel.setUsePkDataToRoute(row .getBoolean("use_pk_data_to_route")); nodeChannel.setContainsBigLob(row .getBoolean("contains_big_lob")); nodeChannel.setBatchAlgorithm(row .getString("batch_algorithm"));
trigger.setChannelId(rs.getString("channel_id")); trigger.setSourceTableName(rs.getString("source_table_name")); trigger.setSyncOnInsert(rs.getBoolean("sync_on_insert")); trigger.setSyncOnUpdate(rs.getBoolean("sync_on_update")); trigger.setSyncOnDelete(rs.getBoolean("sync_on_delete")); trigger.setSyncOnIncomingBatch(rs.getBoolean("sync_on_incoming_batch")); trigger.setUseStreamLobs(rs.getBoolean("use_stream_lobs")); trigger.setUseCaptureLobs(rs.getBoolean("use_capture_lobs")); trigger.setUseCaptureOldData(rs.getBoolean("use_capture_old_data")); trigger.setUseHandleKeyUpdates(rs.getBoolean("use_handle_key_updates")); trigger.setNameForDeleteTrigger(rs.getString("name_for_delete_trigger")); trigger.setNameForInsertTrigger(rs.getString("name_for_insert_trigger"));
public FileTriggerRouter mapRow(Row rs) { FileTriggerRouter fileTriggerRouter = new FileTriggerRouter(); String triggerId = rs.getString("trigger_id"); FileTrigger fileTrigger = getFileTrigger(triggerId); fileTriggerRouter.setFileTrigger(fileTrigger); fileTriggerRouter.setConflictStrategy(FileConflictStrategy.valueOf(rs.getString( "conflict_strategy").toUpperCase())); fileTriggerRouter.setCreateTime(rs.getDateTime("create_time")); fileTriggerRouter.setLastUpdateBy(rs.getString("last_update_by")); fileTriggerRouter.setLastUpdateTime(rs.getDateTime("last_update_time")); fileTriggerRouter.setEnabled(rs.getBoolean("enabled")); fileTriggerRouter.setInitialLoadEnabled(rs.getBoolean("initial_load_enabled")); fileTriggerRouter.setTargetBaseDir((rs.getString("target_base_dir")==null)?null:rs.getString("target_base_dir").replace('\\', '/')); fileTriggerRouter.setRouter(engine.getTriggerRouterService().getRouterById( rs.getString("router_id"))); return fileTriggerRouter; } }
public NodeGroupChannelWindow mapRow(Row row) { NodeGroupChannelWindow window = new NodeGroupChannelWindow(); window.setNodeGroupId(row.getString("node_group_id")); window.setChannelId(row.getString("channel_id")); window.setStartTime(row.getTime("start_time")); window.setEndTime(row.getTime("end_time")); window.setEnabled(row.getBoolean("enabled")); return window; } }
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 Router mapRow(Row rs) { Router router = new Router(); router.setSyncOnInsert(rs.getBoolean("r_sync_on_insert")); router.setSyncOnUpdate(rs.getBoolean("r_sync_on_update")); router.setSyncOnDelete(rs.getBoolean("r_sync_on_delete")); router.setTargetCatalogName(rs.getString("target_catalog_name")); router.setNodeGroupLink(configurationService.getNodeGroupLinkFor( rs.getString("source_node_group_id"), rs.getString("target_node_group_id"))); router.setTargetSchemaName(rs.getString("target_schema_name")); router.setTargetTableName(rs.getString("target_table_name")); String condition = rs.getString("router_expression"); if (!StringUtils.isBlank(condition)) { router.setRouterExpression(condition); } router.setRouterType(rs.getString("router_type")); router.setRouterId(rs.getString("router_id")); router.setCreateTime(rs.getDateTime("r_create_time")); router.setLastUpdateTime(rs.getDateTime("r_last_update_time")); router.setLastUpdateBy(rs.getString("r_last_update_by")); return router; } }
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; } }
loadFilter.setTargetSchemaName(rs.getString("target_schema_name")); loadFilter.setTargetTableName(rs.getString("target_table_name")); loadFilter.setFilterOnInsert(rs.getBoolean("filter_on_insert")); loadFilter.setFilterOnUpdate(rs.getBoolean("filter_on_update")); loadFilter.setFilterOnDelete(rs.getBoolean("filter_on_delete")); loadFilter.setBeforeWriteScript(rs.getString("before_write_script")); loadFilter.setAfterWriteScript(rs.getString("after_write_script")); loadFilter.setLastUpdateTime(rs.getDateTime("last_update_time")); loadFilter.setLoadFilterOrder(rs.getInt("load_filter_order")); loadFilter.setFailOnError(rs.getBoolean("fail_on_error"));
public TableReloadRequest mapRow(Row rs) { TableReloadRequest request = new TableReloadRequest(key); request.setReloadSelect(rs.getString("reload_select")); request.setReloadEnabled(rs.getBoolean("reload_enabled")); request.setReloadTime(rs.getDateTime("reload_time")); request.setReloadDeleteStmt(rs.getString("reload_delete_stmt")); request.setCreateTime(rs.getDateTime("create_time")); request.setLastUpdateBy(rs.getString("last_update_by")); request.setLastUpdateTime(rs.getDateTime("last_update_time")); return request; } }, key.getSourceNodeId(), key.getTargetNodeId(), key.getTriggerId(), key.getRouterId());
public ConflictNodeGroupLink mapRow(Row rs) { ConflictNodeGroupLink setting = new ConflictNodeGroupLink(); setting.setNodeGroupLink(configurationService.getNodeGroupLinkFor( rs.getString("source_node_group_id"), rs.getString("target_node_group_id"))); setting.setTargetChannelId(rs.getString("target_channel_id")); setting.setTargetCatalogName(rs.getString("target_catalog_name")); setting.setTargetSchemaName(rs.getString("target_schema_name")); setting.setTargetTableName(rs.getString("target_table_name")); setting.setDetectType(DetectConflict.valueOf(rs.getString("detect_type").toUpperCase())); setting.setResolveType(ResolveConflict.valueOf(rs.getString("resolve_type") .toUpperCase())); setting.setPingBack(PingBack.valueOf(rs.getString("ping_back"))); setting.setResolveChangesOnly(rs.getBoolean("resolve_changes_only")); setting.setResolveRowOnly(rs.getBoolean("resolve_row_only")); setting.setDetectExpression(rs.getString("detect_expression")); setting.setLastUpdateBy(rs.getString("last_update_by")); setting.setConflictId(rs.getString("conflict_id")); setting.setCreateTime(rs.getDateTime("create_time")); setting.setLastUpdateTime(rs.getDateTime("last_update_time")); return setting; } }
summary.setPendingBatchCount(summary.getPendingBatchCount() + count); boolean inError = rs.getBoolean("error_flag"); summary.setInError(inError || summary.isInError());
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; } }
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")); batch.setExtractJobFlag(rs.getBoolean("extract_job_flag")); batch.setLoadId(rs.getLong("load_id")); batch.setCreateBy(rs.getString("create_by"));
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; } }
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; } }
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; } }
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; } }