InsertDefaultsTest.php

Same filename in other branches
  1. 9 core/tests/Drupal/KernelTests/Core/Database/InsertDefaultsTest.php
  2. 8.9.x core/tests/Drupal/KernelTests/Core/Database/InsertDefaultsTest.php
  3. 10 core/tests/Drupal/KernelTests/Core/Database/InsertDefaultsTest.php

Namespace

Drupal\KernelTests\Core\Database

File

core/tests/Drupal/KernelTests/Core/Database/InsertDefaultsTest.php

View source
<?php

declare (strict_types=1);
namespace Drupal\KernelTests\Core\Database;

use Drupal\Core\Database\Query\NoFieldsException;

/**
 * Tests the Insert query builder with default values.
 *
 * @group Database
 */
class InsertDefaultsTest extends DatabaseTestBase {
    
    /**
     * Tests that we can run a query that uses default values for everything.
     *
     * @see \database_test_schema()
     */
    public function testDefaultInsert() : void {
        $query = $this->connection
            ->insert('test')
            ->useDefaults([
            'job',
        ]);
        $id = $query->execute();
        $job = $this->connection
            ->query('SELECT [job] FROM {test} WHERE [id] = :id', [
            ':id' => $id,
        ])
            ->fetchField();
        $this->assertSame('Undefined', $job, 'Default field value is set.');
    }
    
    /**
     * Tests that no action will be preformed if no fields are specified.
     */
    public function testDefaultEmptyInsert() : void {
        $num_records_before = (int) $this->connection
            ->query('SELECT COUNT(*) FROM {test}')
            ->fetchField();
        try {
            $this->connection
                ->insert('test')
                ->execute();
            // This is only executed if no exception has been thrown.
            $this->fail('Expected exception NoFieldsException has not been thrown.');
        } catch (NoFieldsException) {
            // Expected exception; just continue testing.
        }
        $num_records_after = (int) $this->connection
            ->query('SELECT COUNT(*) FROM {test}')
            ->fetchField();
        $this->assertSame($num_records_before, $num_records_after, 'Do nothing as no fields are specified.');
    }
    
    /**
     * Tests that we can insert fields with values and defaults in the same query.
     *
     * @see \database_test_schema()
     */
    public function testDefaultInsertWithFields() : void {
        $query = $this->connection
            ->insert('test')
            ->fields([
            'name' => 'Bob',
        ])
            ->useDefaults([
            'job',
        ]);
        $id = $query->execute();
        $job = $this->connection
            ->query('SELECT [job] FROM {test} WHERE [id] = :id', [
            ':id' => $id,
        ])
            ->fetchField();
        $this->assertSame('Undefined', $job, 'Default field value is set.');
    }

}

Classes

Title Deprecated Summary
InsertDefaultsTest Tests the Insert query builder with default values.

Buggy or inaccurate documentation? Please file an issue. Need support? Need help programming? Connect with the Drupal community.