Hello Group,
Ruby/Rails noob coming from PHP land please excuse the simple
question…
BACKGROUND:
I have 2 tables ‘assets’ & ‘types’ (well, I have more, but for the
sake of simplicity…):
CREATE TABLE assets
(
id
int(11) NOT NULL auto_increment,
type_id
int(11) NOT NULL,
… [snip] …
PRIMARY KEY (id
),
KEY fk_asset_type
(type_id
),
… [snip] …
CONSTRAINT fk_asset_type
FOREIGN KEY (type_id
) REFERENCES
types
(id
)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT=‘Asset Records’;
CREATE TABLE types
(
id
int(11) NOT NULL auto_increment,
typename
varchar(20) NOT NULL default ‘’,
PRIMARY KEY (id
)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT=‘Asset Type
Definitions’;
Here are my model definitions for the two tables:
class Asset < ActiveRecord::Base
set_table_name “assets”
set_primary_key “id”
has_one :type, :class_name=>“Type”, :foreign_key=>“type_id”
end
class Type < ActiveRecord::Base
set_table_name “types”
set_primary_key “id”
belongs_to :asset, :class_name=>“Asset”
end
And finally my controller for assets:
class AssetsController < ApplicationController
… [snip] …
def list
@asset_pages, @assets = paginate :assets, :per_page => 20
@type = Type.find(:all)
end
… [snip] …
end
In my ‘list’ view for assets, this works:
<% for asset in @assets %>
<% end %>
However, I only get the integer value returned.
ISSUE:
The following modification fails:
<% for asset in @assets %>
<% end %>
With Error:
Mysql::Error: Unknown column ‘types.type_id’ in ‘where clause’:
SELECT * FROM types WHERE (types.type_id = 1) LIMIT 1
I am confused as to why Rails is constructing the query for the Types
table assuming the primary key is ‘type_id’ when I specify the PK as
‘id’ in the Types model…
Can anyone set me straight?
TIA.
- Brian