{"id":1612,"date":"2022-08-30T15:17:59","date_gmt":"2022-08-30T15:17:59","guid":{"rendered":"https:\/\/unknownerror.org\/index.php\/2013\/11\/27\/using-doctrine-how-do-you-access-entity-methods-from-a-entityrepository-collection-of-common-programming-errors\/"},"modified":"2022-08-30T15:17:59","modified_gmt":"2022-08-30T15:17:59","slug":"using-doctrine-how-do-you-access-entity-methods-from-a-entityrepository-collection-of-common-programming-errors","status":"publish","type":"post","link":"https:\/\/unknownerror.org\/index.php\/2022\/08\/30\/using-doctrine-how-do-you-access-entity-methods-from-a-entityrepository-collection-of-common-programming-errors\/","title":{"rendered":"Using Doctrine, how do you access Entity methods from a EntityRepository?-Collection of common programming errors"},"content":{"rendered":"

In the Symfony “Book”, they talk about Entities with references to other entities. Like, in my case, if I have a “Post” Entity with many “Comment” Entities referencing it, I can load the Post by its ID and then do $post->getComments().<\/p>\n

The Comment are lazy-loaded, it seems, and I would have to either go one-by-one through them, loading each (which is clearly wrong) or load them all in a separate query (which I could do, but I don’t know where, specifically, to put that query). The Book, however, suggests: “Of course, if you know up front that you’ll need to access both objects, you can avoid the second query by issuing a join in the original query.” It recommends I add a method to my (currently-empty) postRepository class. I do, and it looks like this:<\/p>\n

public function loadPostFull($pid)\n{\n    return $this->getEntityManager()\n        ->createQuery('\n            SELECT p, c FROM BUNDLENAME:Post p\n            JOIN p.comments c\n            WHERE p.id = :id')\n        ->setParameter('id', $pid);\n    try {\n        return $query->getSingleResult();\n    } catch (\\Doctrine\\ORM\\NoResultException $e) {\n        return null;\n    }\n}\n<\/code><\/pre>\n
And then in my controller I do:<\/p>\n
$fullPost = $this->getDoctrine()\n            ->getRepository('BUNDLENAME:Post')\n            ->loadPostFull($id);\n$id = $fullPost->getId();\n<\/code><\/pre>\n
But my simple request for $id gives a “Fatal error: Call to undefined method Doctrine\\ORM\\Query::getId()”. I know the controller is finding the loadPostFull method correctly, because if I typo the name it will fail there. It’s just not returning a proper Post entity. If I change the controller to call ->find($id) instead of ->loadPostFull($id) I can use all the internal methods of the Post id.<\/p>\n
The manual seems to indicate I can do that! What’s wrong?<\/p>\n
    \n
  1. \n
    I believe you have a typo :). Look at the first line of your code. You have a return<\/strong> statement! So you return the Query object and try { } catch() { } is never reached. You should put it like this:<\/p>\n
    $query = $this->getEntityManager()\n    ->createQuery('\n        SELECT p, c FROM BUNDLENAME:Post p\n        JOIN p.comments c\n        WHERE p.id = :id')\n    ->setParameter('id', $pid);\ntry {\n    return $query->getSingleResult();\n} catch (\\Doctrine\\ORM\\NoResultException $e) {\n    return null;\n}\n<\/code><\/pre>\n<\/li>\n<\/ol>\n
    Originally posted 2013-11-27 12:01:56. <\/small><\/p>","protected":false},"excerpt":{"rendered":"
    In the Symfony “Book”, they talk about Entities with references to other entities. Like, in my case, if I have a “Post” Entity with many “Comment” Entities referencing it, I can load the Post by its ID and then do $post->getComments(). The Comment are lazy-loaded, it seems, and I would have to either go one-by-one […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-1612","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"_links":{"self":[{"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/posts\/1612","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/comments?post=1612"}],"version-history":[{"count":0,"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/posts\/1612\/revisions"}],"wp:attachment":[{"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/media?parent=1612"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/categories?post=1612"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/tags?post=1612"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}