function SelectTest::testSimpleSelectMultipleFields in Zircon Profile 8

Same name and namespace in other branches

1. 8.0 core/modules/system/src/Tests/Database/SelectTest.php \Drupal\system\Tests\Database\SelectTest::testSimpleSelectMultipleFields()

Tests adding multiple fields to a SELECT statement at the same time.

File

core/modules/system/src/Tests/Database/SelectTest.php, line 169

Contains \Drupal\system\Tests\Database\SelectTest.

Class

SelectTest

Tests the Select query builder.

Namespace

Drupal\system\Tests\Database

Code

function testSimpleSelectMultipleFields() {
  $record = db_select('test')
    ->fields('test', array(
    '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
    ->assertEqual($record->id, 2, 'ID field has the correct value.');
  $this
    ->assertEqual($record->name, 'George', 'Name field has the correct value.');
  $this
    ->assertEqual($record->age, 27, 'Age field has the correct value.');
  $this
    ->assertEqual($record->job, 'Singer', 'Job field has the correct value.');
}