Attachments to Doctrine Jira Issue DDC-1314 - https://github.com/doctrine/doctrine2/issues/1928

11128_IteratableHydratorTest.php

<?php

namespace Doctrine\Tests\ORM\Functional;

use Doctrine\ORM\Tools\SchemaTool;
use Doctrine\ORM\Query;
use Doctrine\Tests\Models\CMS\CmsUser;

require_once __DIR__ . '/../../TestInit.php';

class IteratableHydratorTest extends \Doctrine\Tests\OrmFunctionalTestCase
{
    protected function setUp()
    {
        $this->useModelSet('cms');
        parent::setUp();
    }

    public function testIterate()
    {
        $user = new CmsUser;
        $user->name = 'Roman';
        $user->username = 'romanb';
        $user->status = 'developer';

        $this->_em->persist($user);

        $user = new CmsUser;
        $user->name = 'Guilherme';
        $user->username = 'gblanco';
        $user->status = 'developer';

        $this->_em->persist($user);

        $user = new CmsUser();
        $user->username = "beberlei";
        $user->name = "Benjamin E.";
        $user->status = 'developer';

        $this->_em->persist($user);

        $this->_em->flush();
        $this->_em->clear();

        $query    = $this->_em->createQuery('SELECT u.id, u.name FROM Doctrine\Tests\Models\CMS\CmsUser u ORDER BY u.name ASC');
        $iterator = $query->iterate();

        while ($user = $iterator->next()) {
            var_dump($user);
            ob_end_flush();
            ob_start();

            $this->assertArrayHasKey(0, $user);

            $this->assertArrayHasKey('id', $user[0]);
            $this->assertArrayHasKey('name', $user[0]);
        }
    }
}