Re: Setting up controllers and models with multiple tables and dependencies

If you set up your models like this you'll have that access in your
controllers. in products controller you have $this->Product-
>ProductsProperty and $this->Product->ProductsProperty->Property ...
thats the cake magic, in any case where you have deep associations you
can "walk" through these associations like that...

On 4 Apr., 05:29, Plasty Grove <plasty.gr...@gmail.com> wrote:
> Thanks Paul, that really helps. I like the approach with a model for the
> link table as well. And since I do need to save extra data in the link
> table, that's probably the way I'll need to do it.
>
> But how should I set up the controllers for this? I'll need to access the
> products and properties at the same time. I know I can probably create one
> controller and access all three models at the same time using the $uses
> variable. But if I understand it correctly, this is not the right approach.
> But if I have 3 different controllers, how do I access products and
> properties at the same time?
>
> Thanks,
> Plasty
>
>
>
> On Sun, Apr 4, 2010 at 2:02 AM, WebbedIT <p...@webbedit.co.uk> wrote:
> > This seems like a pretty basic HABTM association.  If your join table
> > (products_properties) is as simple as
>
> > id
> > product_id
> > property_id
>
> > then all you need to do is define your model associations as:
>
> > Product:
> > var $hasAndBelongsToMany = array(
> >  'Property'
> > );
>
> > Property:
> > var $hasAndBelongsToMany = array(
> >  'Product'
> > );
>
> > Cake will automagically do the rest for you.  However if you want to
> > store extra data in the join table then I find it much easier to
> > create a model for the join table and create associations as follows:
>
> > Product:
> > var $hasMany = array(
> >  'ProductsProperty'
> > );
>
> > Property:
> > var $hasMany = array(
> >  'ProductsProperty'
> > );
>
> > ProductsProperty:
> > var $belongsTo = array(
> >  'Product',
> >  'Property'
> > );
>
> > This way you can run finds and saves on the join table saving extra
> > data with ease, whereas HABTM associations are really only shortcuts
> > to do this without creating the extra model and can complicate things.
>
> > HTH
>
> > Paul
>
> > Check out the new CakePHP Questions sitehttp://cakeqs.organd help others
> > with their CakePHP related questions.
>
> > You received this message because you are subscribed to the Google Groups
> > "CakePHP" group.
> > To post to this group, send email to cake-php@googlegroups.com
> > To unsubscribe from this group, send email to
> > cake-php+unsubscribe@googlegroups.com<cake-php%2Bunsubscribe@googlegroups.c­om>For more options, visit this group at
> >http://groups.google.com/group/cake-php?hl=en
>
> > To unsubscribe, reply using "remove me" as the subject.

Check out the new CakePHP Questions site http://cakeqs.org and help others with their CakePHP related questions.

You received this message because you are subscribed to the Google Groups "CakePHP" group.
To post to this group, send email to cake-php@googlegroups.com
To unsubscribe from this group, send email to
cake-php+unsubscribe@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php?hl=en