/**
* Update stats table from select
*
* @param Zend_Db_Select $select
* @param array $fields
* @return Zend_Db_Statement_Interface
*/
protected function insertSelect(Mzax_Emarketing_Db_Select $select, $table = null)
{
$sql = $select->insertFromSelect($this->_getTable($table ? $table : $this->_reportTable));
$startTime = microtime(true);
try {
$this->log("\n\n\n\n{$sql}\n");
$this->_getWriteAdapter()->query($sql);
$duration = microtime(true) - $startTime;
$this->log("QueryTime [%s]: %01.4fsec\n\n", get_class($this), microtime(true) - $startTime);
return $duration;
} catch (Exception $e) {
$this->log($e->getMessage());
$this->log($e->getTraceAsString());
$this->log($sql);
throw $e;
}
}
