From: Sharon Rosner <ciconia@...>
Date: 2007-11-02T04:34:28+09:00
Subject: ANN: Sequel 0.3.2 Released

Sequel version 0.3.2 has just been released. This release includes new
Dataset functionality, magic methods and a few other minor
improvements and bug fixes.

Following is a discussion of the changes:

=== New Dataset functionality

A few new methods have been added to the Dataset class. The
#group_and_count methods returns a dataset grouped by the given
column, along with a count for each group:

  posts.group_and_count(:category).sql
  #=> "SELECT category, count(category) AS count FROM posts GROUP BY
category ORDER BY count"

The #range method returns a Range object made from the minimum and
maximum values for the given column:

  posts.filter(:category => 'ruby').range(:view_count)
  #=> 11..35

The #interval method returns the interval between the minimum and
maximum values for the given column:

  posts.filter(:category => 'ruby').interval(:view_count)
  #=> 24

=== Dataset magic methods

The Dataset class now supports magic methods: order_by_xxx,
first_by_xxx, last_by_xxx, filter_by_xxx, group_by_xxx and
count_by_xxx. These methods can be used :

  posts.order_by_stamp.sql
  #=> "SELECT * FROM posts ORDER BY stamp"

  posts.first_by_stamp #=> first row ordered by stamp
  posts.last_by_stamp #=> last row ordered by stamp

  posts.filter_by_category('ruby').sql
  #=> "SELECT * FROM posts WHERE (category = 'ruby')"

  posts.group_by_category.sql
  #=> "SELECT * FROM posts GROUP BY category"

  posts.count_by_category.sql
  #=> "SELECT category, count(category) AS count FROM posts GROUP BY
category ORDER BY count"

=== Other improvements and bug fixes

* Model.create and Model.new can now accept a block:

  Post.new do |p|
    p.title = "Hello world"
    p.save
  end

* Added Dataset#set as alias to Dataset#update.

* Fixed Oracle::Database#execute (#84).

* Fixed timestamp translation in SQLite adapter (#83).

* Experimental DB2 adapter.

* Removed long deprecated expressions.rb code.

* More documentation.

* Revised code to refer to 'columns' instead of 'fields'.

=== More info

Sequel project page:
  <http://code.google.com/p/ruby-sequel>

Sequel documentation:
  <http://sequel.rubyforge.org>

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

Install the gem:
  sudo gem install sequel

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