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
-~----------~----~----~----~------~----~------~--~---
