function DatabaseSelectTestCase::testSimpleSelectMultipleFields

Test adding multiple fields to a select statement at the same time.

File

modules/simpletest/tests/database_test.test, line 1597

Class

DatabaseSelectTestCase

Test the SELECT builder.

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.');
}