|
public each ( integer $batchSize = 100, |
||
| $batchSize | integer | the number of records to be fetched in each batch. |
| $db | the database connection. If not set, the "db" application component will be used. | |
| Résultat | the batch query result. It implements the [[\Iterator]] interface and can be traversed to retrieve the data in batches. | |
public function each($batchSize = 100, $db = null)
{
return Yii::createObject(['class' => BatchQueryResult::className(), 'query' => $this, 'batchSize' => $batchSize, 'db' => $db, 'each' => true]);
} /**
* Returns list of users' full names
* @param int $limit records count
* @return array list of users' names
*/
public static function getUserList($limit = null)
{
$query = new Query();
$query->select(['id', 'text' => "CONCAT(`u`.`first_name`,' ', `u`.`last_name`)"])->from(['u' => 'User']);
if (isset($limit)) {
$query->limit($limit);
}
$query->each();
$command = $query->createCommand();
return $command->queryAll();
}
