Here is the model for Category:
var $hasAndBelongsToMany = array(
'Product' => array(
'className' => 'Product',
'joinTable' => 'categories_products',
'foreignKey' => 'category_id',
'associationForeignKey' => 'product_id'
)
);
var $belongsTo = array(
'Parent' => array(
'className' => 'Category',
'foreignKey' => 'parent_id'
)
);
Here is the model for Product:
var $hasMany = array(
'Variation' => array(
'className' => 'Variation',
'foreignKey' => 'product_id',
'dependent' => false,
)
);
I think it's pretty straightforward. There are 32 categories, 86
products and 115 variations. Looks like it's doing a database call for
each variation.
--
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+unsubscr...@googlegroups.com For more options, visit this group at
http://groups.google.com/group/cake-php
