function ViewsQueryGroupByTest::testGroupByCountOnlyFilters

File

tests/views_groupby.test, line 364

Class

ViewsQueryGroupByTest

Tests aggregate functionality of views, for example count.

Code

public function testGroupByCountOnlyFilters() {
    // Check if GROUP BY and HAVING are included when a view
    // Doesn't display SUM, COUNT, MAX... functions in SELECT statment.
    $type1 = $this->drupalCreateContentType();
    $node_1 = array(
        'type' => $type1->type,
    );
    for ($x = 0; $x < 10; $x++) {
        $this->drupalCreateNode($node_1);
    }
    $view = $this->viewsGroupByCountViewOnlyFilters();
    $view->execute_display();
    $this->assertTrue(strpos($view->build_info['query'], 'GROUP BY'), t('Make sure that GROUP BY is in the query'));
    $this->assertTrue(strpos($view->build_info['query'], 'HAVING'), t('Make sure that HAVING is in the query'));
}