# Tests doesn't clear my tables?

**URL:** <https://www.ruby-forum.com/t/tests-doesnt-clear-my-tables/120173>\
**Category:** Rails\
**Created:** [November 14, 2007, 2:21pm UTC](https://www.ruby-forum.com/t/tests-doesnt-clear-my-tables/120173 "2007-11-14T14:21:17Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Davi](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/d/ecb155/32.png) [@Davi](https://www.ruby-forum.com/u/Davi)\
**Post date:** [November 14, 2007, 2:21pm UTC](https://www.ruby-forum.com/t/tests-doesnt-clear-my-tables/120173/1 "2007-11-14T14:21:17Z")

</div>

Hi all. I’m using the following test:

[category\_test.rb]  
require File.dirname( **FILE** ) + ‘/…/test\_helper’

class CategoryTest \< Test::Unit::TestCase  
fixtures :categories  
def aequal(expected, got, message=’’)  
assert\_equal ActiveRecord::Errors.default\_error\_messages[expected],  
got,  
message  
end

# Replace this with your real tests.

def test\_no\_blank\_name  
category = Category.create(:name =\> ‘’)  
aequal :blank, category.errors.on(:name), “Empty name”  
end

def test\_no\_nil\_name  
category = Category.create(:name =\> nil)  
aequal :blank, category.errors.on(:name), “Nil name”  
end

def test\_no\_duplicate\_name  
category1 = Category.create(:name =\> “oi”)  
category2 = Category.create(:name =\> “oi”)  
aequal :taken, category2.errors.on(:name), “Duplicate name”  
end  
end  
[/category\_test.rb]

After call rake test:units, I got:

[output]  
$ rake test:units  
/usr/bin/rake:17:Warning: require\_gem is obsolete. Use gem instead.  
(in /home/davi/documentos/rails/eoe)  
/usr/bin/ruby18 -Ilib:test  
“/usr/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake/rake\_test\_loader.rb”  
“test/unit/category\_test.rb”  
Loaded suite  
/usr/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake/rake\_test\_loader  
Started  
F…  
Finished in 0.120167 seconds.

1. Failure:  
test\_no\_blank\_name(CategoryTest)  
[./test/unit/category\_test.rb:6:in `aequal' ./test/unit/category_test.rb:13:in`test\_no\_blank\_name’]:  
Empty name.  
\<“can’t be blank”\> expected but was  
\<[“has already been taken”, “can’t be blank”]\>.

3 tests, 3 assertions, 1 failures, 0 errors  
rake aborted!  
Command failed with status (1):  
[/usr/bin/ruby18 -Ilib:test "/usr/lib/ruby/…]

(See full trace by running task with --trace)  
[/output]

And my tables has the following data:

[output]

> select \* from categories;  
> ±—±-----+  
> | id | name |  
> ±—±-----+  
> | 1 | |  
> | 2 | |  
> ±—±-----+  
> 2 rows in set (0.00 sec)  
> [/output]

What am I doing wrong?

## Thanks in advice

## Davi V.

E-mail: removed\_email\_address@domain.invalid  
MSN : removed\_email\_address@domain.invalid  
GTalk : removed\_email\_address@domain.invalid  
Skype : davi vidal  
ICQ : 138815296

---

<div class="post-metadata">

**Author:** ![Davi](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/d/ecb155/32.png) [@Davi](https://www.ruby-forum.com/u/Davi)\
**Post date:** [November 14, 2007, 2:58pm UTC](https://www.ruby-forum.com/t/tests-doesnt-clear-my-tables/120173/2 "2007-11-14T14:58:14Z")

</div>

Your database support transactions (commit/rollback) ?

## Regards,

Rafael Mueller

> **[Quero ser Ágil](https://queroseragil.wordpress.com)**
>
> Idéias e experiências de um desenvolvedor em busca da Agilidade

---

<div class="post-metadata">

**Author:** ![Davi](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/d/ecb155/32.png) [@Davi](https://www.ruby-forum.com/u/Davi)\
**Post date:** [November 14, 2007, 3:04pm UTC](https://www.ruby-forum.com/t/tests-doesnt-clear-my-tables/120173/3 "2007-11-14T15:04:41Z")

</div>

On 14 Nov 2007, at 13:24, Davi wrote:

> ±—±-----+  
> 2 rows in set (0.00 sec)  
> [/output]
> 
> What am I doing wrong?

I’ll ask the obvious question: what’s in your categories.yml file ?

Fred

---

<div class="post-metadata">

**Author:** ![Davi](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/d/ecb155/32.png) [@Davi](https://www.ruby-forum.com/u/Davi)\
**Post date:** [November 14, 2007, 3:08pm UTC](https://www.ruby-forum.com/t/tests-doesnt-clear-my-tables/120173/4 "2007-11-14T15:08:12Z")

</div>

Em Qua 14 Nov 2007, Davi escreveu:

> Hi all. I’m using the following test:
> 
> [category\_test.rb]  
> require File.dirname( **FILE** ) + ‘/…/test\_helper’
> 
> class CategoryTest \< Test::Unit::TestCase  
> fixtures :categories  
> […]  
> end  
> [/category\_test.rb]
> 
> What am I doing wrong?

I hadn’t configured my fixtures file.

Sorry my mistake.

## – Davi V.

E-mail: removed\_email\_address@domain.invalid  
MSN : removed\_email\_address@domain.invalid  
GTalk : removed\_email\_address@domain.invalid  
Skype : davi vidal  
ICQ : 138815296

---

<div class="post-metadata">

**Author:** ![Davi](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/d/ecb155/32.png) [@Davi](https://www.ruby-forum.com/u/Davi)\
**Post date:** [November 14, 2007, 3:16pm UTC](https://www.ruby-forum.com/t/tests-doesnt-clear-my-tables/120173/5 "2007-11-14T15:16:25Z")

</div>

Em Qua 14 Nov 2007, Frederick C. escreveu:

> > What am I doing wrong?
> 
> I’ll ask the obvious question: what’s in your categories.yml file ?

categories.yml = fixtures? If yes, I’ve forgotten categories.yml.  
Sorry.

Thank you very much.

## – Davi V.

E-mail: removed\_email\_address@domain.invalid  
MSN : removed\_email\_address@domain.invalid  
GTalk : removed\_email\_address@domain.invalid  
Skype : davi vidal  
ICQ : 138815296