function SchemaTest::testIntrospectIndexSchema

@covers \Drupal\pgsql\Driver\Database\pgsql\Schema::introspectIndexSchema

File

core/modules/pgsql/tests/src/Kernel/pgsql/SchemaTest.php, line 68

Class

SchemaTest

Tests schema API for the PostgreSQL driver.

Namespace

Code

public function testIntrospectIndexSchema() : void {
  $table_specification = [
    'fields' => [
      'id' => [
        'type' => 'int',
        'not null' => TRUE,
        'default' => 0,
      ],
      'test_field_1' => [
        'type' => 'int',
        'not null' => TRUE,
        'default' => 0,
      ],
      'test_field_2' => [
        'type' => 'int',
        'default' => 0,
      ],
      'test_field_3' => [
        'type' => 'int',
        'default' => 0,
      ],
      'test_field_4' => [
        'type' => 'int',
        'default' => 0,
      ],
      'test_field_5' => [
        'type' => 'int',
        'default' => 0,
      ],
    ],
    'primary key' => [
      'id',
      'test_field_1',
    ],
    'unique keys' => [
      'test_field_2' => [
        'test_field_2',
      ],
      'test_field_3_test_field_4' => [
        'test_field_3',
        'test_field_4',
      ],
    ],
    'indexes' => [
      'test_field_4' => [
        'test_field_4',
      ],
      'test_field_4_test_field_5' => [
        'test_field_4',
        'test_field_5',
      ],
    ],
  ];
  $table_name = strtolower($this->getRandomGenerator()
    ->name());
  $this->schema
    ->createTable($table_name, $table_specification);
  unset($table_specification['fields']);
  $introspect_index_schema = new \ReflectionMethod(get_class($this->schema), 'introspectIndexSchema');
  $index_schema = $introspect_index_schema->invoke($this->schema, $table_name);
  // The PostgreSQL driver is using a custom naming scheme for its indexes, so
  // we need to adjust the initial table specification.
  $ensure_identifier_length = new \ReflectionMethod(get_class($this->schema), 'ensureIdentifiersLength');
  foreach ($table_specification['unique keys'] as $original_index_name => $columns) {
    unset($table_specification['unique keys'][$original_index_name]);
    $new_index_name = $ensure_identifier_length->invoke($this->schema, $table_name, $original_index_name, 'key');
    $table_specification['unique keys'][$new_index_name] = $columns;
  }
  foreach ($table_specification['indexes'] as $original_index_name => $columns) {
    unset($table_specification['indexes'][$original_index_name]);
    $new_index_name = $ensure_identifier_length->invoke($this->schema, $table_name, $original_index_name, 'idx');
    $table_specification['indexes'][$new_index_name] = $columns;
  }
  $this->assertEquals($table_specification, $index_schema);
}