<html><head><meta http-equiv="Content-Type" content="text/html charset=windows-1252"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;">I haven't used database views before, but I *think* you should switch to using a SQL schema, using `config.active_record.schema_format` (<a href="http://guides.rubyonrails.org/configuring.html#configuring-active-record">http://guides.rubyonrails.org/configuring.html#configuring-active-record</a>) and you can then use ActiveRecord::Connection#execute to create & manage your views (<a href="http://guides.rubyonrails.org/migrations.html#when-helpers-aren-t-enough">http://guides.rubyonrails.org/migrations.html#when-helpers-aren-t-enough</a>).<div><br></div><div>It should Just Work™.</div><div><br><div><div>On 17 Jan 2014, at 11:20, Ed James (Alt) <<a href="mailto:ed.james.spam@gmail.com">ed.james.spam@gmail.com</a>> wrote:</div><br class="Apple-interchange-newline"><blockquote type="cite">
<div>
Hi all
</div><div><br></div><div>Is anyone using db views in a Rails app? If so, maybe you can help. </div><div><br></div><div>My issue lies more around the management of the views, rather than using them in the app. I’ve done this before in a previous project but I don’t have access to that codebase anymore and I can’t remember what the hell I did.</div><div><ul><li>How do you make ActiveRecord recognise the view and exclude it from the schema.rb file?</li><li>I seem to remember keeping the views as .sql files which were executed after a migration (by enhancing the db:migrate task). Any variations on this?</li></ul><div>The only gem I’ve managed to find is this one: <a href="https://github.com/railsware/db_structure_ext/tree/master/lib/db_structure_ext">https://github.com/railsware/db_structure_ext/tree/master/lib/db_structure_ext</a></div><div>Seems very old though and this seems like something which doesn’t need a gem. I know we didn’t use one previously.</div><div><br></div><div>Unfortunately using the word “view” in search criteria is not very useful ;)</div><div><br></div><div>Thanks,</div></div><div>Ed.</div>
_______________________________________________<br>Chat mailing list<br><a href="mailto:Chat@lists.lrug.org">Chat@lists.lrug.org</a><br>http://lists.lrug.org/listinfo.cgi/chat-lrug.org<br></blockquote></div><br></div></body></html>