Yii: nesting lazy loading with eager loading

Question

Sure I'm missing out something or not thinking about a better way to accomplish what I need, but here is what I want to do.

I have three models: A, B and C. A has a relation MANY-MANY with B called relation1, and Bhas a relation MANY-MANY with C, called relation2. I want to get all B records with their C relations (eager loading), but just from an A instance (lazy loading, because I don't want to waste memory loading all relation1 instances).

So, what I want to do should be something like the following:

A::model()->findByPk($somePrimaryKey)->relation1->with('relation2');

Of course that's not working because using relation1 lazy loading I'm getting an array of instances and then I'm tryng to apply the with() method to a non-object.

Sure I can do a little bit of work around iterating through the array, but I want to know if there is a quick and elegent way :)

Thank you!

Asgaroth · Accepted Answer · 2011-11-23 16:49:45Z

3

You can try this:

A::model()->findByPk($somePrimaryKey)->with('relation1.relation2');

I cant find any sense in that you "don't want to waste memory loading all relation1 instances"

This way you are just loading the B models that relate to that specific A model. not all of them.

Also take a look at Relational Query with through

answered Nov 23, 2011 at 16:49

Asgaroth

4,3443 gold badges22 silver badges36 bronze badges

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

1 Comment

Waiting for Dev... Over a year ago

Ok, thank you @Asgaroth. I thought that nesting the two with that way I was loading first all records of relation1.

Collectives™ on Stack Overflow

Yii: nesting lazy loading with eager loading

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related