cakephp Counter cache in nested model

Question

i have nested model structure

id parent_id counter name

how to use automated counter cache

have you tried the normal way? in the relationship definition... — dogmatic69, Apr 13 '11 at 11:54
yes, i can do it in normal way, but i have excisted nested structure fulled with data. — baur79, Apr 13 '11 at 16:26
Ii did not say 'can you do it the normal way' I said 'have you tried it the normal way' as it should work the normal way — dogmatic69, Apr 14 '11 at 06:01

score 1 · Answer 1 · answered Apr 13 '11 at 15:55

1

Define it in the relationship definition.

<?php

class YourModel extends AppModel {

    var $belongsTo = array(
        'ParentModel' => array(
            'foreignKey' => 'your_model_id',
            'className' => 'ParentModel',
            'counterCache' => 'counter'
            )
        )
    );
}
?>

Where 'counter' is the field in your table that contains the count.

answered Apr 13 '11 at 15:55

Barry Chapman

6,690
3
36
64

Barry - read the page in the cookbook (or the api) - I don't think you get to pass the field name to the counterCache key. From the docs it seems to be fixed to the name of the related table (pluralized) and with _count appended to it. A quick test shows me that your code as is isn't working as expected. – Abba Bryant Apr 14 '11 at 18:07
From the book: counterCache: If set to true the associated Model will automatically increase or decrease the “[singular_model_name]_count” field in the foreign table whenever you do a save() or delete(). If its a string then its the field name to use. The value in the counter field represents the number of related rows. – Barry Chapman Jun 07 '11 at 14:10

cakephp Counter cache in nested model

1 Answers1