Adding funcs, and triggers to test db

Question

I have some custom functions and triggers, that were run as migrations and added into dev db. However when i run my tests - it seems like test db doesn't have these functions and triggers, and throws errors in specs, which using queries that requires these db-functions. I've tried to manually run rake db:test:clone - but that copies only db structure, not its functions and triggers. How do i create full duplicate for db, keeping not only its structure, but also custom db functions, triggers and views?

PS: Db: postgres

apneadiving · Accepted Answer · 2015-08-15 07:57:22Z

2

I recommend you use this setting:

config.active_record.schema_format = :sql

This would create a real sql file containing all details of your db.

And it would be loaded whenever you use rake db:setup

Before changing the setting, you could use rake db:structure:dump to create the sql file.

answered Aug 15, 2015 at 7:57

apneadiving

116k26 gold badges225 silver badges215 bronze badges

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

1 Comment

mlt Over a year ago

With that line, after running rake test, I still get triggers disabled in test database with Rails 5 and PostgreSQL :( I do have reasonable structure.sql and no schema.rb.

Collectives™ on Stack Overflow

Adding funcs, and triggers to test db

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related