From: Aldric Giacomoni <aldric@...>
Date: 2010-01-07T01:49:04+09:00
Subject: Re: Script to interact with a database

Quee WM wrote:
> I have an application in rails in which i am adding a new column in one
> of the tables. The value for the new column is a bit.ly link and I need
> to populate this for each record in the table approx. 250 rows will be
> affected.
> 
> Q1: Can this be done outside the application? i.e. write a script that
> can interact with the db and then populate the appropriate column? And
> is this advisable?
> 
> or
> 
> Q2: if the aforementioned idea is not a good way then what will be the
> best way to update the existing records as any code i will write will
> only be used to update the table once.

Sounds like you should be posting this in the Rails forum / newsgroup.
Also sounds like you should look into migrations.
-- 
Posted via http://www.ruby-forum.com/.