How can I select all relations automatically in Doctrine?

Question

I have a rather big number of classes related to each other via various relations (OneToOne, OneToMany, ManyToOne as well as Class- and Joined Inheritance which in turn again have multiple relations.

When I want to select all of a parent class via a simple ->findAll(), I get around 10 extra queries per Entity. I can reduce this number by a limited extend by unsing the a QueryBuilder with ->leftJoin() and ->addSelect(). Some relations do not join because reasons. Still, it gets a pretty nasty long list of addSelect()s. Is there a way to join and select all relations automatically?

score 1 · Accepted Answer · answered Feb 08 '18 at 13:58

The automatical join can be achieved by setting the fetch-mode of the associations to eager (e.g. on ManyToOne:

/**
 * @ManyToOne(targetEntity="Cart", cascade={"all"}, fetch="EAGER")
 */

, see the docs)

To set the fetch mode programatically, refer to another StackOverflow question.

score 0 · Answer 2 · answered Feb 06 '18 at 23:44

0

Try using "JoinTable" or "JoinColumn"

http://docs.doctrine-project.org/projects/doctrine-orm/en/latest/reference/annotations-reference.html#jointable

answered Feb 06 '18 at 23:44

Cesur APAYDIN

806
3
11
24

Thank you for your response. Unfortunately, I am already using JoinTable as well as JoinColumn, depending on the Entity – BernhardWebstudio Feb 07 '18 at 07:21

How can I select all relations automatically in Doctrine?

2 Answers2