PHP Query::count方法代码示例

 /**
  * Login and submit a POST request to a $url that is expected to delete a given record,
  * and then verify its removal.
  *
  * @param int $user_id The user to login as.
  * @param String $url The url to send the request to.  Be sure to include a trailing /.
  * @param int $delete_id The id of the record to delete.
  * @param String $redirect_url The url to redirect to, after the deletion.
  * @param \Cake\ORM\Table $table The table to delete from.
  */
 protected function deletePOST($user_id, $url, $delete_id, $redirect_url, $table)
 {
     $this->fakeLogin($user_id);
     $this->post($url . $delete_id);
     $this->assertResponseSuccess();
     // 2xx, 3xx
     $this->assertRedirect($redirect_url);
     // Now verify that the record no longer exists
     $query = new Query(ConnectionManager::get('test'), $table);
     $query->find('all')->where(['id' => $delete_id]);
     $this->assertEquals(0, $query->count());
 }

 /**
  * Attaches comments to each entity on find operation.
  *
  * @param \Cake\Event\Event $event The event that was triggered
  * @param \Cake\ORM\Query $query The query object
  * @param array $options Additional options as an array
  * @param bool $primary Whether is find is a primary query or not
  * @return void
  */
 public function beforeFind(Event $event, $query, $options, $primary)
 {
     if ($this->_enabled && $query->count() > 0) {
         $pk = $this->_table->primaryKey();
         $tableAlias = Inflector::underscore($this->_table->alias());
         $query->contain(['Comments' => function ($query) {
             return $query->find('threaded')->contain(['Users'])->order($this->config('order'));
         }]);
         if ($this->config('count') || isset($options['comments_count']) && $options['comments_count'] === true) {
             $query->formatResults(function ($results) use($pk, $tableAlias) {
                 return $results->map(function ($entity) use($pk, $tableAlias) {
                     $entityId = $entity->{$pk};
                     $count = TableRegistry::get('Comment.Comments')->find()->where(['entity_id' => $entityId, 'table_alias' => $tableAlias])->count();
                     $entity->set('comments_count', $count);
                     return $entity;
                 });
             });
         }
     }
 }

 /**
  * Prepare CakePHP paging
  *
  * @param Request $request DataTable request
  */
 protected function preparePaging(Request $request)
 {
     self::$countBeforePaging = $this->query->count();
     $this->query->limit($request->getLength());
     $this->query->offset($request->getStart());
 }