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 J…)
=============================================
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