/** * Generate and return trigger body's row * * @param string $event * @param Varien_Object $subscriber * @return string */ protected function _getInsertRow($event, Varien_Object $subscriber) { switch ($event) { case Magento_Db_Sql_Trigger::SQL_EVENT_INSERT: case Magento_Db_Sql_Trigger::SQL_EVENT_UPDATE: return sprintf("INSERT IGNORE INTO %s (%s) VALUES (NEW.%s);\n", $this->_connection->quoteIdentifier($subscriber->getChangelogName()), $this->_connection->quoteIdentifier($subscriber->getKeyColumn()), $this->_connection->quoteIdentifier($subscriber->getTargetColumn())); case Magento_Db_Sql_Trigger::SQL_EVENT_DELETE: return sprintf("INSERT IGNORE INTO %s (%s) VALUES (OLD.%s);\n", $this->_connection->quoteIdentifier($subscriber->getChangelogName()), $this->_connection->quoteIdentifier($subscriber->getKeyColumn()), $this->_connection->quoteIdentifier($subscriber->getTargetColumn())); default: return ''; } }