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,
        ]));
    }
}