Use migrations to setup test database in Rails 3

Question

I have some raw sql statements that create triggers and functions in my migrations. They are not invoked in the tests.

How can I use normal migrations to setup the test database? And why isn't that the default method?

score 0 · Accepted Answer · edited May 23 '17 at 12:04

0

Reason is that the test database is restored from schema.rb file. And Schema dump doesnt create procedures,functions, fkeys etc. The reason for that is Rails doesnt encourage using them. You can however change the schema dump format to sql.

config.active_record.schema_format = :sql

See following thread Why does rake db:migrate in Rails not add functions to the schema file?

Check this article as well http://pivotallabs.com/users/jdean/blog/articles/1707-using-mysql-foreign-keys-procedures-and-triggers-with-rails

edited May 23 '17 at 12:04

Community

1
1

answered Oct 07 '12 at 11:43

irfn

560
3
11

I already set schema_format to sql in application.rb. But only the standard shema.rb gets generated (and used). – snøreven Oct 07 '12 at 11:54
ok, now a structure.sql was created. but test seems to ignore it. – snøreven Oct 07 '12 at 12:04

Use migrations to setup test database in Rails 3

1 Answers1