# Don't save fixtures into database

**URL:** <https://www.ruby-forum.com/t/dont-save-fixtures-into-database/137979>\
**Category:** Rails\
**Created:** [May 19, 2008, 8:21am UTC](https://www.ruby-forum.com/t/dont-save-fixtures-into-database/137979 "2008-05-19T08:21:49Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![mr\_tibs](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/m/439d5e/32.png) [@mr\_tibs](https://www.ruby-forum.com/u/mr_tibs)\
**Post date:** [May 19, 2008, 8:21am UTC](https://www.ruby-forum.com/t/dont-save-fixtures-into-database/137979/1 "2008-05-19T08:21:49Z")

</div>

Hi,

I’m using RSpec on Rails and it seems that my fixtures are saved into  
the database. I don’t want that. Does the fixtures call take any  
parameters to don’t commit the examples to the database?  
I can’t find the docs for that. Can anyone point to me where they are?

Thanks,  
Tiberiu

---

<div class="post-metadata">

**Author:** ![mr\_tibs](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/m/439d5e/32.png) [@mr\_tibs](https://www.ruby-forum.com/u/mr_tibs)\
**Post date:** [May 19, 2008, 8:22am UTC](https://www.ruby-forum.com/t/dont-save-fixtures-into-database/137979/2 "2008-05-19T08:22:59Z")

</div>

And which database did you configure in your database.yml, the same  
database  
that your development environment is using? They should be in different  
databases because when you run the specs it will reload all data in the  
tables that relate to the fixtures you’re calling.

On Mon, May 19, 2008 at 3:51 PM, Mr\_Tibs [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid)  
wrote:

> >

–  
Appreciated my help?  
Reccommend me on Working With Rails  
[http://workingwithrails.com/person/11030-ryan-bigg](http://workingwithrails.com/person/11030-ryan-bigg)

---

<div class="post-metadata">

**Author:** ![mr\_tibs](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/m/439d5e/32.png) [@mr\_tibs](https://www.ruby-forum.com/u/mr_tibs)\
**Post date:** [May 19, 2008, 9:10am UTC](https://www.ruby-forum.com/t/dont-save-fixtures-into-database/137979/3 "2008-05-19T09:10:02Z")

</div>

Rails T.,

linking to free ebooks on your site like that is illegal. Please do not  
link  
to ebooks of books that authors have worked so hard on. Remove the link  
from  
your signature.

\</off topic\>

On Mon, May 19, 2008 at 4:35 PM, Rails T. \<  
removed\_email\_address@domain.invalid\> wrote:

> 

–  
Appreciated my help?  
Reccommend me on Working With Rails  
[http://workingwithrails.com/person/11030-ryan-bigg](http://workingwithrails.com/person/11030-ryan-bigg)

---

<div class="post-metadata">

**Author:** ![mr\_tibs](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/m/439d5e/32.png) [@mr\_tibs](https://www.ruby-forum.com/u/mr_tibs)\
**Post date:** [May 19, 2008, 9:05am UTC](https://www.ruby-forum.com/t/dont-save-fixtures-into-database/137979/4 "2008-05-19T09:05:49Z")

</div>

Try to make different database for your test environment so it will not  
be mixed to your development or production database.

Reinhart  
[http://teapoci.blogspot.com](http://teapoci.blogspot.com)

---

<div class="post-metadata">

**Author:** ![mr\_tibs](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/m/439d5e/32.png) [@mr\_tibs](https://www.ruby-forum.com/u/mr_tibs)\
**Post date:** [May 19, 2008, 9:32am UTC](https://www.ruby-forum.com/t/dont-save-fixtures-into-database/137979/5 "2008-05-19T09:32:47Z")

</div>

ok I will close it. thank you Ryan.

---

<div class="post-metadata">

**Author:** ![mr\_tibs](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/m/439d5e/32.png) [@mr\_tibs](https://www.ruby-forum.com/u/mr_tibs)\
**Post date:** [May 19, 2008, 10:31pm UTC](https://www.ruby-forum.com/t/dont-save-fixtures-into-database/137979/6 "2008-05-19T22:31:38Z")

</div>

Thanks Ryan. I was kind of surprised when I had to manually change  
spec\_helper.rb and set ENV[“RAILS\_ENV”] to “development”. I will  
create a test db.  
I do want to know, is there a way of not saving the fixtures in the  
database, or do I have to delete them in the teardown method?

Thanks,  
Tiberiu

---

<div class="post-metadata">

**Author:** ![mr\_tibs](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/m/439d5e/32.png) [@mr\_tibs](https://www.ruby-forum.com/u/mr_tibs)\
**Post date:** [May 20, 2008, 4:11am UTC](https://www.ruby-forum.com/t/dont-save-fixtures-into-database/137979/7 "2008-05-20T04:11:34Z")

</div>

Because my model creates files/directories on the disk.

On May 19, 3:11 pm, “Ryan B. (Radar)” [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid)

---

<div class="post-metadata">

**Author:** ![mr\_tibs](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/m/439d5e/32.png) [@mr\_tibs](https://www.ruby-forum.com/u/mr_tibs)\
**Post date:** [May 20, 2008, 12:12am UTC](https://www.ruby-forum.com/t/dont-save-fixtures-into-database/137979/8 "2008-05-20T00:12:38Z")

</div>

Why would you want to delete them? The fixtures are going to be in the  
test  
database until you load more fixtures in.

On Tue, May 20, 2008 at 6:01 AM, Mr\_Tibs [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid)  
wrote:

> 

–  
Appreciated my help?  
Reccommend me on Working With Rails  
[http://workingwithrails.com/person/11030-ryan-bigg](http://workingwithrails.com/person/11030-ryan-bigg)
