CakePHP 3: CounterCache with BelongsToMany

Question

I have a BelongsToMany association, my tables are PostsTable, TagsTable and PostsTagsTable.

As explained here in the CakePHP book (associations), I have this fields:

tags.id, tags.tag, tags.post_count
posts_tags.id, posts_tags.tag_id, posts_tags.post_id

Everything works correctly for now. So, as you can understand, now I want to use the tags.post_count field with CounterCache.

I followed the CakePHP book, but I suppose this is a special case, in fact it doesn't work by simply adding the behavior to the PostsTable.

Can you help me? Thanks.

Salines · Accepted Answer · 2015-10-05T14:14:52.420

2

From CakePHP Book

The CounterCache behavior works for belongsTo associations only. For example for “Comments belongsTo Articles”, you need to add the CounterCache behavior to the CommentsTable in order to generate comment_count for Articles table. It is possible though to make this work for belongsToMany associations. You need to enable the CounterCache behavior in a custom through table configured in association options. See how to configure a custom join table Using the ‘through’ Option.

UPDATE

Bake your PostsTags model
Add CounterCache behavior in your PostsTagsTable
Use the ‘through’ Option

edited Oct 05 '15 at 14:14

answered Oct 05 '15 at 12:55

Salines

5,674
3
25
50

sorry @Salines, the `post_count` field on the `post_tags' table? Are you sure? – Mirko Pagliai Oct 05 '15 at 13:49
I write you what it says in the cakephp book. But what you need is the sum of posts for each tag, where habtm relationship between tags and posts? – Salines Oct 05 '15 at 13:58
yes, sure, I want just a count of post for each tag – Mirko Pagliai Oct 05 '15 at 14:02

CakePHP 3: CounterCache with BelongsToMany

1 Answers1

Linked