Zendcasts Forum

<?php

/**
 * A log writer for Doctrine
 *
 * @author ivotrompert
 */
class Ivo_Log_Writer_Doctrine extends Zend_Log_Writer_Abstract {

    /**
     * The Doctrine class name for the tabel
     * 
     * @var String
     */
    private $_model;

    /**
     * Relates database columns names to log data field keys.
     *
     * @var null|array
     */
    private $_columnMap;

    /**
     * @param string $model
     * @param array $columnMap
     */

    public function  __construct($model,$columnMap) {

        $this->_model = $model;
        $this->_columnMap = $columnMap;
    }

    static public function  factory($config) {
        $config = self::_parseConfig($config);
        $config = array_merge(array(
            'model'     => null,
            'columnMap' => null,
        ), $config);

        if (isset($config['columnmap'])) {
            $config['columnMap'] = $config['columnmap'];
        }

        return new self(
            $config['model'],
            $config['columnMap']
        );
    }

    /**
     * Formatting is not possible on this writer
     */
    public function setFormatter($formatter)
    {
        require_once 'Zend/Log/Exception.php';
        throw new Zend_Log_Exception(get_class() . ' does not support formatting');
    }

    /**
     * Write a message to the log.
     *
     * @param  array  $event  event data
     * @return void
     */
    protected function _write($event)
    {
        if ($this->_model === null) {
            require_once 'Zend/Log/Exception.php';
            throw new Zend_Log_Exception('Doctrine modelname is null');
        }

        if ($this->_columnMap === null) {
            require_once 'Zend/Log/Exception.php';
            throw new Zend_Log_Exception('Colum mapping is null');
        } else {
            $dataToInsert = array();
            foreach ($this->_columnMap as $columnName => $fieldKey) {
                $dataToInsert[$columnName] = $event[$fieldKey];
            }
        }

        $model = new $this->_model;
        
        $model->fromArray($dataToInsert);
        $model->save();
    }
    
}
?>

resources.log.database.writerNamespace = "Ivo_Log_Writer"
resources.log.database.writerName = "Doctrine"
resources.log.database.writerParams.model = "Model_Log"
resources.log.database.writerParams.columnMap.title = "message"
resources.log.database.writerParams.columnMap.priority ="priority"
resources.log.database.writerParams.columnMap.priorityName = "priorityName"
resources.log.database.writerParams.columnMap.message = "info"

options:
  type: INNODB
  collate: utf8_general_ci
  charset: utf8
  
Log:
  columns:
    id:
      type: integer
      primary: true
      autoincrement: true
    priority: tinyint
    priorityName: string(10)
    title: string(250)
    message: text