public function PagerSelectExtender::execute in Drupal 9

Same name and namespace in other branches

1. 8 core/lib/Drupal/Core/Database/Query/PagerSelectExtender.php \Drupal\Core\Database\Query\PagerSelectExtender::execute()

Override the execute method.

Before we run the query, we need to add pager-based range() instructions to it.

Overrides SelectExtender::execute

File

core/lib/Drupal/Core/Database/Query/PagerSelectExtender.php, line 74

Class

PagerSelectExtender

Query extender for pager queries.

Namespace

Drupal\Core\Database\Query

Code

public function execute() {

  // By calling preExecute() here, we force it to preprocess the extender
  // object rather than just the base query object. That means
  // hook_query_alter() gets access to the extended object.
  if (!$this
    ->preExecute($this)) {
    return NULL;
  }

  // A NULL limit is the "kill switch" for pager queries.
  if (empty($this->limit)) {
    return;
  }
  $this
    ->ensureElement();
  $total_items = $this
    ->getCountQuery()
    ->execute()
    ->fetchField();
  $pager = $this->connection
    ->getPagerManager()
    ->createPager($total_items, $this->limit, $this->element);
  $this
    ->range($pager
    ->getCurrentPage() * $this->limit, $this->limit);

  // Now that we've added our pager-based range instructions, run the query normally.
  return $this->query
    ->execute();
}