/**
* Removes redirect rows which have no corresponding records in redirect table from index.
*
* @return Enterprise_UrlRewrite_Model_Index_Action_Url_Rewrite_Redirect_Refresh_Orphan
* @throws Enterprise_Index_Model_Action_Exception
*/
public function execute()
{
try {
$select = $this->_connection->select()->from(array('ur' => $this->_getTable('enterprise_urlrewrite/url_rewrite')), '*')->joinInner(array('rr' => $this->_getTable('enterprise_urlrewrite/redirect_rewrite')), 'ur.url_rewrite_id = rr.url_rewrite_id')->joinLeft(array('redirect' => $this->_getTable('enterprise_urlrewrite/redirect')), 'redirect.redirect_id = rr.redirect_id')->where('ur.entity_type = ?', Enterprise_UrlRewrite_Model_Redirect::URL_REWRITE_ENTITY_TYPE)->where('redirect.redirect_id IS NULL');
$this->_connection->query($this->_connection->deleteFromSelect($select, 'ur'));
} catch (Exception $e) {
$this->_metadata->setInvalidStatus()->save();
throw new Enterprise_Index_Model_Action_Exception($e->getMessage(), $e->getCode(), $e);
}
return $this;
}
/**
* Remove unnecessary data
*
* @param array $rootCatIds
*/
protected function _removeUnnecessaryData($rootCatIds)
{
$this->_connection->query($this->_connection->deleteFromSelect($this->_getSelectUnnecessaryData($rootCatIds), $this->_getMainTable()));
}
