From: Venu9955 Date: 2008-04-01T16:10:17+09:00 Subject: Re: Ruby/Informix 0.7.0 Thanks for the information, Venu 9955 On Apr 1, 10:16 am, Gerardo Santana Gómez Garrido wrote: > 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