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
