Drupal 8  8.0.2
SelectComplexTest Class Reference
Inheritance diagram for SelectComplexTest:

Public Member Functions

 testDefaultJoin ()
 
 testLeftOuterJoin ()
 
 testGroupBy ()
 
 testGroupByAndHaving ()
 
 testRange ()
 
 testDistinct ()
 
 testCountQuery ()
 
 testHavingCountQuery ()
 
 testCountQueryRemovals ()
 
 testCountQueryFieldRemovals ()
 
 testCountQueryDistinct ()
 
 testCountQueryGroupBy ()
 
 testNestedConditions ()
 
 testJoinTwice ()
 
 testJoinSubquery ()
 
 testSelectWithRowCount ()
 
- Public Member Functions inherited from DatabaseTestBase
 ensureSampleDataNull ()
 

Static Public Attributes

static $modules = array('system', 'user', 'node_access_test', 'field')
 
- Static Public Attributes inherited from DatabaseTestBase
static $modules = array('database_test')
 

Additional Inherited Members

- Static Public Member Functions inherited from DatabaseTestBase
static addSampleData ()
 
- Protected Member Functions inherited from DatabaseTestBase
 setUp ()
 

Detailed Description

Tests the Select query builder with more complex queries.

Database

Member Function Documentation

testCountQuery ( )

Tests that we can generate a count query from a built query.

References db_select().

Here is the call graph for this function:

testCountQueryDistinct ( )

Tests that we can generate a count query from a query with distinct.

References db_select().

Here is the call graph for this function:

testCountQueryFieldRemovals ( )

Tests that countQuery properly removes fields and expressions.

References db_select().

Here is the call graph for this function:

testCountQueryGroupBy ( )

Tests that we can generate a count query from a query with GROUP BY.

References db_select().

Here is the call graph for this function:

testCountQueryRemovals ( )

Tests that countQuery removes 'all_fields' statements and ordering clauses.

References db_select(), and Database\getConnection().

Here is the call graph for this function:

testDefaultJoin ( )

Tests simple JOIN statements.

References db_select().

Here is the call graph for this function:

testDistinct ( )

Tests distinct queries.

References db_select().

Here is the call graph for this function:

testGroupBy ( )

Tests GROUP BY clauses.

References db_select(), and format_string().

Here is the call graph for this function:

testGroupByAndHaving ( )

Tests GROUP BY and HAVING clauses together.

References db_select(), and format_string().

Here is the call graph for this function:

testHavingCountQuery ( )

Tests having queries.

References db_select().

Here is the call graph for this function:

testJoinSubquery ( )

Tests that we can join on a query.

References db_select().

Here is the call graph for this function:

testJoinTwice ( )

Confirms we can join on a single table twice with a dynamic alias.

References db_select().

Here is the call graph for this function:

testLeftOuterJoin ( )

Tests LEFT OUTER joins.

References db_select().

Here is the call graph for this function:

testNestedConditions ( )

Confirms that we can properly nest conditional clauses.

References db_or(), and db_select().

Here is the call graph for this function:

testRange ( )

Tests range queries.

The SQL clause varies with the database.

References db_select().

Here is the call graph for this function:

testSelectWithRowCount ( )

Tests that rowCount() throws exception on SELECT query.

References db_select().

Here is the call graph for this function:


The documentation for this class was generated from the following file: