MediaWiki master
BatchRowIterator Class Reference

Allows iterating a large number of rows in batches transparently. More...

Inherits RecursiveIterator.

Collaboration diagram for BatchRowIterator:

Public Member Functions

 __construct (IReadableDatabase $db, $table, $primaryKey, $batchSize)
 
 addConditions (array $conditions)
 
 addJoinConditions (array $conditions)
 
 addOptions (array $options)
 
 current ()
 
 extractPrimaryKeys ( $row)
 Extracts the primary key(s) from a database row.
 
 getChildren ()
 
 hasChildren ()
 
 key ()
 
 next ()
 Fetch the next set of rows from the database.
 
 rewind ()
 Reset the iterator to the beginning of the table.
 
 setCaller ( $caller)
 Use ->setCaller( METHOD ) to indicate which code is using this class.
 
 setFetchColumns (array $columns)
 
 valid ()
 

Protected Member Functions

 buildConditions ()
 Uses the primary key list and the maximal result row from the previous iteration to build an SQL condition sufficient for selecting the next page of results.
 

Protected Attributes

int $batchSize
 The number of rows to fetch per iteration.
 
string null $caller
 For debugging which method is using this class.
 
array $conditions = []
 Array of strings containing SQL conditions to add to the query.
 
IReadableDatabase $db
 
array $fetchColumns
 List of column names to select from the table suitable for use with IDatabase::select()
 
array $joinConditions = []
 
array $options = []
 Additional query options.
 
string $orderBy
 SQL Order by condition generated from $this->primaryKey.
 
array $primaryKey
 The name of the primary key(s)
 
string array $table
 The name or names of the table to read from.
 

Detailed Description

Allows iterating a large number of rows in batches transparently.

By default when iterated over returns the full query result as an array of rows. Can be wrapped in RecursiveIteratorIterator to collapse those arrays into a single stream of rows queried in batches.

Stability: newable

Definition at line 33 of file BatchRowIterator.php.

Constructor & Destructor Documentation

◆ __construct()

BatchRowIterator::__construct ( IReadableDatabase $db,
$table,
$primaryKey,
$batchSize )
Stability: stable
to call
Parameters
IReadableDatabase$db
string | array$tableThe name or names of the table to read from
string | array$primaryKeyThe name or names of the primary key columns
int$batchSizeThe number of rows to fetch per iteration

Definition at line 104 of file BatchRowIterator.php.

References $batchSize, $db, $primaryKey, and $table.

Member Function Documentation

◆ addConditions()

BatchRowIterator::addConditions ( array $conditions)
Parameters
array$conditionsQuery conditions suitable for use with IDatabase::select

Definition at line 120 of file BatchRowIterator.php.

References $conditions.

Referenced by CategoryChangesAsRdf\getCategoryLinksIterator().

◆ addJoinConditions()

BatchRowIterator::addJoinConditions ( array $conditions)
Parameters
array$conditionsQuery join conditions suitable for use with IDatabase::select

Definition at line 136 of file BatchRowIterator.php.

References $conditions.

◆ addOptions()

BatchRowIterator::addOptions ( array $options)
Parameters
array$optionsQuery options suitable for use with IDatabase::select

Definition at line 128 of file BatchRowIterator.php.

References $options.

◆ buildConditions()

BatchRowIterator::buildConditions ( )
protected

Uses the primary key list and the maximal result row from the previous iteration to build an SQL condition sufficient for selecting the next page of results.

Returns
array The SQL conditions necessary to select the next set of rows in the batched query

Definition at line 264 of file BatchRowIterator.php.

◆ current()

BatchRowIterator::current ( )
Returns
array The most recently fetched set of rows from the database

Definition at line 188 of file BatchRowIterator.php.

◆ extractPrimaryKeys()

BatchRowIterator::extractPrimaryKeys ( $row)

Extracts the primary key(s) from a database row.

Parameters
stdClass$rowAn individual database row from this iterator
Returns
array Map of primary key column to value within the row

Definition at line 176 of file BatchRowIterator.php.

◆ getChildren()

BatchRowIterator::getChildren ( )
Returns
null|RecursiveIterator

Definition at line 225 of file BatchRowIterator.php.

◆ hasChildren()

BatchRowIterator::hasChildren ( )
Returns
bool True when this result set has rows

Definition at line 218 of file BatchRowIterator.php.

◆ key()

BatchRowIterator::key ( )
Returns
int 0-indexed count of the page number fetched

Definition at line 195 of file BatchRowIterator.php.

◆ next()

BatchRowIterator::next ( )

Fetch the next set of rows from the database.

Definition at line 232 of file BatchRowIterator.php.

◆ rewind()

BatchRowIterator::rewind ( )

Reset the iterator to the beginning of the table.

Definition at line 202 of file BatchRowIterator.php.

◆ setCaller()

BatchRowIterator::setCaller ( $caller)

Use ->setCaller( METHOD ) to indicate which code is using this class.

Only used in debugging output.

Since
1.36
Parameters
string$caller
Returns
self

Definition at line 164 of file BatchRowIterator.php.

References $caller.

Referenced by CategoryChangesAsRdf\getCategoryLinksIterator().

◆ setFetchColumns()

BatchRowIterator::setFetchColumns ( array $columns)
Parameters
array$columnsList of column names to select from the table suitable for use with IDatabase::select()

Definition at line 144 of file BatchRowIterator.php.

Referenced by CategoryChangesAsRdf\getCategoryLinksIterator().

◆ valid()

BatchRowIterator::valid ( )
Returns
bool True when the iterator is in a valid state

Definition at line 211 of file BatchRowIterator.php.

Member Data Documentation

◆ $batchSize

int BatchRowIterator::$batchSize
protected

The number of rows to fetch per iteration.

Definition at line 53 of file BatchRowIterator.php.

Referenced by __construct().

◆ $caller

string null BatchRowIterator::$caller
protected

For debugging which method is using this class.

Definition at line 94 of file BatchRowIterator.php.

Referenced by setCaller().

◆ $conditions

array BatchRowIterator::$conditions = []
protected

Array of strings containing SQL conditions to add to the query.

Definition at line 58 of file BatchRowIterator.php.

Referenced by addConditions(), and addJoinConditions().

◆ $db

IReadableDatabase BatchRowIterator::$db
protected

Definition at line 38 of file BatchRowIterator.php.

Referenced by __construct().

◆ $fetchColumns

array BatchRowIterator::$fetchColumns
protected

List of column names to select from the table suitable for use with IDatabase::select()

Definition at line 69 of file BatchRowIterator.php.

◆ $joinConditions

array BatchRowIterator::$joinConditions = []
protected

Definition at line 63 of file BatchRowIterator.php.

◆ $options

array BatchRowIterator::$options = []
protected

Additional query options.

Definition at line 89 of file BatchRowIterator.php.

Referenced by addOptions().

◆ $orderBy

string BatchRowIterator::$orderBy
protected

SQL Order by condition generated from $this->primaryKey.

Definition at line 74 of file BatchRowIterator.php.

◆ $primaryKey

array BatchRowIterator::$primaryKey
protected

The name of the primary key(s)

Definition at line 48 of file BatchRowIterator.php.

Referenced by __construct().

◆ $table

string array BatchRowIterator::$table
protected

The name or names of the table to read from.

Definition at line 43 of file BatchRowIterator.php.

Referenced by __construct().


The documentation for this class was generated from the following file: