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