function SelectTest::testSimpleSelectMultipleFields
Same name in other branches
- 9 core/tests/Drupal/KernelTests/Core/Database/SelectTest.php \Drupal\KernelTests\Core\Database\SelectTest::testSimpleSelectMultipleFields()
- 8.9.x core/tests/Drupal/KernelTests/Core/Database/SelectTest.php \Drupal\KernelTests\Core\Database\SelectTest::testSimpleSelectMultipleFields()
- 11.x core/tests/Drupal/KernelTests/Core/Database/SelectTest.php \Drupal\KernelTests\Core\Database\SelectTest::testSimpleSelectMultipleFields()
Tests adding multiple fields to a SELECT statement at the same time.
File
-
core/
tests/ Drupal/ KernelTests/ Core/ Database/ SelectTest.php, line 171
Class
- SelectTest
- Tests the Select query builder.
Namespace
Drupal\KernelTests\Core\DatabaseCode
public function testSimpleSelectMultipleFields() : void {
$record = $this->connection
->select('test')
->fields('test', [
'id',
'name',
'age',
'job',
])
->condition('age', 27)
->execute()
->fetchObject();
// Check that all fields we asked for are present.
$this->assertNotNull($record->id, 'ID field is present.');
$this->assertNotNull($record->name, 'Name field is present.');
$this->assertNotNull($record->age, 'Age field is present.');
$this->assertNotNull($record->job, 'Job field is present.');
// Ensure that we got the right record.
// Check that all fields we asked for are present.
$this->assertEquals(2, $record->id, 'ID field has the correct value.');
$this->assertEquals('George', $record->name, 'Name field has the correct value.');
$this->assertEquals(27, $record->age, 'Age field has the correct value.');
$this->assertEquals('Singer', $record->job, 'Job field has the correct value.');
}
Buggy or inaccurate documentation? Please file an issue. Need support? Need help programming? Connect with the Drupal community.