Class yii\db\BatchQueryResult

Inheritanceyii\db\BatchQueryResult » yii\base\BaseObject
ImplementsIterator, yii\base\Configurable
Available since version2.0
Source Code https://github.com/yiisoft/yii2/blob/master/framework/db/BatchQueryResult.php

BatchQueryResult represents a batch query from which you can retrieve data in batches.

You usually do not instantiate BatchQueryResult directly. Instead, you obtain it by calling yii\db\Query::batch() or yii\db\Query::each(). Because BatchQueryResult implements the Iterator interface, you can iterate it to obtain a batch of data in each iteration. For example,

$query = (new Query)->from('user');
foreach ($query->batch() as $i => $users) {
    // $users represents the rows in the $i-th batch
}
foreach ($query->each() as $user) {
}

Public Properties

Hide inherited properties

PropertyTypeDescriptionDefined By
$batchSize integer The number of rows to be returned in each batch. yii\db\BatchQueryResult
$db yii\db\Connection The DB connection to be used when performing batch query. yii\db\BatchQueryResult
$each boolean Whether to return a single row during each iteration. yii\db\BatchQueryResult
$query yii\db\Query The query object associated with this batch query. yii\db\BatchQueryResult

Public Methods

Hide inherited methods

MethodDescriptionDefined By
__call() Calls the named method which is not a class method. yii\base\BaseObject
__construct() Constructor. yii\base\BaseObject
__destruct() Destructor. yii\db\BatchQueryResult
__get() Returns the value of an object property. yii\base\BaseObject
__isset() Checks if a property is set, i.e. defined and not null. yii\base\BaseObject
__set() Sets value of an object property. yii\base\BaseObject
__unset() Sets an object property to null. yii\base\BaseObject
__wakeup() Unserialization is disabled to prevent remote code execution in case application calls unserialize() on user input containing specially crafted string. yii\db\BatchQueryResult
canGetProperty() Returns a value indicating whether a property can be read. yii\base\BaseObject
canSetProperty() Returns a value indicating whether a property can be set. yii\base\BaseObject
className() Returns the fully qualified name of this class. yii\base\BaseObject
current() Returns the current dataset. yii\db\BatchQueryResult
hasMethod() Returns a value indicating whether a method is defined. yii\base\BaseObject
hasProperty() Returns a value indicating whether a property is defined. yii\base\BaseObject
init() Initializes the object. yii\base\BaseObject
key() Returns the index of the current dataset. yii\db\BatchQueryResult
next() Moves the internal pointer to the next dataset. yii\db\BatchQueryResult
reset() Resets the batch query. yii\db\BatchQueryResult
rewind() Resets the iterator to the initial state. yii\db\BatchQueryResult
valid() Returns whether there is a valid dataset at the current position. yii\db\BatchQueryResult

Protected Methods

Hide inherited methods

MethodDescriptionDefined By
fetchData() Fetches the next batch of data. yii\db\BatchQueryResult
getRows() Reads and collects rows for batch yii\db\BatchQueryResult

Property Details

$batchSize public property

The number of rows to be returned in each batch.

public integer $batchSize 100
$db public property

The DB connection to be used when performing batch query. If null, the "db" application component will be used.

public yii\db\Connection $db null
$each public property

Whether to return a single row during each iteration. If false, a whole batch of rows will be returned in each iteration.

public boolean $each false
$query public property

The query object associated with this batch query. Do not modify this property directly unless after reset() is called explicitly.

public yii\db\Query $query null

Method Details

__destruct() public method

Destructor.

public void __destruct ( )
__wakeup() public method (available since version 2.0.38)

Unserialization is disabled to prevent remote code execution in case application calls unserialize() on user input containing specially crafted string.

See also [[CVE-2020-15148]].

public void __wakeup ( )
current() public method

Returns the current dataset.

This method is required by the interface Iterator.

public mixed current ( )
return mixed

The current dataset.

fetchData() protected method

Fetches the next batch of data.

protected array fetchData ( )
return array

The data fetched

throws yii\db\Exception
getRows() protected method (available since version 2.0.23)

Reads and collects rows for batch

protected array getRows ( )
key() public method

Returns the index of the current dataset.

This method is required by the interface Iterator.

public integer key ( )
return integer

The index of the current row.

next() public method

Moves the internal pointer to the next dataset.

This method is required by the interface Iterator.

public void next ( )
reset() public method

Resets the batch query.

This method will clean up the existing batch query so that a new batch query can be performed.

public void reset ( )
rewind() public method

Resets the iterator to the initial state.

This method is required by the interface Iterator.

public void rewind ( )
valid() public method

Returns whether there is a valid dataset at the current position.

This method is required by the interface Iterator.

public boolean valid ( )
return boolean

Whether there is a valid dataset at the current position.