Rails - Find By with 2 fields?

Ruby on-RailsRuby on-Rails-3

Ruby on-Rails Problem Overview


I have the following in a controller

def update
    @permission = Permission.find_by_user_id(params[:user_id])

But I want it to also find by another param, project_id

How can I do something like this in Rails?

@permission = Permission.find_by_user_id_and_project_id(params[:user_id],params[:user_id])

Ruby on-Rails Solutions


Solution 1 - Ruby on-Rails

Rails 4 introduces the find_by method:

Permission.find_by(user_id: params[:user_id], project_id: params[:project_id])

Solution 2 - Ruby on-Rails

Yes, you can do finds in a bunch of ways.

Your example below works:

@permission = Permission.find_by_user_id_and_project_id(params[:user_id],params[:project_id])

-- Note your example had two user_ids

In rails 2.x you can also use conditions

@permission = Permission.find(:conditions=>["user_id=? and project_id=?", params[:user_id], params[:project_id]])

And in Rails 3, you can be cool like:

@permission = Permission.where(:user_id=>params[:user_id]).where(:project_id=>params[:project_id]).first

Solution 3 - Ruby on-Rails

Try this:

@permission = Permission.find(:conditions => ['user_id = ? and project_id = ?', params[:user_id], params[:project_id]])

Solution 4 - Ruby on-Rails

Rails 3 way with scopes:

scope :by_user_id_and_project_id, lambda {|user_id,project_id| 
    where(:user_id=>user_id).where(:project_id=>project_id])
}

And then you can use it like:

@permission = Permission.by_user_id_and_project_id(params[:user_id],params[:project_id])

Attributions

All content for this solution is sourced from the original question on Stackoverflow.

The content on this page is licensed under the Attribution-ShareAlike 4.0 International (CC BY-SA 4.0) license.

Content TypeOriginal AuthorOriginal Content on Stackoverflow
QuestionAnApprenticeView Question on Stackoverflow
Solution 1 - Ruby on-RailsFred WillmoreView Answer on Stackoverflow
Solution 2 - Ruby on-RailsJesse WolgamottView Answer on Stackoverflow
Solution 3 - Ruby on-RailsJacob RelkinView Answer on Stackoverflow
Solution 4 - Ruby on-RailsDGMView Answer on Stackoverflow