Rails find_or_create_by more than one attribute?

by

Multiple attributes can be connected with an and:

GroupMember.find_or_create_by_member_id_and_group_id(4, 7)

(use find_or_initialize_by if you don’t want to save the record right away)

Edit: The above method is deprecated in Rails 4. The new way to do it will be:

GroupMember.where(:member_id => 4, :group_id => 7).first_or_create

and

GroupMember.where(:member_id => 4, :group_id => 7).first_or_initialize

Edit 2: Not all of these were factored out of rails just the attribute specific ones.

https://github.com/rails/rails/blob/4-2-stable/guides/source/active_record_querying.md

Example 

GroupMember.find_or_create_by_member_id_and_group_id(4, 7)

became 

GroupMember.find_or_create_by(member_id: 4, group_id: 7)

More Related Contents:

  1. Rails ActiveRecord methods in different places [closed]
  2. Is there a way to get a collection of all the Models in your Rails app?
  3. Using helpers in model: how do I include helper dependencies?
  4. How to implement Active Record inheritance in Ruby on Rails?
  5. Rails gem rails3-jquery-autocomplete: How do I query multiple fields
  6. Rails :dependent => :destroy VS :dependent => :delete_all
  7. Eager load polymorphic
  8. accepts_nested_attributes_for with find_or_create?
  9. ActiveRecord.find(array_of_ids), preserving order
  10. Rails has_many with dynamic conditions
  11. Rails order by results count of has_many association
  12. Using Rails serialize to save hash to database
  13. Setting session timeout in Rails 3
  14. How to handle Ruby on Rails error: “Please install the postgresql adapter: `gem install activerecord-postgresql-adapter'”
  15. How to query a model based on attribute of another model which belongs to the first model?
  16. Multiple databases in Rails
  17. Rails ActiveRecord: Find All Users Except Current User
  18. GroupingError: ERROR: column must appear in the GROUP BY clause or be used in an aggregate function
  19. query , can not select column count
  20. belongs_to through associations
  21. Rails 4 nested attributes and has_many :through associaton in a form
  22. Validate uniqueness of multiple columns
  23. Rails: How do I create a default value for attributes in Rails activerecord’s model? [duplicate]
  24. delete_all vs destroy_all?
  25. Converting an array of objects to ActiveRecord::Relation
  26. PGError: ERROR: aggregates not allowed in WHERE clause on a AR query of an object and its has_many objects
  27. Is there a way to avoid automatically updating Rails timestamp fields?
  28. Non persistent ActiveRecord model attributes
  29. Rails best way to get previous and next active record object
  30. How can I use ActiveRecord on a database that has a column named ‘valid’? (DangerousAttributeError)

Leave a Comment