Stefan Riedels Blog

class My_Doctrine_Table extends Doctrine_Table {
 
	/**
	 * @var Zend_Cache_Core
	 */
	protected $_cache_result = null;
 
	/**
	 * My_Doctrine_Table::__construct()
	 *
	 * @param string $name                      the name of the component
     * @param Doctrine_Connection $conn         the connection associated with this table
	 * @return void
	 */
	public function __construct($name, Doctrine_Connection $conn, $initDefinition = false) {
		parent::__construct ( $name, $conn, $initDefinition );
		$frontend = 'Core';
		$backend = 'File';
		$frontendOptions = array ('automatic_cleaning_factor' => 1, 'lifetime' => 1800, 'automatic_serialization' => true );
		$backendOptions = array ('cache_dir' => Zend_Registry::get ( 'config' )->framework->cache_dir );
		$this->_cache_result = Zend_Cache::factory ( $frontend, $backend, $frontendOptions, $backendOptions );
	}
 
	/**
	 * My_Doctrine_Table::findAll()
	 *
	 * @param int $hydrationMode
	 * @return mixed
	 */
	public function findAll($hydrationMode = null) {
		$cache_id = "findAllResult_{$this->getTableName()}_{$hydrationMode}";
		if (! ($result = $this->_cache_result->load ( $cache_id, true ))) {
			$result = parent::findAll ( $hydrationMode );
			$this->_cache_result->save ( $result, $cache_id, array ($this->getTableName () ) );
		}
		return $result;
	}
 
	/**
	 * My_Doctrine_Table::find()
	 *
	 * wir überschreiben, die find Methode
	 * um den eigenen Cache Mechanismus zu nutzen
	 *
	 * @param mixed $id
	 * @param int $hydrationMode
	 * @return mixed
	 */
	public function find($id, $hydrationMode = null) {
		$cache_id = "findResult_{$this->getTableName()}_{$id}_{$hydrationMode}";
		if (! ($result = $this->_cache_result->load ( $cache_id, true ))) {
			$result = parent::find ( $id, $hydrationMode );
			$this->_cache_result->save ( $result, $cache_id, array ($this->getTableName () ) );
		}
		return $result;
	}
 
	/**
	 * My_Doctrine_Table::cleanCaches()
	 *
	 * löscht die caches zur aktuellen Tabelle
	 *
	 * @return void
	 */
	public function cleanCaches() {
		if ($this->_cache_pager instanceof Zend_Cache_Core) {
			$this->_cache_pager->clean ( Zend_Cache::CLEANING_MODE_MATCHING_TAG, array ($this->getTableName () ) );
		}
		if ($this->_cache_result instanceof Zend_Cache_Core) {
			$this->_cache_result->clean ( Zend_Cache::CLEANING_MODE_MATCHING_TAG, array ($this->getTableName () ) );
		}
	}
 
	/**
	 * My_Doctrine_Table::findBy()
	 *
	 * wir überschreiben, die findBy Methode
	 * um den eigenen Cache Mechanismus zu nutzen
	 *
	 * @param string $fieldName
	 * @param mixed $value
	 * @param int $hydrationMode
	 * @return mixed
	 */
	protected function findBy($fieldName, $value, $hydrationMode = null) {
		$cache_id = "findBy{$fieldName}Result_{$this->getTableName()}_{$value}_{$hydrationMode}";
		if (! ($result = $this->_cache_result->load ( $cache_id, true ))) {
			$result = parent::findBy ( $fieldName, $value, $hydrationMode );
			$this->_cache_result->save ( $result, $cache_id, array ($this->getTableName () ) );
		}
		return $result;
	}
 
	/**
	 * My_Doctrine_Table::findOneBy()
	 *
	 * wir überschreiben, die findOneBy Methode
	 * um den eigenen Cache Mechanismus zu nutzen
	 *
	 * @param mixed $fieldName
	 * @param mixed $value
	 * @param int $hydrationMode
	 * @return mixed
	 */
	protected function findOneBy($fieldName, $value, $hydrationMode = null) {
		$cache_id = "findOneBy{$fieldName}Result_{$this->getTableName()}_{$value}_{$hydrationMode}";
		if (! ($result = $this->_cache_result->load ( $cache_id, true ))) {
			$result = parent::findOneBy ( $fieldName, $value, $hydrationMode );
			$this->_cache_result->save ( $result, $cache_id, array ($this->getTableName () ) );
		}
		return $result;
	}
 
}

	/**
	 * wird beim einfügen eines datensatzes ausgeführt
	 * @see My_Doctrine_Table::cleanCaches()
	 * @param Doctrine_Event $event
	 */
	public function postInsert(Doctrine_Event $event) {
		$table = $this->getTable ();
		$table->cleanCaches ();
		parent::postInsert ( $event );
	}