function ConnectionTest::testPostgresqlReservedWords

Test the escapeTable(), escapeField() and escapeAlias() methods with all possible reserved words in PostgreSQL.

File

core/tests/Drupal/KernelTests/Core/Database/ConnectionTest.php, line 147

Class

ConnectionTest

Tests of the core database system.

Namespace

Code

public function testPostgresqlReservedWords() {
  if (Database::getConnection()->databaseType() !== 'pgsql') {
    $this->markTestSkipped("This test only runs for PostgreSQL");
  }
  $db = Database::getConnection('default', 'default');
  $stmt = $db->query("SELECT word FROM pg_get_keywords() WHERE catcode IN ('R', 'T')");
  $stmt->execute();
  foreach ($stmt->fetchAllAssoc('word') as $word => $row) {
    $expected = '"' . $word . '"';
    $this->assertIdentical($db->escapeTable($word), $expected, new FormattableMarkup('The reserved word %word was correctly escaped when used as a table name.', [
      '%word' => $word,
    ]));
    $this->assertIdentical($db->escapeField($word), $expected, new FormattableMarkup('The reserved word %word was correctly escaped when used as a column name.', [
      '%word' => $word,
    ]));
    $this->assertIdentical($db->escapeAlias($word), $expected, new FormattableMarkup('The reserved word %word was correctly escaped when used as an alias.', [
      '%word' => $word,
    ]));
  }
}