class EntityQueryAggregateTest in Zircon Profile 8
Same name and namespace in other branches
- 8.0 core/modules/system/src/Tests/Entity/EntityQueryAggregateTest.php \Drupal\system\Tests\Entity\EntityQueryAggregateTest
Tests the Entity Query Aggregation API.
@group Entity
Hierarchy
- class \Drupal\simpletest\TestBase uses AssertHelperTrait, RandomGeneratorTrait, SessionTestTrait- class \Drupal\simpletest\KernelTestBase uses AssertContentTrait- class \Drupal\system\Tests\Entity\EntityUnitTestBase- class \Drupal\system\Tests\Entity\EntityQueryAggregateTest
 
 
- class \Drupal\system\Tests\Entity\EntityUnitTestBase
 
- class \Drupal\simpletest\KernelTestBase uses AssertContentTrait
Expanded class hierarchy of EntityQueryAggregateTest
See also
\Drupal\entity_test\Entity\EntityTest
File
- core/modules/ system/ src/ Tests/ Entity/ EntityQueryAggregateTest.php, line 15 
- Contains \Drupal\system\Tests\Entity\EntityQueryAggregateTest.
Namespace
Drupal\system\Tests\EntityView source
class EntityQueryAggregateTest extends EntityUnitTestBase {
  /**
   * Modules to enable.
   *
   * @var array
   */
  public static $modules = array();
  /**
   * The entity_test storage to create the test entities.
   *
   * @var \Drupal\entity_test\EntityTestStorage
   */
  protected $entityStorage;
  /**
   * The actual query result, to compare later.
   *
   * @var array
   */
  protected $queryResult;
  /**
   * The query factory to create entity queries.
   *
   * @var \Drupal\Core\Entity\Query\QueryFactory
   */
  public $factory;
  protected function setUp() {
    parent::setUp();
    $this->entityStorage = $this->entityManager
      ->getStorage('entity_test');
    $this->factory = $this->container
      ->get('entity.query');
    // Add some fieldapi fields to be used in the test.
    for ($i = 1; $i <= 2; $i++) {
      $field_name = 'field_test_' . $i;
      entity_create('field_storage_config', array(
        'field_name' => $field_name,
        'entity_type' => 'entity_test',
        'type' => 'integer',
        'cardinality' => 2,
      ))
        ->save();
      entity_create('field_config', array(
        'field_name' => $field_name,
        'entity_type' => 'entity_test',
        'bundle' => 'entity_test',
      ))
        ->save();
    }
    $entity = $this->entityStorage
      ->create(array(
      'id' => 1,
      'user_id' => 1,
      'field_test_1' => 1,
      'field_test_2' => 2,
    ));
    $entity
      ->enforceIsNew();
    $entity
      ->save();
    $entity = $this->entityStorage
      ->create(array(
      'id' => 2,
      'user_id' => 2,
      'field_test_1' => 1,
      'field_test_2' => 7,
    ));
    $entity
      ->enforceIsNew();
    $entity
      ->save();
    $entity = $this->entityStorage
      ->create(array(
      'id' => 3,
      'user_id' => 2,
      'field_test_1' => 2,
      'field_test_2' => 1,
    ));
    $entity
      ->enforceIsNew();
    $entity
      ->save();
    $entity = $this->entityStorage
      ->create(array(
      'id' => 4,
      'user_id' => 2,
      'field_test_1' => 2,
      'field_test_2' => 8,
    ));
    $entity
      ->enforceIsNew();
    $entity
      ->save();
    $entity = $this->entityStorage
      ->create(array(
      'id' => 5,
      'user_id' => 3,
      'field_test_1' => 2,
      'field_test_2' => 2,
    ));
    $entity
      ->enforceIsNew();
    $entity
      ->save();
    $entity = $this->entityStorage
      ->create(array(
      'id' => 6,
      'user_id' => 3,
      'field_test_1' => 3,
      'field_test_2' => 8,
    ));
    $entity
      ->enforceIsNew();
    $entity
      ->save();
  }
  /**
   * Test aggregation support.
   */
  public function testAggregation() {
    // Apply a simple groupby.
    $this->queryResult = $this->factory
      ->getAggregate('entity_test')
      ->groupBy('user_id')
      ->execute();
    $this
      ->assertResults(array(
      array(
        'user_id' => 1,
      ),
      array(
        'user_id' => 2,
      ),
      array(
        'user_id' => 3,
      ),
    ));
    $function_expected = array();
    $function_expected['count'] = array(
      array(
        'id_count' => 6,
      ),
    );
    $function_expected['min'] = array(
      array(
        'id_min' => 1,
      ),
    );
    $function_expected['max'] = array(
      array(
        'id_max' => 6,
      ),
    );
    $function_expected['sum'] = array(
      array(
        'id_sum' => 21,
      ),
    );
    $function_expected['avg'] = array(
      array(
        'id_avg' => 21.0 / 6.0,
      ),
    );
    // Apply a simple aggregation for different aggregation functions.
    foreach ($function_expected as $aggregation_function => $expected) {
      $this->queryResult = $this->factory
        ->getAggregate('entity_test')
        ->aggregate('id', $aggregation_function)
        ->execute();
      $this
        ->assertEqual($this->queryResult, $expected);
    }
    // Apply aggregation and groupby on the same query.
    $this->queryResult = $this->factory
      ->getAggregate('entity_test')
      ->aggregate('id', 'COUNT')
      ->groupBy('user_id')
      ->execute();
    $this
      ->assertResults(array(
      array(
        'user_id' => 1,
        'id_count' => 1,
      ),
      array(
        'user_id' => 2,
        'id_count' => 3,
      ),
      array(
        'user_id' => 3,
        'id_count' => 2,
      ),
    ));
    // Apply aggregation and a condition which matches.
    $this->queryResult = $this->factory
      ->getAggregate('entity_test')
      ->aggregate('id', 'COUNT')
      ->groupBy('id')
      ->conditionAggregate('id', 'COUNT', 8)
      ->execute();
    $this
      ->assertResults(array());
    // Don't call aggregate to test the implicit aggregate call.
    $this->queryResult = $this->factory
      ->getAggregate('entity_test')
      ->groupBy('id')
      ->conditionAggregate('id', 'COUNT', 8)
      ->execute();
    $this
      ->assertResults(array());
    // Apply aggregation and a condition which matches.
    $this->queryResult = $this->factory
      ->getAggregate('entity_test')
      ->aggregate('id', 'count')
      ->groupBy('id')
      ->conditionAggregate('id', 'COUNT', 6)
      ->execute();
    $this
      ->assertResults(array(
      array(
        'id_count' => 6,
      ),
    ));
    // Apply aggregation, a groupby and a condition which matches partially via
    // the operator '='.
    $this->queryResult = $this->factory
      ->getAggregate('entity_test')
      ->aggregate('id', 'count')
      ->conditionAggregate('id', 'count', 2)
      ->groupBy('user_id')
      ->execute();
    $this
      ->assertResults(array(
      array(
        'id_count' => 2,
        'user_id' => 3,
      ),
    ));
    // Apply aggregation, a groupby and a condition which matches partially via
    // the operator '>'.
    $this->queryResult = $this->factory
      ->getAggregate('entity_test')
      ->aggregate('id', 'count')
      ->conditionAggregate('id', 'COUNT', 1, '>')
      ->groupBy('user_id')
      ->execute();
    $this
      ->assertResults(array(
      array(
        'id_count' => 2,
        'user_id' => 3,
      ),
      array(
        'id_count' => 3,
        'user_id' => 2,
      ),
    ));
    // Apply aggregation and a sort. This might not be useful, but have a proper
    // test coverage.
    $this->queryResult = $this->factory
      ->getAggregate('entity_test')
      ->aggregate('id', 'COUNT')
      ->sortAggregate('id', 'COUNT')
      ->execute();
    $this
      ->assertSortedResults(array(
      array(
        'id_count' => 6,
      ),
    ));
    // Don't call aggregate to test the implicit aggregate call.
    $this->queryResult = $this->factory
      ->getAggregate('entity_test')
      ->sortAggregate('id', 'COUNT')
      ->execute();
    $this
      ->assertSortedResults(array(
      array(
        'id_count' => 6,
      ),
    ));
    // Apply aggregation, groupby and a sort descending.
    $this->queryResult = $this->factory
      ->getAggregate('entity_test')
      ->aggregate('id', 'COUNT')
      ->groupBy('user_id')
      ->sortAggregate('id', 'COUNT', 'DESC')
      ->execute();
    $this
      ->assertSortedResults(array(
      array(
        'user_id' => 2,
        'id_count' => 3,
      ),
      array(
        'user_id' => 3,
        'id_count' => 2,
      ),
      array(
        'user_id' => 1,
        'id_count' => 1,
      ),
    ));
    // Apply aggregation, groupby and a sort ascending.
    $this->queryResult = $this->factory
      ->getAggregate('entity_test')
      ->aggregate('id', 'COUNT')
      ->groupBy('user_id')
      ->sortAggregate('id', 'COUNT', 'ASC')
      ->execute();
    $this
      ->assertSortedResults(array(
      array(
        'user_id' => 1,
        'id_count' => 1,
      ),
      array(
        'user_id' => 3,
        'id_count' => 2,
      ),
      array(
        'user_id' => 2,
        'id_count' => 3,
      ),
    ));
    // Apply aggregation, groupby, an aggregation condition and a sort with the
    // operator '='.
    $this->queryResult = $this->factory
      ->getAggregate('entity_test')
      ->aggregate('id', 'COUNT')
      ->groupBy('user_id')
      ->sortAggregate('id', 'COUNT')
      ->conditionAggregate('id', 'COUNT', 2)
      ->execute();
    $this
      ->assertSortedResults(array(
      array(
        'id_count' => 2,
        'user_id' => 3,
      ),
    ));
    // Apply aggregation, groupby, an aggregation condition and a sort with the
    // operator '<' and order ASC.
    $this->queryResult = $this->factory
      ->getAggregate('entity_test')
      ->aggregate('id', 'COUNT')
      ->groupBy('user_id')
      ->sortAggregate('id', 'COUNT', 'ASC')
      ->conditionAggregate('id', 'COUNT', 3, '<')
      ->execute();
    $this
      ->assertSortedResults(array(
      array(
        'id_count' => 1,
        'user_id' => 1,
      ),
      array(
        'id_count' => 2,
        'user_id' => 3,
      ),
    ));
    // Apply aggregation, groupby, an aggregation condition and a sort with the
    // operator '<' and order DESC.
    $this->queryResult = $this->factory
      ->getAggregate('entity_test')
      ->aggregate('id', 'COUNT')
      ->groupBy('user_id')
      ->sortAggregate('id', 'COUNT', 'DESC')
      ->conditionAggregate('id', 'COUNT', 3, '<')
      ->execute();
    $this
      ->assertSortedResults(array(
      array(
        'id_count' => 2,
        'user_id' => 3,
      ),
      array(
        'id_count' => 1,
        'user_id' => 1,
      ),
    ));
    // Test aggregation/groupby support for fieldapi fields.
    // Just group by a fieldapi field.
    $this->queryResult = $this->factory
      ->getAggregate('entity_test')
      ->groupBy('field_test_1')
      ->execute();
    $this
      ->assertResults(array(
      array(
        'field_test_1' => 1,
      ),
      array(
        'field_test_1' => 2,
      ),
      array(
        'field_test_1' => 3,
      ),
    ));
    // Group by a fieldapi field and aggregate a normal property.
    $this->queryResult = $this->factory
      ->getAggregate('entity_test')
      ->aggregate('user_id', 'COUNT')
      ->groupBy('field_test_1')
      ->execute();
    $this
      ->assertResults(array(
      array(
        'field_test_1' => 1,
        'user_id_count' => 2,
      ),
      array(
        'field_test_1' => 2,
        'user_id_count' => 3,
      ),
      array(
        'field_test_1' => 3,
        'user_id_count' => 1,
      ),
    ));
    // Group by a normal property and aggregate a fieldapi field.
    $this->queryResult = $this->factory
      ->getAggregate('entity_test')
      ->aggregate('field_test_1', 'COUNT')
      ->groupBy('user_id')
      ->execute();
    $this
      ->assertResults(array(
      array(
        'user_id' => 1,
        'field_test_1_count' => 1,
      ),
      array(
        'user_id' => 2,
        'field_test_1_count' => 3,
      ),
      array(
        'user_id' => 3,
        'field_test_1_count' => 2,
      ),
    ));
    $this->queryResult = $this->factory
      ->getAggregate('entity_test')
      ->aggregate('field_test_1', 'SUM')
      ->groupBy('user_id')
      ->execute();
    $this
      ->assertResults(array(
      array(
        'user_id' => 1,
        'field_test_1_sum' => 1,
      ),
      array(
        'user_id' => 2,
        'field_test_1_sum' => 5,
      ),
      array(
        'user_id' => 3,
        'field_test_1_sum' => 5,
      ),
    ));
    // Aggregate by two different fieldapi fields.
    $this->queryResult = $this->factory
      ->getAggregate('entity_test')
      ->aggregate('field_test_1', 'SUM')
      ->aggregate('field_test_2', 'SUM')
      ->groupBy('user_id')
      ->execute();
    $this
      ->assertResults(array(
      array(
        'user_id' => 1,
        'field_test_1_sum' => 1,
        'field_test_2_sum' => 2,
      ),
      array(
        'user_id' => 2,
        'field_test_1_sum' => 5,
        'field_test_2_sum' => 16,
      ),
      array(
        'user_id' => 3,
        'field_test_1_sum' => 5,
        'field_test_2_sum' => 10,
      ),
    ));
    // This time aggregate the same field twice.
    $this->queryResult = $this->factory
      ->getAggregate('entity_test')
      ->aggregate('field_test_1', 'SUM')
      ->aggregate('field_test_1', 'COUNT')
      ->groupBy('user_id')
      ->execute();
    $this
      ->assertResults(array(
      array(
        'user_id' => 1,
        'field_test_1_sum' => 1,
        'field_test_1_count' => 1,
      ),
      array(
        'user_id' => 2,
        'field_test_1_sum' => 5,
        'field_test_1_count' => 3,
      ),
      array(
        'user_id' => 3,
        'field_test_1_sum' => 5,
        'field_test_1_count' => 2,
      ),
    ));
    // Group by and aggregate by a fieldapi field.
    $this->queryResult = $this->factory
      ->getAggregate('entity_test')
      ->groupBy('field_test_1')
      ->aggregate('field_test_2', 'COUNT')
      ->execute();
    $this
      ->assertResults(array(
      array(
        'field_test_1' => 1,
        'field_test_2_count' => 2,
      ),
      array(
        'field_test_1' => 2,
        'field_test_2_count' => 3,
      ),
      array(
        'field_test_1' => 3,
        'field_test_2_count' => 1,
      ),
    ));
    // Group by and aggregate by a fieldapi field and use multiple aggregate
    // functions.
    $this->queryResult = $this->factory
      ->getAggregate('entity_test')
      ->groupBy('field_test_1')
      ->aggregate('field_test_2', 'COUNT')
      ->aggregate('field_test_2', 'SUM')
      ->execute();
    $this
      ->assertResults(array(
      array(
        'field_test_1' => 1,
        'field_test_2_count' => 2,
        'field_test_2_sum' => 9,
      ),
      array(
        'field_test_1' => 2,
        'field_test_2_count' => 3,
        'field_test_2_sum' => 11,
      ),
      array(
        'field_test_1' => 3,
        'field_test_2_count' => 1,
        'field_test_2_sum' => 8,
      ),
    ));
    // Apply an aggregate condition for a fieldapi field and group by a simple
    // property.
    $this->queryResult = $this->factory
      ->getAggregate('entity_test')
      ->conditionAggregate('field_test_1', 'COUNT', 3)
      ->groupBy('user_id')
      ->execute();
    $this
      ->assertResults(array(
      array(
        'user_id' => 2,
        'field_test_1_count' => 3,
      ),
      array(
        'user_id' => 3,
        'field_test_1_count' => 2,
      ),
    ));
    $this->queryResult = $this->factory
      ->getAggregate('entity_test')
      ->aggregate('field_test_1', 'SUM')
      ->conditionAggregate('field_test_1', 'COUNT', 2, '>')
      ->groupBy('user_id')
      ->execute();
    $this
      ->assertResults(array(
      array(
        'user_id' => 2,
        'field_test_1_sum' => 5,
        'field_test_1_count' => 3,
      ),
      array(
        'user_id' => 3,
        'field_test_1_sum' => 5,
        'field_test_1_count' => 2,
      ),
    ));
    // Apply an aggregate condition for a simple property and a group by a
    // fieldapi field.
    $this->queryResult = $this->factory
      ->getAggregate('entity_test')
      ->conditionAggregate('user_id', 'COUNT', 2)
      ->groupBy('field_test_1')
      ->execute();
    $this
      ->assertResults(array(
      array(
        'field_test_1' => 1,
        'user_id_count' => 2,
      ),
    ));
    $this->queryResult = $this->factory
      ->getAggregate('entity_test')
      ->conditionAggregate('user_id', 'COUNT', 2, '>')
      ->groupBy('field_test_1')
      ->execute();
    $this
      ->assertResults(array(
      array(
        'field_test_1' => 1,
        'user_id_count' => 2,
      ),
      array(
        'field_test_1' => 2,
        'user_id_count' => 3,
      ),
    ));
    // Apply an aggregate condition and a group by fieldapi fields.
    $this->queryResult = $this->factory
      ->getAggregate('entity_test')
      ->groupBy('field_test_1')
      ->conditionAggregate('field_test_2', 'COUNT', 2)
      ->execute();
    $this
      ->assertResults(array(
      array(
        'field_test_1' => 1,
        'field_test_2_count' => 2,
      ),
    ));
    $this->queryResult = $this->factory
      ->getAggregate('entity_test')
      ->groupBy('field_test_1')
      ->conditionAggregate('field_test_2', 'COUNT', 2, '>')
      ->execute();
    $this
      ->assertResults(array(
      array(
        'field_test_1' => 1,
        'field_test_2_count' => 2,
      ),
      array(
        'field_test_1' => 2,
        'field_test_2_count' => 3,
      ),
    ));
    // Apply an aggregate condition and a group by fieldapi fields with multiple
    // conditions via AND.
    $this->queryResult = $this->factory
      ->getAggregate('entity_test')
      ->groupBy('field_test_1')
      ->conditionAggregate('field_test_2', 'COUNT', 2)
      ->conditionAggregate('field_test_2', 'SUM', 8)
      ->execute();
    $this
      ->assertResults(array());
    // Apply an aggregate condition and a group by fieldapi fields with multiple
    // conditions via OR.
    $this->queryResult = $this->factory
      ->getAggregate('entity_test', 'OR')
      ->groupBy('field_test_1')
      ->conditionAggregate('field_test_2', 'COUNT', 2)
      ->conditionAggregate('field_test_2', 'SUM', 8)
      ->execute();
    $this
      ->assertResults(array(
      array(
        'field_test_1' => 1,
        'field_test_2_count' => 2,
        'field_test_2_sum' => 9,
      ),
      array(
        'field_test_1' => 3,
        'field_test_2_count' => 1,
        'field_test_2_sum' => 8,
      ),
    ));
    // Group by a normal property and aggregate a fieldapi field and sort by the
    // groupby field.
    $this->queryResult = $this->factory
      ->getAggregate('entity_test')
      ->aggregate('field_test_1', 'COUNT')
      ->groupBy('user_id')
      ->sort('user_id', 'DESC')
      ->execute();
    $this
      ->assertSortedResults(array(
      array(
        'user_id' => 3,
        'field_test_1_count' => 2,
      ),
      array(
        'user_id' => 2,
        'field_test_1_count' => 3,
      ),
      array(
        'user_id' => 1,
        'field_test_1_count' => 1,
      ),
    ));
    $this->queryResult = $this->factory
      ->getAggregate('entity_test')
      ->aggregate('field_test_1', 'COUNT')
      ->groupBy('user_id')
      ->sort('user_id', 'ASC')
      ->execute();
    $this
      ->assertSortedResults(array(
      array(
        'user_id' => 1,
        'field_test_1_count' => 1,
      ),
      array(
        'user_id' => 2,
        'field_test_1_count' => 3,
      ),
      array(
        'user_id' => 3,
        'field_test_1_count' => 2,
      ),
    ));
    $this->queryResult = $this->factory
      ->getAggregate('entity_test')
      ->conditionAggregate('field_test_1', 'COUNT', 2, '>')
      ->groupBy('user_id')
      ->sort('user_id', 'ASC')
      ->execute();
    $this
      ->assertSortedResults(array(
      array(
        'user_id' => 2,
        'field_test_1_count' => 3,
      ),
      array(
        'user_id' => 3,
        'field_test_1_count' => 2,
      ),
    ));
    // Group by a normal property, aggregate a fieldapi field, and sort by the
    // aggregated field.
    $this->queryResult = $this->factory
      ->getAggregate('entity_test')
      ->sortAggregate('field_test_1', 'COUNT', 'DESC')
      ->groupBy('user_id')
      ->execute();
    $this
      ->assertSortedResults(array(
      array(
        'user_id' => 2,
        'field_test_1_count' => 3,
      ),
      array(
        'user_id' => 3,
        'field_test_1_count' => 2,
      ),
      array(
        'user_id' => 1,
        'field_test_1_count' => 1,
      ),
    ));
    $this->queryResult = $this->factory
      ->getAggregate('entity_test')
      ->sortAggregate('field_test_1', 'COUNT', 'ASC')
      ->groupBy('user_id')
      ->execute();
    $this
      ->assertSortedResults(array(
      array(
        'user_id' => 1,
        'field_test_1_count' => 1,
      ),
      array(
        'user_id' => 3,
        'field_test_1_count' => 2,
      ),
      array(
        'user_id' => 2,
        'field_test_1_count' => 3,
      ),
    ));
    // Group by and aggregate by fieldapi field, and sort by the groupby field.
    $this->queryResult = $this->factory
      ->getAggregate('entity_test')
      ->groupBy('field_test_1')
      ->aggregate('field_test_2', 'COUNT')
      ->sort('field_test_1', 'ASC')
      ->execute();
    $this
      ->assertSortedResults(array(
      array(
        'field_test_1' => 1,
        'field_test_2_count' => 2,
      ),
      array(
        'field_test_1' => 2,
        'field_test_2_count' => 3,
      ),
      array(
        'field_test_1' => 3,
        'field_test_2_count' => 1,
      ),
    ));
    $this->queryResult = $this->factory
      ->getAggregate('entity_test')
      ->groupBy('field_test_1')
      ->aggregate('field_test_2', 'COUNT')
      ->sort('field_test_1', 'DESC')
      ->execute();
    $this
      ->assertSortedResults(array(
      array(
        'field_test_1' => 3,
        'field_test_2_count' => 1,
      ),
      array(
        'field_test_1' => 2,
        'field_test_2_count' => 3,
      ),
      array(
        'field_test_1' => 1,
        'field_test_2_count' => 2,
      ),
    ));
    // Groupby and aggregate by fieldapi field, and sort by the aggregated
    // field.
    $this->queryResult = $this->factory
      ->getAggregate('entity_test')
      ->groupBy('field_test_1')
      ->sortAggregate('field_test_2', 'COUNT', 'DESC')
      ->execute();
    $this
      ->assertSortedResults(array(
      array(
        'field_test_1' => 2,
        'field_test_2_count' => 3,
      ),
      array(
        'field_test_1' => 1,
        'field_test_2_count' => 2,
      ),
      array(
        'field_test_1' => 3,
        'field_test_2_count' => 1,
      ),
    ));
    $this->queryResult = $this->factory
      ->getAggregate('entity_test')
      ->groupBy('field_test_1')
      ->sortAggregate('field_test_2', 'COUNT', 'ASC')
      ->execute();
    $this
      ->assertSortedResults(array(
      array(
        'field_test_1' => 3,
        'field_test_2_count' => 1,
      ),
      array(
        'field_test_1' => 1,
        'field_test_2_count' => 2,
      ),
      array(
        'field_test_1' => 2,
        'field_test_2_count' => 3,
      ),
    ));
  }
  /**
   * Asserts the results as expected regardless of order between and in rows.
   *
   * @param array $expected
   *   An array of the expected results.
   */
  protected function assertResults($expected, $sorted = FALSE) {
    $found = TRUE;
    $expected_keys = array_keys($expected);
    foreach ($this->queryResult as $key => $row) {
      $keys = $sorted ? array(
        $key,
      ) : $expected_keys;
      foreach ($keys as $key) {
        $expected_row = $expected[$key];
        if (!array_diff_assoc($row, $expected_row) && !array_diff_assoc($expected_row, $row)) {
          continue 2;
        }
      }
      $found = FALSE;
      break;
    }
    return $this
      ->assertTrue($found, strtr('!expected expected, !found found', array(
      '!expected' => print_r($expected, TRUE),
      '!found' => print_r($this->queryResult, TRUE),
    )));
  }
  /**
   * Asserts the results as expected regardless of order in rows.
   *
   * @param array $expected
   *   An array of the expected results.
   */
  protected function assertSortedResults($expected) {
    return $this
      ->assertResults($expected, TRUE);
  }
}Members
| Name   | Modifiers | Type | Description | Overrides | 
|---|---|---|---|---|
| AssertContentTrait:: | protected | property | The current raw content. | |
| AssertContentTrait:: | protected | property | The drupalSettings value from the current raw $content. | |
| AssertContentTrait:: | protected | property | The XML structure parsed from the current raw $content. | 2 | 
| AssertContentTrait:: | protected | property | The plain-text content of raw $content (text nodes). | |
| AssertContentTrait:: | protected | function | Passes if the raw text IS found escaped on the loaded page, fail otherwise. | |
| AssertContentTrait:: | protected | function | Asserts that a field exists with the given name or ID. | |
| AssertContentTrait:: | protected | function | Asserts that a field exists with the given ID and value. | |
| AssertContentTrait:: | protected | function | Asserts that a field exists with the given name and value. | |
| AssertContentTrait:: | protected | function | Asserts that a field exists in the current page by the given XPath. | |
| AssertContentTrait:: | protected | function | Asserts that a checkbox field in the current page is checked. | |
| AssertContentTrait:: | protected | function | Asserts that a field exists in the current page with a given Xpath result. | |
| AssertContentTrait:: | protected | function | Passes if a link with the specified label is found. | |
| AssertContentTrait:: | protected | function | Passes if a link containing a given href (part) is found. | |
| AssertContentTrait:: | protected | function | Asserts that each HTML ID is used for just a single element. | |
| AssertContentTrait:: | protected | function | Passes if the raw text IS NOT found escaped on the loaded page, fail otherwise. | |
| AssertContentTrait:: | protected | function | Asserts that a field does not exist with the given name or ID. | |
| AssertContentTrait:: | protected | function | Asserts that a field does not exist with the given ID and value. | |
| AssertContentTrait:: | protected | function | Asserts that a field does not exist with the given name and value. | |
| AssertContentTrait:: | protected | function | Asserts that a field does not exist or its value does not match, by XPath. | |
| AssertContentTrait:: | protected | function | Asserts that a checkbox field in the current page is not checked. | |
| AssertContentTrait:: | protected | function | Passes if a link with the specified label is not found. | |
| AssertContentTrait:: | protected | function | Passes if a link containing a given href (part) is not found. | |
| AssertContentTrait:: | protected | function | Passes if a link containing a given href is not found in the main region. | |
| AssertContentTrait:: | protected | function | Asserts that a select option in the current page does not exist. | |
| AssertContentTrait:: | protected | function | Asserts that a select option in the current page is not checked. | |
| AssertContentTrait:: | protected | function | Triggers a pass if the perl regex pattern is not found in raw content. | |
| AssertContentTrait:: | protected | function | Passes if the raw text is NOT found on the loaded page, fail otherwise. | |
| AssertContentTrait:: | protected | function | Passes if the page (with HTML stripped) does not contains the text. | |
| AssertContentTrait:: | protected | function | Pass if the page title is not the given string. | |
| AssertContentTrait:: | protected | function | Passes if the text is found MORE THAN ONCE on the text version of the page. | |
| AssertContentTrait:: | protected | function | Asserts that a select option in the current page exists. | |
| AssertContentTrait:: | protected | function | Asserts that a select option in the current page is checked. | |
| AssertContentTrait:: | protected | function | Asserts that a select option in the current page is checked. | |
| AssertContentTrait:: | protected | function | Asserts that a select option in the current page exists. | |
| AssertContentTrait:: | protected | function | Triggers a pass if the Perl regex pattern is found in the raw content. | |
| AssertContentTrait:: | protected | function | Passes if the raw text IS found on the loaded page, fail otherwise. | |
| AssertContentTrait:: | protected | function | Passes if the page (with HTML stripped) contains the text. | |
| AssertContentTrait:: | protected | function | Helper for assertText and assertNoText. | |
| AssertContentTrait:: | protected | function | Asserts that a Perl regex pattern is found in the plain-text content. | |
| AssertContentTrait:: | protected | function | Asserts themed output. | |
| AssertContentTrait:: | protected | function | Pass if the page title is the given string. | |
| AssertContentTrait:: | protected | function | Passes if the text is found ONLY ONCE on the text version of the page. | |
| AssertContentTrait:: | protected | function | Helper for assertUniqueText and assertNoUniqueText. | |
| AssertContentTrait:: | protected | function | Builds an XPath query. | |
| AssertContentTrait:: | protected | function | Helper: Constructs an XPath for the given set of attributes and value. | |
| AssertContentTrait:: | protected | function | Searches elements using a CSS selector in the raw content. | |
| AssertContentTrait:: | protected | function | Get all option elements, including nested options, in a select. | |
| AssertContentTrait:: | protected | function | Gets the value of drupalSettings for the currently-loaded page. | |
| AssertContentTrait:: | protected | function | Gets the current raw content. | |
| AssertContentTrait:: | protected | function | Get the selected value from a select field. | |
| AssertContentTrait:: | protected | function | Retrieves the plain-text content from the current raw content. | |
| AssertContentTrait:: | protected | function | Get the current URL from the cURL handler. | 1 | 
| AssertContentTrait:: | protected | function | Parse content returned from curlExec using DOM and SimpleXML. | |
| AssertContentTrait:: | protected | function | Removes all white-space between HTML tags from the raw content. | |
| AssertContentTrait:: | protected | function | Sets the value of drupalSettings for the currently-loaded page. | |
| AssertContentTrait:: | protected | function | Sets the raw content (e.g. HTML). | |
| AssertContentTrait:: | protected | function | Performs an xpath search on the contents of the internal browser. | |
| AssertHelperTrait:: | protected | function | Casts MarkupInterface objects into strings. | |
| EntityQueryAggregateTest:: | protected | property | The entity_test storage to create the test entities. | |
| EntityQueryAggregateTest:: | public | property | The query factory to create entity queries. | |
| EntityQueryAggregateTest:: | public static | property | Modules to enable. Overrides EntityUnitTestBase:: | |
| EntityQueryAggregateTest:: | protected | property | The actual query result, to compare later. | |
| EntityQueryAggregateTest:: | protected | function | Asserts the results as expected regardless of order between and in rows. | |
| EntityQueryAggregateTest:: | protected | function | Asserts the results as expected regardless of order in rows. | |
| EntityQueryAggregateTest:: | protected | function | Performs setup tasks before each individual test method is run. Overrides EntityUnitTestBase:: | |
| EntityQueryAggregateTest:: | public | function | Test aggregation support. | |
| EntityUnitTestBase:: | protected | property | The entity manager service. | |
| EntityUnitTestBase:: | protected | property | A list of generated identifiers. | |
| EntityUnitTestBase:: | protected | property | The state service. | |
| EntityUnitTestBase:: | protected | function | Creates a user. | |
| EntityUnitTestBase:: | protected | function | Generates a random ID avoiding collisions. | |
| EntityUnitTestBase:: | protected | function | Returns the entity_test hook invocation info. | |
| EntityUnitTestBase:: | protected | function | Installs a module and refreshes services. | |
| EntityUnitTestBase:: | protected | function | Refresh services. | 1 | 
| EntityUnitTestBase:: | protected | function | Reloads the given entity from the storage and returns it. | |
| EntityUnitTestBase:: | protected | function | Uninstalls a module and refreshes services. | |
| KernelTestBase:: | protected | property | The configuration directories for this test run. | |
| KernelTestBase:: | protected | property | A KeyValueMemoryFactory instance to use when building the container. | |
| KernelTestBase:: | private | property | ||
| KernelTestBase:: | protected | property | Array of registered stream wrappers. | |
| KernelTestBase:: | private | property | ||
| KernelTestBase:: | protected | function | Act on global state information before the environment is altered for a test. Overrides TestBase:: | |
| KernelTestBase:: | public | function | Sets up the base service container for this test. | 12 | 
| KernelTestBase:: | protected | function | Provides the data for setting the default language on the container. | 1 | 
| KernelTestBase:: | protected | function | Disables modules for this test. | |
| KernelTestBase:: | protected | function | Enables modules for this test. | |
| KernelTestBase:: | protected | function | Installs default configuration for a given list of modules. | |
| KernelTestBase:: | protected | function | Installs the storage schema for a specific entity type. | |
| KernelTestBase:: | protected | function | Installs a specific table from a module schema definition. | |
| KernelTestBase:: | protected | function | Create and set new configuration directories. | 1 | 
| KernelTestBase:: | protected | function | Registers a stream wrapper for this test. | |
| KernelTestBase:: | protected | function | Renders a render array. | |
| KernelTestBase:: | protected | function | Performs cleanup tasks after each individual test method has been run. Overrides TestBase:: | |
| KernelTestBase:: | function | Constructor for Test. Overrides TestBase:: | ||
| RandomGeneratorTrait:: | protected | property | The random generator. | |
| RandomGeneratorTrait:: | protected | function | Gets the random generator for the utility methods. | |
| RandomGeneratorTrait:: | protected | function | Generates a unique random string containing letters and numbers. | |
| RandomGeneratorTrait:: | public | function | Generates a random PHP object. | |
| RandomGeneratorTrait:: | public | function | Generates a pseudo-random string of ASCII characters of codes 32 to 126. | |
| RandomGeneratorTrait:: | public | function | Callback for random string validation. | |
| SessionTestTrait:: | protected | property | The name of the session cookie. | |
| SessionTestTrait:: | protected | function | Generates a session cookie name. | |
| SessionTestTrait:: | protected | function | Returns the session name in use on the child site. | |
| TestBase:: | protected | property | Assertions thrown in that test case. | |
| TestBase:: | protected | property | The config importer that can used in a test. | 5 | 
| TestBase:: | protected static | property | An array of config object names that are excluded from schema checking. | |
| TestBase:: | protected | property | The dependency injection container used in the test. | |
| TestBase:: | protected | property | The database prefix of this test run. | |
| TestBase:: | public | property | Whether to die in case any test assertion fails. | |
| TestBase:: | protected | property | HTTP authentication credentials (<username>:<password>). | |
| TestBase:: | protected | property | HTTP authentication method (specified as a CURLAUTH_* constant). | |
| TestBase:: | protected | property | The DrupalKernel instance used in the test. | 1 | 
| TestBase:: | protected | property | The original configuration (variables), if available. | |
| TestBase:: | protected | property | The original configuration (variables). | |
| TestBase:: | protected | property | The original configuration directories. | |
| TestBase:: | protected | property | The original container. | |
| TestBase:: | protected | property | The original file directory, before it was changed for testing purposes. | |
| TestBase:: | protected | property | The original language. | |
| TestBase:: | protected | property | The original database prefix when running inside Simpletest. | |
| TestBase:: | protected | property | The original installation profile. | |
| TestBase:: | protected | property | The name of the session cookie of the test-runner. | |
| TestBase:: | protected | property | The settings array. | |
| TestBase:: | protected | property | The original array of shutdown function callbacks. | 1 | 
| TestBase:: | protected | property | The site directory of the original parent site. | |
| TestBase:: | protected | property | The original user, before testing began. | 1 | 
| TestBase:: | protected | property | The private file directory for the test environment. | |
| TestBase:: | protected | property | The public file directory for the test environment. | |
| TestBase:: | public | property | Current results of this test case. | |
| TestBase:: | protected | property | The site directory of this test run. | |
| TestBase:: | protected | property | This class is skipped when looking for the source of an assertion. | |
| TestBase:: | protected | property | Set to TRUE to strict check all configuration saved. | 4 | 
| TestBase:: | protected | property | The temporary file directory for the test environment. | |
| TestBase:: | protected | property | The test run ID. | |
| TestBase:: | protected | property | Time limit for the test. | |
| TestBase:: | protected | property | The translation file directory for the test environment. | |
| TestBase:: | public | property | TRUE if verbose debugging is enabled. | |
| TestBase:: | protected | property | Safe class name for use in verbose output filenames. | |
| TestBase:: | protected | property | Directory where verbose output files are put. | |
| TestBase:: | protected | property | URL to the verbose output file directory. | |
| TestBase:: | protected | property | Incrementing identifier for verbose output filenames. | |
| TestBase:: | protected | function | Internal helper: stores the assert. | |
| TestBase:: | protected | function | Check to see if two values are equal. | |
| TestBase:: | protected | function | Asserts that a specific error has been logged to the PHP error log. | |
| TestBase:: | protected | function | Check to see if a value is false. | |
| TestBase:: | protected | function | Check to see if two values are identical. | |
| TestBase:: | protected | function | Checks to see if two objects are identical. | |
| TestBase:: | protected | function | Asserts that no errors have been logged to the PHP error.log thus far. | |
| TestBase:: | protected | function | Check to see if two values are not equal. | |
| TestBase:: | protected | function | Check to see if two values are not identical. | |
| TestBase:: | protected | function | Check to see if a value is not NULL. | |
| TestBase:: | protected | function | Check to see if a value is NULL. | |
| TestBase:: | protected | function | Check to see if a value is not false. | |
| TestBase:: | private | function | Changes the database connection to the prefixed one. | |
| TestBase:: | protected | function | Checks the matching requirements for Test. | 2 | 
| TestBase:: | protected | function | Configuration accessor for tests. Returns non-overridden configuration. | |
| TestBase:: | public | function | Returns a ConfigImporter object to import test importing of configuration. | 5 | 
| TestBase:: | public | function | Copies configuration objects from source storage to target storage. | |
| TestBase:: | public static | function | Delete an assertion record by message ID. | |
| TestBase:: | protected | function | Fire an error assertion. | 3 | 
| TestBase:: | public | function | Handle errors during test runs. | |
| TestBase:: | protected | function | Handle exceptions. | |
| TestBase:: | protected | function | Fire an assertion that is always negative. | |
| TestBase:: | public static | function | Ensures test files are deletable within file_unmanaged_delete_recursive(). | |
| TestBase:: | public static | function | Converts a list of possible parameters into a stack of permutations. | |
| TestBase:: | protected | function | Cycles through backtrace until the first non-assertion method is found. | |
| TestBase:: | protected | function | Gets the config schema exclusions for this test. | |
| TestBase:: | public static | function | Returns the database connection to the site running Simpletest. | |
| TestBase:: | public | function | Gets the database prefix. | |
| TestBase:: | public | function | Gets the temporary files directory. | |
| TestBase:: | public static | function | Store an assertion from outside the testing context. | |
| TestBase:: | protected | function | Fire an assertion that is always positive. | |
| TestBase:: | private | function | Generates a database prefix for running tests. | |
| TestBase:: | private | function | Prepares the current environment for running the test. | |
| TestBase:: | private | function | Cleans up the test environment and restores the original environment. | |
| TestBase:: | public | function | Run all tests in this class. | 1 | 
| TestBase:: | protected | function | Changes in memory settings. | |
| TestBase:: | protected | function | Helper method to store an assertion record in the configured database. | |
| TestBase:: | protected | function | Logs a verbose message in a text file. | 
