spec_helper.rb

Spec::Runner.configure do |config|
  require File.dirname(__FILE__) + "/spec_helpers"
  
  include SpecHelperFunctions
  setup_tests
  
  config.prepend_before(:each) do
    FixtureReplacementController::AttributeCollection.clear_out_instances!
  end
  
  config.prepend_after(:each) do
    FixtureReplacementController::AttributeCollection.clear_out_instances!
  end
end

spec_helpers.rb

module SpecHelperFunctions
  
  def setup_tests
    setup_database_connection
    setup_project_requires
  end
  
private
  
  def setup_database_connection
    require 'rubygems'
    require 'sqlite3'
    require 'active_record'
    require 'active_support'
    
    ActiveRecord::Base.establish_connection :adapter => 'sqlite3', :database  => ':memory:'
    ActiveRecord::Migration.verbose = false

    ActiveRecord::Schema.define do  
      create_table :users, :force => true do |t|
        t.column  :key,       :string
        t.column  :other_key, :string
        t.column  :gender_id, :integer
        t.column  :username,  :string
      end
      
      create_table :players, :force => true do |t|
        t.column :username, :string
        t.column :key, :string
      end

      create_table :genders, :force => true do |t|
        t.column  :sex, :string
      end

      create_table :aliens, :force => true do |t|
        t.column :gender_id, :string
      end

      create_table :admins, :force => true do |t|
        t.column :admin_status, :boolean
        t.column :name, :string
        t.column :username, :string
        t.column :key, :string
        t.column :other_key, :string
      end  

      create_table :items, :force => true do |t|
        t.column :category, :integer
        t.column :type, :string
        t.column :name, :string
        t.column :cache_latest_activity_time, :datetime, :null => false
      end
      
      create_table :categories, :force => true do |t|
        t.column :name, :string
      end
      
      create_table :subscribers, :force => true do |t|
        t.column :first_name, :string
      end
      
      create_table :subscriptions, :force => true do |t|
        t.column :name, :string
      end
      
      create_table :subscribers_subscriptions, :force => true, :id => false do |t|
        t.column :subscriber_id, :integer
        t.column :subscription_id, :integer
      end
    end
  end
  
  def setup_project_requires
    require File.dirname(__FILE__) + "/../lib/fixture_replacement"
    require File.dirname(__FILE__) + "/fixture_replacement/fixtures/classes"
  end
end