Asp Forum - ANN: Sequel 0.1.7 Released

Sharon Rosner

6/30/2007 7:17:00 PM

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:

Pagination
=========

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])
end

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 => Time.now)

You can now write:

items[:group_id => 29] = {:stamp => Time.now}

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 = Sequel.open '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
Gutierrez).

======================

Sequel documentation:
<http://sequel.rubyfor...

Join the Sequel-talk group:
<http://groups.google.com/group/seque...

Install the gem:
sudo gem install sequel

Or check out the source and install manually:
svn co http://ruby-sequel.googlecode.com... sequel
cd sequel
rake install

comp.lang.ruby

ANN: Sequel 0.1.7 Released

Sharon Rosner

x Login to ForumsZone