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; } }
protected static Row getMapForRow(ResultSet rs, boolean readStringsAsBytes) throws SQLException { ResultSetMetaData rsmd = rs.getMetaData(); int columnCount = rsmd.getColumnCount(); Row mapOfColValues = new Row(columnCount); for (int i = 1; i <= columnCount; i++) { String key = JdbcSqlTemplate.lookupColumnName(rsmd, i); Object obj = JdbcSqlTemplate.getResultSetValue(rs, i, readStringsAsBytes); mapOfColValues.put(key, obj); } return mapOfColValues; }
protected String[] toStringData(Row row, Column[] columns) { String[] stringValues = new String[columns.length]; for (int i = 0; i < columns.length; i++) { Object value = row.get(columns[i].getName()); if (value instanceof byte[]) { stringValues[i] = new String(Base64.encodeBase64((byte[])value)); } else if (value != null) { stringValues[i] = value.toString(); } } return stringValues; }
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 DataGap mapRow(Row rs) { return new DataGap(rs.getLong("start_id"), rs.getLong("end_id"), rs .getDateTime("create_time")); } }, status.name());
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 Object mapRow(Row row) { String channelId = row.getString("channel_id"); Date extractTime = row.getDateTime("last_extract_time"); NodeChannel nodeChannel = nodeChannelsMap.get(channelId); if (nodeChannel != null) { nodeChannel.setLastExtractTime(extractTime); } return nodeChannelsMap; }; }, nodeId);
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());
@Override protected String getDateTimeStringValue(String name, int type, Row row, boolean useVariableDates) { return row.getString(name); }
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 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 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 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 NodeGroup mapRow(Row row) { NodeGroup group = new NodeGroup(); group.setNodeGroupId(row.getString("node_group_id")); group.setDescription(row.getString("description")); group.setCreateTime(row.getDateTime("create_time")); group.setLastUpdateBy(row.getString("last_update_by")); group.setLastUpdateTime(row.getDateTime("last_update_time")); return group; } }
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 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; } }