How to get association foreign key IDs in Doctrine 2 without loading the associated object?

Question

Hi I'm having trouble with what I thought would be an easy task.

I am retrieving a post from the database. The Post entity has a field createdBy which is associated to a User entity.

What I would like to do is load Post and User with two separate queries (no join). That means I need to have access to the created_by foreign key integer on the $post object. Doctrine does not seem to expose that at all. A var_dump of post shows createdBy => null. If I join the user on directly in the post query createdBy => User object. Is there no way to get the created_by foreign key integer from post so I can query for the user?

Thanks

Maxence · Accepted Answer · 2011-07-27 21:10:59Z

20

Use this on your query:

$q->setHint(\Doctrine\ORM\Query::HINT_INCLUDE_META_COLUMNS, true); $q->getResult(\Doctrine\ORM\Query::HYDRATE_ARRAY);

Hydratation is disabled, so you have your result as an array.

edited Jul 27, 2011 at 21:10

answered Jul 27, 2011 at 6:01

Maxence

13.4k5 gold badges63 silver badges72 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Marc Over a year ago

Ah great. Hadn't known about that hint. However there does not seem to be a setHydrate method on the query object. You can just hydrate it as an array though and it works (and you still get a nicely hydrated result). $q->getResult(\Doctrine\ORM\Query::HYDRATE_ARRAY); If you update your answer I'll accept it. Thanks!

Marc Over a year ago

I actually just decided to give the MongoDB ODM a try so I'll keep that in mind. Thanks!

Collectives™ on Stack Overflow

How to get association foreign key IDs in Doctrine 2 without loading the associated object?

1 Answer 1

2 Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Linked

Related