class ReservedWordTest in Drupal 10

Tests queries that include reserved words.

@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\ReservedWordTest

File

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

Namespace

Drupal\KernelTests\Core\Database

class ReservedWordTest extends DatabaseTestBase {

  /**
   * Tests SELECT count query from a table with a reserved name.
   */
  public function testSelectReservedWordTableCount() {
    $query = $this->connection
      ->select('virtual');
    $num_records = $query
      ->countQuery()
      ->execute()
      ->fetchField();
    $this
      ->assertSame('1', $num_records);
  }

  /**
   * Tests SELECT query with a specific field from a table with a reserved name.
   */
  public function testSelectReservedWordTableSpecificField() {
    $query = $this->connection
      ->select('virtual');
    $query
      ->addField('virtual', 'function');
    $rows = $query
      ->execute()
      ->fetchCol();
    $this
      ->assertSame('Function value 1', $rows[0]);
  }

  /**
   * Tests SELECT query with all fields from a table with a reserved name.
   */
  public function testSelectReservedWordTableAllFields() {
    $query = $this->connection
      ->select('virtual');
    $query
      ->fields('virtual');
    $result = $query
      ->execute()
      ->fetchObject();
    $this
      ->assertSame('Function value 1', $result->function);
  }

  /**
   * Tests SELECT count query from a table with a reserved alias.
   */
  public function testSelectReservedWordAliasCount() {
    $query = $this->connection
      ->select('test', 'character');
    $num_records = $query
      ->countQuery()
      ->execute()
      ->fetchField();
    $this
      ->assertSame('4', $num_records);
  }

  /**
   * Tests SELECT query with specific fields from a table with a reserved alias.
   */
  public function testSelectReservedWordAliasSpecificFields() {
    $query = $this->connection
      ->select('test', 'high_priority');
    $query
      ->addField('high_priority', 'name');
    $query
      ->addField('high_priority', 'age', 'age');
    $query
      ->condition('age', 27);
    $record = $query
      ->execute()
      ->fetchObject();

    // Ensure that we got the right record.
    $this
      ->assertSame('George', $record->name);
    $this
      ->assertSame('27', $record->age);
  }

  /**
   * Tests SELECT query with all fields from a table with a reserved alias.
   */
  public function testSelectReservedWordAliasAllFields() {
    $record = $this->connection
      ->select('test', 'signal')
      ->fields('signal')
      ->condition('age', 27)
      ->execute()
      ->fetchObject();

    // Ensure that we got the right record.
    $this
      ->assertSame('George', $record->name);
    $this
      ->assertSame('27', $record->age);
  }

}