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

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 <paul@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 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

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