Clean way to find ActiveRecord objects by id in the order specified

by

It’s not that MySQL and other DBs sort things on their own, it’s that they don’t sort them. When you call Model.find([5, 2, 3]), the SQL generated is something like:

SELECT * FROM models WHERE models.id IN (5, 2, 3)

This doesn’t specify an order, just the set of records you want returned. It turns out that generally MySQL will return the database rows in 'id' order, but there’s no guarantee of this.

The only way to get the database to return records in a guaranteed order is to add an order clause. If your records will always be returned in a particular order, then you can add a sort column to the db and do Model.find([5, 2, 3], :order => 'sort_column'). If this isn’t the case, you’ll have to do the sorting in code:

ids = [5, 2, 3]
records = Model.find(ids)
sorted_records = ids.collect {|id| records.detect {|x| x.id == id}}

More Related Contents:

  1. ActiveRecord OR query Hash notation
  2. How to chain scope queries with OR instead of AND?
  3. Rails 5: ActiveRecord OR query
  4. ActiveRecord Find By Year, Day or Month on a Date field
  5. Rails 3 SQLite3 Boolean false
  6. GroupingError: ERROR: column must appear in the GROUP BY clause or be used in an aggregate function
  7. query , can not select column count
  8. Creating a PostgreSQL sequence to a field (which is not the ID of the record)
  9. Validate uniqueness of multiple columns
  10. Boolean Validation
  11. Deploying RoR app to Heroku with SQLite 3 fails
  12. Random record in ActiveRecord
  13. What is the easiest way to duplicate an activerecord record?
  14. accepts_nested_attributes_for with find_or_create?
  15. How can I avoid running ActiveRecord callbacks?
  16. Rails 4: List of available datatypes
  17. ActiveRecord.find(array_of_ids), preserving order
  18. Rails order by results count of has_many association
  19. How to sort text in sqlite3 with specified locale?
  20. Rails: Access to current_user from within a model in Ruby on Rails
  21. Add a reference column migration in Rails 4
  22. Multiple databases in Rails
  23. Rails: How do I create a default value for attributes in Rails activerecord’s model? [duplicate]
  24. Pushing Rails with SQLite3 to Heroku fails [duplicate]
  25. Using helpers in model: how do I include helper dependencies?
  26. Converting an array of objects to ActiveRecord::Relation
  27. PGError: ERROR: aggregates not allowed in WHERE clause on a AR query of an object and its has_many objects
  28. What is the difference between pluck and collect in Rails?
  29. Rails: Overriding ActiveRecord association method
  30. Errors of pushing rails app to Heroku error occurred while installing sqlite3, and Bundler cannot continue [duplicate]

Leave a Comment