I am working on a game system. My models include User, Game, and Player:
User has_many Players
Game has_many Players
Player belongs_to User, Game
Basically, Player is a join table between User and Game, but since there
is
information that is specific to the relationship I want it to be a model
in
its own right. The part where I’d like some AR magic is that given a
User
(the id is in the session) and a Game (the id is part of the URL), I
want
to find the Player (assuming there is one) relating them. My current
implementation looks something like this (pseudocode):
@user = User.find(session[:user_id])
@game = Game.find(params[:id])
@player = @game.players.detect { |p| p.user_id = @user.id }
It works, and I’m likely to use the players list later anyway, but I
feel
like there should be a simple way to get the Player without loading all
the
players. I suppose Player.find_by_game_id_and_user_id(@game.id,
@user.id)
would work, but it isn’t a whole lot nicer. I’m hoping for something
like
Player.find_by_owners(:user => @user, :game => @game).
–Greg