cake-php@googlegroups.com
[Top] [All Lists]

Re: Retrograde counterCache

Subject: Re: Retrograde counterCache
From: euromark
Date: Wed, 6 Jul 2011 14:26:31 -0700 PDT
well of course you have to trigger it somehow
but you can simply invoke that for every record (shell, admin action).

some behaviors (i remember this from geocoder et cetera) even have an
own "updateAll" method
which does extacly that.
if not, invent it for yours :)


On 6 Jul., 22:58, Miles J <mileswjohn...@xxxxxxxxx> wrote:
> In that case, just create a shell that loops over everything, runs
> count queries, and then saves the counter cache value.
>
> On Jul 6, 1:11 pm, Jeremy Burns | Class Outfit
>
>
>
>
>
>
>
> <jeremybu...@xxxxxxxxxxxxxxx> wrote:
> > I think he's adding it to existing tables, so it won't start from zero. He 
> > needs to do a find count group by and update the new counterCache field.
>
> > Jeremy Burns
> > Class Outfit
>
> >http://www.classoutfit.com
>
> > On 6 Jul 2011, at 20:21, Miles J wrote:
>
> > > Well, do you need to populate it right off the bat?
>
> > > Cake will automatically insert the correct counter value the next time
> > > a save or delete is made (all it does is a findCount()).
>
> > > On Jul 6, 10:38 am, Thomas Ploch <profipl...@xxxxxxxxxxxxxx> wrote:
> > >> Wouldn't a simple find('all') saveAll() script do the trick?
>
> > >> Am Mittwoch, den 06.07.2011, 18:29 +0100 schrieb Jeremy Burns | Class
> > >> Outfit:
>
> > >>> Doesn't his question relate to populating the counterCache fields with
> > >>> the right values on creation, rather than maintaining it?
>
> > >>> Jeremy Burns
> > >>> Class Outfit
>
> > >>>http://www.classoutfit.com
>
> > >>> On 6 Jul 2011, at 17:17, euromark wrote:
>
> > >>>> there are already several different counterCache solutions available
> > >>>> one in the core
> > >>>> see the cookbook or
> > >>>>http://stackoverflow.com/questions/1351823/countercache-in-cake-php
>
> > >>>> and several als plugins etc
> > >>>> depends on what exactly you need
>
> > >>>>http://bakery.cakephp.org/articles/danaki/2009/05/29/counter-cache-be...
> > >>>>http://bakery.cakephp.org/articles/dericknwq/2007/05/02/countercache-...
> > >>>>http://www.neilcrookes.com/2010/01/09/cakephp-treecountercachebehavio...
> > >>>> and probably some more
>
> > >>>> On 6 Jul., 17:46, Jeremy Burns | Class Outfit
> > >>>> <jeremybu...@xxxxxxxxxxxxxxx> wrote:
> > >>>>> In my experience you need to do it with a simple SQL query at the
> > >>>>> db level. I am not aware of any Cake magic. If it's a continuous
> > >>>>> problem worthy of some dev time you could write a simple behaviour
> > >>>>> to do it.
>
> > >>>>> Jeremy Burns
> > >>>>> Class Outfit
>
> > >>>>>http://www.classoutfit.com
>
> > >>>>> On 6 Jul 2011, at 16:43, wiseguysonly wrote:
>
> > >>>>>> One of my early CakePHP sites has come back to haunt me. I need
> > >>>>>> to add
> > >>>>>> a counterCache to a pre-existing hasMany relationship.
>
> > >>>>>> Does there exist a method to set up the counterCache with
> > >>>>>> current
> > >>>>>> counts field once I have have created it?
>
> > >>>>>> Thanks in advance,
>
> > >>>>>> Tim
>
> > >>>>>> --
> > >>>>>> Our newest site for the community: CakePHP Video
> > >>>>>> Tutorialshttp://tv.cakephp.org
> > >>>>>> Check out the new CakePHP Questions
> > >>>>>> sitehttp://ask.cakephp.organdhelpotherswith their CakePHP
> > >>>>>> related questions.
>
> > >>>>>> To unsubscribe from this group, send email to
> > >>>>>> cake-php+unsubscribe@xxxxxxxxxxxxxxxx For more options, visit
> > >>>>>> this group athttp://groups.google.com/group/cake-php
>
> > >>>> --
> > >>>> Our newest site for the community: CakePHP Video Tutorials
> > >>>>http://tv.cakephp.org
> > >>>> Check out the new CakePHP Questions sitehttp://ask.cakephp.organd
> > >>>> help others with their CakePHP related questions.
>
> > >>>> To unsubscribe from this group, send email to
> > >>>> cake-php+unsubscribe@xxxxxxxxxxxxxxxx For more options, visit this
> > >>>> group athttp://groups.google.com/group/cake-php
>
> > >>> --
> > >>> Our newest site for the community: CakePHP Video Tutorials
> > >>>http://tv.cakephp.org
> > >>> Check out the new CakePHP Questions sitehttp://ask.cakephp.organd
> > >>> help others with their CakePHP related questions.
>
> > >>> To unsubscribe from this group, send email to
> > >>> cake-php+unsubscribe@xxxxxxxxxxxxxxxx For more options, visit this
> > >>> group athttp://groups.google.com/group/cake-php
>
> > > --
> > > Our newest site for the community: CakePHP Video 
> > > Tutorialshttp://tv.cakephp.org
> > > Check out the new CakePHP Questions sitehttp://ask.cakephp.organdhelp 
> > > others with their CakePHP related questions.
>
> > > To unsubscribe from this group, send email to
> > > cake-php+unsubscribe@xxxxxxxxxxxxxxxx For more options, visit this group 
> > > athttp://groups.google.com/group/cake-php

-- 
Our newest site for the community: CakePHP Video Tutorials 
http://tv.cakephp.org 
Check out the new CakePHP Questions site http://ask.cakephp.org and help others 
with their CakePHP related questions.


To unsubscribe from this group, send email to
cake-php+unsubscribe@xxxxxxxxxxxxxxxx For more options, visit this group at 
http://groups.google.com/group/cake-php

<Prev in Thread] Current Thread [Next in Thread>