Update data via cron?

rubyonrails-talk
1

Hi!

I'm building a small site and I wish to fill the data in the database nightly via cron. What is best practice here? Do I: 1) have cron do a normal web request to /nightRunner/doIt? 2) build a maintenance script and place it somewhere (where?) that have access to the models and database and call it via script/runner?

Thanks.

2

1) urgh. 2) Yes. we typically have a cron_jobs folder with (you guessed it) cron jobs

Sticking

#!/usr/bin/env ruby require File.dirname(__FILE__) + '/../config/boot' require File.dirname(__FILE__) + '/../config/environment' ActiveRecord::Base.establish_connection

at the top should get all the rails stuff setup for you

Fred

3

Or you can run your cron script with script/runner