ANN: Sequel 0.1.2 Released

Ruby
1

Sequel version 0.1.2 has just been released. This release contains
vaious bug fixes and enhancements. Here are the important changes:

  • Support for SQL set operations (UNION, INTERSECT and EXCEPT):

DB[:a].union(DB[:b]).sql #=>
“SELECT * FROM a UNION SELECT * FROM b”

The #union, #intersect and #except methods take an optional second
parameter to specify ALL for the clause:

DB[:a].intersect(DB[:b], true).sql #=>
“SELECT * FROM a INTERSECT ALL SELECT * FROM b”

  • SequelConnectionError has been removed, as it caused a some
    difficulties dealing with non DB-related errors that were raised
    inside transactions. However, Exception errors are automatically
    converted into RuntimeError. Future releases might convert adapter-
    specific errors into standard Sequel errors.

  • Added DSL for defining subsets in Model classes:

class A < Sequel::Model(:a)
subset(:high_priced) {price > 100}
subset :china, :category => ‘china’
end

A.high_priced.sql #=> “SELECT * FROM a WHERE (price > 100)”
A.china.sql #=> “SELECT * FROM a WHERE (category = ‘china’)”

  • Cleaned up PostgreSQL adapter code.

  • Updated spec to conform with RSpec 1.0.

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

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 locally:
svn co http://ruby-sequel.googlecode.com/svn/trunk sequel
cd sequel
rake install