public function BasicSyntaxTest::testAllowSquareBrackets in Drupal 9

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

Drupal\KernelTests\Core\Database

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());
}