Dosctrine Generator

CustomerRepository.php

<?php declare(strict_types=1);

namespace My\Application\Repository;

class CustomerRepository extends Doctrine\ORM\EntityRepository
{
    public function findAll()
    {
        $queryBuilder = $this->createQueryBuilder('c')
            ->select('c')
            ->orderBy('c.id');
            
        $limit = 1000;
        $offset = 0;
            
        while (true) {
            $queryBuilder->setFirstResult($offset);
            $queryBuilder->setMaxResults($limit);
            
            $customers = $queryBuilder->getQuery()->getResult();
            
            if (count($customers) === 0) {
                break;
            }
            
            foreach ($customers as $customer) {
                yield $customer;
                $this->_em->detach($customer);
            }
            
            $offset += $limit;
        }
    }
}