public function assertEqualsSQLQueries(
        $expected,
        $actual,
        string $message = '',
        float $delta = 0.0,
        int $maxDepth = 10,
        bool $canonicalize = FALSE,
        bool $ignoreCase = FALSE
    ): void
    {
        $flatten = function (array $value) {
            $flattened = [];
            array_walk_recursive(
                $value,
                function ($a) use ( & $flattened) {
                    $flattened[] = $a;
                }
            );
            return $flattened;
        };

        $expectedArray = $flatten([$expected]);
        $actualArray = $flatten([$actual]);
        $constraint = new EqualsSQLQueriesConstraint($expectedArray, $delta, $maxDepth, $canonicalize, $ignoreCase);
        $this->assertThat($actualArray, $constraint, $message);
    }
public function assertEqualsSQLQueries(
        $expected,
        $actual,
        string $message = '',
        float $delta = 0.0,
        int $maxDepth = 10,
        bool $canonicalize = FALSE,
        bool $ignoreCase = FALSE
    ): void
    {
        $flatten = function (array $value) {
            $flattened = [];
            array_walk_recursive(
                $value,
                function ($a) use ( & $flattened) {
                    $flattened[] = $a;
                }
            );
            return $flattened;
        };

        $expectedArray = $flatten([$expected]);
        $actualArray = $flatten([$actual]);
        $constraint = new EqualsSQLQueriesConstraint($expectedArray, $delta, $maxDepth, $canonicalize, $ignoreCase);
        $this->assertThat($actualArray, $constraint, $message);
    }
public function assertEqualsSQLQueries ( $ expected , $ actual , string $ message = '' , float $ delta = 0.0 , int $ maxDepth = 10 , bool $ canonicalize = FALSE , bool $ ignoreCase = FALSE ) : void { $ flatten = function ( array $ value ) { $ flattened = [ ] ; array_walk_recursive ( $ value , function ( $ a ) use ( & $ flattened ) { $ flattened [ ] = $ a ; } ) ; return $ flattened ; } ; $ expectedArray = $ flatten ( [ $ expected ] ) ; $ actualArray = $ flatten ( [ $ actual ] ) ; $ constraint = new EqualsSQLQueriesConstraint ( $ expectedArray , $ delta , $ maxDepth , $ canonicalize , $ ignoreCase ) ; $ this -> assertThat ( $ actualArray , $ constraint , $ message ) ; }
Assert two SQL queries or two series of SQL queries are equal.

@param  mixed    $expected      string[] or string
@param  mixed    $actual        string[] or string
@param  string   $message
@param  float    $delta
@param  integer  $maxDepth
@param  boolean  $canonicalize
@param  boolean  $ignoreCase
Assert two SQL queries or two series of SQL queries are equal .