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 20

Class

QueryTest

Tests Drupal's extended prepared statement syntax.

Namespace

Code

public function testArraySubstitution() : void {
    $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');
}