You are here

public function OrderByTest::testFieldEscaping in Drupal driver for SQL Server and SQL Azure 3.1.x

Same name and namespace in other branches
  1. 8.2 tests/src/Unit/OrderByTest.php \Drupal\Tests\sqlsrv\Unit\OrderByTest::testFieldEscaping()
  2. 4.2.x tests/src/Unit/OrderByTest.php \Drupal\Tests\sqlsrv\Unit\OrderByTest::testFieldEscaping()
  3. 3.0.x tests/src/Unit/OrderByTest.php \Drupal\Tests\sqlsrv\Unit\OrderByTest::testFieldEscaping()
  4. 4.0.x tests/src/Unit/OrderByTest.php \Drupal\Tests\sqlsrv\Unit\OrderByTest::testFieldEscaping()
  5. 4.1.x tests/src/Unit/OrderByTest.php \Drupal\Tests\sqlsrv\Unit\OrderByTest::testFieldEscaping()

Tests that fields passed for ordering get escaped properly.

File

tests/src/Unit/OrderByTest.php, line 48

Class

OrderByTest
Tests the orderBy() method of select queries.

Namespace

Drupal\Tests\sqlsrv\Unit

Code

public function testFieldEscaping() {
  $this->query
    ->orderBy('x; DROP table node; --');
  $sql = $this->query
    ->__toString();
  $this
    ->assertStringEndsWith('ORDER BY xDROPtablenode ASC', $sql, 'Order by field is escaped correctly.');
}