/* See the NOTICE file distributed with
* this work for additional information regarding copyright ownership.
* Esri Inc. licenses this file to You under the Apache License, Version 2.0
* (the "License"); you may not use this file except in compliance with
* the License. You may obtain a copy of the License at
*
* http://www.apache.org/licenses/LICENSE-2.0
*
* Unless required by applicable law or agreed to in writing, software
* distributed under the License is distributed on an "AS IS" BASIS,
* WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
* See the License for the specific language governing permissions and
* limitations under the License.
*/
package com.esri.gpt.catalog.harvest.history;
import com.esri.gpt.catalog.harvest.repository.HrRecords;
import com.esri.gpt.catalog.harvest.repository.HrSelectRequest;
import com.esri.gpt.framework.context.RequestContext;
import com.esri.gpt.framework.sql.ManagedConnection;
import com.esri.gpt.framework.util.UuidUtil;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
/**
* Selects a single event.
*/
public class HeSelectOneRequest extends HeRequest {
/**
* Create instance of the request.
* @param requestContext request context
* @param eventUuid event uuid
*/
public HeSelectOneRequest(RequestContext requestContext, String eventUuid) {
super(requestContext, new HeCriteria(), new HeResult());
getQueryCriteria().setEventUuid(eventUuid);
}
/**
* Executes request.
* @throws java.sql.SQLException if accessing database fails
*/
public void execute() throws SQLException {
PreparedStatement st = null;
HeQueryCriteria criteria = getQueryCriteria();
HeRecords records = getQueryResult().getRecords();
ResultSet rs = null;
try {
StringBuffer sbSql = new StringBuffer();
StringBuffer sbWhere = new StringBuffer();
sbSql.append("SELECT A.HARVEST_ID,A.HARVEST_DATE,");
sbSql.append("A.HARVESTED_COUNT,A.VALIDATED_COUNT,A.PUBLISHED_COUNT");
sbSql.append(" FROM ");
sbSql.append(getHarvestingHistoryTableName());
sbSql.append(" A");
// harvest event UUID
String sEventUuid =
UuidUtil.addCurlies(
UuidUtil.removeCurlies(criteria.getEventUuid().toUpperCase()));
if (sEventUuid.length() > 0) {
sEventUuid = appendValueFilter(sbWhere,"UPPER(A.UUID)",sEventUuid,false);
}
// append the where clause expressions
if (sbWhere.length() > 0) {
sbSql.append(" WHERE ").append(sbWhere.toString());
}
// establish the connection
ManagedConnection mc = returnConnection();
Connection con = mc.getJdbcConnection();
// prepare the statements
int n = 0;
st = con.prepareStatement(sbSql.toString());
// harvest UUID
if (sEventUuid.length() > 0) {
n++;
st.setString(n,sEventUuid);
}
// execute the query
logExpression(sbSql.toString());
rs = st.executeQuery();
while (rs.next()) {
n = 1;
String ownerUuid = rs.getString(n++);
HrSelectRequest hrSelect = new HrSelectRequest(getRequestContext(),ownerUuid);
hrSelect.execute();
HrRecords hrRecords = hrSelect.getQueryResult().getRecords();
if (!hrRecords.isEmpty()) {
HeRecord record = new HeRecord(hrRecords.get(0));
records.add(record);
record.setUuid(sEventUuid);
record.setHarvestDate(rs.getTimestamp(n++));
record.setHarvestedCount(rs.getInt(n++));
record.setValidatedCount(rs.getInt(n++));
record.setPublishedCount(rs.getInt(n++));
}
}
} finally {
closeResultSet(rs);
closeStatement(st);
}
}
}