Db.php 3.5 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139
  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. * @param array|Zend_Config $config
  67. * @return Zend_Log_Writer_Db
  68. * @throws Zend_Log_Exception
  69. */
  70. static public function factory($config)
  71. {
  72. $config = self::_parseConfig($config);
  73. $config = array_merge(array(
  74. 'db' => null,
  75. 'table' => null,
  76. 'columnMap' => null,
  77. ), $config);
  78. if (isset($config['columnmap'])) {
  79. $config['columnMap'] = $config['columnmap'];
  80. }
  81. return new self(
  82. $config['db'],
  83. $config['table'],
  84. $config['columnMap']
  85. );
  86. }
  87. /**
  88. * Formatting is not possible on this writer
  89. */
  90. public function setFormatter($formatter)
  91. {
  92. require_once 'Zend/Log/Exception.php';
  93. throw new Zend_Log_Exception(get_class() . ' does not support formatting');
  94. }
  95. /**
  96. * Remove reference to database adapter
  97. *
  98. * @return void
  99. */
  100. public function shutdown()
  101. {
  102. $this->_db = null;
  103. }
  104. /**
  105. * Write a message to the log.
  106. *
  107. * @param array $event event data
  108. * @return void
  109. */
  110. protected function _write($event)
  111. {
  112. if ($this->_db === null) {
  113. require_once 'Zend/Log/Exception.php';
  114. throw new Zend_Log_Exception('Database adapter is null');
  115. }
  116. if ($this->_columnMap === null) {
  117. $dataToInsert = $event;
  118. } else {
  119. $dataToInsert = array();
  120. foreach ($this->_columnMap as $columnName => $fieldKey) {
  121. $dataToInsert[$columnName] = $event[$fieldKey];
  122. }
  123. }
  124. $this->_db->insert($this->_table, $dataToInsert);
  125. }
  126. }