Ruby On Rails ActiveRecord SQL view into schema

Question

I created a view and was able to successfully access it through rails by creating the view through a migration with execute sql.

The problem with this is that the view is not entered into the schema. So when I need to create my test database to run my tests against the view is not created. I then need to create it by running the sql statement. Is there a way to implement SQL views elegantly in ruby on rails?

My environment: Ruby on Rails 3.0.3 PostgreSQL 8.3

adamlamar · Accepted Answer · 2011-05-27 20:02:44Z

1

The rails_sql_views gem is intended to solve this problem. It adds support to the schema dumper to include views, which means you can use them in your test database. I'm not sure how well it works in Rails 3, but the github issues list has a pull request that appears to add Rails 3 support.

answered May 27, 2011 at 20:02

adamlamar

4,9472 gold badges29 silver badges22 bronze badges

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

2 Comments

Nicolo77 Over a year ago

This did solve my problem although there were a few pauses for concern. I had to edit the code for it to work with Postgres.

GeorgeW Over a year ago

Nicolo77> Could you share what code change you made to make the gem work with postgres?

khustochka · Accepted Answer · 2011-01-10 01:43:19Z

0

Possibly. using config.active_record.schema_format = :sql may help.

answered Jan 10, 2011 at 1:43

khustochka

2,39621 silver badges31 bronze badges

Collectives™ on Stack Overflow

Ruby On Rails ActiveRecord SQL view into schema

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related