I am using Beta: 1.2.0.6311. I have a Article Table which is having
associations with other tables like Category, Tags and User.
I have a view counter in Article Table which would increment the
counter each time the article is viewed. I am using the Restrict
Behavior by Mariano. This is what I do in the article view controller
action.
$this->Article->restrict();
$this->data = $this->Article->findById($id);
$this->Article->restrict();
$views = $this->data['Article']['views'] + 1;
$this->Article->id = $this->data['Article']['id'];
$this->Article->saveField('views', $views);
This code does update the views but I am not sure why I get all the
join statements in the UPDATE Sql statement? The following is the SQL
statement issued to update only one field in Article.
UPDATE `articles` AS `Article` LEFT JOIN `tags` AS `Tag` ON
(`Tag`.`articles_id` = `Article`.`id`) LEFT JOIN `categories` AS
`Category` ON (`Article`.`categories_id` = `Category`.`id`) SET
`Article`.`views` = 646 WHERE `Article`.`id` IN (618)
I am removing all the associations using 'restrict'. However, I have
found a function _getJoins($model) in the dbo_source.php which is
called explicity for all 'updates' and 'delete' calls. This is where
the extra join statements are coming from. The above code does what is
expected to do, but its adding this extra join statements which
shouldn't be there if one removes the associations.
What do you guys have to say?
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"CakePHP" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/cake-php?hl=en
-~----------~----~----~----~------~----~------~--~---
