Skip to content

Instantly share code, notes, and snippets.

Created July 26, 2013 10:49
Show Gist options
  • Star 62 You must be signed in to star a gist
  • Fork 8 You must be signed in to fork a gist
  • Save drogus/6087979 to your computer and use it in GitHub Desktop.
Save drogus/6087979 to your computer and use it in GitHub Desktop.
This is the example contents of the Rakefile, which you would use to run active record tasks without using Rails. It assumes using the same directories as rails uses: `db/migrate`, `config/database.yml`.
require 'bundler/setup'
require 'active_record'
include ActiveRecord::Tasks
db_dir = File.expand_path('../db', __FILE__)
config_dir = File.expand_path('../config', __FILE__)
DatabaseTasks.env = ENV['ENV'] || 'development'
DatabaseTasks.db_dir = db_dir
DatabaseTasks.database_configuration = YAML.load(, 'database.yml')))
DatabaseTasks.migrations_paths = File.join(db_dir, 'migrate')
task :environment do
ActiveRecord::Base.configurations = DatabaseTasks.database_configuration
ActiveRecord::Base.establish_connection DatabaseTasks.env
load 'active_record/railties/databases.rake'
Copy link

Suggested addition just below require 'active_record' above:

module Rails
  def self.root

(Fixes the uninitialized constant ActiveRecord::Tasks::SQLiteDatabaseTasks::Rails error when using the above with SQLite.)

Copy link

For activerecord v4.0.2 I've got an error with rake db:drop, but setting ActiveRecord::Tasks::DatabaseTasks.root attribute helped to resolve that issue.

The error:

$ rake db:drop
can't convert nil into String
<backtrace goes below>

Copy link

Timo614 commented Feb 1, 2014

Thanks for the gist! Was a huge help -- there's no way I would have been able to figure out how to include those tasks without it.

Just a tiny note to anyone using this, remember to change the environment variable mentioned above to match the environment variable you use to set your env.

DatabaseTasks.env = ENV['ENV'] || 'development'

I wasn't thinking and just copied that outright and wasted some time debugging a stupid issue as a result.

Had a goliath, test unit, active support test cases setup and was trying to get parallel_tests to work with it. It always passes RAILS_ENV though so some of the commands were acting up as a result because I had this set to development.

Copy link

Thank you!! This was so buried. Only when I googled 'rake file using DatabaseTasks' did this come up as the fourth hit. Here are some suggested key words. I'll add them here so others can find this.

  • active record rake file without rails
  • active record rake tasks without rails
  • how to load databases.rake

The other hits were about referencing the same active record configuration for using DatabaseTasks. Seriously, I wanted the authentic rake tasks instead of implementing them myself. So again thank you.

Copy link

Simpler solution to uninitialized constant ActiveRecord::Tasks::SQLiteDatabaseTasks::Rails:

DatabaseTasks.root = File.dirname(__FILE__)

Copy link

I just tried this gist with activerecord (4.2.0) and got the following error: NoMethodError: undefined methodapplication' for Rails:Module`

The fix was something like this:

module Rails
  def self.root

  def self.env

  def self.application

class Paths
  def paths
    { "db/migrate" => [File.expand_path("../db/migrate", __FILE__)] }

  def load_seed
    load File.expand_path("../db/seeds.rb", __FILE__)

EDIT: This also includes a fix for the rake db:seed task.

Copy link

qd3v commented May 27, 2015

If someone need only part of AR tasks (for example while testing gem you don't need half of them, because you test against test db and do not need seed or bunch of others) and for more details on how @drogus gist works, check my variation (based on this, thanks, btw :)

Copy link

Super helpful gist!

I'm using Ruby 2.3.1 and found I needed to change the env variable to a symbol when making the connection:

ActiveRecord::Base.establish_connection DatabaseTasks.env.to_sym

Otherwise I was getting a missing adapter error.

Copy link

foton commented Mar 21, 2017

I would like to point to Jason modification of this gist, which works for ActiveRecord 4.2.0

Copy link

Paxa commented Jul 3, 2017

Solved as:

# Rakefile
if Rake.application.top_level_tasks != ['test']
  require_relative 'config/application'

task :test do
  ENV['RAILS_ENV'] = 'test'
  Dir.glob('./test/**/*_test.rb').each { |file| require file}

Copy link

I have made minimal example/setup using Rails migration and active record outside Rails
(Support Rails >= 5.2)

Copy link

I get
ActiveRecord::AdapterNotSpecified: database configuration does not specify adapter

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment