custom db rake task gives 'development database not configured'

rubyonrails-talk
1

Hi all, I'm trying to write a simple custom rake task to easily delete some database records. However when I run it, I get an error 'development database is not configured'.

Here's the code: lib/tasks/custom.rake

require 'activerecord'

namespace :db do   task :delete_sessions do     sessions = ENV['sessions'].split(',').collect! {|n| n.to_i}     ActiveRecord::Base.establish_connection(RAILS_ENV.to_sym)     for session in sessions do       ActiveRecord::Base.connection.execute("DELETE FROM pool_sessions WHERE pool_session_id=#{session};")     end end end

And how I call it:

$ rake db:delete_sessions sessions=1,2 (in <rails root>) rake aborted! development database is not configured

(See full trace by running task with --trace)

If I change RAILS_ENV to test or production I get parallel results.

I can still do other rake db tasks, such as drop, create, and migrate, so I know that my config/database.yml is OK.

Any ideas? Thanks. -David

2

Taking a look at databases.rake in rails itself, I think you want to depend on the :load_config task so that your database.yml file is actually loaded

Fred

3

Frederick Cheung wrote: