S
Sharon Rosner
== Sequel 0.0.19 Released
Sequel: Concise ORM for Ruby. Sequel provides thread safety,
connection pooling and a concise DSL for constructing database queries
and table schemas. Version 0.0.19 fixes a bunch of minor bugs has
improved code coverage (rcov reports 74.5% coverage!)
Sequel currently supports SQLite, PostgreSQL and MySQL databases.
== Sequel by Example
require 'sequel/sqlite'
DB = Sequel.open 'sqlite:/:memory:'
DB.create_table
osts
column :title, :text
column :category, :text
end
posts = DB[
osts]
posts << {:title => 'first', :category => 'ruby'}
posts << {:title => 'second', :category => 'orm'}
posts.count #=> 2
posts.sql #=> 'SELECT * FROM posts'
posts.filter
category => 'orm').count #=> 1
posts.filter
category => 'orm').sql #=> "SELECT * FROM posts WHERE
(category = 'orm')"
posts.order
category).print # pretty-prints the table ordered by
category
== Installing Sequel
sudo gem install sequel
You can also check out the trunk and install locally:
svn co http://ruby-sequel.googlecode.com/svn/trunk sequel
cd sequel
rake install
== Changes in 0.0.19
* More specs for Dataset.
* Fixed Dataset#invert_order to work correctly with strings.
* Fixed Model#== to check equality of values.
* Added Model#exclude and Model#order.
* Fixed Dataset#order and Dataset#group to behave correctly when
supplied with qualified field name symbols.
* Removed Database#literal. Shouldn't have been there.
* Added SQLite:
ataset#explain. Returns an array of opcode hashes.
* Specs for ConnectionPool.
== Sequel Discussion List
I've created a google group dedicated to Sequel. Youcan find it here:
http://groups.google.com/group/sequel-talk
== Sequel RDoc
http://sequel.rubyforge.org
Sequel: Concise ORM for Ruby. Sequel provides thread safety,
connection pooling and a concise DSL for constructing database queries
and table schemas. Version 0.0.19 fixes a bunch of minor bugs has
improved code coverage (rcov reports 74.5% coverage!)
Sequel currently supports SQLite, PostgreSQL and MySQL databases.
== Sequel by Example
require 'sequel/sqlite'
DB = Sequel.open 'sqlite:/:memory:'
DB.create_table
column :title, :text
column :category, :text
end
posts = DB[
posts << {:title => 'first', :category => 'ruby'}
posts << {:title => 'second', :category => 'orm'}
posts.count #=> 2
posts.sql #=> 'SELECT * FROM posts'
posts.filter
posts.filter
(category = 'orm')"
posts.order
category
== Installing Sequel
sudo gem install sequel
You can also check out the trunk and install locally:
svn co http://ruby-sequel.googlecode.com/svn/trunk sequel
cd sequel
rake install
== Changes in 0.0.19
* More specs for Dataset.
* Fixed Dataset#invert_order to work correctly with strings.
* Fixed Model#== to check equality of values.
* Added Model#exclude and Model#order.
* Fixed Dataset#order and Dataset#group to behave correctly when
supplied with qualified field name symbols.
* Removed Database#literal. Shouldn't have been there.
* Added SQLite:
* Specs for ConnectionPool.
== Sequel Discussion List
I've created a google group dedicated to Sequel. Youcan find it here:
http://groups.google.com/group/sequel-talk
== Sequel RDoc
http://sequel.rubyforge.org