/* 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;
}

}