From: "Gerardo Santana Gómez Garrido" Date: 2008-04-01T14:16:39+09:00 Subject: [ANN] Ruby/Informix 0.7.0 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. -- Gerardo Santana