<?php

/**

 * Zend Framework

 *

 * LICENSE

 *

 * This source file is subject to the new BSD license that is bundled

 * with this package in the file LICENSE.txt.

 * It is also available through the world-wide-web at this URL:

 * http://framework.zend.com/license/new-bsd

 * If you did not receive a copy of the license and are unable to

 * obtain it through the world-wide-web, please send an email

 * to license@zend.com so we can send you a copy immediately.

 *

 * @category   Zend

 * @package    Zend_Log

 * @subpackage Writer

 * @copyright  Copyright (c) 2005-2010 Zend Technologies USA Inc. (http://www.zend.com)

 * @license    http://framework.zend.com/license/new-bsd     New BSD License

 * @version    $Id: Db.php 22513 2010-07-01 13:48:39Z ramon $

 */

/** Zend_Log_Writer_Abstract */

require_once 'Zend/Log/Writer/Abstract.php';

/**

 * @category   Zend

 * @package    Zend_Log

 * @subpackage Writer

 * @copyright  Copyright (c) 2005-2010 Zend Technologies USA Inc. (http://www.zend.com)

 * @license    http://framework.zend.com/license/new-bsd     New BSD License

 * @version    $Id: Db.php 22513 2010-07-01 13:48:39Z ramon $

 */

class Zend_Log_Writer_Db extends Zend_Log_Writer_Abstract

{

    /**

     * Database adapter instance

     * @var Zend_Db_Adapter

     */

    private $_db;

    /**

     * Name of the log table in the database

     * @var string

     */

    private $_table;

    /**

     * Relates database columns names to log data field keys.

     *

     * @var null|array

     */

    private $_columnMap;

    /**

     * Class constructor

     *

     * @param Zend_Db_Adapter $db   Database adapter instance

     * @param string $table         Log table in database

     * @param array $columnMap

     */

    public function __construct($db, $table, $columnMap = null)

    {

        $this->_db    = $db;

        $this->_table = $table;

        $this->_columnMap = $columnMap;

    }

    /**

     * Create a new instance of Zend_Log_Writer_Db

     *

     * @param  array|Zend_Config $config

     * @return Zend_Log_Writer_Db

     * @throws Zend_Log_Exception

     */

    static public function factory($config)

    {

        $config = self::_parseConfig($config);

        $config = array_merge(array(

            'db'        => null,

            'table'     => null,

            'columnMap' => null,

        ), $config);

        if (isset($config['columnmap'])) {

            $config['columnMap'] = $config['columnmap'];

        }

        return new self(

            $config['db'],

            $config['table'],

            $config['columnMap']

        );

    }

    /**

     * Formatting is not possible on this writer

     */

    public function setFormatter(Zend_Log_Formatter_Interface $formatter)

    {

        require_once 'Zend/Log/Exception.php';

        throw new Zend_Log_Exception(get_class($this) . ' does not support formatting');

    }

    /**

     * Remove reference to database adapter

     *

     * @return void

     */

    public function shutdown()

    {

        $this->_db = null;

    }

    /**

     * Write a message to the log.

     *

     * @param  array  $event  event data

     * @return void

     */

    protected function _write($event)

    {

        if ($this->_db === null) {

            require_once 'Zend/Log/Exception.php';

            throw new Zend_Log_Exception('Database adapter is null');

        }

        if ($this->_columnMap === null) {

            $dataToInsert = $event;

        } else {

            $dataToInsert = array();

            foreach ($this->_columnMap as $columnName => $fieldKey) {

                $dataToInsert[$columnName] = $event[$fieldKey];

            }

        }

        $this->_db->insert($this->_table, $dataToInsert);

    }

}