function SelectTest::testSimpleSelectConditional in Zircon Profile 8
Same name and namespace in other branches
- 8.0 core/modules/system/src/Tests/Database/SelectTest.php \Drupal\system\Tests\Database\SelectTest::testSimpleSelectConditional()
Tests basic conditionals on SELECT statements.
File
- core/
modules/ system/ src/ Tests/ Database/ SelectTest.php, line 107 - Contains \Drupal\system\Tests\Database\SelectTest.
Class
- SelectTest
- Tests the Select query builder.
Namespace
Drupal\system\Tests\DatabaseCode
function testSimpleSelectConditional() {
$query = db_select('test');
$name_field = $query
->addField('test', 'name');
$age_field = $query
->addField('test', 'age', '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, '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, 'Fetched age is correct.');
}