Sequel::Plugins::DefaultOrder

This gem aims to tackle a frequent issue where the database does not return consistent results due to a lack of default ordering. This will allow you set a default dataset order as part of the model.

Add this line to your application's Gemfile:

gem 'sequel-default-order'

And then execute:

$ bundle

Or install it yourself as:

$ gem install sequel-default-order

In any of your models you can use this plugin like this:

class Foo < Sequel::Model
  default_order Sequel.desc(:column)
end

This will override the default dataset of the model to set the default order. If you have a query that you would like to override the default order on, you can request the default dataset with:

Foo.with_original_dataset

Associations will also respect the default order outlined in the model. For example:

class Foo < Sequel::Model
  one_to_many :bars
end

class Bar < Sequel::Model
  default_order Sequel.desc(:name)
end

With this pattern I can do this:

Foo.first.bars_dataset

=> SELECT * FROM bars WHERE (id = 1) ORDER BY name

But if you want to override that and get the unordered dataset you can do the following:

Foo.first.bars_dataset.from_original_dataset

=> SELECT * FROM bars WHERE (id = 1)

Bug reports and pull requests are welcome on GitHub at https://github.com/ehowe/sequel-default-order.

The gem is available as open source under the terms of the MIT License.