gistfile1.txt

<?php

namespace Elcweb\LegacyBundle\Entity;

/**
 * Class RawSQLTrait.
 */
trait RawSQLTrait
{
    /**
     * @param string $sql
     *
     * @return array
     *
     * @throws \Doctrine\DBAL\DBALException
     */
    private function fetchAll($sql)
    {
        return $this->execute($sql)->fetchAll();
    }

    /**
     * @param string $sql
     *
     * @return mixed
     */
    private function execute($sql)
    {
        $stmt = $this->getEntityManager()->getConnection()->prepare($sql);
        $stmt->execute();

        return $stmt;
    }

    /**
     * @param string $sql
     * @param string $fieldName
     *
     * @return mixed
     *
     * @throws \Doctrine\DBAL\DBALException
     */
    private function fetchSingleField($sql, $fieldName)
    {
        return $this->fetch($sql)[$fieldName];
    }

    /**
     * @param string $sql
     *
     * @return array
     *
     * @throws \Doctrine\DBAL\DBALException
     */
    private function fetch($sql)
    {
        return $this->execute($sql)->fetch();
    }
}