Hi ! I have a little problem with the HABTM associations. Group hasManyAndBelongsTo Lesson Lesson hasManyAndBelongsTo Group
*Groups*
groups.id | groups.name | ...
*Lessons*
lessons.id | lessons.title | ...
*Groups_Lessons*
groups_lessons.id | groups_lessons.lesson_id | groups_lessons.group_id
I have write this the Lesson model :
class Lesson extends AppModel {
> public $name = 'Lesson';
> public $hasAndBelongsToMany = array(
> 'Groups' =>
> array(
> 'className' => 'Group',
> 'joinTable' => 'groups_lessons',
> 'foreignKey' => 'lesson_id',
> 'associationForeignKey' => 'group_id'
> )
> );
> }
and this Group model :
class Group extends AppModel {
> public $name = 'Group';
>
> public $hasAndBelongsToMany = array(
> 'Lessons' =>
> array(
> 'className' => 'Lesson',
> 'joinTable' => 'groups_lessons',
> 'foreignKey' => 'group_id',
> 'associationForeignKey' => 'lesson_id',
> )
> );
>
> }
In the index of my lesson controller, I realize a $this->Lesson->find('all')
call.
I have 2 SQL query :
SELECT "Lesson"."id" AS "Lesson__id", "Lesson"."teacher_id" AS
> "Lesson__teacher_id", "Lesson"."entitled" AS "Lesson__entitled",
> "Lesson"."abbreviation" AS "Lesson__abbreviation", "Lesson"."hours" AS
> "Lesson__hours", "Lesson"."option" AS "Lesson__option" FROM "lessons" AS
> "Lesson" WHERE 1 = 1
> One row
SELECT "Groups"."id" AS "Groups__id", "Groups"."holder_id" AS
> "Groups__holder_id", "Groups"."education_id" AS "Groups__education_id",
> "Groups"."name" AS "Groups__name", "Groups"."abbreviation" AS
> "Groups__abbreviation", "GroupsLesson"."id" AS "GroupsLesson__id",
> "GroupsLesson"."group_id" AS "GroupsLesson__group_id",
> "GroupsLesson"."lesson_id" AS "GroupsLesson__lesson_id" FROM "groups" AS
> "Groups" JOIN "groups_lessons" AS "GroupsLesson" ON
> ("GroupsLesson"."lesson_id" = 1 AND "GroupsLesson"."group_id" =
> "Groups"."id")
> One row
But, when I realize a print_r on $this->Lesson->find('all'), I have no
group...
Array ( [0] => Array ( [Lesson] => Array ( [id] => 1 [teacher_id] => 1
> [entitled] => Math [abbreviation] => M [hours] => 14 [option] => ) [Groups]
> => Array ( ) ) )
Can you help me ?
Thanks !
--
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
[email protected] For more options, visit this group at
http://groups.google.com/group/cake-php
<<attachment: Capture.PNG>>
