Db.php 3.5 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136
  1. <?php
  2. /**
  3. * Zend Framework
  4. *
  5. * LICENSE
  6. *
  7. * This source file is subject to the new BSD license that is bundled
  8. * with this package in the file LICENSE.txt.
  9. * It is also available through the world-wide-web at this URL:
  10. * http://framework.zend.com/license/new-bsd
  11. * If you did not receive a copy of the license and are unable to
  12. * obtain it through the world-wide-web, please send an email
  13. * to license@zend.com so we can send you a copy immediately.
  14. *
  15. * @category Zend
  16. * @package Zend_Log
  17. * @subpackage Writer
  18. * @copyright Copyright (c) 2005-2009 Zend Technologies USA Inc. (http://www.zend.com)
  19. * @license http://framework.zend.com/license/new-bsd New BSD License
  20. * @version $Id$
  21. */
  22. /** Zend_Log_Writer_Abstract */
  23. require_once 'Zend/Log/Writer/Abstract.php';
  24. /**
  25. * @category Zend
  26. * @package Zend_Log
  27. * @subpackage Writer
  28. * @copyright Copyright (c) 2005-2009 Zend Technologies USA Inc. (http://www.zend.com)
  29. * @license http://framework.zend.com/license/new-bsd New BSD License
  30. * @version $Id$
  31. */
  32. class Zend_Log_Writer_Db extends Zend_Log_Writer_Abstract
  33. {
  34. /**
  35. * Database adapter instance
  36. * @var Zend_Db_Adapter
  37. */
  38. private $_db;
  39. /**
  40. * Name of the log table in the database
  41. * @var string
  42. */
  43. private $_table;
  44. /**
  45. * Relates database columns names to log data field keys.
  46. *
  47. * @var null|array
  48. */
  49. private $_columnMap;
  50. /**
  51. * Class constructor
  52. *
  53. * @param Zend_Db_Adapter $db Database adapter instance
  54. * @param string $table Log table in database
  55. * @param array $columnMap
  56. */
  57. public function __construct($db, $table, $columnMap = null)
  58. {
  59. $this->_db = $db;
  60. $this->_table = $table;
  61. $this->_columnMap = $columnMap;
  62. }
  63. /**
  64. * Create a new instance of Zend_Log_Writer_Db
  65. *
  66. * @exception Zend_Log_Exception
  67. * @param mixed $config
  68. * @return Zend_Log_Writer_Db
  69. */
  70. static public function factory($config)
  71. {
  72. $config = self::_parseConfig($config);
  73. $config = $config + array('db'=>NULL, 'table'=>NULL, 'columnMap'=>NULL);
  74. if (isset($config['columnmap'])) {
  75. $config['columnMap'] = $config['columnmap'];
  76. }
  77. return new self(
  78. $config['db'],
  79. $config['table'],
  80. $config['columnMap']
  81. );
  82. }
  83. /**
  84. * Formatting is not possible on this writer
  85. */
  86. public function setFormatter($formatter)
  87. {
  88. require_once 'Zend/Log/Exception.php';
  89. throw new Zend_Log_Exception(get_class() . ' does not support formatting');
  90. }
  91. /**
  92. * Remove reference to database adapter
  93. *
  94. * @return void
  95. */
  96. public function shutdown()
  97. {
  98. $this->_db = null;
  99. }
  100. /**
  101. * Write a message to the log.
  102. *
  103. * @param array $event event data
  104. * @return void
  105. */
  106. protected function _write($event)
  107. {
  108. if ($this->_db === null) {
  109. require_once 'Zend/Log/Exception.php';
  110. throw new Zend_Log_Exception('Database adapter is null');
  111. }
  112. if ($this->_columnMap === null) {
  113. $dataToInsert = $event;
  114. } else {
  115. $dataToInsert = array();
  116. foreach ($this->_columnMap as $columnName => $fieldKey) {
  117. $dataToInsert[$columnName] = $event[$fieldKey];
  118. }
  119. }
  120. $this->_db->insert($this->_table, $dataToInsert);
  121. }
  122. }