Yet another blog about PHP, HTML and CSS

I guess I haven’t mastered the model relationships enough in order to appreciate them – and use correctly. On one hand they seem to be really cool and provide an easy access to linked database records while on the other hand, they just seem to stand in the way too often.

Caring about database queries performance as I am I find myself unbinding models more often than I might be binding them. I guess I should not set default binding in the model but that’s just a natural place to put the logic. I’m trying to follow DRY as much as possible.

Anyway, here’s a piece of code that unbinds all belongsTo models in order to remove JOINs from an updateAll() query.

(suggested by Serge Rodovnichenko)

Setting $content->recursive = -1 doesn’t work. I debugged the call in CakePHP 1.2.5.

Edit September 27th, 2009:

Let’s move this up to another level – let’s override the default updateAll() and add support for recursive = -1. Add this to your app_model.php

Edit April 22th, 2011:

I just found out that I forgot to put back the unbinded associations. The function above already contains the fix.

This entry was posted on Sunday, September 13th, 2009 at 11:28 pm and is filed under CakePHP. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.