[ANN] Ruby/Informix 0.7.0

Gerardo_Santana_Gome · 1 April 2008 05:16

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 <reidmo at gmail>

    * 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

Venu9955 · 1 April 2008 07:10

Thanks for the information,
Venu 9955

···

On Apr 1, 10:16 am, Gerardo Santana Gómez Garrido <gerardo.sant...@gmail.com> 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\(&#39;stores&#39;\)
Inserting records
stmt = db\.prepare\(&#39;insert into state values\(?, ?\)&#39;\)
stmt\.execute\(&#39;CA&#39;, &#39;California&#39;\)
Iterating over a table using a hash (shortcut):
db\.each\_hash\(&#39;select \* from customers&#39;\) do |cust|
  puts &quot;\#\{cust\[&#39;firstname&#39;\]\} \#\{cust\[&#39;lastname&#39;\]\}&quot;
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 <reidmo at gmail>
\* 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