Skip to Main Content
Professional Ruby on Rails™
book

Professional Ruby on Rails™

by Noel Rappin
February 2008
Intermediate to advanced content levelIntermediate to advanced
479 pages
14h
English
Wrox
Content preview from Professional Ruby on Rails™

6.3. Testing a Legacy Database with Fixtures

As previously mentioned, when you go against Rails defaults by adding a legacy database, you lose some of Rails automatic generation magic. One thing that becomes a little bit harder is using fixtures in your unit and automated tests. The standard fixtures method call (which technically is a class method added by Rails to the TestUnit class) assumes that it will be working with the database defined for the test environment. Your secondary database, defined as ingredient_test, is somewhat out of luck. Fortunately, there is a workaround that allows you to have all the functionality of Rails fixtures, and most, if not all, of the convenience that you have when working in a Rails database.

Among the conveniences you give up are the nice little Rake tasks that automatically prepare your test database based on the schema of the development database. You'll need to go in manually to create the test database. You might want to invest the time to create a shell script and/or a Rake task to create your legacy database automatically. Usually that's going to be something like this:

mysql legacy_database < schema.sql

If you do declare this as a Rake task, you can add it as a dependency to the existing test:prepare style tasks like this:

namespace :db do
  namespace :test do
    task :legacy_prepare do
      sh my_load_test_script
    end

    task :prepare => :legacy_prepare
  end
end

Put something like that in your lib/tasks directory, and the Rake db:test:prepare task ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Ruby on Rails® Bible

Ruby on Rails® Bible

Timothy Fisher
Rails 4 in Action

Rails 4 in Action

Yehuda Katz, Rebecca Skinner, Stephen Klabnik, Ryan Bigg

Publisher Resources

ISBN: 9780470223888Purchase book