function MenuTreeStorageSchemaUpdateTest::testSchemaLengthAfterUpdate

Tests DB behavior after update.

File

core/modules/system/tests/src/Functional/Update/MenuTreeStorageSchemaUpdateTest.php, line 46

Class

MenuTreeStorageSchemaUpdateTest

Tests update of menu tree storage fields.

Namespace

Code

public function testSchemaLengthAfterUpdate() : void {
  if (\Drupal::service('database')->databaseType() == 'sqlite') {
    $this->markTestSkipped("This test does not support the SQLite database driver.");
  }
  $results = $this->connection
    ->query('SELECT CHARACTER_MAXIMUM_LENGTH FROM INFORMATION_SCHEMA.COLUMNS WHERE table_name = :menu AND COLUMN_NAME IN ( :column_names[] )', [
    ':menu' => $this->connection
      ->schema()
      ->prefixNonTable('menu_tree'),
    ':column_names[]' => [
      'route_param_key',
      'url',
    ],
  ])
    ->fetchCol();
  $this->assertNotEmpty($results);
  foreach ($results as $result) {
    self::assertEquals(255, $result);
  }
  $this->runUpdates();
  $results = $this->connection
    ->query('SELECT CHARACTER_MAXIMUM_LENGTH FROM INFORMATION_SCHEMA.COLUMNS WHERE table_name = :menu AND COLUMN_NAME IN ( :column_names[] )', [
    ':menu' => $this->connection
      ->schema()
      ->prefixNonTable('menu_tree'),
    ':column_names[]' => [
      'route_param_key',
      'url',
    ],
  ])
    ->fetchCol();
  $this->assertNotEmpty($results);
  foreach ($results as $result) {
    self::assertEquals(2048, $result);
  }
}