Forum: Ruby ANN: Sequel 0.1.7 Released

Announcement (2017-05-07): is now read-only since I unfortunately do not have the time to support and maintain the forum any more. Please see and for other Rails- und Ruby-related community platforms.
6d21f1858dda3716c76cd2a7f92ca08f?d=identicon&s=25 Sharon Rosner (ciconia)
on 2007-06-30 21:17
(Received via mailing list)
Sequel version 0.1.7 has just been released. This is mainly a bug fix
release, but there is also some new functionality, mainly convenience
methods, and a new pagination feature. Following is a discussion of
the main changes:


If you're using Sequel in an MVC setting you might find this one
useful. A new Dataset#paginate method provides a very simple
pagination interface. Here's a contrived example:

  def search
    @recipes = Recipe.filter('body LIKE ?',
params[:search]).paginate(params[:page], params[:page_size])

What you get back from #paginate is just a regular dataset, but with
the following methods:

  @recipes.page_count #=> the total number of pages available
  @recipes.current_page #=> the current page number
  @recipes.prev_page #=> the previous page number or nil if we're on
the first page
  @recipes.next_page #=> the next page number or nil if we're on the
last page

Dataset#[]= for updating records

New shorthand for conditional UPDATEs. Instead of:

  items.filter(:group_id => 29).update(:stamp =>

You can now write:

  items[:group_id => 29] = {:stamp =>}

More concise first and last calls

Dataset#first and Dataset#last now accept hashes for specifying
filters, so now you can drop the filter call. Instead of:

  people.filter(:name => 'sharon').first

You can now write:

  items.first(:name => 'sharon')

More concise opening of databases

Sequel now defines a Sequel method call, so instead of:

  DB = 'sqlite:/'

You can now write:

  DB = Sequel('sqlite:/')

Bug fixes

* Implemented Model.join method to restrict returned columns to the
model table (thanks Pedro Gutierrez).

* Fixed after_destroy hook to actually work.

* Fixed Dataset#first to include a LIMIT clause for a single record.

* Small fix to Postgres driver to return a primary_key value for the
inserted record if it is specified in the insertion values (thanks
Florian AƟmann and Pedro Gutierrez).

* Fixed Symbol#DESC to support qualified notation (thanks Pedro


Sequel documentation:

Join the Sequel-talk group:

Install the gem:
  sudo gem install sequel

Or check out the source and install manually:
  svn co sequel
  cd sequel
  rake install
This topic is locked and can not be replied to.