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:in `execute' 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:in `select_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:in `find_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:in `find' 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:in `load_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:in `method_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