simple_database_cleaner.rb

# Add this file to `spec/support/simple_database_cleaner.rb`

class SimpleDatabaseCleaner
  def clean(connection)
    @cached_sql ||= {}
    sql = @cached_sql[connection] ||=
      begin
        "".tap do |sql|
          connection.tables.each do |table_name|
            next if table_name == "schema_migrations".freeze
            sql << %{DELETE FROM #{connection.quote_table_name(table_name)};\n}
          end
        end
      end
    
    connection.execute sql
  end
end

RSpec.configure do |config|
  database_cleaner = SimpleDatabaseCleaner.new

  config.before do |example|
    database_cleaner.clean(ActiveRecord::Base.connection)
    database_cleaner.clean(RecordWithOtherDatabase.connection)
  end
end