# Cannot save to test database

**URL:** <https://www.ruby-forum.com/t/cannot-save-to-test-database/89390>\
**Category:** Rails\
**Created:** [March 20, 2007, 3:02am UTC](https://www.ruby-forum.com/t/cannot-save-to-test-database/89390 "2007-03-20T03:02:28Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Vic](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/v/9e8a1a/32.png) [@Vic](https://www.ruby-forum.com/u/Vic)\
**Post date:** [March 20, 2007, 3:02am UTC](https://www.ruby-forum.com/t/cannot-save-to-test-database/89390/1 "2007-03-20T03:02:28Z")

</div>

Hi all,  
I am having problems writing data in the test database. I have a  
functional test method that calls a method in my application, which is  
creating a new object and saving it. Although fc.save! returns “true”,  
nothing is written in the database…

Thanks for your help,  
Vic

my method:  
def test\_should\_add\_criterion  
get :add\_criterion, { :id=\>filters(:one).id }, {  
:current\_context\_id=\>1, :current\_user\_id=\>1}  
old\_count = FilterCriterion.count  
end

in the application:  
def add\_criterion  
fc = FilterCriterion.new  
fc.save! # this returns true (but no save)…  
end

---

<div class="post-metadata">

**Author:** ![Vic](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/v/9e8a1a/32.png) [@Vic](https://www.ruby-forum.com/u/Vic)\
**Post date:** [March 20, 2007, 7:03pm UTC](https://www.ruby-forum.com/t/cannot-save-to-test-database/89390/2 "2007-03-20T19:03:20Z")

</div>

This might be due to using transactional fixtures, which does a rollback  
on anything the tests do to the test db.

b
