doctrine / DoctrineBundle

class DoctrineExtensionTest extends TestCase

{

    public function testReplaceQueryParametersWithPostgresCasting() : void

    {

        $extension  = new DoctrineExtension();

        $query      = 'a=? OR (1)::string OR b=?';

        $parameters = [1, 2];

        $result = $extension->replaceQueryParameters($query, $parameters);

        $this->assertEquals('a=1 OR (1)::string OR b=2', $result);

    }

    public function testReplaceQueryParametersWithStartingIndexAtOne() : void

    {

        $this->assertEquals('a=1 OR (1)::string OR b=2', $result);

    }

    public function testReplaceQueryParametersWithStartingIndexAtOne() : void

    {

        $extension  = new DoctrineExtension();

        $query      = 'a=? OR b=?';

        $parameters = [

            1 => 1,

            2 => 2,

        ];

        $result = $extension->replaceQueryParameters($query, $parameters);

        $this->assertEquals('a=1 OR b=2', $result);

    }

    public function testReplaceQueryParameters() : void

    {

        $this->assertEquals('a=1 OR b=2', $result);

    }

    public function testReplaceQueryParameters() : void

    {

        $extension  = new DoctrineExtension();

        $query      = 'a=? OR b=?';

        $parameters = [

            1,

            2,

        ];

        $result = $extension->replaceQueryParameters($query, $parameters);

        $this->assertEquals('a=1 OR b=2', $result);

    }

    public function testReplaceQueryParametersWithNamedIndex() : void

    {

        $this->assertEquals('a=1 OR b=2', $result);

    }

    public function testReplaceQueryParametersWithEmptyArray() : void

    {

        $extension  = new DoctrineExtension();

        $query      = 'IN (?)';

        $parameters = [

            [],

        ];

        $result = $extension->replaceQueryParameters($query, $parameters);

        $this->assertEquals('IN (NULL)', $result);

    }

    public function testEscapeBinaryParameter() : void

    {