Doctrine Format result to a Array Of strings

Question

Over my repository I have the following method:

  /**
  * List and Seatch for existing emails
  * @param Integer $page The pagination page
  * @param Integet $limit The page limit
  * @return String[]
  */
  public function getEmailListInOrderToSendEmail()
  {
    $em=$this->getEntityManager();

    $queryBuilder = $em->createQueryBuilder();
    $queryBuilder->select('c.email')->from(ContactEmail::class,'c');

    $value=$queryBuilder->getQuery()->getScalarResult();

    if(empty($value)){
      return [];
    }

    return $value;
  }

A custom example of the returned type that I want to get returned is the following:

["[email protected]","[email protected]"]

But Instead the following result is returned:

[['email'=>"[email protected]"],["name"=>"[email protected]"]]

So a Naive approach is to iterate over the results with a loop and unfold it:

$newResults=[];
foreach($results as $result){
 $newResults[]=$result['email'];
}

But seems way to inefficient to me. Is there a way to format the returned query data on the way that being fetched without the need to do the loop?

The reason I am asking is because the result set may become rather big and iterating over a big array seems a bit slow (for example in a batch process via cli using a symfony command).

I suppose nothing has changed and stackoverflow.com/questions/27822809/… — u_mulder
– u_mulder, Commented Oct 7, 2018 at 18:05

Dimitrios Desyllas · Accepted Answer · 2018-10-10 19:54:40Z

You should create your own Hydrator as :

namespace AppBundle\Hydrators;

use Doctrine\ORM\Internal\Hydration\AbstractHydrator;

class ColumnHydrator extends AbstractHydrator
{
    protected function hydrateAllData()
    {
        return $this->_stmt->fetchAll(\PDO::FETCH_COLUMN);
    }
}

And load it on entity Manager when you need to load the data as an array:

//Namepsace Definitions etc etc
use AppBundle\Hydrators\ColumnHydrator;

//Class definition

 /**
  * List and Search for existing emails
  * @param Integer $page The pagination page
  * @param Integer $limit The page limit
  * @return String[]
  */
  public function getEmailListInOrderToSendEmail()
  {
    $em=$this->getEntityManager();
    $em->getConfiguration()->addCustomHydrationMode('ColumnHydrator', ColumnHydrator::class);

    $queryBuilder = $em->createQueryBuilder();
    $queryBuilder->select('c.email')->from(ContactEmail::class,'c');

    $value=$queryBuilder->getQuery()->getResult('ColumnHydrator');

    if(empty($value)){
      return [];
    }

    return $value;
  }

As you can see:

You load the hydrator via $em->getConfiguration()->addCustomHydrationMode('ColumnHydrator', ColumnHydrator::class);
Instead of fetching the results with getScalarResult fetch it with a simple getResult and pass as parameter the custom Hydrator.

Collectives™ on Stack Overflow

Doctrine Format result to a Array Of strings

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related