Hi, I''m in the process of learning ruby on rails so this will be one
of many posts by me when I can''t find the solution by googling.
I have set up a polymorphic relationship that I can''t get to work when
storing data.
def self.up
create_table :table_labels do |t|
t.column :label_type, :string
t.column :label_id, :integer
t.column :english, :text
t.timestamps
end
create_table :menus do |t|
t.column :name, :string, :limit=>50
t.column :parent_id, :integer
t.column :position, :integer
t.column :main, :boolean
t.column :footer, :boolean
t.column :active, :boolean
t.column :controller,:string, :limit=>50
t.column :action, :string, :limit=>50
t.timestamps
end
end
class Menus < ActiveRecord::Base
acts_as_list
acts_as_tree
has_one :table_labels, :as => :label
validates_presence_of :name, :english, :parent_id
validates_uniqueness_of :name
end
class TableLabels < ActiveRecord::Base
belongs_to :label, :polymorphic => true
end
def add_menu
newmenu = Menus.new(:name => params[:label][:name], :parent_id =>
params[:label][:parent_id])
newlabel = TableLabels.new(:english => params[:label][:english])
newlabel.label = newmenu
newlabel.save!
render :action => :list_menus
end
What happens is a row is added to the table_labels but with a NULL
entry for label_id and nothing is added to menus table.
What am I missing?
can anyone help?
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---
On Aug 21, 9:39 pm, almartin <al...-KsOGQxSsmFO9FHfhHBbuYA@public.gmane.org> wrote:> What happens is a row is added to the table_labels but with a NULL > entry for label_id and nothing is added to menus table. >Try saving the newmenu object before you assign it. Fred> What am I missing? > > can anyone help?--~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe@googlegroups.com For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
Tried that with newmenu.save and the same thing happens. however if I use newmenu.save! I get the error English can''t be blank, even though it isn''t Shouldn''t rails be creating a JOIN in the sql? at the moment in the trace is shows both tables being loaded seperately. I''m sure it''s just me not yet understanding how table relationships work. Can any one help? On Aug 22, 1:37 am, Frederick Cheung <frederick.che...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote:> On Aug 21, 9:39 pm, almartin <al...-KsOGQxSsmFO9FHfhHBbuYA@public.gmane.org> wrote: > > > What happens is a row is added to the table_labels but with a NULL > > entry for label_id and nothing is added to menus table. > > Try saving the newmenu object before you assign it. > > Fred > > > What am I missing? > > > can anyone help?--~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe@googlegroups.com For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
On 22 Aug 2008, at 18:20, almartin <allan-KsOGQxSsmFO9FHfhHBbuYA@public.gmane.org> wrote:> > Tried that with newmenu.save and the same thing happens. > however if I use newmenu.save! I get the error English can''t be blank, > even though it isn''t >Well if there is a failing validation you need to fix it since rails won''t save it> Shouldn''t rails be creating a JOIN in the sql? at the moment in the > trace is shows both tables being loaded seperately. > I''m sure it''s just me not yet understanding how table relationships > work. > Can any one help? > > > On Aug 22, 1:37 am, Frederick Cheung <frederick.che...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> > wrote: >> On Aug 21, 9:39 pm, almartin <al...-KsOGQxSsmFO9FHfhHBbuYA@public.gmane.org> wrote: >> >>> What happens is a row is added to the table_labels but with a NULL >>> entry for label_id and nothing is added to menus table. >> >> Try saving the newmenu object before you assign it. >> >> Fred >> >>> What am I missing? >> >>> can anyone help? > >--~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
Perhaps I need to explain how I wish this to work
I have a form on a page that adds a new menu item. the form consists
of the menu name, name in english (other languages will be added
later) and parent_id (from dropdown list of menu items).
When you submit I want the data to be added to the database like this
Menus.name = > post.name
Menus.parent_id => post.parent_id
TableLabels.english => post.english
TableLabels.label_id => Menus.id
TableLabels.label_type => Menus
How do I write the code to achieve this?
. If I wrote it in php - sql it would look like this.
$sql1 = "INSERT INTO menus (name, parent_id) VALUES (''".
$_POST[''name'']."'',".$_POST[''parent_id''].")";
$sql2 = "INSERT INTO table_labels (menu_id,menu_type,english) VALUES
(".mysql_insert_id().",''menus'',''".$_POST[''english'']."'')";
Anyone?
On Aug 22, 8:48 pm, Frederick Cheung
<frederick.che...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org>
wrote:> On 22 Aug 2008, at 18:20, almartin
<al...-KsOGQxSsmFO9FHfhHBbuYA@public.gmane.org> wrote:
>
>
>
> > Tried that with newmenu.save and the same thing happens.
> > however if I use newmenu.save! I get the error English can''t
be blank,
> > even though it isn''t
>
> Well if there is a failing validation you need to fix it since rails
> won''t save it
>
> > Shouldn''t rails be creating a JOIN in the sql? at the moment
in the
> > trace is shows both tables being loaded seperately.
> > I''m sure it''s just me not yet understanding how
table relationships
> > work.
> > Can any one help?
>
> > On Aug 22, 1:37 am, Frederick Cheung
<frederick.che...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org>
> > wrote:
> >> On Aug 21, 9:39 pm, almartin
<al...-KsOGQxSsmFO9FHfhHBbuYA@public.gmane.org> wrote:
>
> >>> What happens is a row is added to the table_labels but with a
NULL
> >>> entry for label_id and nothing is added to menus table.
>
> >> Try saving the newmenu object before you assign it.
>
> >> Fred
>
> >>> What am I missing?
>
> >>> can anyone help?
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk+unsubscribe@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---
I fixed it! The problem was so simple I had the validation for the english field in the wrong class, it should have been in the TableLabels class and not the Menus class. works perfectly now. On Aug 22, 10:07 pm, almartin <al...-KsOGQxSsmFO9FHfhHBbuYA@public.gmane.org> wrote:> Perhaps I need to explain how I wish this to work > > I have a form on a page that adds a new menu item. the form consists > of the menu name, name in english (other languages will be added > later) and parent_id (from dropdown list of menu items). > When you submit I want the data to be added to the database like this > > Menus.name = > post.name > Menus.parent_id => post.parent_id > TableLabels.english => post.english > TableLabels.label_id => Menus.id > TableLabels.label_type => Menus > > How do I write the code to achieve this? > > . If I wrote it in php - sql it would look like this. > > $sql1 = "INSERT INTO menus (name, parent_id) VALUES (''". > $_POST[''name'']."'',".$_POST[''parent_id''].")"; > $sql2 = "INSERT INTO table_labels (menu_id,menu_type,english) VALUES > (".mysql_insert_id().",''menus'',''".$_POST[''english'']."'')"; > > Anyone? > > On Aug 22, 8:48 pm, Frederick Cheung <frederick.che...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> > wrote: > > > On 22 Aug 2008, at 18:20, almartin <al...-KsOGQxSsmFO9FHfhHBbuYA@public.gmane.org> wrote: > > > > Tried that with newmenu.save and the same thing happens. > > > however if I use newmenu.save! I get the error English can''t be blank, > > > even though it isn''t > > > Well if there is a failing validation you need to fix it since rails > > won''t save it > > > > Shouldn''t rails be creating a JOIN in the sql? at the moment in the > > > trace is shows both tables being loaded seperately. > > > I''m sure it''s just me not yet understanding how table relationships > > > work. > > > Can any one help? > > > > On Aug 22, 1:37 am, Frederick Cheung <frederick.che...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> > > > wrote: > > >> On Aug 21, 9:39 pm, almartin <al...-KsOGQxSsmFO9FHfhHBbuYA@public.gmane.org> wrote: > > > >>> What happens is a row is added to the table_labels but with a NULL > > >>> entry for label_id and nothing is added to menus table. > > > >> Try saving the newmenu object before you assign it. > > > >> Fred > > > >>> What am I missing? > > > >>> can anyone help?--~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe@googlegroups.com For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
Hi. I believe that I need to write a method to get my user''s
information, but I''m not sure how to write this and where it should go.
I have Reviews as polymorphic and there are several types items that can
be reviewed (books, music, movies, etc). A user can search for a book
and see all of the reviews for that book. Posted with each review, I
want to provide the name of the user. Based on what I have, what is the
best way to do this and where does this code go? Right now if I pull up
the book, I can see all of the reviews. In the review table I have the
review_user_id and now I want to display the name of that user from the
users table.
Here''s my basic structure, but noting that I have put snippets of the
data here for brevity.
class CreateReviews < ActiveRecord::Migration
def self.up
create_table :reviews
t.string :reviewable_type
t.integer :reviewable_id
t.string :title
t.text :body
t.integer :review_user_id
end
end
end
class CreateUsers < ActiveRecord::Migration
def self.up
create_table :users
t.string :name
end
end
end
class Review < ActiveRecord::Base
belongs_to :reviewable, :polymorphic => true
end
class Book < ActiveRecord::Base
has_many :reviews, :as => reviewable
end
class User < ActiveRecord::Base
has_many :reviews, :as => :reviewable
end
THANKS!
--
Posted via http://www.ruby-forum.com/.
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---
Please see the above post for the setup of my models. While trying to figure this out, I put this into script/console:>> Book.find(1).reviews=> [<#Review id: 2, reviewable_type: "Book", reviewable_id: 1, review_user_id: 1>] How can I take the value of review_user_id and get the name of the user in the users table? Thanks! -- Posted via http://www.ruby-forum.com/. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
If your review model looks like this: class Review belongs_to :user belongs_to :reviewable, :polymorphic => true end You could probably do something like this: Book.find(1).reviews.each do |r| puts r.user.name end On Fri, Sep 19, 2008 at 7:10 PM, Becca Girl <rails-mailing-list-ARtvInVfO7ksV2N9l4h3zg@public.gmane.org> wrote:> > Please see the above post for the setup of my models. > > While trying to figure this out, I put this into script/console: > >>> Book.find(1).reviews > > => [<#Review id: 2, reviewable_type: "Book", reviewable_id: 1, > review_user_id: 1>] > > > How can I take the value of review_user_id and get the name of the user > in the users table? > > Thanks! > ---- Maurício Linhares http://alinhavado.wordpress.com/ (pt-br) | http://blog.codevader.com/ (en) João Pessoa, PB, +55 83 8867-7208 --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe@googlegroups.com For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
On Sep 19, 2008, at 6:10 PM, Becca Girl wrote:> > Please see the above post for the setup of my models. > > While trying to figure this out, I put this into script/console: > >>> Book.find(1).reviews > > => [<#Review id: 2, reviewable_type: "Book", reviewable_id: 1, > review_user_id: 1>] > > > How can I take the value of review_user_id and get the name of the > user > in the users table? > > Thanks!You need to let ActiveRecord know about the association: (You don''t specify the Rails version you''re using, but I''m guessing 2.x) class Review < ActiveRecord::Base belongs_to :reviewable, :polymorphic => true belongs_to :review_user, :class_name => ''User'' # or perhaps: # belongs_to :reviewer, :class_name => ''User'', :foreign_key => ''review_user_id'' end class Book < ActiveRecord::Base has_many :reviews, :as => reviewable end class User < ActiveRecord::Base has_many :reviews, :as => :reviewable # can users be reviewed like Books, etc.? # if you mean for user.reviews to be the set of reviews # that this user wrote, then you want: has_many :reviews, :foreign_key => ''review_user_id'' end Does that work for you? -Rob Rob Biedenharn http://agileconsultingllc.com Rob-xa9cJyRlE0mWcWVYNo9pwxS2lgjeYSpx@public.gmane.org --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
> You need to let ActiveRecord know about the association: > (You don''t specify the Rails version you''re using, but I''m guessing 2.x)Yes, using Rails 2.1> class User < ActiveRecord::Base > has_many :reviews, :as => :reviewable # can users be reviewed like > Books, etc.? > > # if you mean for user.reviews to be the set of reviews > # that this user wrote, then you want: > has_many :reviews, :foreign_key => ''review_user_id'' > end >In my reviews table I have 2 user values, created_by and modifed_by. Users can not be reviewed, but you can view all of the reviews per user. Can I do the foreign key like you have in your second example if my review table has 2 fields that link back to the user.id field? -- Posted via http://www.ruby-forum.com/. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
On Sep 22, 2008, at 9:23 AM, Becca Girl wrote:>> You need to let ActiveRecord know about the association: >> (You don''t specify the Rails version you''re using, but I''m guessing >> 2.x) > > Yes, using Rails 2.1 > > >> class User < ActiveRecord::Base >> has_many :reviews, :as => :reviewable # can users be reviewed like >> Books, etc.? >> >> # if you mean for user.reviews to be the set of reviews >> # that this user wrote, then you want: >> has_many :reviews, :foreign_key => ''review_user_id'' >> end > > In my reviews table I have 2 user values, created_by and modifed_by. > Users can not be reviewed, but you can view all of the reviews per > user. > Can I do the foreign key like you have in your second example if my > review table has 2 fields that link back to the user.id field?Then you need to give the proper foreign_key class User has_many :reviews, :foreign_key => ''created_by'' end class Review belongs_to :creator, :class_name => ''User'', :foreign_key => ''created_by'' end -Rob Rob Biedenharn http://agileconsultingllc.com Rob-xa9cJyRlE0mWcWVYNo9pwxS2lgjeYSpx@public.gmane.org --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
Rob Biedenharn wrote:> Then you need to give the proper foreign_key > > class User > has_many :reviews, :foreign_key => ''created_by'' > end > > class Review > belongs_to :creator, :class_name => ''User'', :foreign_key => > ''created_by'' > end >I must be missing what you''re telling me because I get an error. Polymorphic associations are new to me and quite confusing. I''ve read a lot, but still don''t quite understand how to set these up. C:/project/vendor/rails/activesupport/lib/active_support/dependencies.rb:2 15:in `load_without_new_constant_marking'': C:/var/intranet3/app/models/user.rb:1 55: parse error, unexpected kEND, expecting $ (SyntaxError) class CreateReviews < ActiveRecord::Migration def self.up create_table :reviews t.string :reviewable_type t.integer :reviewable_id t.string :title t.text :body t.integer :create_review_user_id t.integer :modify_review_user_id end end end class User has_many :reviews, :foreign_key => ''create_review_user_id'' has_many :reviews, :foreign_key => ''modify_review_user_id'' end class Review belongs_to :creator, :class_name => ''User'', :foreign_key => ''create_review_user_id'' belongs_to :modified, :class_name => ''User'', :foreign_key => ''modify_review_user_id'' end -- Posted via http://www.ruby-forum.com/. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
On Sep 22, 2008, at 9:54 AM, Becca Girl wrote:> Rob Biedenharn wrote: >> Then you need to give the proper foreign_key >> >> class User >> has_many :reviews, :foreign_key => ''created_by'' >> end >> >> class Review >> belongs_to :creator, :class_name => ''User'', :foreign_key => >> ''created_by'' >> end > > > I must be missing what you''re telling me because I get an error. > Polymorphic associations are new to me and quite confusing. I''ve > read a > lot, but still don''t quite understand how to set these up. > > C:/project/vendor/rails/activesupport/lib/active_support/ > dependencies.rb:2 > 15:in `load_without_new_constant_marking'': > C:/var/intranet3/app/models/user.rb:1 > 55: parse error, unexpected kEND, expecting $ (SyntaxError) > > > class CreateReviews < ActiveRecord::Migration > def self.up > create_table :reviewsmissing: do |t|> > t.string :reviewable_type > t.integer :reviewable_id > t.string :title > t.text :body > t.integer :create_review_user_id > t.integer :modify_review_user_id > end > end > end > > > > > class User > has_many :reviews, :foreign_key => ''create_review_user_id'' > has_many :reviews, :foreign_key => ''modify_review_user_id''You can''t call both associations "reviews" has_many :created_reviews, ... has_many :editted_reviews, ...> > end > > class Review > belongs_to :creator, :class_name => ''User'', :foreign_key => > ''create_review_user_id'' > belongs_to :modified, :class_name => ''User'', :foreign_key => > ''modify_review_user_id''belongs_to :modifier might be a better name than ''modifiED''> > end-Rob Rob Biedenharn http://agileconsultingllc.com Rob-xa9cJyRlE0mWcWVYNo9pwxS2lgjeYSpx@public.gmane.org --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
Ok, here''s what I have in my models. class Review < ActiveRecord::Base belongs_to :reviewable, :polymorphic => true belongs_to :created_reviews, :class_name => ''User'', :foreign_key => ''create_review_user_id'' belongs_to :modified_reviews, :class_name => ''User'', :foreign_key => ''modify_review_user_id'' end class User < ActiveRecord::Base has_many :reviews, :as => :reviewable has_many :created_reviews, :foreign_key => ''create_review_user_id'' has_many :modified_reviews, :foreign_key => ''create_review_user_id'' Sorry I''m so dense, but after all of that, how do I access User.name? -- Posted via http://www.ruby-forum.com/. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
review.created_reviews.name On Mon, Sep 22, 2008 at 4:58 PM, Becca Girl <rails-mailing-list-ARtvInVfO7ksV2N9l4h3zg@public.gmane.org> wrote:> > Ok, here''s what I have in my models. > > class Review < ActiveRecord::Base > belongs_to :reviewable, :polymorphic => true > belongs_to :created_reviews, :class_name => ''User'', :foreign_key => > ''create_review_user_id'' > belongs_to :modified_reviews, :class_name => ''User'', :foreign_key => > ''modify_review_user_id'' > end > > > > class User < ActiveRecord::Base > has_many :reviews, :as => :reviewable > has_many :created_reviews, :foreign_key => ''create_review_user_id'' > has_many :modified_reviews, :foreign_key => ''create_review_user_id'' > > > Sorry I''m so dense, but after all of that, how do I access User.name? > > > -- > Posted via http://www.ruby-forum.com/. > > > >-- Maurício Linhares http://alinhavado.wordpress.com/ (pt-br) | http://blog.codevader.com/ (en) João Pessoa, PB, +55 83 8867-7208 --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe@googlegroups.com For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
Maurício Linhares wrote:> review.created_reviews.name >I wasn''t sure where this should all go, but I am still getting errors. Here''s what I did in script/console:>> Book.find(1).reviews=> [<#Review id: 2, reviewable_type: "Book", reviewable_id: 1, create_review_user_id: 1>]>> review.created_reviews.name=> NameError: undefined local variable or method `review'' for #<Object:0x18fa38> from (irb):9 If I put this in, I also get an error.>> Book.find(1).reviews.each do |r|?> puts review.created_reviews.name>> endNameError: undefined local variable or method `review'' for #<Object:0x18fa38> from (irb):11 Clearly I''m lost and confused. Thanks for helping out this new ruby girl. -- Posted via http://www.ruby-forum.com/. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe@googlegroups.com For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
On Sep 22, 2008, at 3:58 PM, Becca Girl wrote:> Ok, here''s what I have in my models. > > class Review < ActiveRecord::Base > belongs_to :reviewable, :polymorphic => true > belongs_to :created_reviews, :class_name => ''User'', :foreign_key => > ''create_review_user_id''This would be clearer as something singular (like ''reviewer'') since a belongs_to is going to give a single associated record.> > belongs_to :modified_reviews, :class_name => ''User'', :foreign_key => > ''modify_review_user_id'' > end > > class User < ActiveRecord::Base > has_many :reviews, :as => :reviewable > has_many :created_reviews, :foreign_key => ''create_review_user_id'' > has_many :modified_reviews, :foreign_key => ''create_review_user_id''Perhaps you meant for the second one to be ''modify_review_user_id''?> > > > Sorry I''m so dense, but after all of that, how do I access User.name?On Sep 22, 2008, at 4:27 PM, Becca Girl wrote:> > Maurício Linhares wrote: >> review.created_reviews.name >> > > I wasn''t sure where this should all go, but I am still getting errors. > Here''s what I did in script/console: > >>> Book.find(1).reviews > > => [<#Review id: 2, reviewable_type: "Book", reviewable_id: 1, > create_review_user_id: 1>] > > >>> review.created_reviews.name > > => NameError: undefined local variable or method `review'' for > #<Object:0x18fa38> > from (irb):9review = Book.find(1).reviews.first> > > If I put this in, I also get an error. > >>> Book.find(1).reviews.each do |r| > ?> puts review.created_reviews.name >>> end > NameError: undefined local variable or method `review'' for > #<Object:0x18fa38> > from (irb):11Close, try: Book.find(1).reviews.each do |review| then the block will have a variable named review (rather than the r in your first attempt)> Clearly I''m lost and confused. Thanks for helping out this new ruby > girl.Be aware that your confusion seems to be a mix of Rails (specifically, ActiveRecord) conventions and Ruby syntax. -Rob Rob Biedenharn http://agileconsultingllc.com Rob-xa9cJyRlE0mWcWVYNo9pwxS2lgjeYSpx@public.gmane.org --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe@googlegroups.com For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
Rob Biedenharn wrote:> > Be aware that your confusion seems to be a mix of Rails (specifically, > ActiveRecord) conventions and Ruby syntax. >Yes, I''m still new to this. Thank you so much for your patience and great help. I''ve got it all working now! -- Posted via http://www.ruby-forum.com/. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---