RoR Associations

gistfile1.rb

#rails gen model Player name:string
class Player < ActiveRecord:Base
  has_many :wins, :class_name => "Game", :foreign_key => "winner"
  has_many :losses, :class_name => "Game", :foreign_key => "loser"
end

#rails gen model Game winner:integer loser:integer
class Game < ActiveRecord:Base
  belongs_to :winner, :class_name => "Player", :foreign_key => "player_id"
  belongs_to :loser, :class_name => "Player", :foreign_key => "player_id"
end

Is this a completely wrong approach? It seems like I should be able to do this.

Nevermind, looks like I had the Game record setup horribly :-) Here is what worked (I haven't tested "wins" and "losses" on the Player model yet)

class Game < ActiveRecord:Base
    belongs_to :player, :foreign_key => "winner"
    belongs_to :player, :foreign_key => "loser"
end