Displaying 1 result from an estimated 1 matches for "school_term".
2006 Aug 02
1
ActiveRecord: find_or_create with has_and_belongs_to_many --
...my current table. I am doing
the following:
term = school.terms.find_or_create_by_code("FALL06")
the queries in the log show the expected SELECT statement to query if
there is a join table record between the school and term with code
"FALL06":
SELECT * FROM term
INNER JOIN school_term ON term.id = school_term.term_id
WHERE (school_term.school_id = 1 )
AND (term.`code` = ''FALL06'' )
LIMIT 1
but the INSERT behavior does not include a join table insert if the
SELECT does not find an appropriate record:
INSERT INTO term (`code`, `name_full`, `name_common`, `dat...