function DatabaseSelectTestCase::testSimpleSelectExpression in Drupal 7
Test SELECT statements with expressions.
File
- modules/
simpletest/ tests/ database_test.test, line 1489
Class
- DatabaseSelectTestCase
- Test the SELECT builder.
Code
function testSimpleSelectExpression() {
$query = db_select('test');
$name_field = $query
->addField('test', 'name');
$age_field = $query
->addExpression("age*2", 'double_age');
$query
->condition('age', 27);
$result = $query
->execute();
// Check that the aliases are being created the way we want.
$this
->assertEqual($name_field, 'name', 'Name field alias is correct.');
$this
->assertEqual($age_field, 'double_age', 'Age field alias is correct.');
// 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 * 2, 'Fetched age expression is correct.');
}