InstallerIsolationLevelNoDatabaseSettingsTest.php

<?php

declare (strict_types=1);
namespace Drupal\Tests\mysql\Functional;

use Drupal\Core\Database\Database;
use Drupal\FunctionalTests\Installer\InstallerTestBase;

/**
 * Tests the isolation_level setting with no database settings.
 *
 * @group Installer
 */
class InstallerIsolationLevelNoDatabaseSettingsTest extends InstallerTestBase {
  
  /**
   * {@inheritdoc}
   */
  protected $defaultTheme = 'stark';
  
  /**
   * {@inheritdoc}
   */
  protected function prepareEnvironment() {
    parent::prepareEnvironment();
    // The isolation_level option is only available for MySQL.
    $connection_info = Database::getConnectionInfo();
    if ($connection_info['default']['driver'] !== 'mysql') {
      $this->markTestSkipped("This test does not support the {$connection_info['default']['driver']} database driver.");
    }
  }
  
  /**
   * Verifies that the isolation_level was added to the database settings.
   */
  public function testInstaller() : void {
    $contents = file_get_contents($this->container
      ->getParameter('app.root') . '/' . $this->siteDirectory . '/settings.php');
    // Test that isolation_level was set to "READ COMMITTED".
    $this->assertStringContainsString("'isolation_level' => 'READ COMMITTED',", $contents);
    // Change the default database connection to use the isolation level from
    // the test.
    $connection_info = Database::getConnectionInfo();
    $driver_test_connection = $connection_info['default'];
    // We have asserted that the isolation level was set to 'READ COMMITTED'.
    $driver_test_connection['isolation_level'] = 'READ COMMITTED';
    unset($driver_test_connection['init_commands']);
    Database::renameConnection('default', 'original_database_connection');
    Database::addConnectionInfo('default', 'default', $driver_test_connection);
    // Close and reopen the database connection, so the database init commands
    // get executed.
    Database::closeConnection('default', 'default');
    $connection = Database::getConnection('default', 'default');
    $query = 'SELECT @@SESSION.tx_isolation';
    // The database variable "tx_isolation" has been removed in MySQL v8.0 and
    // has been replaced by "transaction_isolation".
    // @see https://dev.mysql.com/doc/refman/5.7/en/server-system-variables.html#sysvar_tx_isolation
    if (!$connection->isMariaDb() && version_compare($connection->version(), '8.0.0-AnyName', '>')) {
      $query = 'SELECT @@SESSION.transaction_isolation';
    }
    // Test that transaction level is READ-COMMITTED.
    $this->assertEquals('READ-COMMITTED', $connection->query($query)
      ->fetchField());
    // Restore the old database connection.
    Database::addConnectionInfo('default', 'default', $connection_info['default']);
    Database::closeConnection('default', 'default');
    Database::getConnection('default', 'default');
  }

}