Thanks! that saved my life ;) ________________________________________ Java & C# desktop developer PHP web developer www.mohamnag.com
On Wed, Aug 7, 2013 at 8:11 PM, euromark <[email protected]> wrote: > If you already got the parent_id filled out, just use the recover > functionality of the behavior > Either from console (CLI) via shell or from your controller action call > $this->Model->recover() > This should fix your lft/rght fields based on your parent_id > > > Am Mittwoch, 7. August 2013 19:03:52 UTC+2 schrieb Mohammad Naghavi: >> >> I had this model for a long time and my table and model already has >> parent_id and existing data inside the table has relations. The new fields >> added are lft and rght which has for now only NULL values inside. I want to >> fill these in a way that the tree behavior can be used with this existing >> data and relation. >> >> Regards, >> Mohammad >> On Aug 7, 2013 6:18 PM, "euromark" <[email protected]> wrote: >> >>> Do not forget the parent_id >>> >>> Also, what do you mean with existing data? >>> By default it would all be just a flat list (none of them would have a >>> parent). >>> This is also a valid tree >>> >>> How would you be able to tell which is the parent of which? >>> If it can be automated, there is an easy way to do that with Cake. >>> But first, you need to find out how it can be automated. Otherwise you >>> need to manually >>> edit each record. >>> >>> >>> Am Mittwoch, 7. August 2013 17:03:25 UTC+2 schrieb Mohammad Naghavi: >>>> >>>> Hi all, >>>> this is straight forward, I have a bid table, which used parent_id to >>>> make a threaded hierarchy. now after a time that the application is used, >>>> I'm facing problems that can be done perfectly using tree behavior. I have >>>> added the lft and rght columns but can find an easy way to convert existing >>>> data into a tree behavior compatible form. >>>> >>>> the last way is to make a temporary table, read from current and write >>>> into new, and later swap old with new and remove the old, but I have too >>>> much data in the table that it may not be possible at least at once. >>>> >>>> do you have any idea how to do it easier? It can be done also directly >>>> in DB (mysql). >>>> >>>> Thanks in advance for any suggestion. >>>> Mohammad >>>> >>> -- >>> Like Us on FaceBook >>> https://www.facebook.com/**CakePHP<https://www.facebook.com/CakePHP> >>> Find us on Twitter http://twitter.com/CakePHP >>> >>> --- >>> You received this message because you are subscribed to the Google >>> Groups "CakePHP" group. >>> To unsubscribe from this group and stop receiving emails from it, send >>> an email to cake-php+u...@**googlegroups.com. >>> To post to this group, send email to [email protected]. >>> >>> Visit this group at >>> http://groups.google.com/**group/cake-php<http://groups.google.com/group/cake-php> >>> . >>> For more options, visit >>> https://groups.google.com/**groups/opt_out<https://groups.google.com/groups/opt_out> >>> . >>> >>> >>> >> -- > Like Us on FaceBook https://www.facebook.com/CakePHP > Find us on Twitter http://twitter.com/CakePHP > > --- > You received this message because you are subscribed to the Google Groups > "CakePHP" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To post to this group, send email to [email protected]. > Visit this group at http://groups.google.com/group/cake-php. > For more options, visit https://groups.google.com/groups/opt_out. > > > -- Like Us on FaceBook https://www.facebook.com/CakePHP Find us on Twitter http://twitter.com/CakePHP --- You received this message because you are subscribed to the Google Groups "CakePHP" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/cake-php. For more options, visit https://groups.google.com/groups/opt_out.
