DB-views not present i schema.rb

Question

DB-views not present i schema.rb

Opened this issue 12 years ago · 2 comments

Database-views appear to have been constructed in the database manually, meaning rake db:schema:load will not work because instructions to construct db-views are not present.

Answer 1 · 2012-05-01T12:46:34.000Z

Our views from other databases have been a long standing pain for us. THis is why we want to integrate core into internal to hopefully fix some of the more complicated view-logic away.

Any suggestions on how to fix it with isfit.org?

Answer 2 · 2012-05-01T14:55:54.000Z

https://github.com/mremolt/rails_sql_views is a Rails 3.1.1-compatible gem to create views through migrations. That might work for isfit.org. A dangerous solution for internal is reverse-engineering the create-view-instructions from the existing database and put in schema.rb.