Hello,
I became a user of AS few days ago. Despite reading Documentation and
this forum, I was not able to find how to create relationship between
2 models.
I have 2 models: place and people. 2 controllers - places and peoples
Models:
###
class Place < ActiveRecord::Base
has_many :peoples
end
class People < ActiveRecord::Base
belongs_to :place
end
###
Controllers:
###
class PlacesController < ApplicationController
layout "places"
active_scaffold :place do |config|
config.nested.add_link "People", [:peoples]
end
end
class PeoplesController < ApplicationController
layout "peoples"
active_scaffold :people do |config|
config.label = "People"
config.columns =
[:last_name, :first_name, :family_name, :date1, :date2, :place_number]
list.columns.exclude :poznamka
list.sorting = {:priezvisko => "ASC"}
columns[:place_number].label = "Place"
end
end
###
Using AS only, everything is working fine. Once I add a relationship,
(has_many, belongs_to + config.nested.add_link), I am getting error:
Mysql::Error: #42S22Unknown column 'peoples.place_id' in 'on clause':
SELECT count(DISTINCT `places`.id) AS count_all FROM `places` LEFT
OUTER JOIN `peoples` ON peoples.place_id = places.id
I assume I need to set somewhere what columns should be used for
association. In my case, both tables contains column
'place_number' (something like place_id) - and this column should be
one used for association.
There is no foreing key present at the moment in mysql database. This
might be the cause?
I would highly appreciate your advice if you spot what is missing. My
assumptions were, that somewhere need to be set a foreign key.
Thanks
J
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"ActiveScaffold : Ruby on Rails plugin" 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/activescaffold?hl=en
-~----------~----~----~----~------~----~------~--~---
