function FetchTest::testQueryFetchFieldEdgeCases

Tests ::fetchField() for edge values returned.

File

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

Class

FetchTest

Tests the Database system's various fetch capabilities.

Namespace

Code

public function testQueryFetchFieldEdgeCases() : void {
  $this->connection
    ->insert('test_null')
    ->fields([
    'name' => 'Foo',
    'age' => 0,
  ])
    ->execute();
  $this->connection
    ->insert('test_null')
    ->fields([
    'name' => 'Bar',
    'age' => NULL,
  ])
    ->execute();
  $this->connection
    ->insert('test_null')
    ->fields([
    'name' => 'Qux',
    'age' => (int) FALSE,
  ])
    ->execute();
  $statement = $this->connection
    ->select('test_null')
    ->fields('test_null', [
    'age',
  ])
    ->orderBy('id')
    ->execute();
  // First fetch returns '0' since an existing value is always a string.
  $this->assertSame('0', $statement->fetchField());
  // Second fetch returns NULL since NULL was inserted.
  $this->assertNull($statement->fetchField());
  // Third fetch returns '0' since a FALSE bool cast to int was inserted.
  $this->assertSame('0', $statement->fetchField());
  // Fourth fetch returns FALSE since no row was available.
  $this->assertFalse($statement->fetchField());
}