How to copy views from development db to test db while running rake?

Question

I am stuck at a particular situation . When I run
rake db:test:clone_structure ,the test db is not copying the views that are in the development db.So is there any solution for this problem so that I can get the views in test db also . I have tried using rake db:test:purge and rake db:test:clone as well. But it doesn't support me as well.

Hope I get some suggestions here ,

Thanks in Advance .

When you say views, do you mean the tables and data?

Chris Kimpton
– Chris Kimpton

2011-01-20 07:22:51 +00:00
Commented Jan 20, 2011 at 7:22 — Chris Kimpton
– Chris Kimpton, Commented Jan 20, 2011 at 7:22

Milan Novota · Accepted Answer · 2011-01-20 10:24:55Z

1

Try to change the database schema format to :sql instead of its default :ruby format and see if it helps.

Just add his line to your application.rb:

config.active_record.schema_format = :sql

Note: By using this option, your schema dump might become less portable.

answered Jan 20, 2011 at 10:24

Milan Novota

15.6k7 gold badges57 silver badges62 bronze badges

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

1 Comment

karthik339 Over a year ago

@Chris Kimpton yes I mean tables and data. I have each view for a given table .So I must be able to add or delete data through this view .

nickgrim · Accepted Answer · 2011-01-20 10:31:16Z

0

Haven't tried it myself (although I'm just about to), but the solution is supposed to be to install the rails_sql_views gem.

answered Jan 20, 2011 at 10:31

nickgrim

5,4371 gold badge26 silver badges29 bronze badges

Collectives™ on Stack Overflow

How to copy views from development db to test db while running rake?

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related