PHP sfDoctrinePager::getResults方法代碼示例

 public function getResults($hydrationMode = Doctrine::HYDRATE_RECORD)
 {
     if (!$this->getQuery()->getConnection() instanceof Doctrine_Connection_Mysql) {
         return parent::getResults($hydrationMode);
     }
     return $this->results;
 }

 public function getResults()
 {
     if (is_null($this->results)) {
         $this->getQuery()->orderBy($this->sqlOrderColumn . ' ' . $this->sqlOrder);
         $this->results = parent::getResults();
         if ($this->sqlOrder !== $this->listOrder) {
             $obj = new Doctrine_Collection($this->results->getTable(), $this->results->getKeyColumn());
             $obj->fromArray(array_reverse($this->results->toArray(true)));
             $this->results = $obj;
         }
     }
     return $this->results;
 }

 public function executeIndex(sfWebRequest $request)
 {
     $this->buildParams();
     $pager = new sfDoctrinePager($this->modelClass, 10);
     $pager->setQuery($this->buildQuery($request));
     $pager->setPage($this->getRequestParameter('page', 1));
     $pager->init();
     $this->pager = $pager;
     aBlogItemTable::populatePages($pager->getResults());
     if ($this->getRequestParameter('feed', false)) {
         $this->getFeed();
         return sfView::NONE;
     }
 }

 /**
  * Get results
  * 
  * @param   mixed   $hydrationMode  Doctrine hydration mode
  * @return  array|Doctrine_Collection   Results
  * @author  relo_san
  * @since   march 10, 2010
  */
 public function getResults($hydrationMode = null)
 {
     if ($this->useCache) {
         if (isset($this->cache['data'])) {
             return $this->cache['data'];
         }
         $this->setTableMethod($this->cacheManager->getQueryMethod($this->cacheRoute));
         $hydrationMode = Doctrine::HYDRATE_ARRAY;
     }
     $results = parent::getResults($hydrationMode);
     if ($this->useCache && isset($this->cache['pager'])) {
         $results = $this->cacheManager->prepareTranslations($results);
         $this->cache['data'] = $results;
         $this->cacheManager->setContent($this->cacheRoute, $this->cache, $this->getClass(), array_merge(array('page' => $this->getPage()), $this->queryParams));
     }
     return $results;
 }

 public function executeIndex(sfWebRequest $request)
 {
     $this->buildParams();
     $this->max_per_page = $this->getUser()->getAttribute('max_per_page', sfConfig::get('app_aBlog_max_per_page', 20), 'apostropheBlog_prefs');
     $pager = new sfDoctrinePager($this->modelClass);
     $pager->setMaxPerPage($this->max_per_page);
     $pager->setQuery($this->buildQuery($request));
     $pager->setPage($this->getRequestParameter('page', 1));
     $pager->init();
     $this->pager = $pager;
     aBlogItemTable::populatePages($pager->getResults());
     if ($request->hasParameter('year') || $request->hasParameter('month') || $request->hasParameter('day') || $request->hasParameter('cat') || $request->hasParameter('tag')) {
         // Forbid combinations of filters for bots like Google. This prevents aggressive overspidering
         // of the same data
         $this->getResponse()->addMeta('robots', 'noarchive, nofollow');
     }
     if ($this->getRequestParameter('feed', false)) {
         $this->getFeed();
         return sfView::NONE;
     }
     return $this->pageTemplate;
 }

 /**
  * Get results for the pager instance
  *
  * @param integer $hydrationMode Doctrine::HYDRATE_* constants
  * @return mixed Doctrine_Collection/array
  */
 public function getResults($hydrationMode = Doctrine::HYDRATE_RECORD)
 {
     if ($this->results) {
         return $this->results;
     } else {
         return parent::getResults($hydrationMode);
     }
 }

$pager->init();
$t->is($pager->getQuery()->getSqlQuery(), 'SELECT a.id AS a__id, a.name AS a__name, a.type AS a__type FROM author a WHERE (a.id > 0) LIMIT 25');
$t->ok($pager->isFirstPage());
$pager->setPage(2);
$pager->init();
$t->is($pager->getQuery()->getSqlQuery(), 'SELECT a.id AS a__id, a.name AS a__name, a.type AS a__type FROM author a WHERE (a.id > 0) LIMIT 25 OFFSET 25');
$t->is($pager->getQuery()->count(), $total);
$t->ok($pager->isLastPage());
$results = $pager->getResults();
$t->is(gettype($results), 'object');
$t->is(get_class($results), 'Doctrine_Collection');
$t->is(count($results), $numPerPage);
$t->is($pager->getCountQuery()->count(), $total);
$pager = new sfDoctrinePager('Author', $numPerPage);
$pager->setTableMethod('testTableMethod');
$pager->setPage(1);
$pager->init();
$results = $pager->getResults(Doctrine::HYDRATE_ARRAY);
$t->is(gettype($results), 'array');
$t->is(count($results), $numPerPage);
$pager = new sfDoctrinePager('Author', $numPerPage);
$pager->setTableMethod('testTableMethod2');
$pager->setQuery(Doctrine_Query::create()->from('Author a')->where('a.id < 9999999'));
$pager->setPage(1);
$pager->init();
$t->is($pager->getQuery()->getSqlQuery(), 'SELECT a.id AS a__id, a.name AS a__name, a.type AS a__type FROM author a WHERE (a.id < 9999999 AND a.id > 0) LIMIT 25');
$pager = new sfDoctrinePager('Author', $numPerPage);
$pager->setQuery(Doctrine_Query::create()->from('Author a')->where('a.id < 9999999'));
$pager->setPage(1);
$pager->init();
$t->is($pager->getQuery()->getSqlQuery(), 'SELECT a.id AS a__id, a.name AS a__name, a.type AS a__type FROM author a WHERE (a.id < 9999999) LIMIT 25');

 /**
  * Get all the results for the pager instance
  *
  * @param mixed $hydrationMode A hydration mode identifier
  *
  * @return Doctrine_Collection|array
  */
 public function getResultsWithoutCache($hydrationMode = null)
 {
     return parent::getResults($hydrationMode)->getData();
 }

$t->diag('->getResults()');
$query = Doctrine_Core::getTable('Article')->createQuery();
$query->setHydrationMode(Doctrine_Core::HYDRATE_NONE);
$pager = new sfDoctrinePager('Article', 10);
$pager->setQuery($query);
$pager->init();
$t->isa_ok($pager->getResults(), 'array', '->getResults() uses the hydration mode set on the query');
// ->getNbResults()
$t->diag('->getNbResults()');
$pager = new sfDoctrinePager('Article', 10);
$pager->init();
$count = Doctrine_Core::getTable('Article')->createQuery()->count();
$t->is($pager->getNbResults(), $count, '->getNbResults() returns the number of results');
// Countable interface
$t->diag('Countable interface');
$pager = new sfDoctrinePager('Article', 10);
$pager->init();
$t->is(count($pager), count($pager->getResults()), '"Countable" interface returns the number of objects in the current pager');
// Iterator interface
$t->diag('Iterator interface');
$pager = new sfDoctrinePager('Article', 10);
$pager->init();
$normal = 0;
$iterated = 0;
foreach ($pager->getResults() as $object) {
    $normal++;
}
foreach ($pager as $object) {
    $iterated++;
}
$t->is($iterated, $normal, '"Iterator" interface loops over objects in the current pager');

$pager->setTableMethod('testTableMethod');
$pager->setPage(1);
$pager->init();
$t->is($pager->getQuery()->getSql(), 'SELECT a.id AS a__id, a.name AS a__name FROM author a WHERE a.id > 0 LIMIT 25');
$pager->setPage(2);
$pager->init();
$t->is($pager->getQuery()->getSql(), 'SELECT a.id AS a__id, a.name AS a__name FROM author a WHERE a.id > 0 LIMIT 25 OFFSET 25');
$results = $pager->getResults();
$t->is(gettype($results), 'object');
$t->is(get_class($results), 'Doctrine_Collection');
$t->is(count($results), $numPerPage);
$t->is($pager->getQuery()->count(), $total);
$t->is($pager->getCountQuery()->count(), $total);
$pager = new sfDoctrinePager('Author', $numPerPage);
$pager->setTableMethod('testTableMethod');
$pager->setPage(1);
$pager->init();
$results = $pager->getResults('array');
$t->is(gettype($results), 'array');
$t->is(count($results), $numPerPage);
$pager = new sfDoctrinePager('Author', $numPerPage);
$pager->setTableMethod('testTableMethod2');
$pager->setQuery(Doctrine_Query::create()->from('Author a')->where('a.id < 9999999'));
$pager->setPage(1);
$pager->init();
$t->is($pager->getQuery()->getSql(), 'SELECT a.id AS a__id, a.name AS a__name FROM author a WHERE a.id < 9999999 AND a.id > 0 LIMIT 25');
$pager = new sfDoctrinePager('Author', $numPerPage);
$pager->setQuery(Doctrine_Query::create()->from('Author a')->where('a.id < 9999999'));
$pager->setPage(1);
$pager->init();
$t->is($pager->getQuery()->getSql(), 'SELECT a.id AS a__id, a.name AS a__name FROM author a WHERE a.id < 9999999 LIMIT 25');