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 =
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
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 J…)
Sequel project page:
Join the Sequel-talk group:
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