From: hemant <gethemant@...>
Date: 2007-07-22T12:29:07+09:00
Subject: Re: first ruby script mysql data input

On 7/22/07, PB0711 <hpbenton@gmail.com> wrote:
> Hello all,
>
> I'm trying to use ruby for the first time. I want to make a script
> that is going to parse through my file and pick stuff up and place it
> into a database. When I put it into the database I would like to first
> ask the database if there is something already like it and if there is
> an "empty" primary key to use.
> The key ID's in the database go something like:
> 1 2 3 5 6 7 8 10 11 12 18 22 23 24 and so on. I want to put stuff into
> ID 4, 9, 13 and so on. I was wondering what modules I should use and
> how to go about this.
> I come from Perl and I'm pretty use to doing this type of thing in
> Perl, expect for asking what ID is "free",
>
> So just ideas of how to do it and what tools you all think I will
> need
>
> Thank

You would need  a library capable of handling connection to mysql db.
You can try:

sudo gem install mysql

Or you can use DBI bindings(which in some form exist in perl also i believe).

you can do google search on "mysql+ruby" and find many meaningful
tutorials and documents.