how to clean database before running the each spec file?

Question

I want to clear my test database before running the each spec files.

I am already using rspec with factory girl.

Thanks, Hare

Yes, I am using it. But not sure how to write for each file. — Hare Ram, Jan 28 '17 at 16:15

score 7 · Answer 1 · answered Jan 28 '17 at 16:20

7

Add to RSpec.configure block in your spec_helper.rb

  config.before(:suite) do
    DatabaseCleaner.clean_with :truncation
  end

  config.before(:each) do
    DatabaseCleaner.strategy = :transaction
  end

  config.before(:each) do
    DatabaseCleaner.start
  end

  config.after(:each) do
    DatabaseCleaner.clean
  end

Must work

answered Jan 28 '17 at 16:20

VAD

2,351
4
20
32

Actually in my spec/controllers fold has many controllers, i want clean my database before running each controllers. – Hare Ram Jan 28 '17 at 16:23
1

One should clean their database before executing each test. It's necessary to ensure that the test executed previously did not affect the testing environment prepared for the current test e.g. there was not any garbage in your test database. – VAD Jan 28 '17 at 17:17
Why do you need to set the strategy `before :each`? Isn't `before :suite` sufficient? – CyberMew Aug 03 '18 at 05:47
To clean your database after each test so the next test could use clean database without garbage from the previous test. The idea is you need to run every single test on a clean setup – VAD Aug 03 '18 at 07:13

score 3 · Answer 2 · answered Jul 04 '19 at 12:34

3

In your spec_helper.rb, inside the RSpec.configure block

RSpec.configure do |config|

  # ...

  config.before(:suite) do
    DatabaseCleaner.clean_with :transaction
  end

  config.before(:each) do
    DatabaseCleaner.strategy = :transaction
  end

  config.before(:all) do
    DatabaseCleaner.start
  end

  config.after(:all) do
    DatabaseCleaner.clean
  end

  # ...
end

before(:all) and after(:all) runs for every spec file and not before and after the whole suite. So, for every spec file you will be able to clear database using any of the three strategies :transaction, :truncation, :deletion

answered Jul 04 '19 at 12:34

Venkateshwara Cholan

43
6

? This looks just like @VAD's answer from Jan 28, 2017. – L. Scott Johnson Jul 04 '19 at 12:55
1

VAD's answer will clean database for every single test case, mine does it for every single spec file(which was the actual question). the difference is :all instead of :each – Venkateshwara Cholan Jul 04 '19 at 15:31

score 0 · Answer 3 · answered Jan 31 '17 at 17:26

This is what I typically do for DatabaseCleaner

# Database Cleaner
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

That will make sure you have a clean database for each test.

Checkout a related, albeit old, article by Avdi for more info.

how to clean database before running the each spec file?

3 Answers3