Ruby Forum Ruby on Rails > Using ActiveRecord in a script?

Hello,
 ...at least I'm pretty sure its called ActiveRecord. I have an app
running on InstantRails 1.6 that will periodically call a ruby script in
the /script folder. In the script, I use the same models to connect to
my database as the ones in the rest of the app, but it doesn't seem to
work. I'm using "Model.connection.select_all('sql statement')" where
Model is the name of the model. Do I have to call a special gem or
something?

Thanks,
 - Jeff Miller

does it call the script as in
system(script_name)?  If so then that script would need to load up the
whole AR framework somehow, at its start.
-R

On Thu, May 1, 2008 at 7:44 PM, Jeff Miller

Jeff Miller wrote:
> Hello,
>  ...at least I'm pretty sure its called ActiveRecord. I have an app
> running on InstantRails 1.6 that will periodically call a ruby script in
> the /script folder. In the script, I use the same models to connect to
> my database as the ones in the rest of the app, but it doesn't seem to
> work. I'm using "Model.connection.select_all('sql statement')" where
> Model is the name of the model. Do I have to call a special gem or
> something?

you need to include your "environment.rb"

sticking this line;
require File.expand_path(File.dirname(__FILE__) + 
"/../config/environment")

at the top of your file should load up rails, giving you access to all 
of your models.

That worked great! Thanks very much!

I think another way to do this is with script/runner.  I think you can
use script runner in place of sh or tcsh (e.g. #! script/runner as the
first line of the script file) and that is supposed to load the
environment.  See script/runner -help.  I haven't tried it myself yet,
but was just learning about it.

On May 2, 4:35 pm, Jeff Miller <rails-mailing-l...@andreas-s.net>