Your HABTM relation is backwards. Course belongsTo Accreditation, and
Accreditation hasMany Course.
The rule of thumb is that if a SQL table contains a foreignKey (as in
this case the courses table contains accreditation_id), then it should
implement a belongsTo relationship with the other table (in this case,
accreditations). Your business logic will determine which relationship
the other relationship (either hasOne or hasMany).
/a
On Apr 21, 11:49 am, NoelC <[EMAIL PROTECTED]> wrote:
> I've come unstuck when attempting to establish associations between
> models. As far as I can tell, I've designed the database using Cake
> conventions, but the results I receive from finds on models with
> associations are incorrect. The Cake version is 1.2.0.6311 and the
> database is PostgreSQL 8.3.
>
> These are the DDL statements for two of the tables in my app.
>
> CREATE TABLE courses
> (
> id bigint NOT NULL DEFAULT nextval('courses_id_seq'::regclass),
> course_code dm_short_code NOT NULL,
> course_title dm_title NOT NULL,
> course_details dm_description,
> accreditation_id integer NOT NULL,
> CONSTRAINT pk_courses PRIMARY KEY (course_id),
> CONSTRAINT fk_course_accreditations FOREIGN KEY (accreditation_id)
> REFERENCES accreditations (id) MATCH SIMPLE
> ON UPDATE NO ACTION ON DELETE NO ACTION
> )
>
> CREATE TABLE accreditations
> (
> id integer NOT NULL DEFAULT
> nextval('accreditation_id_seq'::regclass),
> accreditation_title dm_title NOT NULL,
> description dm_description,
> accreditor_id integer NOT NULL,
> CONSTRAINT pk_accreditations PRIMARY KEY (id)
> )
>
> The two related models are defined as:
>
> class Course extends AppModel
> {
> var $name = 'Course';
>
> var $hasOne = array('Accreditation' =>
> array('className' => 'Accreditation',
> 'foreignKey' => 'id'
>
> )
> );
>
> }
>
> class Accreditation extends AppModel
> {
>
> var $name = 'Accreditation';
> var $belongsTo = array('Course' =>
> array( 'className' => 'Course',
> 'foreignKey' =>
> 'accreditation_id'
> )
> );
>
> }
>
> When doing a find on a Course, it seems to be joining the courses
> table to the accreditations table by using course.id =
> accreditation.id, which is not what I would expect from the model
> declarations above.
>
> The generated SQL is:
>
> SELECT "Course"."id" AS "Course__id", "Course"."course_code" AS
> "Course__course_code", "Course"."course_title" AS
> "Course__course_title", "Course"."course_details" AS
> "Course__course_details", "Course"."accreditation_id" AS
> "Course__accreditation_id", "Accreditation"."id" AS
> "Accreditation__id", "Accreditation"."accreditation_title" AS
> "Accreditation__accreditation_title", "Accreditation"."description" AS
> "Accreditation__description", "Accreditation"."accreditor_id" AS
> "Accreditation__accreditor_id" FROM "courses" AS "Course" LEFT JOIN
> "accreditations" AS "Accreditation" ON ("Accreditation"."id" =
> "Course"."id") WHERE "Course"."course_code" = 'X123'
>
> Perhaps I am misunderstanding the way Cake works, but I have tried
> many different combinations (including setting $primaryKey in the
> Model) but to no avail. The last part of the SQL should read:
>
> ON ("Accreditation"."id" = "Course"."accreditation_id")
>
> This would give the expected results.
>
> Can anyone give me any pointers as to what I may be doing wrong?
>
> Thanks!
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"CakePHP" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/cake-php?hl=en
-~----------~----~----~----~------~----~------~--~---
