Rougin\Windstorm\Doctrine\Result

Complexity

Total Complexity

7

Size/Duplication

Total Lines	77
Duplicated Lines	0 %

Test Coverage

Coverage

95.45%

Importance

Changes

0

4 Methods

Rating	Name	Duplication	Size	Complexity
A	manager()	0	3	1
A	execute()	0	24	4
A	mapping()	0	5	1
A	__construct()	0	3	1

<?php

namespace Rougin\Windstorm\Doctrine;

use Doctrine\ORM\EntityManager;
use Doctrine\ORM\NativeQuery;
use Doctrine\ORM\Query\ResultSetMapping;
use Rougin\Windstorm\ResultInterface;

/**
 * Result
 *
 * @package Windstorm
 * @author  Rougin Gutib <rougingutib@gmail.com>
 */
class Result implements ResultInterface
{
    /**
     * @var \Doctrine\ORM\EntityManager
     */
    protected $manager;

    /**
     * @var \Doctrine\ORM\Query\ResultSetMapping|null
     */
    protected $mapping = null;

    /**
     * Initializes the entity manager instance.
     *
     * @param \Doctrine\ORM\EntityManager $manager
     */
    public function __construct(EntityManager $manager)
    {
        $this->manager = $manager;
    }

    /**
     * Returns the entity manager instance.
     *
     * @return \Doctrine\ORM\EntityManager
     */
    public function manager()
    {
        return $this->manager;
    }

    /**
     * Executes an SQL statement with its bindings and types.
     *
     * @param  string $sql
     * @param  array  $bindings
     * @param  array  $types
     * @return mixed
     */
    public function execute($sql, array $bindings, array $types)
    {
        $connection = $this->manager->getConnection();

        if (strpos($sql, 'SELECT') === false)
        {
            return $connection->executeUpdate($sql, $bindings, $types);
        }

        if ($this->mapping === null)
        {
            return $connection->executeQuery($sql, $bindings, $types);
        }

        $query = new NativeQuery($this->manager);

        $query->setSql($sql)->setResultSetMapping($this->mapping);

        foreach ($bindings as $key => $binding)
        {
            $query->setParameter($key, $binding, $types[$key]);
        }

        return (array) $query->getResult();
    }

    /**
     * Sets the result set mapping instance.
     *
     * @param  \Doctrine\ORM\Query\ResultSetMapping $mapping
     * @return self
     */
    public function mapping(ResultSetMapping $mapping)
    {
        $this->mapping = $mapping;

        return $this;
    }
}