Tests alter queries.
Expanded class hierarchy of AlterTest
class AlterTest extends DatabaseTestBase {
public static function getInfo() {
return array(
'name' => 'Query altering tests',
'description' => 'Test the hook_query_alter capabilities of the Select builder.',
'group' => 'Database',
);
}
/**
* Tests that we can do basic alters.
*/
function testSimpleAlter() {
$query = db_select('test');
$query
->addField('test', 'name');
$query
->addField('test', 'age', 'age');
$query
->addTag('database_test_alter_add_range');
$result = $query
->execute();
$num_records = 0;
foreach ($result as $record) {
$num_records++;
}
$this
->assertEqual($num_records, 2, 'Returned the correct number of rows.');
}
/**
* Tests that we can alter the joins on a query.
*/
function testAlterWithJoin() {
$query = db_select('test_task');
$tid_field = $query
->addField('test_task', 'tid');
$task_field = $query
->addField('test_task', 'task');
$query
->orderBy($task_field);
$query
->addTag('database_test_alter_add_join');
$result = $query
->execute();
$records = $result
->fetchAll();
$this
->assertEqual(count($records), 2, 'Returned the correct number of rows.');
$this
->assertEqual($records[0]->name, 'George', 'Correct data retrieved.');
$this
->assertEqual($records[0]->{$tid_field}, 4, 'Correct data retrieved.');
$this
->assertEqual($records[0]->{$task_field}, 'sing', 'Correct data retrieved.');
$this
->assertEqual($records[1]->name, 'George', 'Correct data retrieved.');
$this
->assertEqual($records[1]->{$tid_field}, 5, 'Correct data retrieved.');
$this
->assertEqual($records[1]->{$task_field}, 'sleep', 'Correct data retrieved.');
}
/**
* Tests that we can alter a query's conditionals.
*/
function testAlterChangeConditional() {
$query = db_select('test_task');
$tid_field = $query
->addField('test_task', 'tid');
$pid_field = $query
->addField('test_task', 'pid');
$task_field = $query
->addField('test_task', 'task');
$people_alias = $query
->join('test', 'people', "test_task.pid = people.id");
$name_field = $query
->addField($people_alias, 'name', 'name');
$query
->condition('test_task.tid', '1');
$query
->orderBy($tid_field);
$query
->addTag('database_test_alter_change_conditional');
$result = $query
->execute();
$records = $result
->fetchAll();
$this
->assertEqual(count($records), 1, 'Returned the correct number of rows.');
$this
->assertEqual($records[0]->{$name_field}, 'John', 'Correct data retrieved.');
$this
->assertEqual($records[0]->{$tid_field}, 2, 'Correct data retrieved.');
$this
->assertEqual($records[0]->{$pid_field}, 1, 'Correct data retrieved.');
$this
->assertEqual($records[0]->{$task_field}, 'sleep', 'Correct data retrieved.');
}
/**
* Tests that we can alter the fields of a query.
*/
function testAlterChangeFields() {
$query = db_select('test');
$name_field = $query
->addField('test', 'name');
$age_field = $query
->addField('test', 'age', 'age');
$query
->orderBy('name');
$query
->addTag('database_test_alter_change_fields');
$record = $query
->execute()
->fetch();
$this
->assertEqual($record->{$name_field}, 'George', 'Correct data retrieved.');
$this
->assertFalse(isset($record->{$age_field}), 'Age field not found, as intended.');
}
/**
* Tests that we can alter expressions in the query.
*/
function testAlterExpression() {
$query = db_select('test');
$name_field = $query
->addField('test', 'name');
$age_field = $query
->addExpression("age*2", 'double_age');
$query
->condition('age', 27);
$query
->addTag('database_test_alter_change_expressions');
$result = $query
->execute();
// Ensure that we got the right record.
$record = $result
->fetch();
$this
->assertEqual($record->{$name_field}, 'George', 'Fetched name is correct.');
$this
->assertEqual($record->{$age_field}, 27 * 3, 'Fetched age expression is correct.');
}
/**
* Tests that we can remove a range() value from a query.
*
* This also tests hook_query_TAG_alter().
*/
function testAlterRemoveRange() {
$query = db_select('test');
$query
->addField('test', 'name');
$query
->addField('test', 'age', 'age');
$query
->range(0, 2);
$query
->addTag('database_test_alter_remove_range');
$num_records = count($query
->execute()
->fetchAll());
$this
->assertEqual($num_records, 4, 'Returned the correct number of rows.');
}
/**
* Tests that we can do basic alters on subqueries.
*/
function testSimpleAlterSubquery() {
// Create a sub-query with an alter tag.
$subquery = db_select('test', 'p');
$subquery
->addField('p', 'name');
$subquery
->addField('p', 'id');
// Pick out George.
$subquery
->condition('age', 27);
$subquery
->addExpression("age*2", 'double_age');
// This query alter should change it to age * 3.
$subquery
->addTag('database_test_alter_change_expressions');
// Create a main query and join to sub-query.
$query = db_select('test_task', 'tt');
$query
->join($subquery, 'pq', 'pq.id = tt.pid');
$age_field = $query
->addField('pq', 'double_age');
$name_field = $query
->addField('pq', 'name');
$record = $query
->execute()
->fetch();
$this
->assertEqual($record->{$name_field}, 'George', 'Fetched name is correct.');
$this
->assertEqual($record->{$age_field}, 27 * 3, 'Fetched age expression is correct.');
}
}
Name | Modifiers | Type | Description | Overrides |
---|---|---|---|---|
AlterTest:: |
public static | function | ||
AlterTest:: |
function | Tests that we can do basic alters. | ||
AlterTest:: |
function | Tests that we can alter the joins on a query. | ||
AlterTest:: |
function | Tests that we can alter a query's conditionals. | ||
AlterTest:: |
function | Tests that we can alter the fields of a query. | ||
AlterTest:: |
function | Tests that we can alter expressions in the query. | ||
AlterTest:: |
function | Tests that we can remove a range() value from a query. | ||
AlterTest:: |
function | Tests that we can do basic alters on subqueries. | ||
DatabaseTestBase:: |
function |
Sets up Drupal unit test environment. Overrides DrupalUnitTestBase:: |
||
DatabaseTestBase:: |
function | Sets up tables for NULL handling. | ||
DatabaseTestBase:: |
static | function | Sets up our sample data. | |
DrupalUnitTestBase:: |
function |
Overrides \Drupal\simpletest\UnitTestBase::__construct(). Overrides UnitTestBase:: |
||
DrupalUnitTestBase:: |
protected | function |
Deletes created files, database tables, and reverts all environment changes. Overrides TestBase:: |
2 |
DrupalUnitTestBase:: |
public | function | Sets up the base service container for this test. | 1 |
DrupalUnitTestBase:: |
protected | function | Installs default configuration for a given list of modules. | |
DrupalUnitTestBase:: |
protected | function | Installs a specific table from a module schema definition. | |
DrupalUnitTestBase:: |
protected | function | Enables modules for this test. | |
DrupalUnitTestBase:: |
protected | function | Disables modules for this test. | |
TestBase:: |
protected | function | Checks the matching requirements for Test. | 4 |
TestBase:: |
protected | function | Internal helper: stores the assert. | |
TestBase:: |
public static | function | Store an assertion from outside the testing context. | |
TestBase:: |
public static | function | Delete an assertion record by message ID. | |
TestBase:: |
public static | function | Returns the database connection to the site running Simpletest. | |
TestBase:: |
protected | function | Cycles through backtrace until the first non-assertion method is found. | |
TestBase:: |
protected | function | Check to see if a value is not false (not an empty string, 0, NULL, or FALSE). | |
TestBase:: |
protected | function | Check to see if a value is false (an empty string, 0, NULL, or FALSE). | |
TestBase:: |
protected | function | Check to see if a value is NULL. | |
TestBase:: |
protected | function | Check to see if a value is not NULL. | |
TestBase:: |
protected | function | Check to see if two values are equal. | |
TestBase:: |
protected | function | Check to see if two values are not equal. | |
TestBase:: |
protected | function | Check to see if two values are identical. | |
TestBase:: |
protected | function | Check to see if two values are not identical. | |
TestBase:: |
protected | function | Checks to see if two objects are identical. | |
TestBase:: |
protected | function | Fire an assertion that is always positive. | |
TestBase:: |
protected | function | Fire an assertion that is always negative. | |
TestBase:: |
protected | function | Fire an error assertion. | 1 |
TestBase:: |
protected | function | Logs verbose message in a text file. | |
TestBase:: |
public | function | Run all tests in this class. | |
TestBase:: |
protected | function | Generates a database prefix for running tests. | |
TestBase:: |
protected | function | Changes the database connection to the prefixed one. | |
TestBase:: |
protected | function | Prepares the current environment for running the test. | |
TestBase:: |
protected | function | Create and set new configuration directories. | 1 |
TestBase:: |
protected | function | Rebuild drupal_container(). | 1 |
TestBase:: |
public | function | Handle errors during test runs. | |
TestBase:: |
protected | function | Handle exceptions. | |
TestBase:: |
protected | function | Changes in memory settings. | |
TestBase:: |
public static | function | Generates a random string of ASCII characters of codes 32 to 126. | |
TestBase:: |
public static | function | Generates a random string containing letters and numbers. | |
TestBase:: |
public static | function | Generates a random PHP object. | |
TestBase:: |
public static | function | Converts a list of possible parameters into a stack of permutations. | |
TestBase:: |
public static | function | Ensures test files are deletable within file_unmanaged_delete_recursive(). | |
TestBase:: |
public | function | Returns a ConfigImporter object to import test importing of configuration. | 1 |
TestBase:: |
public | function | Copies configuration objects from source storage to target storage. | |
DatabaseTestBase:: |
public static | property |
Modules to enable. Overrides DrupalUnitTestBase:: |
3 |
DrupalUnitTestBase:: |
private | property | ||
DrupalUnitTestBase:: |
private | property | ||
DrupalUnitTestBase:: |
private | property | ||
DrupalUnitTestBase:: |
protected | property | A KeyValueMemoryFactory instance to use when building the container. | |
UnitTestBase:: |
protected | property | ||
TestBase:: |
protected | property | The test run ID. | |
TestBase:: |
protected | property | The database prefix of this test run. | |
TestBase:: |
protected | property | The original file directory, before it was changed for testing purposes. | |
TestBase:: |
protected | property | Time limit for the test. | |
TestBase:: |
public | property | Current results of this test case. | |
TestBase:: |
protected | property | Assertions thrown in that test case. | |
TestBase:: |
protected | property | This class is skipped when looking for the source of an assertion. | |
TestBase:: |
protected | property | Flag to indicate whether the test has been set up. | |
TestBase:: |
protected | property | ||
TestBase:: |
protected | property | ||
TestBase:: |
protected | property | TRUE if verbose debugging is enabled. | |
TestBase:: |
protected | property | Incrementing identifier for verbose output filenames. | |
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 | The original database prefix when running inside Simpletest. | |
TestBase:: |
protected | property | URL to the verbose output file directory. | |
TestBase:: |
protected | property | The settings array. | |
TestBase:: |
protected | property | The public file directory for the test environment. | |
TestBase:: |
public | property | Whether to die in case any test assertion fails. | |
TestBase:: |
protected | property | The dependency injection container used in the test. | 1 |
TestBase:: |
protected | property | The config importer that can used in a test. | 1 |