--- /dev/null
+<?php
+
+namespace Doctrine\Tests\ORM\Hydration;
+
+use Doctrine\Tests\Mocks\HydratorMockStatement;
+use Doctrine\ORM\Query\ResultSetMapping;
+use Doctrine\ORM\Proxy\ProxyFactory;
+use Doctrine\ORM\Mapping\AssociationMapping;
+use Doctrine\ORM\Mapping\ClassMetadata;
+use Doctrine\ORM\Query;
+
+use Doctrine\Tests\Models\CMS\CmsUser;
+
+require_once __DIR__ . '/../../TestInit.php';
+
+class ObjectHydratorTest extends HydrationTestCase
+{
+ public function provideDataForUserEntityResult()
+ {
+ return array(
+ array(0),
+ array('user'),
+ );
+ }
+
+ public function provideDataForMultipleRootEntityResult()
+ {
+ return array(
+ array(0, 0),
+ array('user', 0),
+ array(0, 'article'),
+ array('user', 'article'),
+ );
+ }
+
+ public function provideDataForProductEntityResult()
+ {
+ return array(
+ array(0),
+ array('product'),
+ );
+ }
+
+ /**
+ * SELECT PARTIAL u.{id,name}
+ * FROM Doctrine\Tests\Models\CMS\CmsUser u
+ */
+ public function testSimpleEntityQuery()
+ {
+ $rsm = new ResultSetMapping;
+ $rsm->addEntityResult('Doctrine\Tests\Models\CMS\CmsUser', 'u');
+ $rsm->addFieldResult('u', 'u__id', 'id');
+ $rsm->addFieldResult('u', 'u__name', 'name');
+
+ // Faked result set
+ $resultSet = array(
+ array(
+ 'u__id' => '1',
+ 'u__name' => 'romanb'
+ ),
+ array(
+ 'u__id' => '2',
+ 'u__name' => 'jwage'
+ )
+ );
+
+ $stmt = new HydratorMockStatement($resultSet);
+ $hydrator = new \Doctrine\ORM\Internal\Hydration\ObjectHydrator($this->_em);
+ $result = $hydrator->hydrateAll($stmt, $rsm, array(Query::HINT_FORCE_PARTIAL_LOAD => true));
+
+ $this->assertEquals(2, count($result));
+
+ $this->assertInstanceOf('Doctrine\Tests\Models\CMS\CmsUser', $result[0]);
+ $this->assertInstanceOf('Doctrine\Tests\Models\CMS\CmsUser', $result[1]);
+
+ $this->assertEquals(1, $result[0]->id);
+ $this->assertEquals('romanb', $result[0]->name);
+
+ $this->assertEquals(2, $result[1]->id);
+ $this->assertEquals('jwage', $result[1]->name);
+ }
+
+ /**
+ * SELECT PARTIAL u.{id,name} AS user
+ * FROM Doctrine\Tests\Models\CMS\CmsUser u
+ */
+ public function testSimpleEntityQueryWithAliasedUserEntity()
+ {
+ $rsm = new ResultSetMapping;
+ $rsm->addEntityResult('Doctrine\Tests\Models\CMS\CmsUser', 'u', 'user');
+ $rsm->addFieldResult('u', 'u__id', 'id');
+ $rsm->addFieldResult('u', 'u__name', 'name');
+
+ // Faked result set
+ $resultSet = array(
+ array(
+ 'u__id' => '1',
+ 'u__name' => 'romanb'
+ ),
+ array(
+ 'u__id' => '2',
+ 'u__name' => 'jwage'
+ )
+ );
+
+ $stmt = new HydratorMockStatement($resultSet);
+ $hydrator = new \Doctrine\ORM\Internal\Hydration\ObjectHydrator($this->_em);
+ $result = $hydrator->hydrateAll($stmt, $rsm, array(Query::HINT_FORCE_PARTIAL_LOAD => true));
+
+ $this->assertEquals(2, count($result));
+
+ $this->assertArrayHasKey('user', $result[0]);
+ $this->assertInstanceOf('Doctrine\Tests\Models\CMS\CmsUser', $result[0]['user']);
+
+ $this->assertArrayHasKey('user', $result[1]);
+ $this->assertInstanceOf('Doctrine\Tests\Models\CMS\CmsUser', $result[1]['user']);
+
+ $this->assertEquals(1, $result[0]['user']->id);
+ $this->assertEquals('romanb', $result[0]['user']->name);
+
+ $this->assertEquals(2, $result[1]['user']->id);
+ $this->assertEquals('jwage', $result[1]['user']->name);
+ }
+
+ /**
+ * SELECT PARTIAL u.{id, name}, PARTIAL a.{id, topic}
+ * FROM Doctrine\Tests\Models\CMS\CmsUser u, Doctrine\Tests\Models\CMS\CmsArticle a
+ */
+ public function testSimpleMultipleRootEntityQuery()
+ {
+ $rsm = new ResultSetMapping;
+ $rsm->addEntityResult('Doctrine\Tests\Models\CMS\CmsUser', 'u');
+ $rsm->addEntityResult('Doctrine\Tests\Models\CMS\CmsArticle', 'a');
+ $rsm->addFieldResult('u', 'u__id', 'id');
+ $rsm->addFieldResult('u', 'u__name', 'name');
+ $rsm->addFieldResult('a', 'a__id', 'id');
+ $rsm->addFieldResult('a', 'a__topic', 'topic');
+
+ // Faked result set
+ $resultSet = array(
+ array(
+ 'u__id' => '1',
+ 'u__name' => 'romanb',
+ 'a__id' => '1',
+ 'a__topic' => 'Cool things.'
+ ),
+ array(
+ 'u__id' => '2',
+ 'u__name' => 'jwage',
+ 'a__id' => '2',
+ 'a__topic' => 'Cool things II.'
+ )
+ );
+
+ $stmt = new HydratorMockStatement($resultSet);
+ $hydrator = new \Doctrine\ORM\Internal\Hydration\ObjectHydrator($this->_em);
+ $result = $hydrator->hydrateAll($stmt, $rsm, array(Query::HINT_FORCE_PARTIAL_LOAD => true));
+
+ $this->assertEquals(4, count($result));
+
+ $this->assertInstanceOf('Doctrine\Tests\Models\CMS\CmsUser', $result[0]);
+ $this->assertInstanceOf('Doctrine\Tests\Models\CMS\CmsArticle', $result[1]);
+ $this->assertInstanceOf('Doctrine\Tests\Models\CMS\CmsUser', $result[2]);
+ $this->assertInstanceOf('Doctrine\Tests\Models\CMS\CmsArticle', $result[3]);
+
+ $this->assertEquals(1, $result[0]->id);
+ $this->assertEquals('romanb', $result[0]->name);
+
+ $this->assertEquals(1, $result[1]->id);
+ $this->assertEquals('Cool things.', $result[1]->topic);
+
+ $this->assertEquals(2, $result[2]->id);
+ $this->assertEquals('jwage', $result[2]->name);
+
+ $this->assertEquals(2, $result[3]->id);
+ $this->assertEquals('Cool things II.', $result[3]->topic);
+ }
+
+ /**
+ * SELECT PARTIAL u.{id, name} AS user, PARTIAL a.{id, topic}
+ * FROM Doctrine\Tests\Models\CMS\CmsUser u, Doctrine\Tests\Models\CMS\CmsArticle a
+ */
+ public function testSimpleMultipleRootEntityQueryWithAliasedUserEntity()
+ {
+ $rsm = new ResultSetMapping;
+ $rsm->addEntityResult('Doctrine\Tests\Models\CMS\CmsUser', 'u', 'user');
+ $rsm->addEntityResult('Doctrine\Tests\Models\CMS\CmsArticle', 'a');
+ $rsm->addFieldResult('u', 'u__id', 'id');
+ $rsm->addFieldResult('u', 'u__name', 'name');
+ $rsm->addFieldResult('a', 'a__id', 'id');
+ $rsm->addFieldResult('a', 'a__topic', 'topic');
+
+ // Faked result set
+ $resultSet = array(
+ array(
+ 'u__id' => '1',
+ 'u__name' => 'romanb',
+ 'a__id' => '1',
+ 'a__topic' => 'Cool things.'
+ ),
+ array(
+ 'u__id' => '2',
+ 'u__name' => 'jwage',
+ 'a__id' => '2',
+ 'a__topic' => 'Cool things II.'
+ )
+ );
+
+ $stmt = new HydratorMockStatement($resultSet);
+ $hydrator = new \Doctrine\ORM\Internal\Hydration\ObjectHydrator($this->_em);
+ $result = $hydrator->hydrateAll($stmt, $rsm, array(Query::HINT_FORCE_PARTIAL_LOAD => true));
+
+ $this->assertEquals(4, count($result));
+
+ $this->assertArrayHasKey('user', $result[0]);
+ $this->assertArrayNotHasKey(0, $result[0]);
+ $this->assertInstanceOf('Doctrine\Tests\Models\CMS\CmsUser', $result[0]['user']);
+ $this->assertEquals(1, $result[0]['user']->id);
+ $this->assertEquals('romanb', $result[0]['user']->name);
+
+ $this->assertArrayHasKey(0, $result[1]);
+ $this->assertArrayNotHasKey('user', $result[1]);
+ $this->assertInstanceOf('Doctrine\Tests\Models\CMS\CmsArticle', $result[1][0]);
+ $this->assertEquals(1, $result[1][0]->id);
+ $this->assertEquals('Cool things.', $result[1][0]->topic);
+
+ $this->assertArrayHasKey('user', $result[2]);
+ $this->assertArrayNotHasKey(0, $result[2]);
+ $this->assertInstanceOf('Doctrine\Tests\Models\CMS\CmsUser', $result[2]['user']);
+ $this->assertEquals(2, $result[2]['user']->id);
+ $this->assertEquals('jwage', $result[2]['user']->name);
+
+ $this->assertArrayHasKey(0, $result[3]);
+ $this->assertArrayNotHasKey('user', $result[3]);
+ $this->assertInstanceOf('Doctrine\Tests\Models\CMS\CmsArticle', $result[3][0]);
+ $this->assertEquals(2, $result[3][0]->id);
+ $this->assertEquals('Cool things II.', $result[3][0]->topic);
+ }
+
+ /**
+ * SELECT PARTIAL u.{id, name}, PARTIAL a.{id, topic} AS article
+ * FROM Doctrine\Tests\Models\CMS\CmsUser u, Doctrine\Tests\Models\CMS\CmsArticle a
+ */
+ public function testSimpleMultipleRootEntityQueryWithAliasedArticleEntity()
+ {
+ $rsm = new ResultSetMapping;
+ $rsm->addEntityResult('Doctrine\Tests\Models\CMS\CmsUser', 'u');
+ $rsm->addEntityResult('Doctrine\Tests\Models\CMS\CmsArticle', 'a', 'article');
+ $rsm->addFieldResult('u', 'u__id', 'id');
+ $rsm->addFieldResult('u', 'u__name', 'name');
+ $rsm->addFieldResult('a', 'a__id', 'id');
+ $rsm->addFieldResult('a', 'a__topic', 'topic');
+
+ // Faked result set
+ $resultSet = array(
+ array(
+ 'u__id' => '1',
+ 'u__name' => 'romanb',
+ 'a__id' => '1',
+ 'a__topic' => 'Cool things.'
+ ),
+ array(
+ 'u__id' => '2',
+ 'u__name' => 'jwage',
+ 'a__id' => '2',
+ 'a__topic' => 'Cool things II.'
+ )
+ );
+
+ $stmt = new HydratorMockStatement($resultSet);
+ $hydrator = new \Doctrine\ORM\Internal\Hydration\ObjectHydrator($this->_em);
+ $result = $hydrator->hydrateAll($stmt, $rsm, array(Query::HINT_FORCE_PARTIAL_LOAD => true));
+
+ $this->assertEquals(4, count($result));
+
+ $this->assertArrayHasKey(0, $result[0]);
+ $this->assertArrayNotHasKey('article', $result[0]);
+ $this->assertInstanceOf('Doctrine\Tests\Models\CMS\CmsUser', $result[0][0]);
+ $this->assertEquals(1, $result[0][0]->id);
+ $this->assertEquals('romanb', $result[0][0]->name);
+
+ $this->assertArrayHasKey('article', $result[1]);
+ $this->assertArrayNotHasKey(0, $result[1]);
+ $this->assertInstanceOf('Doctrine\Tests\Models\CMS\CmsArticle', $result[1]['article']);
+ $this->assertEquals(1, $result[1]['article']->id);
+ $this->assertEquals('Cool things.', $result[1]['article']->topic);
+
+ $this->assertArrayHasKey(0, $result[2]);
+ $this->assertArrayNotHasKey('article', $result[2]);
+ $this->assertInstanceOf('Doctrine\Tests\Models\CMS\CmsUser', $result[2][0]);
+ $this->assertEquals(2, $result[2][0]->id);
+ $this->assertEquals('jwage', $result[2][0]->name);
+
+ $this->assertArrayHasKey('article', $result[3]);
+ $this->assertArrayNotHasKey(0, $result[3]);
+ $this->assertInstanceOf('Doctrine\Tests\Models\CMS\CmsArticle', $result[3]['article']);
+ $this->assertEquals(2, $result[3]['article']->id);
+ $this->assertEquals('Cool things II.', $result[3]['article']->topic);
+ }
+
+ /**
+ * SELECT PARTIAL u.{id, name} AS user, PARTIAL a.{id, topic} AS article
+ * FROM Doctrine\Tests\Models\CMS\CmsUser u, Doctrine\Tests\Models\CMS\CmsArticle a
+ */
+ public function testSimpleMultipleRootEntityQueryWithAliasedEntities()
+ {
+ $rsm = new ResultSetMapping;
+ $rsm->addEntityResult('Doctrine\Tests\Models\CMS\CmsUser', 'u', 'user');
+ $rsm->addEntityResult('Doctrine\Tests\Models\CMS\CmsArticle', 'a', 'article');
+ $rsm->addFieldResult('u', 'u__id', 'id');
+ $rsm->addFieldResult('u', 'u__name', 'name');
+ $rsm->addFieldResult('a', 'a__id', 'id');
+ $rsm->addFieldResult('a', 'a__topic', 'topic');
+
+ // Faked result set
+ $resultSet = array(
+ array(
+ 'u__id' => '1',
+ 'u__name' => 'romanb',
+ 'a__id' => '1',
+ 'a__topic' => 'Cool things.'
+ ),
+ array(
+ 'u__id' => '2',
+ 'u__name' => 'jwage',
+ 'a__id' => '2',
+ 'a__topic' => 'Cool things II.'
+ )
+ );
+
+ $stmt = new HydratorMockStatement($resultSet);
+ $hydrator = new \Doctrine\ORM\Internal\Hydration\ObjectHydrator($this->_em);
+ $result = $hydrator->hydrateAll($stmt, $rsm, array(Query::HINT_FORCE_PARTIAL_LOAD => true));
+
+ $this->assertEquals(4, count($result));
+
+ $this->assertArrayHasKey('user', $result[0]);
+ $this->assertArrayNotHasKey('article', $result[0]);
+ $this->assertInstanceOf('Doctrine\Tests\Models\CMS\CmsUser', $result[0]['user']);
+ $this->assertEquals(1, $result[0]['user']->id);
+ $this->assertEquals('romanb', $result[0]['user']->name);
+
+ $this->assertArrayHasKey('article', $result[1]);
+ $this->assertArrayNotHasKey('user', $result[1]);
+ $this->assertInstanceOf('Doctrine\Tests\Models\CMS\CmsArticle', $result[1]['article']);
+ $this->assertEquals(1, $result[1]['article']->id);
+ $this->assertEquals('Cool things.', $result[1]['article']->topic);
+
+ $this->assertArrayHasKey('user', $result[2]);
+ $this->assertArrayNotHasKey('article', $result[2]);
+ $this->assertInstanceOf('Doctrine\Tests\Models\CMS\CmsUser', $result[2]['user']);
+ $this->assertEquals(2, $result[2]['user']->id);
+ $this->assertEquals('jwage', $result[2]['user']->name);
+
+ $this->assertArrayHasKey('article', $result[3]);
+ $this->assertArrayNotHasKey('user', $result[3]);
+ $this->assertInstanceOf('Doctrine\Tests\Models\CMS\CmsArticle', $result[3]['article']);
+ $this->assertEquals(2, $result[3]['article']->id);
+ $this->assertEquals('Cool things II.', $result[3]['article']->topic);
+ }
+
+ /**
+ * SELECT PARTIAL u.{id, status}, COUNT(p.phonenumber) numPhones
+ * FROM User u
+ * JOIN u.phonenumbers p
+ * GROUP BY u.id
+ *
+ * @dataProvider provideDataForUserEntityResult
+ */
+ public function testMixedQueryNormalJoin($userEntityKey)
+ {
+ $rsm = new ResultSetMapping;
+ $rsm->addEntityResult('Doctrine\Tests\Models\CMS\CmsUser', 'u', $userEntityKey ?: null);
+ $rsm->addFieldResult('u', 'u__id', 'id');
+ $rsm->addFieldResult('u', 'u__status', 'status');
+ $rsm->addScalarResult('sclr0', 'numPhones');
+
+ // Faked result set
+ $resultSet = array(
+ //row1
+ array(
+ 'u__id' => '1',
+ 'u__status' => 'developer',
+ 'sclr0' => '2',
+ ),
+ array(
+ 'u__id' => '2',
+ 'u__status' => 'developer',
+ 'sclr0' => '1',
+ )
+ );
+
+ $stmt = new HydratorMockStatement($resultSet);
+ $hydrator = new \Doctrine\ORM\Internal\Hydration\ObjectHydrator($this->_em);
+ $result = $hydrator->hydrateAll($stmt, $rsm, array(Query::HINT_FORCE_PARTIAL_LOAD => true));
+
+ $this->assertEquals(2, count($result));
+
+ $this->assertInternalType('array', $result);
+ $this->assertInternalType('array', $result[0]);
+ $this->assertInternalType('array', $result[1]);
+
+ // first user => 2 phonenumbers
+ $this->assertEquals(2, $result[0]['numPhones']);
+ $this->assertInstanceOf('Doctrine\Tests\Models\CMS\CmsUser', $result[0][$userEntityKey]);
+
+ // second user => 1 phonenumber
+ $this->assertEquals(1, $result[1]['numPhones']);
+ $this->assertInstanceOf('Doctrine\Tests\Models\CMS\CmsUser', $result[1][$userEntityKey]);
+ }
+
+ /**
+ * SELECT PARTIAL u.{id, status}, PARTIAL p.{phonenumber}, UPPER(u.name) nameUpper
+ * FROM Doctrine\Tests\Models\CMS\CmsUser u
+ * JOIN u.phonenumbers p
+ *
+ * @dataProvider provideDataForUserEntityResult
+ */
+ public function testMixedQueryFetchJoin($userEntityKey)
+ {
+ $rsm = new ResultSetMapping;
+ $rsm->addEntityResult('Doctrine\Tests\Models\CMS\CmsUser', 'u', $userEntityKey ?: null);
+ $rsm->addJoinedEntityResult(
+ 'Doctrine\Tests\Models\CMS\CmsPhonenumber',
+ 'p',
+ 'u',
+ 'phonenumbers'
+ );
+ $rsm->addFieldResult('u', 'u__id', 'id');
+ $rsm->addFieldResult('u', 'u__status', 'status');
+ $rsm->addFieldResult('p', 'p__phonenumber', 'phonenumber');
+ $rsm->addScalarResult('sclr0', 'nameUpper');
+
+ // Faked result set
+ $resultSet = array(
+ //row1
+ array(
+ 'u__id' => '1',
+ 'u__status' => 'developer',
+ 'p__phonenumber' => '42',
+ 'sclr0' => 'ROMANB',
+ ),
+ array(
+ 'u__id' => '1',
+ 'u__status' => 'developer',
+ 'p__phonenumber' => '43',
+ 'sclr0' => 'ROMANB',
+ ),
+ array(
+ 'u__id' => '2',
+ 'u__status' => 'developer',
+ 'p__phonenumber' => '91',
+ 'sclr0' => 'JWAGE',
+ )
+ );
+
+ $stmt = new HydratorMockStatement($resultSet);
+ $hydrator = new \Doctrine\ORM\Internal\Hydration\ObjectHydrator($this->_em);
+ $result = $hydrator->hydrateAll($stmt, $rsm, array(Query::HINT_FORCE_PARTIAL_LOAD => true));
+
+ $this->assertEquals(2, count($result));
+
+ $this->assertInternalType('array', $result);
+ $this->assertInternalType('array', $result[0]);
+ $this->assertInternalType('array', $result[1]);
+
+ $this->assertInstanceOf('Doctrine\Tests\Models\CMS\CmsUser', $result[0][$userEntityKey]);
+ $this->assertInstanceOf('Doctrine\ORM\PersistentCollection', $result[0][$userEntityKey]->phonenumbers);
+ $this->assertInstanceOf('Doctrine\Tests\Models\CMS\CmsPhonenumber', $result[0][$userEntityKey]->phonenumbers[0]);
+
+ $this->assertInstanceOf('Doctrine\Tests\Models\CMS\CmsUser', $result[1][$userEntityKey]);
+ $this->assertInstanceOf('Doctrine\ORM\PersistentCollection', $result[1][$userEntityKey]->phonenumbers);
+ $this->assertInstanceOf('Doctrine\Tests\Models\CMS\CmsPhonenumber', $result[0][$userEntityKey]->phonenumbers[1]);
+
+ // first user => 2 phonenumbers
+ $this->assertEquals(2, count($result[0][$userEntityKey]->phonenumbers));
+ $this->assertEquals('ROMANB', $result[0]['nameUpper']);
+
+ // second user => 1 phonenumber
+ $this->assertEquals(1, count($result[1][$userEntityKey]->phonenumbers));
+ $this->assertEquals('JWAGE', $result[1]['nameUpper']);
+
+ $this->assertEquals(42, $result[0][$userEntityKey]->phonenumbers[0]->phonenumber);
+ $this->assertEquals(43, $result[0][$userEntityKey]->phonenumbers[1]->phonenumber);
+ $this->assertEquals(91, $result[1][$userEntityKey]->phonenumbers[0]->phonenumber);
+ }
+
+ /**
+ * SELECT u, p, UPPER(u.name) nameUpper
+ * FROM User u
+ * INDEX BY u.id
+ * JOIN u.phonenumbers p
+ * INDEX BY p.phonenumber
+ *
+ * @dataProvider provideDataForUserEntityResult
+ */
+ public function testMixedQueryFetchJoinCustomIndex($userEntityKey)
+ {
+ $rsm = new ResultSetMapping;
+ $rsm->addEntityResult('Doctrine\Tests\Models\CMS\CmsUser', 'u', $userEntityKey ?: null);
+ $rsm->addJoinedEntityResult(
+ 'Doctrine\Tests\Models\CMS\CmsPhonenumber',
+ 'p',
+ 'u',
+ 'phonenumbers'
+ );
+ $rsm->addFieldResult('u', 'u__id', 'id');
+ $rsm->addFieldResult('u', 'u__status', 'status');
+ $rsm->addScalarResult('sclr0', 'nameUpper');
+ $rsm->addFieldResult('p', 'p__phonenumber', 'phonenumber');
+ $rsm->addIndexBy('u', 'id');
+ $rsm->addIndexBy('p', 'phonenumber');
+
+ // Faked result set
+ $resultSet = array(
+ //row1
+ array(
+ 'u__id' => '1',
+ 'u__status' => 'developer',
+ 'sclr0' => 'ROMANB',
+ 'p__phonenumber' => '42',
+ ),
+ array(
+ 'u__id' => '1',
+ 'u__status' => 'developer',
+ 'sclr0' => 'ROMANB',
+ 'p__phonenumber' => '43',
+ ),
+ array(
+ 'u__id' => '2',
+ 'u__status' => 'developer',
+ 'sclr0' => 'JWAGE',
+ 'p__phonenumber' => '91'
+ )
+ );
+
+
+ $stmt = new HydratorMockStatement($resultSet);
+ $hydrator = new \Doctrine\ORM\Internal\Hydration\ObjectHydrator($this->_em);
+ $result = $hydrator->hydrateAll($stmt, $rsm, array(Query::HINT_FORCE_PARTIAL_LOAD => true));
+
+ $this->assertEquals(2, count($result));
+
+ $this->assertInternalType('array', $result);
+ $this->assertInternalType('array', $result[1]);
+ $this->assertInternalType('array', $result[2]);
+
+ // test the scalar values
+ $this->assertEquals('ROMANB', $result[1]['nameUpper']);
+ $this->assertEquals('JWAGE', $result[2]['nameUpper']);
+
+ $this->assertInstanceOf('Doctrine\Tests\Models\CMS\CmsUser', $result[1][$userEntityKey]);
+ $this->assertInstanceOf('Doctrine\Tests\Models\CMS\CmsUser', $result[2][$userEntityKey]);
+ $this->assertInstanceOf('Doctrine\ORM\PersistentCollection', $result[1][$userEntityKey]->phonenumbers);
+
+ // first user => 2 phonenumbers. notice the custom indexing by user id
+ $this->assertEquals(2, count($result[1][$userEntityKey]->phonenumbers));
+
+ // second user => 1 phonenumber. notice the custom indexing by user id
+ $this->assertEquals(1, count($result[2][$userEntityKey]->phonenumbers));
+
+ // test the custom indexing of the phonenumbers
+ $this->assertTrue(isset($result[1][$userEntityKey]->phonenumbers['42']));
+ $this->assertTrue(isset($result[1][$userEntityKey]->phonenumbers['43']));
+ $this->assertTrue(isset($result[2][$userEntityKey]->phonenumbers['91']));
+ }
+
+ /**
+ * SELECT u, p, UPPER(u.name) nameUpper, a
+ * FROM User u
+ * JOIN u.phonenumbers p
+ * JOIN u.articles a
+ *
+ * @dataProvider provideDataForUserEntityResult
+ */
+ public function testMixedQueryMultipleFetchJoin($userEntityKey)
+ {
+ $rsm = new ResultSetMapping;
+ $rsm->addEntityResult('Doctrine\Tests\Models\CMS\CmsUser', 'u', $userEntityKey ?: null);
+ $rsm->addJoinedEntityResult(
+ 'Doctrine\Tests\Models\CMS\CmsPhonenumber',
+ 'p',
+ 'u',
+ 'phonenumbers'
+ );
+ $rsm->addJoinedEntityResult(
+ 'Doctrine\Tests\Models\CMS\CmsArticle',
+ 'a',
+ 'u',
+ 'articles'
+ );
+ $rsm->addFieldResult('u', 'u__id', 'id');
+ $rsm->addFieldResult('u', 'u__status', 'status');
+ $rsm->addScalarResult('sclr0', 'nameUpper');
+ $rsm->addFieldResult('p', 'p__phonenumber', 'phonenumber');
+ $rsm->addFieldResult('a', 'a__id', 'id');
+ $rsm->addFieldResult('a', 'a__topic', 'topic');
+
+ // Faked result set
+ $resultSet = array(
+ //row1
+ array(
+ 'u__id' => '1',
+ 'u__status' => 'developer',
+ 'sclr0' => 'ROMANB',
+ 'p__phonenumber' => '42',
+ 'a__id' => '1',
+ 'a__topic' => 'Getting things done!'
+ ),
+ array(
+ 'u__id' => '1',
+ 'u__status' => 'developer',
+ 'sclr0' => 'ROMANB',
+ 'p__phonenumber' => '43',
+ 'a__id' => '1',
+ 'a__topic' => 'Getting things done!'
+ ),
+ array(
+ 'u__id' => '1',
+ 'u__status' => 'developer',
+ 'sclr0' => 'ROMANB',
+ 'p__phonenumber' => '42',
+ 'a__id' => '2',
+ 'a__topic' => 'ZendCon'
+ ),
+ array(
+ 'u__id' => '1',
+ 'u__status' => 'developer',
+ 'sclr0' => 'ROMANB',
+ 'p__phonenumber' => '43',
+ 'a__id' => '2',
+ 'a__topic' => 'ZendCon'
+ ),
+ array(
+ 'u__id' => '2',
+ 'u__status' => 'developer',
+ 'sclr0' => 'JWAGE',
+ 'p__phonenumber' => '91',
+ 'a__id' => '3',
+ 'a__topic' => 'LINQ'
+ ),
+ array(
+ 'u__id' => '2',
+ 'u__status' => 'developer',
+ 'sclr0' => 'JWAGE',
+ 'p__phonenumber' => '91',
+ 'a__id' => '4',
+ 'a__topic' => 'PHP6'
+ ),
+ );
+
+ $stmt = new HydratorMockStatement($resultSet);
+ $hydrator = new \Doctrine\ORM\Internal\Hydration\ObjectHydrator($this->_em);
+ $result = $hydrator->hydrateAll($stmt, $rsm, array(Query::HINT_FORCE_PARTIAL_LOAD => true));
+
+ $this->assertEquals(2, count($result));
+
+ $this->assertTrue(is_array($result));
+ $this->assertTrue(is_array($result[0]));
+ $this->assertTrue(is_array($result[1]));
+
+ $this->assertInstanceOf('Doctrine\Tests\Models\CMS\CmsUser', $result[0][$userEntityKey]);
+ $this->assertInstanceOf('Doctrine\ORM\PersistentCollection', $result[0][$userEntityKey]->phonenumbers);
+ $this->assertInstanceOf('Doctrine\Tests\Models\CMS\CmsPhonenumber', $result[0][$userEntityKey]->phonenumbers[0]);
+ $this->assertInstanceOf('Doctrine\Tests\Models\CMS\CmsPhonenumber', $result[0][$userEntityKey]->phonenumbers[1]);
+ $this->assertInstanceOf('Doctrine\ORM\PersistentCollection', $result[0][$userEntityKey]->articles);
+ $this->assertInstanceOf('Doctrine\Tests\Models\CMS\CmsArticle', $result[0][$userEntityKey]->articles[0]);
+ $this->assertInstanceOf('Doctrine\Tests\Models\CMS\CmsArticle', $result[0][$userEntityKey]->articles[1]);
+
+ $this->assertInstanceOf('Doctrine\Tests\Models\CMS\CmsUser', $result[1][$userEntityKey]);
+ $this->assertInstanceOf('Doctrine\ORM\PersistentCollection', $result[1][$userEntityKey]->phonenumbers);
+ $this->assertInstanceOf('Doctrine\Tests\Models\CMS\CmsPhonenumber', $result[1][$userEntityKey]->phonenumbers[0]);
+ $this->assertInstanceOf('Doctrine\Tests\Models\CMS\CmsArticle', $result[1][$userEntityKey]->articles[0]);
+ $this->assertInstanceOf('Doctrine\Tests\Models\CMS\CmsArticle', $result[1][$userEntityKey]->articles[1]);
+ }
+
+ /**
+ * SELECT u, p, UPPER(u.name) nameUpper, a, c
+ * FROM User u
+ * JOIN u.phonenumbers p
+ * JOIN u.articles a
+ * LEFT JOIN a.comments c
+ *
+ * @dataProvider provideDataForUserEntityResult
+ */
+ public function testMixedQueryMultipleDeepMixedFetchJoin($userEntityKey)
+ {
+ $rsm = new ResultSetMapping;
+ $rsm->addEntityResult('Doctrine\Tests\Models\CMS\CmsUser', 'u', $userEntityKey ?: null);
+ $rsm->addJoinedEntityResult(
+ 'Doctrine\Tests\Models\CMS\CmsPhonenumber',
+ 'p',
+ 'u',
+ 'phonenumbers'
+ );
+ $rsm->addJoinedEntityResult(
+ 'Doctrine\Tests\Models\CMS\CmsArticle',
+ 'a',
+ 'u',
+ 'articles'
+ );
+ $rsm->addJoinedEntityResult(
+ 'Doctrine\Tests\Models\CMS\CmsComment',
+ 'c',
+ 'a',
+ 'comments'
+ );
+ $rsm->addFieldResult('u', 'u__id', 'id');
+ $rsm->addFieldResult('u', 'u__status', 'status');
+ $rsm->addScalarResult('sclr0', 'nameUpper');
+ $rsm->addFieldResult('p', 'p__phonenumber', 'phonenumber');
+ $rsm->addFieldResult('a', 'a__id', 'id');
+ $rsm->addFieldResult('a', 'a__topic', 'topic');
+ $rsm->addFieldResult('c', 'c__id', 'id');
+ $rsm->addFieldResult('c', 'c__topic', 'topic');
+
+ // Faked result set
+ $resultSet = array(
+ //row1
+ array(
+ 'u__id' => '1',
+ 'u__status' => 'developer',
+ 'sclr0' => 'ROMANB',
+ 'p__phonenumber' => '42',
+ 'a__id' => '1',
+ 'a__topic' => 'Getting things done!',
+ 'c__id' => '1',
+ 'c__topic' => 'First!'
+ ),
+ array(
+ 'u__id' => '1',
+ 'u__status' => 'developer',
+ 'sclr0' => 'ROMANB',
+ 'p__phonenumber' => '43',
+ 'a__id' => '1',
+ 'a__topic' => 'Getting things done!',
+ 'c__id' => '1',
+ 'c__topic' => 'First!'
+ ),
+ array(
+ 'u__id' => '1',
+ 'u__status' => 'developer',
+ 'sclr0' => 'ROMANB',
+ 'p__phonenumber' => '42',
+ 'a__id' => '2',
+ 'a__topic' => 'ZendCon',
+ 'c__id' => null,
+ 'c__topic' => null
+ ),
+ array(
+ 'u__id' => '1',
+ 'u__status' => 'developer',
+ 'sclr0' => 'ROMANB',
+ 'p__phonenumber' => '43',
+ 'a__id' => '2',
+ 'a__topic' => 'ZendCon',
+ 'c__id' => null,
+ 'c__topic' => null
+ ),
+ array(
+ 'u__id' => '2',
+ 'u__status' => 'developer',
+ 'sclr0' => 'JWAGE',
+ 'p__phonenumber' => '91',
+ 'a__id' => '3',
+ 'a__topic' => 'LINQ',
+ 'c__id' => null,
+ 'c__topic' => null
+ ),
+ array(
+ 'u__id' => '2',
+ 'u__status' => 'developer',
+ 'sclr0' => 'JWAGE',
+ 'p__phonenumber' => '91',
+ 'a__id' => '4',
+ 'a__topic' => 'PHP6',
+ 'c__id' => null,
+ 'c__topic' => null
+ ),
+ );
+
+ $stmt = new HydratorMockStatement($resultSet);
+ $hydrator = new \Doctrine\ORM\Internal\Hydration\ObjectHydrator($this->_em);
+ $result = $hydrator->hydrateAll($stmt, $rsm, array(Query::HINT_FORCE_PARTIAL_LOAD => true));
+
+ $this->assertEquals(2, count($result));
+
+ $this->assertTrue(is_array($result));
+ $this->assertTrue(is_array($result[0]));
+ $this->assertTrue(is_array($result[1]));
+
+ $this->assertInstanceOf('Doctrine\Tests\Models\CMS\CmsUser', $result[0][$userEntityKey]);
+ $this->assertInstanceOf('Doctrine\Tests\Models\CMS\CmsUser', $result[1][$userEntityKey]);
+
+ // phonenumbers
+ $this->assertInstanceOf('Doctrine\ORM\PersistentCollection', $result[0][$userEntityKey]->phonenumbers);
+ $this->assertInstanceOf('Doctrine\Tests\Models\CMS\CmsPhonenumber', $result[0][$userEntityKey]->phonenumbers[0]);
+ $this->assertInstanceOf('Doctrine\Tests\Models\CMS\CmsPhonenumber', $result[0][$userEntityKey]->phonenumbers[1]);
+
+ $this->assertInstanceOf('Doctrine\ORM\PersistentCollection', $result[1][$userEntityKey]->phonenumbers);
+ $this->assertInstanceOf('Doctrine\Tests\Models\CMS\CmsPhonenumber', $result[1][$userEntityKey]->phonenumbers[0]);
+
+ // articles
+ $this->assertInstanceOf('Doctrine\ORM\PersistentCollection', $result[0][$userEntityKey]->articles);
+ $this->assertInstanceOf('Doctrine\Tests\Models\CMS\CmsArticle', $result[0][$userEntityKey]->articles[0]);
+ $this->assertInstanceOf('Doctrine\Tests\Models\CMS\CmsArticle', $result[0][$userEntityKey]->articles[1]);
+
+ $this->assertInstanceOf('Doctrine\Tests\Models\CMS\CmsArticle', $result[1][$userEntityKey]->articles[0]);
+ $this->assertInstanceOf('Doctrine\Tests\Models\CMS\CmsArticle', $result[1][$userEntityKey]->articles[1]);
+
+ // article comments
+ $this->assertInstanceOf('Doctrine\ORM\PersistentCollection', $result[0][$userEntityKey]->articles[0]->comments);
+ $this->assertInstanceOf('Doctrine\Tests\Models\CMS\CmsComment', $result[0][$userEntityKey]->articles[0]->comments[0]);
+
+ // empty comment collections
+ $this->assertInstanceOf('Doctrine\ORM\PersistentCollection', $result[0][$userEntityKey]->articles[1]->comments);
+ $this->assertEquals(0, count($result[0][$userEntityKey]->articles[1]->comments));
+
+ $this->assertInstanceOf('Doctrine\ORM\PersistentCollection', $result[1][$userEntityKey]->articles[0]->comments);
+ $this->assertEquals(0, count($result[1][$userEntityKey]->articles[0]->comments));
+ $this->assertInstanceOf('Doctrine\ORM\PersistentCollection', $result[1][$userEntityKey]->articles[1]->comments);
+ $this->assertEquals(0, count($result[1][$userEntityKey]->articles[1]->comments));
+ }
+
+ /**
+ * Tests that the hydrator does not rely on a particular order of the rows
+ * in the result set.
+ *
+ * DQL:
+ * select c, b from Doctrine\Tests\Models\Forum\ForumCategory c inner join c.boards b
+ * order by c.position asc, b.position asc
+ *
+ * Checks whether the boards are correctly assigned to the categories.
+ *
+ * The 'evil' result set that confuses the object population is displayed below.
+ *
+ * c.id | c.position | c.name | boardPos | b.id | b.category_id (just for clarity)
+ * 1 | 0 | First | 0 | 1 | 1
+ * 2 | 0 | Second | 0 | 2 | 2 <--
+ * 1 | 0 | First | 1 | 3 | 1
+ * 1 | 0 | First | 2 | 4 | 1
+ */
+ public function testEntityQueryCustomResultSetOrder()
+ {
+ $rsm = new ResultSetMapping;
+ $rsm->addEntityResult('Doctrine\Tests\Models\Forum\ForumCategory', 'c');
+ $rsm->addJoinedEntityResult(
+ 'Doctrine\Tests\Models\Forum\ForumBoard',
+ 'b',
+ 'c',
+ 'boards'
+ );
+ $rsm->addFieldResult('c', 'c__id', 'id');
+ $rsm->addFieldResult('c', 'c__position', 'position');
+ $rsm->addFieldResult('c', 'c__name', 'name');
+ $rsm->addFieldResult('b', 'b__id', 'id');
+ $rsm->addFieldResult('b', 'b__position', 'position');
+
+ // Faked result set
+ $resultSet = array(
+ array(
+ 'c__id' => '1',
+ 'c__position' => '0',
+ 'c__name' => 'First',
+ 'b__id' => '1',
+ 'b__position' => '0',
+ //'b__category_id' => '1'
+ ),
+ array(
+ 'c__id' => '2',
+ 'c__position' => '0',
+ 'c__name' => 'Second',
+ 'b__id' => '2',
+ 'b__position' => '0',
+ //'b__category_id' => '2'
+ ),
+ array(
+ 'c__id' => '1',
+ 'c__position' => '0',
+ 'c__name' => 'First',
+ 'b__id' => '3',
+ 'b__position' => '1',
+ //'b__category_id' => '1'
+ ),
+ array(
+ 'c__id' => '1',
+ 'c__position' => '0',
+ 'c__name' => 'First',
+ 'b__id' => '4',
+ 'b__position' => '2',
+ //'b__category_id' => '1'
+ )
+ );
+
+ $stmt = new HydratorMockStatement($resultSet);
+ $hydrator = new \Doctrine\ORM\Internal\Hydration\ObjectHydrator($this->_em);
+ $result = $hydrator->hydrateAll($stmt, $rsm, array(Query::HINT_FORCE_PARTIAL_LOAD => true));
+
+ $this->assertEquals(2, count($result));
+
+ $this->assertInstanceOf('Doctrine\Tests\Models\Forum\ForumCategory', $result[0]);
+ $this->assertInstanceOf('Doctrine\Tests\Models\Forum\ForumCategory', $result[1]);
+
+ $this->assertTrue($result[0] !== $result[1]);
+
+ $this->assertEquals(1, $result[0]->getId());
+ $this->assertEquals(2, $result[1]->getId());
+
+ $this->assertTrue(isset($result[0]->boards));
+ $this->assertEquals(3, count($result[0]->boards));
+
+ $this->assertTrue(isset($result[1]->boards));
+ $this->assertEquals(1, count($result[1]->boards));
+ }
+
+ /**
+ * SELECT PARTIAL u.{id,name}
+ * FROM Doctrine\Tests\Models\CMS\CmsUser u
+ *
+ * @group DDC-644
+ */
+ public function testSkipUnknownColumns()
+ {
+ $rsm = new ResultSetMapping;
+ $rsm->addEntityResult('Doctrine\Tests\Models\CMS\CmsUser', 'u');
+ $rsm->addFieldResult('u', 'u__id', 'id');
+ $rsm->addFieldResult('u', 'u__name', 'name');
+
+ // Faked result set
+ $resultSet = array(
+ array(
+ 'u__id' => '1',
+ 'u__name' => 'romanb',
+ 'foo' => 'bar', // unknown!
+ ),
+ );
+
+ $stmt = new HydratorMockStatement($resultSet);
+ $hydrator = new \Doctrine\ORM\Internal\Hydration\ObjectHydrator($this->_em);
+ $result = $hydrator->hydrateAll($stmt, $rsm, array(Query::HINT_FORCE_PARTIAL_LOAD => true));
+
+ $this->assertEquals(1, count($result));
+ $this->assertInstanceOf('Doctrine\Tests\Models\CMS\CmsUser', $result[0]);
+ }
+
+ /**
+ * SELECT u.id, u.name
+ * FROM Doctrine\Tests\Models\CMS\CmsUser u
+ *
+ * @dataProvider provideDataForUserEntityResult
+ */
+ public function testScalarQueryWithoutResultVariables($userEntityKey)
+ {
+ $rsm = new ResultSetMapping;
+ $rsm->addEntityResult('Doctrine\Tests\Models\CMS\CmsUser', 'u', $userEntityKey ?: null);
+ $rsm->addScalarResult('sclr0', 'id');
+ $rsm->addScalarResult('sclr1', 'name');
+
+ // Faked result set
+ $resultSet = array(
+ array(
+ 'sclr0' => '1',
+ 'sclr1' => 'romanb'
+ ),
+ array(
+ 'sclr0' => '2',
+ 'sclr1' => 'jwage'
+ )
+ );
+
+ $stmt = new HydratorMockStatement($resultSet);
+ $hydrator = new \Doctrine\ORM\Internal\Hydration\ObjectHydrator($this->_em);
+ $result = $hydrator->hydrateAll($stmt, $rsm, array(Query::HINT_FORCE_PARTIAL_LOAD => true));
+
+ $this->assertEquals(2, count($result));
+
+ $this->assertInternalType('array', $result[0]);
+ $this->assertInternalType('array', $result[1]);
+
+ $this->assertEquals(1, $result[0]['id']);
+ $this->assertEquals('romanb', $result[0]['name']);
+
+ $this->assertEquals(2, $result[1]['id']);
+ $this->assertEquals('jwage', $result[1]['name']);
+ }
+
+ /**
+ * SELECT p
+ * FROM Doctrine\Tests\Models\ECommerce\ECommerceProduct p
+ */
+ public function testCreatesProxyForLazyLoadingWithForeignKeys()
+ {
+ $rsm = new ResultSetMapping;
+ $rsm->addEntityResult('Doctrine\Tests\Models\ECommerce\ECommerceProduct', 'p');
+ $rsm->addFieldResult('p', 'p__id', 'id');
+ $rsm->addFieldResult('p', 'p__name', 'name');
+ $rsm->addMetaResult('p', 'p__shipping_id', 'shipping_id');
+
+ // Faked result set
+ $resultSet = array(
+ array(
+ 'p__id' => '1',
+ 'p__name' => 'Doctrine Book',
+ 'p__shipping_id' => 42
+ )
+ );
+
+ $proxyInstance = new \Doctrine\Tests\Models\ECommerce\ECommerceShipping();
+
+ // mocking the proxy factory
+ $proxyFactory = $this->getMock('Doctrine\ORM\Proxy\ProxyFactory', array('getProxy'), array(), '', false, false, false);
+ $proxyFactory->expects($this->once())
+ ->method('getProxy')
+ ->with($this->equalTo('Doctrine\Tests\Models\ECommerce\ECommerceShipping'), array('id' => 42))
+ ->will($this->returnValue($proxyInstance));
+
+ $this->_em->setProxyFactory($proxyFactory);
+
+ // configuring lazy loading
+ $metadata = $this->_em->getClassMetadata('Doctrine\Tests\Models\ECommerce\ECommerceProduct');
+ $metadata->associationMappings['shipping']['fetch'] = ClassMetadata::FETCH_LAZY;
+
+ $stmt = new HydratorMockStatement($resultSet);
+ $hydrator = new \Doctrine\ORM\Internal\Hydration\ObjectHydrator($this->_em);
+ $result = $hydrator->hydrateAll($stmt, $rsm);
+
+ $this->assertEquals(1, count($result));
+
+ $this->assertInstanceOf('Doctrine\Tests\Models\ECommerce\ECommerceProduct', $result[0]);
+ }
+
+ /**
+ * SELECT p AS product
+ * FROM Doctrine\Tests\Models\ECommerce\ECommerceProduct p
+ */
+ public function testCreatesProxyForLazyLoadingWithForeignKeysWithAliasedProductEntity()
+ {
+ $rsm = new ResultSetMapping;
+ $rsm->addEntityResult('Doctrine\Tests\Models\ECommerce\ECommerceProduct', 'p', 'product');
+ $rsm->addFieldResult('p', 'p__id', 'id');
+ $rsm->addFieldResult('p', 'p__name', 'name');
+ $rsm->addMetaResult('p', 'p__shipping_id', 'shipping_id');
+
+ // Faked result set
+ $resultSet = array(
+ array(
+ 'p__id' => '1',
+ 'p__name' => 'Doctrine Book',
+ 'p__shipping_id' => 42
+ )
+ );
+
+ $proxyInstance = new \Doctrine\Tests\Models\ECommerce\ECommerceShipping();
+
+ // mocking the proxy factory
+ $proxyFactory = $this->getMock('Doctrine\ORM\Proxy\ProxyFactory', array('getProxy'), array(), '', false, false, false);
+ $proxyFactory->expects($this->once())
+ ->method('getProxy')
+ ->with($this->equalTo('Doctrine\Tests\Models\ECommerce\ECommerceShipping'), array('id' => 42))
+ ->will($this->returnValue($proxyInstance));
+
+ $this->_em->setProxyFactory($proxyFactory);
+
+ // configuring lazy loading
+ $metadata = $this->_em->getClassMetadata('Doctrine\Tests\Models\ECommerce\ECommerceProduct');
+ $metadata->associationMappings['shipping']['fetch'] = ClassMetadata::FETCH_LAZY;
+
+ $stmt = new HydratorMockStatement($resultSet);
+ $hydrator = new \Doctrine\ORM\Internal\Hydration\ObjectHydrator($this->_em);
+ $result = $hydrator->hydrateAll($stmt, $rsm);
+
+ $this->assertEquals(1, count($result));
+
+ $this->assertInternalType('array', $result[0]);
+ $this->assertInstanceOf('Doctrine\Tests\Models\ECommerce\ECommerceProduct', $result[0]['product']);
+ }
+
+ /**
+ * SELECT PARTIAL u.{id, status}, PARTIAL a.{id, topic}, PARTIAL c.{id, topic}
+ * FROM Doctrine\Tests\Models\CMS\CmsUser u
+ * LEFT JOIN u.articles a
+ * LEFT JOIN a.comments c
+ */
+ public function testChainedJoinWithEmptyCollections()
+ {
+ $rsm = new ResultSetMapping;
+ $rsm->addEntityResult('Doctrine\Tests\Models\CMS\CmsUser', 'u');
+ $rsm->addJoinedEntityResult(
+ 'Doctrine\Tests\Models\CMS\CmsArticle',
+ 'a',
+ 'u',
+ 'articles'
+ );
+ $rsm->addJoinedEntityResult(
+ 'Doctrine\Tests\Models\CMS\CmsComment',
+ 'c',
+ 'a',
+ 'comments'
+ );
+ $rsm->addFieldResult('u', 'u__id', 'id');
+ $rsm->addFieldResult('u', 'u__status', 'status');
+ $rsm->addFieldResult('a', 'a__id', 'id');
+ $rsm->addFieldResult('a', 'a__topic', 'topic');
+ $rsm->addFieldResult('c', 'c__id', 'id');
+ $rsm->addFieldResult('c', 'c__topic', 'topic');
+
+ // Faked result set
+ $resultSet = array(
+ //row1
+ array(
+ 'u__id' => '1',
+ 'u__status' => 'developer',
+ 'a__id' => null,
+ 'a__topic' => null,
+ 'c__id' => null,
+ 'c__topic' => null
+ ),
+ array(
+ 'u__id' => '2',
+ 'u__status' => 'developer',
+ 'a__id' => null,
+ 'a__topic' => null,
+ 'c__id' => null,
+ 'c__topic' => null
+ ),
+ );
+
+ $stmt = new HydratorMockStatement($resultSet);
+ $hydrator = new \Doctrine\ORM\Internal\Hydration\ObjectHydrator($this->_em);
+ $result = $hydrator->hydrateAll($stmt, $rsm, array(Query::HINT_FORCE_PARTIAL_LOAD => true));
+
+ $this->assertEquals(2, count($result));
+
+ $this->assertInstanceOf('Doctrine\Tests\Models\CMS\CmsUser', $result[0]);
+ $this->assertInstanceOf('Doctrine\Tests\Models\CMS\CmsUser', $result[1]);
+
+ $this->assertEquals(0, $result[0]->articles->count());
+ $this->assertEquals(0, $result[1]->articles->count());
+ }
+
+ /**
+ * SELECT PARTIAL u.{id, status} AS user, PARTIAL a.{id, topic}, PARTIAL c.{id, topic}
+ * FROM Doctrine\Tests\Models\CMS\CmsUser u
+ * LEFT JOIN u.articles a
+ * LEFT JOIN a.comments c
+ */
+ public function testChainedJoinWithEmptyCollectionsWithAliasedUserEntity()
+ {
+ $rsm = new ResultSetMapping;
+ $rsm->addEntityResult('Doctrine\Tests\Models\CMS\CmsUser', 'u', 'user');
+ $rsm->addJoinedEntityResult(
+ 'Doctrine\Tests\Models\CMS\CmsArticle',
+ 'a',
+ 'u',
+ 'articles'
+ );
+ $rsm->addJoinedEntityResult(
+ 'Doctrine\Tests\Models\CMS\CmsComment',
+ 'c',
+ 'a',
+ 'comments'
+ );
+ $rsm->addFieldResult('u', 'u__id', 'id');
+ $rsm->addFieldResult('u', 'u__status', 'status');
+ $rsm->addFieldResult('a', 'a__id', 'id');
+ $rsm->addFieldResult('a', 'a__topic', 'topic');
+ $rsm->addFieldResult('c', 'c__id', 'id');
+ $rsm->addFieldResult('c', 'c__topic', 'topic');
+
+ // Faked result set
+ $resultSet = array(
+ //row1
+ array(
+ 'u__id' => '1',
+ 'u__status' => 'developer',
+ 'a__id' => null,
+ 'a__topic' => null,
+ 'c__id' => null,
+ 'c__topic' => null
+ ),
+ array(
+ 'u__id' => '2',
+ 'u__status' => 'developer',
+ 'a__id' => null,
+ 'a__topic' => null,
+ 'c__id' => null,
+ 'c__topic' => null
+ ),
+ );
+
+ $stmt = new HydratorMockStatement($resultSet);
+ $hydrator = new \Doctrine\ORM\Internal\Hydration\ObjectHydrator($this->_em);
+ $result = $hydrator->hydrateAll($stmt, $rsm, array(Query::HINT_FORCE_PARTIAL_LOAD => true));
+
+ $this->assertEquals(2, count($result));
+
+ $this->assertInternalType('array', $result[0]);
+ $this->assertInstanceOf('Doctrine\Tests\Models\CMS\CmsUser', $result[0]['user']);
+
+ $this->assertInternalType('array', $result[1]);
+ $this->assertInstanceOf('Doctrine\Tests\Models\CMS\CmsUser', $result[1]['user']);
+
+ $this->assertEquals(0, $result[0]['user']->articles->count());
+ $this->assertEquals(0, $result[1]['user']->articles->count());
+ }
+
+ /**
+ * SELECT PARTIAL u.{id,status}, a.id, a.topic, c.id as cid, c.topic as ctopic
+ * FROM CmsUser u
+ * LEFT JOIN u.articles a
+ * LEFT JOIN a.comments c
+ *
+ * @group bubu
+ * @dataProvider provideDataForUserEntityResult
+ */
+ /*public function testChainedJoinWithScalars($userEntityKey)
+ {
+ $rsm = new ResultSetMapping;
+ $rsm->addEntityResult('Doctrine\Tests\Models\CMS\CmsUser', 'u', $userEntityKey ?: null);
+ $rsm->addFieldResult('u', 'u__id', 'id');
+ $rsm->addFieldResult('u', 'u__status', 'status');
+ $rsm->addScalarResult('a__id', 'id');
+ $rsm->addScalarResult('a__topic', 'topic');
+ $rsm->addScalarResult('c__id', 'cid');
+ $rsm->addScalarResult('c__topic', 'ctopic');
+
+ // Faked result set
+ $resultSet = array(
+ //row1
+ array(
+ 'u__id' => '1',
+ 'u__status' => 'developer',
+ 'a__id' => '1',
+ 'a__topic' => 'The First',
+ 'c__id' => '1',
+ 'c__topic' => 'First Comment'
+ ),
+ array(
+ 'u__id' => '1',
+ 'u__status' => 'developer',
+ 'a__id' => '1',
+ 'a__topic' => 'The First',
+ 'c__id' => '2',
+ 'c__topic' => 'Second Comment'
+ ),
+ array(
+ 'u__id' => '1',
+ 'u__status' => 'developer',
+ 'a__id' => '42',
+ 'a__topic' => 'The Answer',
+ 'c__id' => null,
+ 'c__topic' => null
+ ),
+ );
+
+ $stmt = new HydratorMockStatement($resultSet);
+ $hydrator = new \Doctrine\ORM\Internal\Hydration\ObjectHydrator($this->_em);
+ $result = $hydrator->hydrateAll($stmt, $rsm, array(Query::HINT_FORCE_PARTIAL_LOAD => true));
+
+ \Doctrine\Common\Util\Debug::dump($result, 3);
+
+ $this->assertEquals(1, count($result));
+
+ $this->assertInstanceOf('Doctrine\Tests\Models\CMS\CmsUser', $result[0][$userEntityKey]); // User object
+ $this->assertEquals(42, $result[0]['id']);
+ $this->assertEquals('The First', $result[0]['topic']);
+ $this->assertEquals(1, $result[0]['cid']);
+ $this->assertEquals('First Comment', $result[0]['ctopic']);
+ }*/
+
+ /**
+ * SELECT PARTIAL u.{id, name}
+ * FROM Doctrine\Tests\Models\CMS\CmsUser u
+ */
+ public function testResultIteration()
+ {
+ $rsm = new ResultSetMapping;
+ $rsm->addEntityResult('Doctrine\Tests\Models\CMS\CmsUser', 'u');
+ $rsm->addFieldResult('u', 'u__id', 'id');
+ $rsm->addFieldResult('u', 'u__name', 'name');
+
+ // Faked result set
+ $resultSet = array(
+ array(
+ 'u__id' => '1',
+ 'u__name' => 'romanb'
+ ),
+ array(
+ 'u__id' => '2',
+ 'u__name' => 'jwage'
+ )
+ );
+
+ $stmt = new HydratorMockStatement($resultSet);
+ $hydrator = new \Doctrine\ORM\Internal\Hydration\ObjectHydrator($this->_em);
+ $iterableResult = $hydrator->iterate($stmt, $rsm, array(Query::HINT_FORCE_PARTIAL_LOAD => true));
+ $rowNum = 0;
+
+ while (($row = $iterableResult->next()) !== false) {
+ $this->assertEquals(1, count($row));
+ $this->assertInstanceOf('Doctrine\Tests\Models\CMS\CmsUser', $row[0]);
+
+ if ($rowNum == 0) {
+ $this->assertEquals(1, $row[0]->id);
+ $this->assertEquals('romanb', $row[0]->name);
+ } else if ($rowNum == 1) {
+ $this->assertEquals(2, $row[0]->id);
+ $this->assertEquals('jwage', $row[0]->name);
+ }
+
+ ++$rowNum;
+ }
+ }
+
+ /**
+ * SELECT PARTIAL u.{id, name}
+ * FROM Doctrine\Tests\Models\CMS\CmsUser u
+ */
+ public function testResultIterationWithAliasedUserEntity()
+ {
+ $rsm = new ResultSetMapping;
+ $rsm->addEntityResult('Doctrine\Tests\Models\CMS\CmsUser', 'u', 'user');
+ $rsm->addFieldResult('u', 'u__id', 'id');
+ $rsm->addFieldResult('u', 'u__name', 'name');
+
+ // Faked result set
+ $resultSet = array(
+ array(
+ 'u__id' => '1',
+ 'u__name' => 'romanb'
+ ),
+ array(
+ 'u__id' => '2',
+ 'u__name' => 'jwage'
+ )
+ );
+
+ $stmt = new HydratorMockStatement($resultSet);
+ $hydrator = new \Doctrine\ORM\Internal\Hydration\ObjectHydrator($this->_em);
+ $iterableResult = $hydrator->iterate($stmt, $rsm, array(Query::HINT_FORCE_PARTIAL_LOAD => true));
+ $rowNum = 0;
+
+ while (($row = $iterableResult->next()) !== false) {
+ $this->assertEquals(1, count($row));
+ $this->assertArrayHasKey(0, $row);
+ $this->assertArrayHasKey('user', $row[0]);
+ $this->assertInstanceOf('Doctrine\Tests\Models\CMS\CmsUser', $row[0]['user']);
+
+ if ($rowNum == 0) {
+ $this->assertEquals(1, $row[0]['user']->id);
+ $this->assertEquals('romanb', $row[0]['user']->name);
+ } else if ($rowNum == 1) {
+ $this->assertEquals(2, $row[0]['user']->id);
+ $this->assertEquals('jwage', $row[0]['user']->name);
+ }
+
+ ++$rowNum;
+ }
+ }
+
+ /**
+ * Checks if multiple joined multiple-valued collections is hydrated correctly.
+ *
+ * SELECT PARTIAL u.{id, status}, PARTIAL g.{id, name}, PARTIAL p.{phonenumber}
+ * FROM Doctrine\Tests\Models\CMS\CmsUser u
+ *
+ * @group DDC-809
+ */
+ public function testManyToManyHydration()
+ {
+ $rsm = new ResultSetMapping;
+ $rsm->addEntityResult('Doctrine\Tests\Models\CMS\CmsUser', 'u');
+ $rsm->addFieldResult('u', 'u__id', 'id');
+ $rsm->addFieldResult('u', 'u__name', 'name');
+ $rsm->addJoinedEntityResult('Doctrine\Tests\Models\CMS\CmsGroup', 'g', 'u', 'groups');
+ $rsm->addFieldResult('g', 'g__id', 'id');
+ $rsm->addFieldResult('g', 'g__name', 'name');
+ $rsm->addJoinedEntityResult('Doctrine\Tests\Models\CMS\CmsPhonenumber', 'p', 'u', 'phonenumbers');
+ $rsm->addFieldResult('p', 'p__phonenumber', 'phonenumber');
+
+ // Faked result set
+ $resultSet = array(
+ array(
+ 'u__id' => '1',
+ 'u__name' => 'romanb',
+ 'g__id' => '3',
+ 'g__name' => 'TestGroupB',
+ 'p__phonenumber' => 1111,
+ ),
+ array(
+ 'u__id' => '1',
+ 'u__name' => 'romanb',
+ 'g__id' => '5',
+ 'g__name' => 'TestGroupD',
+ 'p__phonenumber' => 1111,
+ ),
+ array(
+ 'u__id' => '1',
+ 'u__name' => 'romanb',
+ 'g__id' => '3',
+ 'g__name' => 'TestGroupB',
+ 'p__phonenumber' => 2222,
+ ),
+ array(
+ 'u__id' => '1',
+ 'u__name' => 'romanb',
+ 'g__id' => '5',
+ 'g__name' => 'TestGroupD',
+ 'p__phonenumber' => 2222,
+ ),
+ array(
+ 'u__id' => '2',
+ 'u__name' => 'jwage',
+ 'g__id' => '2',
+ 'g__name' => 'TestGroupA',
+ 'p__phonenumber' => 3333,
+ ),
+ array(
+ 'u__id' => '2',
+ 'u__name' => 'jwage',
+ 'g__id' => '3',
+ 'g__name' => 'TestGroupB',
+ 'p__phonenumber' => 3333,
+ ),
+ array(
+ 'u__id' => '2',
+ 'u__name' => 'jwage',
+ 'g__id' => '4',
+ 'g__name' => 'TestGroupC',
+ 'p__phonenumber' => 3333,
+ ),
+ array(
+ 'u__id' => '2',
+ 'u__name' => 'jwage',
+ 'g__id' => '5',
+ 'g__name' => 'TestGroupD',
+ 'p__phonenumber' => 3333,
+ ),
+ array(
+ 'u__id' => '2',
+ 'u__name' => 'jwage',
+ 'g__id' => '2',
+ 'g__name' => 'TestGroupA',
+ 'p__phonenumber' => 4444,
+ ),
+ array(
+ 'u__id' => '2',
+ 'u__name' => 'jwage',
+ 'g__id' => '3',
+ 'g__name' => 'TestGroupB',
+ 'p__phonenumber' => 4444,
+ ),
+ array(
+ 'u__id' => '2',
+ 'u__name' => 'jwage',
+ 'g__id' => '4',
+ 'g__name' => 'TestGroupC',
+ 'p__phonenumber' => 4444,
+ ),
+ array(
+ 'u__id' => '2',
+ 'u__name' => 'jwage',
+ 'g__id' => '5',
+ 'g__name' => 'TestGroupD',
+ 'p__phonenumber' => 4444,
+ ),
+ );
+
+ $stmt = new HydratorMockStatement($resultSet);
+ $hydrator = new \Doctrine\ORM\Internal\Hydration\ObjectHydrator($this->_em);
+ $result = $hydrator->hydrateAll($stmt, $rsm, array(Query::HINT_FORCE_PARTIAL_LOAD => true));
+
+ $this->assertEquals(2, count($result));
+
+ $this->assertContainsOnly('Doctrine\Tests\Models\CMS\CmsUser', $result);
+
+ $this->assertEquals(2, count($result[0]->groups));
+ $this->assertEquals(2, count($result[0]->phonenumbers));
+
+ $this->assertEquals(4, count($result[1]->groups));
+ $this->assertEquals(2, count($result[1]->phonenumbers));
+ }
+
+ /**
+ * Checks if multiple joined multiple-valued collections is hydrated correctly.
+ *
+ * SELECT PARTIAL u.{id, status} As user, PARTIAL g.{id, name}, PARTIAL p.{phonenumber}
+ * FROM Doctrine\Tests\Models\CMS\CmsUser u
+ *
+ * @group DDC-809
+ */
+ public function testManyToManyHydrationWithAliasedUserEntity()
+ {
+ $rsm = new ResultSetMapping;
+ $rsm->addEntityResult('Doctrine\Tests\Models\CMS\CmsUser', 'u', 'user');
+ $rsm->addFieldResult('u', 'u__id', 'id');
+ $rsm->addFieldResult('u', 'u__name', 'name');
+ $rsm->addJoinedEntityResult('Doctrine\Tests\Models\CMS\CmsGroup', 'g', 'u', 'groups');
+ $rsm->addFieldResult('g', 'g__id', 'id');
+ $rsm->addFieldResult('g', 'g__name', 'name');
+ $rsm->addJoinedEntityResult('Doctrine\Tests\Models\CMS\CmsPhonenumber', 'p', 'u', 'phonenumbers');
+ $rsm->addFieldResult('p', 'p__phonenumber', 'phonenumber');
+
+ // Faked result set
+ $resultSet = array(
+ array(
+ 'u__id' => '1',
+ 'u__name' => 'romanb',
+ 'g__id' => '3',
+ 'g__name' => 'TestGroupB',
+ 'p__phonenumber' => 1111,
+ ),
+ array(
+ 'u__id' => '1',
+ 'u__name' => 'romanb',
+ 'g__id' => '5',
+ 'g__name' => 'TestGroupD',
+ 'p__phonenumber' => 1111,
+ ),
+ array(
+ 'u__id' => '1',
+ 'u__name' => 'romanb',
+ 'g__id' => '3',
+ 'g__name' => 'TestGroupB',
+ 'p__phonenumber' => 2222,
+ ),
+ array(
+ 'u__id' => '1',
+ 'u__name' => 'romanb',
+ 'g__id' => '5',
+ 'g__name' => 'TestGroupD',
+ 'p__phonenumber' => 2222,
+ ),
+ array(
+ 'u__id' => '2',
+ 'u__name' => 'jwage',
+ 'g__id' => '2',
+ 'g__name' => 'TestGroupA',
+ 'p__phonenumber' => 3333,
+ ),
+ array(
+ 'u__id' => '2',
+ 'u__name' => 'jwage',
+ 'g__id' => '3',
+ 'g__name' => 'TestGroupB',
+ 'p__phonenumber' => 3333,
+ ),
+ array(
+ 'u__id' => '2',
+ 'u__name' => 'jwage',
+ 'g__id' => '4',
+ 'g__name' => 'TestGroupC',
+ 'p__phonenumber' => 3333,
+ ),
+ array(
+ 'u__id' => '2',
+ 'u__name' => 'jwage',
+ 'g__id' => '5',
+ 'g__name' => 'TestGroupD',
+ 'p__phonenumber' => 3333,
+ ),
+ array(
+ 'u__id' => '2',
+ 'u__name' => 'jwage',
+ 'g__id' => '2',
+ 'g__name' => 'TestGroupA',
+ 'p__phonenumber' => 4444,
+ ),
+ array(
+ 'u__id' => '2',
+ 'u__name' => 'jwage',
+ 'g__id' => '3',
+ 'g__name' => 'TestGroupB',
+ 'p__phonenumber' => 4444,
+ ),
+ array(
+ 'u__id' => '2',
+ 'u__name' => 'jwage',
+ 'g__id' => '4',
+ 'g__name' => 'TestGroupC',
+ 'p__phonenumber' => 4444,
+ ),
+ array(
+ 'u__id' => '2',
+ 'u__name' => 'jwage',
+ 'g__id' => '5',
+ 'g__name' => 'TestGroupD',
+ 'p__phonenumber' => 4444,
+ ),
+ );
+
+ $stmt = new HydratorMockStatement($resultSet);
+ $hydrator = new \Doctrine\ORM\Internal\Hydration\ObjectHydrator($this->_em);
+ $result = $hydrator->hydrateAll($stmt, $rsm, array(Query::HINT_FORCE_PARTIAL_LOAD => true));
+
+ $this->assertEquals(2, count($result));
+
+ $this->assertInternalType('array', $result[0]);
+ $this->assertInstanceOf('Doctrine\Tests\Models\CMS\CmsUser', $result[0]['user']);
+ $this->assertInternalType('array', $result[1]);
+ $this->assertInstanceOf('Doctrine\Tests\Models\CMS\CmsUser', $result[1]['user']);
+
+ $this->assertEquals(2, count($result[0]['user']->groups));
+ $this->assertEquals(2, count($result[0]['user']->phonenumbers));
+
+ $this->assertEquals(4, count($result[1]['user']->groups));
+ $this->assertEquals(2, count($result[1]['user']->phonenumbers));
+ }
+
+ /**
+ * SELECT PARTIAL u.{id, status}, UPPER(u.name) as nameUpper
+ * FROM Doctrine\Tests\Models\CMS\CmsUser u
+ *
+ * @group DDC-1358
+ * @dataProvider provideDataForUserEntityResult
+ */
+ public function testMissingIdForRootEntity($userEntityKey)
+ {
+ $rsm = new ResultSetMapping;
+ $rsm->addEntityResult('Doctrine\Tests\Models\CMS\CmsUser', 'u', $userEntityKey ?: null);
+ $rsm->addFieldResult('u', 'u__id', 'id');
+ $rsm->addFieldResult('u', 'u__status', 'status');
+ $rsm->addScalarResult('sclr0', 'nameUpper');
+
+ // Faked result set
+ $resultSet = array(
+ //row1
+ array(
+ 'u__id' => '1',
+ 'u__status' => 'developer',
+ 'sclr0' => 'ROMANB',
+ ),
+ array(
+ 'u__id' => null,
+ 'u__status' => null,
+ 'sclr0' => 'ROMANB',
+ ),
+ array(
+ 'u__id' => '2',
+ 'u__status' => 'developer',
+ 'sclr0' => 'JWAGE',
+ ),
+ array(
+ 'u__id' => null,
+ 'u__status' => null,
+ 'sclr0' => 'JWAGE',
+ ),
+ );
+
+ $stmt = new HydratorMockStatement($resultSet);
+ $hydrator = new \Doctrine\ORM\Internal\Hydration\ObjectHydrator($this->_em);
+ $result = $hydrator->hydrateAll($stmt, $rsm, array(Query::HINT_FORCE_PARTIAL_LOAD => true));
+
+ $this->assertEquals(4, count($result), "Should hydrate four results.");
+
+ $this->assertEquals('ROMANB', $result[0]['nameUpper']);
+ $this->assertEquals('ROMANB', $result[1]['nameUpper']);
+ $this->assertEquals('JWAGE', $result[2]['nameUpper']);
+ $this->assertEquals('JWAGE', $result[3]['nameUpper']);
+
+ $this->assertInstanceOf('Doctrine\Tests\Models\CMS\CmsUser', $result[0][$userEntityKey]);
+ $this->assertNull($result[1][$userEntityKey]);
+
+ $this->assertInstanceOf('Doctrine\Tests\Models\CMS\CmsUser', $result[2][$userEntityKey]);
+ $this->assertNull($result[3][$userEntityKey]);
+ }
+
+ /**
+ * SELECT PARTIAL u.{id, status}, PARTIAL p.{phonenumber}, UPPER(u.name) AS nameUpper
+ * FROM Doctrine\Tests\Models\CMS\CmsUser u
+ * LEFT JOIN u.phonenumbers u
+ *
+ * @group DDC-1358
+ * @dataProvider provideDataForUserEntityResult
+ */
+ public function testMissingIdForCollectionValuedChildEntity($userEntityKey)
+ {
+ $rsm = new ResultSetMapping;
+ $rsm->addEntityResult('Doctrine\Tests\Models\CMS\CmsUser', 'u', $userEntityKey ?: null);
+ $rsm->addJoinedEntityResult(
+ 'Doctrine\Tests\Models\CMS\CmsPhonenumber',
+ 'p',
+ 'u',
+ 'phonenumbers'
+ );
+ $rsm->addFieldResult('u', 'u__id', 'id');
+ $rsm->addFieldResult('u', 'u__status', 'status');
+ $rsm->addScalarResult('sclr0', 'nameUpper');
+ $rsm->addFieldResult('p', 'p__phonenumber', 'phonenumber');
+
+ // Faked result set
+ $resultSet = array(
+ //row1
+ array(
+ 'u__id' => '1',
+ 'u__status' => 'developer',
+ 'sclr0' => 'ROMANB',
+ 'p__phonenumber' => '42',
+ ),
+ array(
+ 'u__id' => '1',
+ 'u__status' => 'developer',
+ 'sclr0' => 'ROMANB',
+ 'p__phonenumber' => null
+ ),
+ array(
+ 'u__id' => '2',
+ 'u__status' => 'developer',
+ 'sclr0' => 'JWAGE',
+ 'p__phonenumber' => '91'
+ ),
+ array(
+ 'u__id' => '2',
+ 'u__status' => 'developer',
+ 'sclr0' => 'JWAGE',
+ 'p__phonenumber' => null
+ )
+ );
+
+ $stmt = new HydratorMockStatement($resultSet);
+ $hydrator = new \Doctrine\ORM\Internal\Hydration\ObjectHydrator($this->_em);
+ $result = $hydrator->hydrateAll($stmt, $rsm, array(Query::HINT_FORCE_PARTIAL_LOAD => true));
+
+ $this->assertEquals(2, count($result));
+
+ $this->assertEquals(1, $result[0][$userEntityKey]->phonenumbers->count());
+ $this->assertEquals(1, $result[1][$userEntityKey]->phonenumbers->count());
+ }
+
+ /**
+ * SELECT PARTIAL u.{id, status}, PARTIAL a.{id, city}, UPPER(u.name) AS nameUpper
+ * FROM Doctrine\Tests\Models\CMS\CmsUser u
+ * JOIN u.address a
+ *
+ * @group DDC-1358
+ * @dataProvider provideDataForUserEntityResult
+ */
+ public function testMissingIdForSingleValuedChildEntity($userEntityKey)
+ {
+ $rsm = new ResultSetMapping;
+ $rsm->addEntityResult('Doctrine\Tests\Models\CMS\CmsUser', 'u', $userEntityKey ?: null);
+ $rsm->addJoinedEntityResult(
+ 'Doctrine\Tests\Models\CMS\CmsAddress',
+ 'a',
+ 'u',
+ 'address'
+ );
+ $rsm->addFieldResult('u', 'u__id', 'id');
+ $rsm->addFieldResult('u', 'u__status', 'status');
+ $rsm->addScalarResult('sclr0', 'nameUpper');
+ $rsm->addFieldResult('a', 'a__id', 'id');
+ $rsm->addFieldResult('a', 'a__city', 'city');
+ $rsm->addMetaResult('a', 'user_id', 'user_id');
+
+ // Faked result set
+ $resultSet = array(
+ //row1
+ array(
+ 'u__id' => '1',
+ 'u__status' => 'developer',
+ 'sclr0' => 'ROMANB',
+ 'a__id' => 1,
+ 'a__city' => 'Berlin',
+ ),
+ array(
+ 'u__id' => '2',
+ 'u__status' => 'developer',
+ 'sclr0' => 'BENJAMIN',
+ 'a__id' => null,
+ 'a__city' => null,
+ ),
+ );
+
+ $stmt = new HydratorMockStatement($resultSet);
+ $hydrator = new \Doctrine\ORM\Internal\Hydration\ObjectHydrator($this->_em);
+ $result = $hydrator->hydrateAll($stmt, $rsm, array(Query::HINT_FORCE_PARTIAL_LOAD => true));
+
+ $this->assertEquals(2, count($result));
+
+ $this->assertInstanceOf('Doctrine\Tests\Models\CMS\CmsAddress', $result[0][$userEntityKey]->address);
+ $this->assertNull($result[1][$userEntityKey]->address);
+ }
+
+ /**
+ * SELECT PARTIAL u.{id, status}, UPPER(u.name) AS nameUpper
+ * FROM Doctrine\Tests\Models\CMS\CmsUser u
+ * INDEX BY u.id
+ *
+ * @group DDC-1385
+ * @dataProvider provideDataForUserEntityResult
+ */
+ public function testIndexByAndMixedResult($userEntityKey)
+ {
+ $rsm = new ResultSetMapping;
+ $rsm->addEntityResult('Doctrine\Tests\Models\CMS\CmsUser', 'u', $userEntityKey ?: null);
+ $rsm->addFieldResult('u', 'u__id', 'id');
+ $rsm->addFieldResult('u', 'u__status', 'status');
+ $rsm->addScalarResult('sclr0', 'nameUpper');
+ $rsm->addIndexBy('u', 'id');
+
+ // Faked result set
+ $resultSet = array(
+ //row1
+ array(
+ 'u__id' => '1',
+ 'u__status' => 'developer',
+ 'sclr0' => 'ROMANB',
+ ),
+ array(
+ 'u__id' => '2',
+ 'u__status' => 'developer',
+ 'sclr0' => 'JWAGE',
+ ),
+ );
+
+ $stmt = new HydratorMockStatement($resultSet);
+ $hydrator = new \Doctrine\ORM\Internal\Hydration\ObjectHydrator($this->_em);
+ $result = $hydrator->hydrateAll($stmt, $rsm, array(Query::HINT_FORCE_PARTIAL_LOAD => true));
+
+ $this->assertEquals(2, count($result));
+
+ $this->assertTrue(isset($result[1]));
+ $this->assertEquals(1, $result[1][$userEntityKey]->id);
+
+ $this->assertTrue(isset($result[2]));
+ $this->assertEquals(2, $result[2][$userEntityKey]->id);
+ }
+
+ /**
+ * SELECT UPPER(u.name) AS nameUpper
+ * FROM Doctrine\Tests\Models\CMS\CmsUser u
+ *
+ * @group DDC-1385
+ * @dataProvider provideDataForUserEntityResult
+ */
+ public function testIndexByScalarsOnly($userEntityKey)
+ {
+ $rsm = new ResultSetMapping;
+ $rsm->addEntityResult('Doctrine\Tests\Models\CMS\CmsUser', 'u', $userEntityKey ?: null);
+ $rsm->addScalarResult('sclr0', 'nameUpper');
+ $rsm->addIndexByScalar('sclr0');
+
+ // Faked result set
+ $resultSet = array(
+ //row1
+ array(
+ 'sclr0' => 'ROMANB',
+ ),
+ array(
+ 'sclr0' => 'JWAGE',
+ ),
+ );
+
+ $stmt = new HydratorMockStatement($resultSet);
+ $hydrator = new \Doctrine\ORM\Internal\Hydration\ObjectHydrator($this->_em);
+ $result = $hydrator->hydrateAll($stmt, $rsm, array(Query::HINT_FORCE_PARTIAL_LOAD => true));
+
+ $this->assertEquals(
+ array(
+ 'ROMANB' => array('nameUpper' => 'ROMANB'),
+ 'JWAGE' => array('nameUpper' => 'JWAGE')
+ ),
+ $result
+ );
+ }
+
+
+ /**
+ * @group DDC-1470
+ *
+ * @expectedException \Doctrine\ORM\Internal\Hydration\HydrationException
+ * @expectedExceptionMessage The meta mapping for the discriminator column "c_discr" is missing for "Doctrine\Tests\Models\Company\CompanyFixContract" using the DQL alias "c".
+ */
+ public function testMissingMetaMappingException()
+ {
+ $rsm = new ResultSetMapping;
+
+ $rsm->addEntityResult('Doctrine\Tests\Models\Company\CompanyFixContract', 'c');
+ $rsm->addJoinedEntityResult('Doctrine\Tests\Models\Company\CompanyEmployee', 'e', 'c', 'salesPerson');
+
+ $rsm->addFieldResult('c', 'c__id', 'id');
+ $rsm->setDiscriminatorColumn('c', 'c_discr');
+
+ $resultSet = array(
+ array(
+ 'c__id' => '1',
+ 'c_discr' => 'fix',
+ ),
+ );
+
+ $stmt = new HydratorMockStatement($resultSet);
+ $hydrator = new \Doctrine\ORM\Internal\Hydration\ObjectHydrator($this->_em);
+ $hydrator->hydrateAll($stmt, $rsm);
+ }
+
+ /**
+ * @group DDC-1470
+ *
+ * @expectedException \Doctrine\ORM\Internal\Hydration\HydrationException
+ * @expectedExceptionMessage The discriminator column "discr" is missing for "Doctrine\Tests\Models\Company\CompanyEmployee" using the DQL alias "e".
+ */
+ public function testMissingDiscriminatorColumnException()
+ {
+ $rsm = new ResultSetMapping;
+
+ $rsm->addEntityResult('Doctrine\Tests\Models\Company\CompanyFixContract', 'c');
+ $rsm->addJoinedEntityResult('Doctrine\Tests\Models\Company\CompanyEmployee', 'e', 'c', 'salesPerson');
+
+ $rsm->addFieldResult('c', 'c__id', 'id');
+ $rsm->addMetaResult('c', 'c_discr', 'discr');
+ $rsm->setDiscriminatorColumn('c', 'c_discr');
+
+ $rsm->addFieldResult('e', 'e__id', 'id');
+ $rsm->addFieldResult('e', 'e__name', 'name');
+ $rsm->addMetaResult('e ', 'e_discr', 'discr');
+ $rsm->setDiscriminatorColumn('e', 'e_discr');
+
+ $resultSet = array(
+ array(
+ 'c__id' => '1',
+ 'c_discr' => 'fix',
+ 'e__id' => '1',
+ 'e__name' => 'Fabio B. Silva'
+ ),
+ );
+
+ $stmt = new HydratorMockStatement($resultSet);
+ $hydrator = new \Doctrine\ORM\Internal\Hydration\ObjectHydrator($this->_em);
+ $hydrator->hydrateAll($stmt, $rsm);
+ }
+}
projects / zf2.biz / application_blanche.git / blobdiff