Transaction vs Truncation Database Cleaner

Question

Recently I had a problem with one of my cucumber scenarios. Certain entries in my test database were disappearing whilst the feature was running. I solved the problem by changing the line

DatabaseCleaner.strategy = :transaction

to

DatabaseCleaner.strategy = :truncation

I'm not sure why that helped. There is a table on the database cleaners gem webpage, but it dosen't really say what the two terms mean. Any help on understanding the difference between the two concepts would be great.

score 41 · Accepted Answer · answered Sep 17 '11 at 19:13

41

Putting it in a very simple way: truncation removes all data from the database and transaction rollbacks all changes that has been made by the running scenario.

answered Sep 17 '11 at 19:13

socjopata

5,028
3
30
33

1

thats pretty much what I needed. Thanks – elliance Sep 18 '11 at 00:46

score 2 · Answer 2 · edited May 23 '17 at 12:00

2

Truncation removes the data leaving the database structure, transaction majorly rollback the database operation and it is the fastest strategy. And there is the last one which is deletion. Deletion deletes the data and removes the structure of the database, it is the slowest but safest. You can also check Difference between truncation, transaction and deletion database strategies

edited May 23 '17 at 12:00

Community

1
1

answered Feb 24 '15 at 13:09

Olalekan Sogunle

2,299
1
20
26

Transaction vs Truncation Database Cleaner

2 Answers2