I am attempting to setup a belongs_to / has_many relationship
and the resulting where clause is wrong:
ruby code
require “rubygems”
require_gem “activerecord”
require “pp”
ActiveRecord::Base.establish_connection(
:adapter => “mysql”,
:host => “devbox…internal”,
:database => “test2”,
:username => “XXX”,
:password => “XXXpassword” )
class Job < ActiveRecord::Base
doesnt have id as the primary key
set_primary_key “jobid”
has_many :audits
end
class Audit < ActiveRecord::Base
set_table_name “job_audit” # legacy name
belongs_to :job,
:class_name => “Job”,
:foreign_key => “jobid”
end
jj = Job.find(900000)
pp jj
jj.audits.each do |ja|
pp ja
end
what I get is this
ttyp6 > ruby report.rb
#<Job:0x810d760
@attributes=
{“doa”=>“0”,
“item_id”=>“0”,
“faultid”=>“3110”,
“status”=>“CLOSED”,
“proj_mustfinish”=>“0000-00-00 00:00:00”,
… omitted columns …
“jobid”=>“900000”,
“partid”=>“0”,
“resp_ts”=>“10:42:00”,
… omitted columns …
“escalation”=>“0”}>
which is the correct job record
and then this
/usr/local/lib/ruby/gems/1.8/gems/activerecord-1.15.1/lib/
active_record/connection_adapters/abstract_adapter.rb:128:in log': Mysql::Error: Unknown column 'job_audit.job_id' in 'where clause': SELECT * FROM job_audit WHERE (job_audit.job_id = 900000) (ActiveRecord::StatementInvalid) from /usr/local/lib/ruby/gems/1.8/gems/activerecord-1.15.1/lib/ active_record/connection_adapters/mysql_adapter.rb:243:inexecute’
from /usr/local/lib/ruby/gems/1.8/gems/activerecord-1.15.1/lib/
active_record/connection_adapters/mysql_adapter.rb:395:in select' from /usr/local/lib/ruby/gems/1.8/gems/activerecord-1.15.1/lib/ active_record/connection_adapters/abstract/database_statements.rb:7:inselect_all’
from /usr/local/lib/ruby/gems/1.8/gems/activerecord-1.15.1/lib/
active_record/base.rb:424:in find_by_sql' from /usr/local/lib/ruby/gems/1.8/gems/activerecord-1.15.1/lib/ active_record/base.rb:994:infind_every’
from /usr/local/lib/ruby/gems/1.8/gems/activerecord-1.15.1/lib/
active_record/base.rb:415:in find' from /usr/local/lib/ruby/gems/1.8/gems/activerecord-1.15.1/lib/ active_record/associations/has_many_association.rb:91:infind’
from /usr/local/lib/ruby/gems/1.8/gems/activerecord-1.15.1/lib/
active_record/associations/association_collection.rb:159:in
find_target' from /usr/local/lib/ruby/gems/1.8/gems/activerecord-1.15.1/lib/ active_record/associations/has_many_association.rb:123:inload_target’
from /usr/local/lib/ruby/gems/1.8/gems/activerecord-1.15.1/lib/
active_record/associations/association_proxy.rb:122:in
method_missing' from /usr/local/lib/ruby/gems/1.8/gems/activerecord-1.15.1/lib/ active_record/associations/has_many_association.rb:98:inmethod_missing’
from report.rb:35
From my understanding of the belongs_to / has_many options
and the legacy renaming of the id field the where clause above
should be
SELECT * FROM job_audit WHERE (job_audit.jobid = 900000)
not
SELECT * FROM job_audit WHERE (job_audit.job_id = 900000)
what am i doing wrong?
mjt