<?php

declare(strict_types=1);

/**

* This file is part of Hyperf.

*

* @link https://www.hyperf.io

* @document https://hyperf.wiki

* @contact group@hyperf.io

* @license https://github.com/hyperf/hyperf/blob/master/LICENSE

*/

namespace HyperfTest\Database;

use Hyperf\Database\Connection;

use Hyperf\Database\Query\Grammars\MySqlGrammar;

use HyperfTest\Database\Stubs\ContainerStub;

use Mockery as m;

use PHPUnit\Framework\TestCase;

/**

* @internal

* @coversNothing

*/

class DatabaseMySqlQueryGrammarTest extends TestCase

{

protected function setUp(): void

{

ContainerStub::unsetContainer();

}

protected function tearDown(): void

{

m::close();

}

public function testToRawSql()

{

$connection = m::mock(Connection::class);

$connection->shouldReceive('escape')->with('foo', false)->andReturn("'foo'");

$grammar = new MySqlGrammar();

$bindings = array_map(fn ($value) => $connection->escape($value, false), ['foo']);

$query = $grammar->substituteBindingsIntoRawSql(

'select * from "users" where \'Hello\\\'World?\' IS NOT NULL AND "email" = ?',

$bindings,

);

$this->assertSame('select * from "users" where \'Hello\\\'World?\' IS NOT NULL AND "email" = \'foo\'', $query);

}

}