/* 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.jobs;
import com.esri.gpt.framework.context.RequestContext;
import com.esri.gpt.framework.sql.ManagedConnection;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.SQLException;
/**
* Withdraw a single resource.
*/
public class HjWithdrawRequest extends HjRequest {
/**
* Creates instance of the request.
* @param requestContext request context
* @param resourceUuids resource UUIDs
*/
public HjWithdrawRequest(RequestContext requestContext, String [] resourceUuids) {
super(requestContext, new HjCriteria(), new HjResult());
this.getActionCriteria().setResourceUuids(resourceUuids);
}
/**
* Executes request.
* @return <code>true</code> if records has been found and deleted
* @throws SQLException if deleting jobs fails
*/
public boolean execute() throws SQLException {
if (this.getActionCriteria().getResourceUuidsForSql().length()==0) return false;
// intitalize
PreparedStatement st = null;
// establish the connection
ManagedConnection mc = returnConnection();
Connection con = mc.getJdbcConnection();
// prepare statement
st = con.prepareStatement(
"DELETE FROM " + getHarvestingJobsPendingTableName()+ " " +
"WHERE HARVEST_ID IN ("+this.getActionCriteria().getResourceUuidsForSql()+")");
// execute
return st.executeUpdate()>0;
}
}