default_scope for MySQL to PostgreSQL project migration. The id sort order is not == when compared to MySQL and many specs are failing, even some relating to Gem models.

sorted_by_id.rb

# Needed because I also have Gem models that are throwing errors not just my models. I'd like to have one simple mixin or monkey patch.
# without mucking with ActiveRecord::Base too much.

module SortedById
  extend ActiveSupport::Concern
  included do
    default_scope order('id ASC')
  end
end
ActiveRecord::Base.send(:include,SortedById)


# Oh Noes!!!
#ruby/1.9.1/gems/activerecord-3.2.11/lib/active_record/model_schema.rb:148:in `reset_table_name': undefined method `abstract_class?' for Object:Class (NoMethodError)
#from /Users/hankbeaver/blinqmedia/blinq_ad_manager/local/ruby/1.9.1/gems/activerecord-3.2.11/lib/active_record/model_schema.rb:104:in `table_name'

I don't like the idea of having a global default scope but if you really need that, you can try something like:

class ActiveRecord::Base
  def self.inherited(klass)
    klass.default_scope order('id ASC')
  end
end

This will call the default scope on each inherited class instead of the base itself (it needs to be loaded before any model).

I'm not sure if active record already do something on Class.inherited, you may need alias_method_chain.

Maybe a cleaner solution:

class ActiveRecord::Base
  def self.default_scope
    order(:id)
  end
end

I tried a monkey patch as a well as creating my own base class that extends ActiveRecord::Base. The former, still threw the abstract_class? exception and the latter could not introspect the table name of the model anymore and asked for me to self.table_name = ?. Trying another route. Thanks!