public function SchemaTest::testDefaultAfterAlter in Drupal 10

Tests default values after altering table.

File

core/tests/Drupal/KernelTests/Core/Database/SchemaTest.php, line 1393

Class

SchemaTest

Tests table creation and modification via the schema API.

Namespace

Drupal\KernelTests\Core\Database

Code

public function testDefaultAfterAlter() {
  $table_name = 'test_table';

  // Create the table.
  $table_specification = [
    'description' => 'Test table.',
    'fields' => [
      'column1' => [
        'type' => 'int',
        'default' => NULL,
      ],
      'column2' => [
        'type' => 'varchar',
        'length' => 20,
        'default' => NULL,
      ],
      'column3' => [
        'type' => 'int',
        'default' => 200,
      ],
      'column4' => [
        'type' => 'float',
        'default' => 1.23,
      ],
      'column5' => [
        'type' => 'varchar',
        'length' => 20,
        'default' => "'s o'clock'",
      ],
      'column6' => [
        'type' => 'varchar',
        'length' => 20,
        'default' => "o'clock",
      ],
      'column7' => [
        'type' => 'varchar',
        'length' => 20,
        'default' => 'default value',
      ],
    ],
  ];
  $this->schema
    ->createTable($table_name, $table_specification);

  // Insert a row and check that columns have the expected default values.
  $this->connection
    ->insert($table_name)
    ->fields([
    'column1' => 1,
  ])
    ->execute();
  $result = $this->connection
    ->select($table_name, 't')
    ->fields('t', [
    'column2',
    'column3',
    'column4',
    'column5',
    'column6',
    'column7',
  ])
    ->condition('column1', 1)
    ->execute()
    ->fetchObject();
  $this
    ->assertNull($result->column2);
  $this
    ->assertSame('200', $result->column3);
  $this
    ->assertSame('1.23', $result->column4);
  $this
    ->assertSame("'s o'clock'", $result->column5);
  $this
    ->assertSame("o'clock", $result->column6);
  $this
    ->assertSame('default value', $result->column7);

  // Force SQLite schema to create a new table and copy data by adding a not
  // field with an initial value.
  $this->schema
    ->addField('test_table', 'new_column', [
    'type' => 'varchar',
    'length' => 20,
    'not null' => TRUE,
    'description' => 'Added new column',
    'initial' => 'test',
  ]);

  // Test that the columns default values are still correct.
  $this->connection
    ->insert($table_name)
    ->fields([
    'column1' => 2,
    'new_column' => 'value',
  ])
    ->execute();
  $result = $this->connection
    ->select($table_name, 't')
    ->fields('t', [
    'column2',
    'column3',
    'column4',
    'column5',
    'column6',
    'column7',
  ])
    ->condition('column1', 2)
    ->execute()
    ->fetchObject();
  $this
    ->assertNull($result->column2);
  $this
    ->assertSame('200', $result->column3);
  $this
    ->assertSame('1.23', $result->column4);
  $this
    ->assertSame("'s o'clock'", $result->column5);
  $this
    ->assertSame("o'clock", $result->column6);
  $this
    ->assertSame('default value', $result->column7);
}