function QueryGroupByTest::groupByTestHelper

Provides a test helper which runs a view with some aggregation function.

Parameters

string|null $aggregation_function: Which aggregation function should be used, for example sum or count. If NULL is passed the aggregation will be tested with no function.

array $values: The expected views result.

File

core/modules/views/tests/src/Kernel/QueryGroupByTest.php, line 113

Class

QueryGroupByTest

Tests aggregate functionality of views, for example count.

Namespace

Code

public function groupByTestHelper($aggregation_function, $values) {
    $this->setupTestEntities();
    $view = Views::getView('test_group_by_count');
    $view->setDisplay();
    // There is no need for a function in order to have aggregation.
    if (empty($aggregation_function)) {
        // The test table has 2 fields ('id' and 'name'). We'll remove 'id'
        // because it's unique and will test aggregation on 'name'.
        unset($view->displayHandlers
            ->get('default')->options['fields']['id']);
    }
    else {
        $view->displayHandlers
            ->get('default')->options['fields']['id']['group_type'] = $aggregation_function;
    }
    $this->executeView($view);
    $this->assertCount(2, $view->result, 'Make sure the count of items is right.');
    // Group by name to identify the right count.
    $results = [];
    foreach ($view->result as $item) {
        $results[$item->entity_test_name] = $item->id;
    }
    $aggregation_function ??= 'NULL';
    $this->assertEquals($values[0], $results['name1'], "Aggregation with {$aggregation_function} and groupby name: name1 returned the expected amount of results");
    $this->assertEquals($values[1], $results['name2'], "Aggregation with {$aggregation_function} and groupby name: name2 returned the expected amount of results");
}