How to create mysql function in rails test database?

Question

I wrote a Mysql function for my rails app and i added it to my database by manual. When i want to test the function using Rails UNIT test, it through the errors like below

ActiveRecord::StatementInvalid: Mysql::Error: FUNCTION mydatabase.fn_Sample_Function does not exist:

How to add the function, out of the test suite or beginning of test run ?

Thanks in Advance, Aaa.

Omar Qureshi · Accepted Answer · 2011-09-09 12:26:00Z

2

I can't see the error. But I assume the problem is your schema format.

config.active_record.schema_format = :sql

in application.rb should be what you need to do.

The reason behind that is by default your test database is not made from a schema only dump of your development database, but, instead from db/schema.rb - which knows nothing about mysql functions.

an sql schema format will do a mysqldump (or pg_dump) with the schema only flag set to true and create a development_structure.sql file.

answered Sep 9, 2011 at 12:26

Omar Qureshi

9,1033 gold badges35 silver badges35 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Jak Over a year ago

Thanks for the Quick answer, i am using 2.3.12 version. I don't think we can use config object in application.rb file.. Please correct me if i was wrong.. i added it in enviroment.rb file but no help..

Omar Qureshi Over a year ago

ok - environment.rb is fine - did it create the development_structure file?

dexter Over a year ago

environment.rb is the place to add this configuration. Please run rake db:schema:dump to generate the schema.rb in the sql format and then run your unit tests.

Collectives™ on Stack Overflow

How to create mysql function in rails test database?

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related