function QueryTest::testArraySubstitution

Tests that we can pass an array of values directly in the query.

File

core/tests/Drupal/KernelTests/Core/Database/QueryTest.php, line 15

Class

QueryTest

Tests Drupal's extended prepared statement syntax..

Namespace

Code

public function testArraySubstitution() {
    $names = $this->connection
        ->query('SELECT name FROM {test} WHERE age IN ( :ages[] ) ORDER BY age', [
        ':ages[]' => [
            25,
            26,
            27,
        ],
    ])
        ->fetchAll();
    $this->assertCount(3, $names, 'Correct number of names returned');
    $names = $this->connection
        ->query('SELECT name FROM {test} WHERE age IN ( :ages[] ) ORDER BY age', [
        ':ages[]' => [
            25,
        ],
    ])
        ->fetchAll();
    $this->assertCount(1, $names, 'Correct number of names returned');
}