function BasicSyntaxTest::testAllowSquareBrackets

Tests allowing square brackets in queries.

See also

\Drupal\Core\Database\Connection::prepareQuery()

File

core/tests/Drupal/KernelTests/Core/Database/BasicSyntaxTest.php, line 149

Class

BasicSyntaxTest

Tests SQL syntax interpretation.

Namespace

Code

public function testAllowSquareBrackets() {
    $this->connection
        ->insert('test')
        ->fields([
        'name',
    ])
        ->values([
        'name' => '[square]',
    ])
        ->execute();
    // Note that this is a very bad example query because arguments should be
    // passed in via the $args parameter.
    $result = $this->connection
        ->query("select name from {test} where name = '[square]'", [], [
        'allow_square_brackets' => TRUE,
    ]);
    $this->assertSame('[square]', $result->fetchField());
    // Test that allow_square_brackets has no effect on arguments.
    $result = $this->connection
        ->query("select [name] from {test} where [name] = :value", [
        ':value' => '[square]',
    ]);
    $this->assertSame('[square]', $result->fetchField());
    $result = $this->connection
        ->query("select name from {test} where name = :value", [
        ':value' => '[square]',
    ], [
        'allow_square_brackets' => TRUE,
    ]);
    $this->assertSame('[square]', $result->fetchField());
    // Test square brackets using the query builder.
    $result = $this->connection
        ->select('test')
        ->fields('test', [
        'name',
    ])
        ->condition('name', '[square]')
        ->execute();
    $this->assertSame('[square]', $result->fetchField());
}