How to limit Twig SQL request number with Doctrine

Question

When using Twig with Doctrine on related entities, a new SQL request is launch every time I want to access a new related variable, like {{ flight.flightSteps[0].position}}

I read on another post here : Symfony2 and Doctrine2 - QueryBuilder with relational entities this:

When you do $p->getSection()->getName() from a Controller or p.section.name from a Twig template, without having stated the JOIN in the query (with default QueryBuilder), Doctrine requests missing informations of the relation at this time. That could be very heavy if you do that in a loop, like in a list display... So try to load what you need from relations at first request ;)

It ends with:

So try to load what you need from relations at first request ;)

So I am looking for a way to create a request directly with the QueryBuilder so that when I call a related variable in my Twig template the query is not executed one more time, but I don't find how to do it.

Here is what I did but that did not work:

$query = $this->createQueryBuilder('f')
                ->where('f.id = :id')
                ->setParameter('id', $id)
                ->leftJoin('f.flightSteps', 's')
                ->orderBy('s.sortPosition', 'ASC')
                ->getQuery();

return $query->getResult();

I still have a new SQL request executed when I call {{ flight.flightSteps[0].position }}

tomhv · Accepted Answer · 2015-05-21 23:06:49Z

1

I think you could also, add the s in the createQueryBuilder() too:

$query = $this->createQueryBuilder('f, s')
// ...

answered May 21, 2015 at 23:06

tomhv

236 bronze badges

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

1 Comment

user2108742 Over a year ago

No, it is not working. Twig executes the sql request again. I think addSelect is the only way..

user2108742 · Accepted Answer · 2015-05-21 20:35:12Z

0

After 2 days of research, I jut found the solution just after I posted it...

I need to add an addSelect like it:

$query = $this->createQueryBuilder('f')
            ->where('f.id = :id')
            ->setParameter('id', $id)
            ->leftJoin('f.flightSteps', 's')
            ->orderBy('s.sortPosition', 'ASC')
            ->addSelect('s')
            ->getQuery();

return $query->getResult();

answered May 21, 2015 at 20:35

user2108742

11712 bronze badges

Collectives™ on Stack Overflow

How to limit Twig SQL request number with Doctrine

2 Answers 2

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related