如何在Doctrine_Record实例上缓存聚合列值？
|
可以说我有一个记录类，该类经常被MySQL聚合值的动态列查询：
$results = Doctrine_Core::getTable(\'MyRecord\')->creatQuery(\'m\')
->select(\'m.*, AVG(m.rating) as avg_rating, SUM(m.id) as nb_related\')
->innerJoin(\'m.AnotherRecords a\')
->where(\'m.id = ?\')
->fetchOne();
// this doesnt actually work because of filterSet and filterGet
// but its general idea
public function getAverageRating($wtihNbRelated = false)
{
if(!isset($this->avg_rating) || ($withNbRelated && !isset($this->nb_related))
{
$rating = $this->getTable()->getAverageRating($this, $withNbRelated);
$this->avg_rating = $rating[\'avg_rating\'];
if($withNbRealted)
{
$this->nb_related = $rating[\'nb_related\'];
}
}
return $withNbRelated
? array(\'avg_rating\' => $this->avg_rating, \'nb_related\' => $this->nb_related)
: array(\'avg_rating\' => $this->avg_rating);
}
没有找到相关结果
已邀请:
1 个回复
粱委教
成员，但我还是忘记了前缀，这给了我与尝试tried4ѭ或其访问方法相同的结果。解决方案是：public function getAverageRating($wtihNbRelated = false) { if(!isset($this->_data[\'avg_rating\']) || ($withNbRelated && !isset($this->_data[\'nb_related\'])) { $rating = $this->getTable()->getAverageRating($this, $withNbRelated); $this->_data[\'avg_rating\'] = $rating[\'avg_rating\']; if($withNbRealted) { $this->_data[\'nb_related\'] = $rating[\'nb_related\']; } } return $withNbRelated ? array(\'avg_rating\' => $this->_data[\'avg_rating\'], \'nb_related\' => $this->_data[\'nb_related\']) : array(\'avg_rating\' => $this->_data[\'avg_rating\']); }