class SqlModeTest in Drupal 10

Tests compatibility of the MySQL driver with various sql_mode options.

@group Database

Hierarchy

• class \Drupal\KernelTests\KernelTestBase extends \PHPUnit\Framework\TestCase implements ServiceProviderInterface uses \Drupal\Tests\PhpUnitCompatibilityTrait, \Symfony\Bridge\PhpUnit\ExpectDeprecationTrait, AssertContentTrait, ConfigTestTrait, ExtensionListTestTrait, RandomGeneratorTrait, TestRequirementsTrait, PhpUnitWarnings
  • class \Drupal\KernelTests\Core\Database\DatabaseTestBase
    • class \Drupal\KernelTests\Core\Database\SqlModeTest

File

core/tests/Drupal/KernelTests/Core/Database/SqlModeTest.php, line 10

Namespace

Drupal\KernelTests\Core\Database

class SqlModeTest extends DatabaseTestBase {

  /**
   * {@inheritdoc}
   */
  protected function setUp() : void {
    parent::setUp();
    if ($this->connection
      ->databaseType() !== 'mysql') {
      $this
        ->markTestSkipped("Skipping test since sql_mode is a MySQL-only feature.");
    }
  }

  /**
   * Tests quoting identifiers in queries.
   */
  public function testQuotingIdentifiers() {

    // Use SQL-reserved words for both the table and column names.
    $query = $this->connection
      ->query('SELECT [update] FROM {select}');
    $this
      ->assertEquals('Update value 1', $query
      ->fetchObject()->update);
    $this
      ->assertStringContainsString('SELECT `update` FROM `', $query
      ->getQueryString());
  }

  /**
   * {@inheritdoc}
   */
  protected function getDatabaseConnectionInfo() {
    $info = parent::getDatabaseConnectionInfo();

    // This runs during setUp(), so is not yet skipped for non MySQL databases.
    // We defer skipping the test to later in setUp(), so that that can be
    // based on databaseType() rather than 'driver', but here all we have to go
    // on is 'driver'.
    if ($info['default']['driver'] === 'mysql') {
      $info['default']['init_commands']['sql_mode'] = "SET sql_mode = ''";
    }
    return $info;
  }

}