test:prepare failure with enum columns

rubyonrails-talk
1

Hi, I have a MySQL database that I use with my Rails application. I attempted to use "rake db:test:prepare" to create a test database. (Very cool, feature, by the way.) I then get the error

rake aborted!   You have a nil object when you didn't expect it!   You might have expected an instance of Array.   The error occured while evaluating nil.

After some search I learned that the schema dump cannot handle e.g. enum columns. There is an old ticket #2379 about it but it seems not to have been implemented in 2.0. ( I am using a Imac and textmate)

I also found another solution (http://snippets.dzone.com/posts/show/2031) using a rake file that I called test_prepare.rake and put in lib/tasks/test_prepare.rake, but when I used the rake command I got the message Don't know how to build task 'test_prepare'

The question is now how to create a test database?? When I tried just to use the development database it complained about that there was no test database configured. I tried several other rake commands but they all complained about the nil object or missing configuration ?

How to go on with the testing ??? Thanks in advance. /Hans

2

The question is now how to create a test database??

Can you create an empty database by hand, in MySQL, then migrate-in your schema with

    rake RAILS_ENV=test db:migrate

?

3

Phlip wrote:

The question is now how to create a test database??

Can you create an empty database by hand, in MySQL, then migrate-in your schema with

    rake RAILS_ENV=test db:migrate

?

Thanks, it seems that your advice solved the problem. I had to do some other corrections as I had a blank before the database name in my configuration file and I had not init a constant in a plugin I not yet use.

But then rake RAILS_ENV=test db:migrate created a test data base and I can now start the testings

Thanks again