function ConfigEntityQueryTest::testSortRange

Tests sorting and range on config entity queries.

File

core/tests/Drupal/KernelTests/Core/Entity/ConfigEntityQueryTest.php, line 457

Class

ConfigEntityQueryTest

Tests Config Entity Query functionality.

Namespace

Code

public function testSortRange() : void {
  // Sort by simple ascending/descending.
  $this->queryResults = $this->entityStorage
    ->getQuery()
    ->sort('number', 'DESC')
    ->execute();
  $this->assertSame([
    '7',
    '3',
    '5',
    '2',
    '1',
    '4',
    '6',
  ], array_values($this->queryResults));
  $this->queryResults = $this->entityStorage
    ->getQuery()
    ->sort('number', 'ASC')
    ->execute();
  $this->assertSame([
    '6',
    '4',
    '1',
    '2',
    '5',
    '3',
    '7',
  ], array_values($this->queryResults));
  // Apply some filters and sort.
  $this->queryResults = $this->entityStorage
    ->getQuery()
    ->condition('id', '3', '>')
    ->sort('number', 'DESC')
    ->execute();
  $this->assertSame([
    '7',
    '5',
    '4',
    '6',
  ], array_values($this->queryResults));
  $this->queryResults = $this->entityStorage
    ->getQuery()
    ->condition('id', '3', '>')
    ->sort('number', 'ASC')
    ->execute();
  $this->assertSame([
    '6',
    '4',
    '5',
    '7',
  ], array_values($this->queryResults));
  // Apply a pager and sort.
  $this->queryResults = $this->entityStorage
    ->getQuery()
    ->sort('number', 'DESC')
    ->range('2', '2')
    ->execute();
  $this->assertSame([
    '5',
    '2',
  ], array_values($this->queryResults));
  $this->queryResults = $this->entityStorage
    ->getQuery()
    ->sort('number', 'ASC')
    ->range('2', '2')
    ->execute();
  $this->assertSame([
    '1',
    '2',
  ], array_values($this->queryResults));
  // Add a range to a query without a start parameter.
  $this->queryResults = $this->entityStorage
    ->getQuery()
    ->range(0, '3')
    ->sort('id', 'ASC')
    ->execute();
  $this->assertSame([
    '1',
    '2',
    '3',
  ], array_values($this->queryResults));
  // Omit optional parameters for the range and sort.
  $this->queryResults = $this->entityStorage
    ->getQuery()
    ->range()
    ->sort('id')
    ->execute();
  $this->assertSame([
    '1',
    '2',
    '3',
    '4',
    '5',
    '6',
    '7',
  ], array_values($this->queryResults));
  // Explicitly pass NULL for the range and sort.
  $this->queryResults = $this->entityStorage
    ->getQuery()
    ->range(NULL, NULL)
    ->sort('id')
    ->execute();
  $this->assertSame([
    '1',
    '2',
    '3',
    '4',
    '5',
    '6',
    '7',
  ], array_values($this->queryResults));
  // Omit the optional start parameter for the range.
  $this->queryResults = $this->entityStorage
    ->getQuery()
    ->range(NULL, 1)
    ->sort('id')
    ->execute();
  $this->assertSame([
    '1',
  ], array_values($this->queryResults));
  // Omit the optional length parameter for the range.
  $this->queryResults = $this->entityStorage
    ->getQuery()
    ->range(4)
    ->sort('id')
    ->execute();
  $this->assertSame([
    '5',
    '6',
    '7',
  ], array_values($this->queryResults));
  // Request an empty range.
  $this->queryResults = $this->entityStorage
    ->getQuery()
    ->range(0, 0)
    ->execute();
  $this->assertEmpty($this->queryResults);
  // Apply a pager with limit 4.
  $this->queryResults = $this->entityStorage
    ->getQuery()
    ->pager('4', 0)
    ->sort('id', 'ASC')
    ->execute();
  $this->assertSame([
    '1',
    '2',
    '3',
    '4',
  ], array_values($this->queryResults));
}