CODEWITHSUNDEEP
sqldatabasecakephpmodels
Aran
Aran

Reputation: 3338

Limit models to select

I have a database table called Event which in CakePHP has its relationships coded to like so:

var $belongsTo = array('Sport');
var $hasOne = array('Result', 'Point', 'Writeup', 'Timetable', 'Photo');

Now am doing a query and only want to pull out Sport, Point, and Timetable

Which would result in me retrieving Sports, Events, Points, and Timetable.

Reason for not pulling everything is due the results having 17000+ rows.

Is there a way to only select those tables using: 

$this->Event->find('all');

I have had a look at the API but can't see how its done.

Upvotes: 1

Views: 56

Answers (1)

dogmatic69
dogmatic69

Reputation: 7575

You should set recursive to -1 in your app_model and only pull the things you require. never use recursive of 2 and http://book.cakephp.org/view/1323/Containable is awesome.

just $this->Event->find('all', array('contain' => array()));

if you do the trick of recursive as -1 in app_model, this is not needed, if would just be find('all') like you have

Upvotes: 4

Related Questions