I’m pleased to announce another release of Ruby/Informix, a Ruby
library for connecting to IBM Informix.
In this release you’ll find support for the INTERVAL data type, more
handy methods and more and better documentation with examples, along
with a new web site.
Web site: http://ruby-informix.rubyforge.org/
Documentation: http://ruby-informix.rubyforge.org/doc/
Some examples:
Connecting to a database:
db = Informix.connect('stores')
Inserting records
stmt = db.prepare('insert into state values(?, ?)')
stmt.execute('CA', 'California')
Iterating over a table using a hash (shortcut):
db.each_hash('select * from customers') do |cust|
puts "#{cust['firstname']} #{cust['lastname']}"
end
Changelog follows:
0.7.0 03/31/2008
New features:
* Experimental support for the INTERVAL data type:
- year_to_month, day_to_fraction, from_months and from_seconds
class
methods for creating an Interval object
- +@ and -@ unary operators
- +, * and / operations available with Integer, Rational, Date,
Time
and DateTime objects
- methods for returning the respective fields of an Interval
object
individually (years, months, days, hours, minutes and seconds)
- to_a method for returning the fields of an Interval object as
an array
- methods for converting the Interval object to the given unit,
where
apply (to_years, to_months, to_days, to_hours, to_minutes and
to_seconds)
- to_s method for displaying an Interval object as an string
according
to ANSI SQL standards
- includes Comparable
* Database#version returns a struct with version information of the
database
server.
* Database#each and Database#each_hash shortcut methods for
declaring and
opening a cursor in a single step.
Contributed by Reid Morrison
* Database#execute is not an alias for Database#immediate any more.
It has become a shortcut for preparing and executing a statement
in a
single step.
* SequentialCursor includes Enumerable
* Ruby 1.9 compatible
* More and better documentation
Bugs fixed:
* The documentation for class Error was not being recognized by rdoc
Remarks:
* Database.new deprecated in favor of Database.open
* Database#do was removed
* A lot of C code has been reimplemented in Ruby
* Modules and classes have been reorganized
* Database#execute still behaves the same, except that it can also
accept
input parameters and return at most one record. Database#immediate
is
more efficient though.