/**
* Method deletes old row in the mview table and insert new one from view.
*
* @return Enterprise_Mview_Model_Action_Mview_Create
* @throws Enterprise_Mview_Exception
*/
public function execute()
{
$this->_validate();
$this->_connection->beginTransaction();
try {
$this->_connection->delete($this->_metadata->getTableName(), array($this->_metadata->getKeyColumn() . '=?' => $this->_keyColumnIdValue));
$this->_connection->query($this->_getInsertSql());
$this->_connection->commit();
} catch (Exception $e) {
$this->_connection->rollBack();
throw new Enterprise_Mview_Exception($e->getMessage(), $e->getCode());
}
return $this;
}
/**
* Refresh rows by ids from changelog
*
* @return Enterprise_Mview_Model_Action_Mview_Refresh_Changelog
* @throws Enterprise_Mview_Exception
*/
public function execute()
{
$this->_validate();
$this->_connection->beginTransaction();
try {
$this->_connection->delete($this->_metadata->getTableName(), array($this->_metadata->getKeyColumn() . ' IN ( ' . $this->_selectChangedIds() . ' )'));
$this->_connection->query($this->_connection->insertFromSelect($this->_selectChangedRows(), $this->_metadata->getTableName()));
$this->_metadata->setVersionId($this->_selectLastVersionId());
$this->_metadata->save();
$this->_connection->commit();
} catch (Exception $e) {
$this->_connection->rollBack();
$this->_metadata->setOutOfDateStatus()->save();
throw new Enterprise_Mview_Exception($e->getMessage(), $e->getCode());
}
return $this;
}
