From: Sharon Rosner <ciconia@...>
Date: 2007-09-08T00:24:27+09:00
Subject: ANN: Sequel 0.2.0.2 Released

Sequel version 0.2.0.2 has just been released. This release includes a
number of minor bug fixes and improvements.

Inserting from subqueries
=========================

You can now use datasets as subqueries in insert statements, if your
database supports this feature:

  DB[:items] << DB[:temp_items].filter(:active => true)

  #=> "INSERT INTO items (SELECT * FROM temp_items WHERE (active =
't'))"

Model classes can be reopened
=============================

Classes deriving from Sequel::Model() can now be reopened and
reloaded. This solves a annoyance people had when using Sequel models
in Camping or Merb applications.

MySQL adapter accepts charset option
====================================

You can now specify the character set in use for MySQL databases:

  Sequel("mysql://localhost/mydb", :charset => 'UTF-8')

Bug fixes and other changes
===========================

* Fixed Dataset#exclude to add parens around NOT expression (#38).

* Fixed use of sub-queries with all comparison operators in block
filters (#38).

* Fixed arithmetic expressions in block filters to not be literalized.

* Changed Symbol#method_missing to return LiteralString.

* Changed PrettyTable to right-align numbers.

* Fixed Model.create_table (thanks Duane Johnson.)

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

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