StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POTest Doctrine ODM respository with phpunit in Symfony2
primarykey
Id
16397268
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
2
CommunityOwnedDate
CreationDate
2013-05-06T10:57:30.100
FavoriteCount
0
LastActivityDate
2013-05-06T14:42:33.190
LastEditDate
2013-05-06T14:42:33.190
LastEditorUserId
1367490
OwnerUserId
1367490
ParentId
0
PostTypeId
1
Score
2
ViewCount
2232
LastEditorDisplayName
text
Body
I want to test this simple query: <pre><code>public function findArticlesByUsers($ids) { $qb = $this->createQueryBuilder(); $qb ->addOr($qb->expr()->field('creator.id')->in($ids)) ->addOr($qb->expr()->field('modifier.id')->in($ids)) ->addOr($qb->expr()->field('publisher.id')->in($ids)); $query = $qb->getQuery(); $results = $query->execute(); return $results; } </code></pre> Where creator, modifier and publisher can be differents user. I'm following this example of Symfony doc: <a href="http://symfony.com/doc/current/cookbook/testing/database.html#mocking-the-repository-in-a-unit-test" rel="nofollow">http://symfony.com/doc/current/cookbook/testing/database.html#mocking-the-repository-in-a-unit-test</a> How to test this query builder?. My code look like this: <pre><code>public function testFindArticlesByUsers() { $article = $this->getMock('\Acme\DemoBundle\Document\Article'); $article->expects($this->once()) ->method('getCreator') ->will($this->returnValue($this->getMock('\Acme\DemoBundle\Document\\User'))); $article->expects($this->once()) ->method('getModifier') ->will($this->returnValue($this->getMock('\Acme\DemoBundle\Document\\User'))); $article->expects($this->once()) ->method('getPublisher') ->will($this->returnValue($this->getMock('\Acme\DemoBundle\Document\\User'))); $articleRepository = $this->getMockBuilder('\Doctrine\ODM\DocumentRepository') ->setMethods(array('findArticlesByUsers')) ->disableOriginalConstructor() ->getMock(); $articleRepository->expects($this->once()) ->method('findArticlesByUsers') ->will($this->returnValue($article)); $documentManager = $this->getMockBuilder('\Doctrine\Common\Persistence\ObjectManager') ->disableOriginalConstructor() ->getMock(); $documentManager->expects($this->once()) ->method('getRepository') ->will($this->returnValue($articleRepository)); $article2 = $documentManager->getRepository('BackendBundle:Article') ->findArticlesByUsers(1); } </code></pre> I haven't idea continuous with it and if this is the correct way. The error is: <pre><code>Expectation failed for method name is equal to <string:getCreator> when invoked 1 time(s). Method was expected to be called 1 times, actually called 0 times. </code></pre> But I'm not sure how to test this and check the result. Update: I changed the code to pass the test(ok, it's green) but for me this test doesn't work fine because although delete findArticlesByUsers method the test is green. What I'm doing wrong? <pre><code>public function testFindArticlesByUsers() { $userCreator = $this->getMock('\TT\BackendBundle\Document\User'); $userCreator->expects($this->any()) ->method('getId') ->will($this->returnValue(1)); $userModifier = $this->getMock('\TT\BackendBundle\Document\User'); $userModifier->expects($this->any()) ->method('getId') ->will($this->returnValue(2)); $userPublisher = $this->getMock('\TT\BackendBundle\Document\User'); $userPublisher->expects($this->any()) ->method('getId') ->will($this->returnValue(3)); //Article mock $article = $this->getMock('\TT\BackendBundle\Document\Article'); $article->expects($this->once()) ->method('getCreator') ->will($this->returnValue($userCreator)); $article->expects($this->once()) ->method('getModifier') ->will($this->returnValue($userModifier)); $article->expects($this->once()) ->method('getPublisher') ->will($this->returnValue($userPublisher)); $articleRepository = $this->getMockBuilder('\Doctrine\ODM\DocumentRepository') ->setMethods(array('findArticlesByUsers')) ->disableOriginalConstructor() ->getMock(); $articleRepository->expects($this->once()) ->method('findArticlesByUsers') ->will($this->returnValue($article)); $documentManager = $this->getMockBuilder('\Doctrine\Common\Persistence\ObjectManager') ->disableOriginalConstructor() ->getMock(); $documentManager->expects($this->once()) ->method('getRepository') ->will($this->returnValue($articleRepository)); $article = $documentManager->getRepository('BackendBundle:Article') ->findArticlesByUsers(1); $this->assertEquals(1, $article->getCreator()->getId()); $this->assertEquals(2, $article->getModifier()->getId()); $this->assertEquals(3, $article->getPublisher()->getId()); } </code></pre> Update2: I think finally I understand mock object :) so doing as above I'm mocking the repository but this isn't the objetive. My last code to test this method is: <pre><code>public function testFindArticlesByUsers() { $userId = $this->dm->createQueryBuilder('AcmeBundle:User') ->field('username')->equals('fakeUser') ->getQuery()->getSingleResult()->getId(); $articles = $this->dm->getRepository('AcmeBundle:Article') ->findArticlesByUsers(array($userId)); $this->assertGreaterThanOrEqual(1, count($articles)); } </code></pre> The test works although it depends on of it the user exists and has articles. Is ok the test?
Tags
<symfony><mocking><phpunit><doctrine-odm>
Title
Test Doctrine ODM respository with phpunit in Symfony2
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. This table or related slice is empty.
PostTypePostTypeId
1. PTQuestion
UserLastEditorUserId
1. USBiruwon
UserOwnerUserId
1. USBiruwon
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. This table or related slice is empty.
VotesPostIdCreationDate
1. This table or related slice is empty.
CommentsPostId
1. This table or related slice is empty.

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.