.rspec

--colour
-I app

active_record_spec_helper.rb

require 'active_record'
require 'database_cleaner'

connection_info = YAML.load_file("config/database.yml")["test"]
ActiveRecord::Base.establish_connection(connection_info)

RSpec.configure do |config|
  config.before(:suite) do
    DatabaseCleaner.strategy = :transaction
    DatabaseCleaner.clean_with(:truncation)
  end
  config.before(:each) do
    DatabaseCleaner.start
  end
  config.after(:each) do
    DatabaseCleaner.clean
  end
end

coderetreat.rb

class Coderetreat < ActiveRecord::Base
  def self.running_today
    where(scheduled_on: Date.today)
  end
end

coderetreat_spec.rb

require 'active_record_spec_helper'
require 'models/coderetreat'

describe Coderetreat do
  describe ".running_today" do
    def coderetreat_on(date)
      Coderetreat.create! city: "Chicago", scheduled_on: date
    end
    
    context 'with a coderetreat scheduled for today' do
      specify do
        coderetreat = coderetreat_on Date.today
        Coderetreat.running_today.should include coderetreat
      end
    end
    
    context 'with a coderetreat not scheduled for today' do
      example do
        coderetreat = coderetreat_on Date.today.advance(:days => -1)
        Coderetreat.running_today.should_not include coderetreat
      end
    end
  end
end

spec_helper.rb

#Some databases get upset if you try to start a new transaction while a transaction is already in play, so running the whole spec suite chokes when rspec is trying to start a transaction. You need to update your spec_helper to rely on active_record_spec_helper to do this for you.

#Replace this line
    config.use_transactional_fixtures = true

#With this
require 'active_record_spec_helper'

#TADA