1 database_test.test | DatabaseAlterTestCase::testAlterExpression() |
Test that we can alter expressions in the query.
File
- core/
modules/ simpletest/ tests/ database_test.test, line 2727 - Database tests.
Class
- DatabaseAlterTestCase
- Select alter tests.
Code
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.');
}