function FetchTest::testQueryFetchField

Tests ::fetchField().

File

core/tests/Drupal/KernelTests/Core/Database/FetchTest.php, line 196

Class

FetchTest

Tests the Database system's various fetch capabilities.

Namespace

Code

public function testQueryFetchField() : void {
    $this->connection
        ->insert('test')
        ->fields([
        'name' => 'Foo',
        'age' => 0,
        'job' => 'Dummy',
    ])
        ->execute();
    $this->connection
        ->insert('test')
        ->fields([
        'name' => 'Kurt',
        'age' => 27,
        'job' => 'Singer',
    ])
        ->execute();
    $expectedResults = [
        '25',
        '27',
        '28',
        '26',
        '0',
        '27',
    ];
    $statement = $this->connection
        ->select('test')
        ->fields('test', [
        'age',
    ])
        ->orderBy('id')
        ->execute();
    $actualResults = [];
    while (TRUE) {
        $result = $statement->fetchField();
        if ($result === FALSE) {
            break;
        }
        $this->assertIsNumeric($result);
        $actualResults[] = $result;
    }
    $this->assertSame($expectedResults, $actualResults);
}