PHP Query::first方法代码示例

 /**
  * converts a query Object into a flat table
  * properties are filed in first row
  *
  * @param Query $query
  * @return array
  */
 public function prepareTableData(Query $query = null)
 {
     /* first row contains properties */
     $data = [array_keys($query->first()->toArray())];
     /** add data of an entity a row */
     foreach ($query as $entity) {
         $data[] = array_values($entity->toArray());
     }
     return $data;
 }

 /**
  * Tests that first can be called against a query with a mapReduce
  *
  * @return void
  */
 public function testFirstMapReduce()
 {
     $map = function ($row, $key, $mapReduce) {
         $mapReduce->emitIntermediate($row['id'], 'id');
     };
     $reduce = function ($values, $key, $mapReduce) {
         $mapReduce->emit(array_sum($values));
     };
     $table = TableRegistry::get('articles', ['table' => 'articles']);
     $query = new Query($this->connection, $table);
     $query->select(['id'])->hydrate(false)->mapReduce($map, $reduce);
     $first = $query->first();
     $this->assertEquals(1, $first);
 }

 /**
  * Custom finder for hashids field.
  *
  * Options:
  * - hid (required), best to use HashidBehavior::HID constant
  * - noFirst (optional, to leave the query open for adjustments, no first() called)
  *
  * @param \Cake\ORM\Query $query Query.
  * @param array $options Array of options as described above
  * @return \Cake\ORM\Query
  */
 public function findHashed(Query $query, array $options)
 {
     $field = $this->_config['field'];
     if (!$field) {
         return $query;
     }
     $idField = $this->_primaryKey;
     $query->formatResults(function ($results) use($field, $idField) {
         $newResult = [];
         $results->each(function ($row, $key) use($field, $idField, &$newResult) {
             if (!empty($row[$idField])) {
                 $row[$field] = $this->encodeId($row[$idField]);
                 if ($row instanceof Entity) {
                     $row->dirty($field, false);
                 }
                 $newResult[] = $row;
             } elseif (is_string($row)) {
                 $newResult[$this->encodeId($key)] = $row;
             }
         });
         return new Collection($newResult);
     });
     if (!empty($options[static::HID])) {
         $id = $this->decodeHashid($options[static::HID]);
         $query->where([$idField => $id]);
     }
     $first = $this->_config['findFirst'] === true ? 'first' : $this->_config['findFirst'];
     if (!$first || !empty($options['noFirst'])) {
         return $query;
     }
     return $query->first();
 }