Saturday, July 12, 2014

Re: Cake splitting up my queries

After discussing the issue with qrok on irc,
try to change the perspective:

$ships = $this->Ship->find('all', [
            'conditions' => ['Ship.user_id' => 5],
            'contain' => [
                'ShipComponent' => [
                    'ShipSlot' => [
                        'ShipType' => [
                            'conditions' => [
//                                'ShipComponent.ship_id = Ship.id'
                            ]
                        ],
                    ]
                ]
            ]
        ]);

This will result in more than one query again, as that is just the way cakephps orm is working, but does not rely on the additional condition...

--
Like Us on FaceBook https://www.facebook.com/CakePHP
Find us on Twitter http://twitter.com/CakePHP

---
You received this message because you are subscribed to the Google Groups "CakePHP" group.
To unsubscribe from this group and stop receiving emails from it, send an email to cake-php+unsubscribe@googlegroups.com.
To post to this group, send email to cake-php@googlegroups.com.
Visit this group at http://groups.google.com/group/cake-php.
For more options, visit https://groups.google.com/d/optout.

No comments: