How can I load ActiveRecord database tasks on a Ruby project outside Rails?

Question

ActiveRecord 3.2.14 I want to use ActiveRecord in a non-Rails Ruby project. I want to have available the rake tasks that are defined by ActiveRecord. How can I do that? rake db:create # Create the database from DATABASE_URL or config/database.yml for the current Rails.env (use db:create:all to create all dbs in the config) rake db:drop # Drops the database using DATABASE_URL or the current Rails.env (use db:drop:all to drop all databases) rake db:fixtures:load # Load fixtures into the current environment's database rake db:migrate # Migrate the database (options: VERSION=x, VERBOSE=false) rake db:migrate:status # Display status of migrations rake db:rollback # Rolls the schema back to the previous version (specify steps w/ STEP=n) rake db:schema:dump # Create a db/schema.rb file that can be portably used against any DB supported by AR rake db:schema:load # Load a schema.rb file into the database rake db:seed # Load the seed data from db/seeds.rb rake db:setup # Create the database, load the schema, and initialize with the seed data (use db:reset to also drop the db first) rake db:structure:dump # Dump the database structure to db/structure.sql rake db:version # Retrieves the current schema version number The above list is the list of tasks that I want to be able to use on my non-Rails Ruby project that uses ActiveRecord. What do I have to write in my Rakefile? Thanks in advance JavaScript questions and answers, JavaScript questions pdf, JavaScript question bank, JavaScript questions and answers pdf, mcq on JavaScript pdf, JavaScript questions and solutions, JavaScript mcq Test , Interview JavaScript questions, JavaScript Questions for Interview, JavaScript MCQ (Multiple Choice Questions)

Answer 1

The easiest thing to do is to load the tasks already defined in databases.rake. Here is a GIST of how it was done. Inspired by this GIST by Drogus Rakefile.rb require 'yaml' require 'logger' require 'active_record' include ActiveRecord::Tasks class Seeder def initialize(seed_file) @seed_file = seed_file end def load_seed raise "Seed file '#{@seed_file}' does not exist" unless File.file?(@seed_file) load @seed_file end end root = File.expand_path '..', __FILE__ DatabaseTasks.env = ENV['ENV'] || 'development' DatabaseTasks.database_configuration = YAML.load(File.read(File.join(root, 'config/database.yml'))) DatabaseTasks.db_dir = File.join root, 'db' DatabaseTasks.fixtures_path = File.join root, 'test/fixtures' DatabaseTasks.migrations_paths = [File.join(root, 'db/migrate')] DatabaseTasks.seed_loader = Seeder.new File.join root, 'db/seeds.rb' DatabaseTasks.root = root task :environment do ActiveRecord::Base.configurations = DatabaseTasks.database_configuration ActiveRecord::Base.establish_connection DatabaseTasks.env.to_sym end load 'active_record/railties/databases.rake'