eZ\Publish\Core\Persistence\Legacy\Tests\TestCase::assertQueryResult PHP Method

assertQueryResult() public static method

Builds text representations of the asserted and fetched query result, based on a eZ\Publish\Core\Persistence\Database\SelectQuery object. Compares them using classic diff for maximum readability of the differences between expectations and real results. The expectation MUST be passed as a two dimensional array containing rows of columns.
public static assertQueryResult ( array $expectation, eZ\Publish\Core\Persistence\Database\SelectQuery $query, string $message = null )
$expectation array
$query eZ\Publish\Core\Persistence\Database\SelectQuery
$message string
    public static function assertQueryResult(array $expectation, SelectQuery $query, $message = null)
    {
        $statement = $query->prepare();
        $statement->execute();
        $result = array();
        while ($row = $statement->fetch(\PDO::FETCH_ASSOC)) {
            $result[] = $row;
        }
        return self::assertEquals(self::getResultTextRepresentation($expectation), self::getResultTextRepresentation($result), $message);
    }