function FetchTest::testQueryFetchClasstype

Confirms that we can fetch a record into a new instance of a custom class.

The name of the class is determined from a value of the first column.

@group legacy

See also

\Drupal\Tests\system\Functional\Database\FakeRecord

File

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

Class

FetchTest

Tests the Database system's various fetch capabilities.

Namespace

Code

public function testQueryFetchClasstype() : void {
    $this->expectDeprecation('Fetch mode FETCH_CLASS | FETCH_CLASSTYPE is deprecated in drupal:10.2.0 and is removed from drupal:11.0.0. Use supported modes only. See https://www.drupal.org/node/3377999');
    $records = [];
    $result = $this->connection
        ->query('SELECT [classname], [name], [job] FROM {test_classtype} WHERE [age] = :age', [
        ':age' => 26,
    ], [
        'fetch' => \PDO::FETCH_CLASS | \PDO::FETCH_CLASSTYPE,
    ]);
    foreach ($result as $record) {
        $records[] = $record;
        $this->assertInstanceOf(FakeRecord::class, $record);
        $this->assertSame('Kay', $record->name);
        $this->assertSame('Web Developer', $record->job);
        $this->assertFalse(isset($record->classname), 'Classname field not found, as intended.');
    }
    $this->assertCount(1, $records, 'There is only one record.');
}