Join GitHub today
Fetching latest commit…
Cannot retrieve the latest commit at this time.
|Failed to load latest commit information.|
== Rails SQL Views Library which adds SQL Views to Rails. Adds create_view and drop_view to the ActiveRecord::ConnectionAdapters::AbstractAdapter (which makes them available to migrations) and adds support for dumping views in the ActiveRecord::SchemaDumper. == Installation To install: gem install rails_sql_views Then add the following to your Rails config/environment.rb: require_gem 'rails_sql_views' require 'rails_sql_views' == Usage You can then use create_view and drop_view in your migrations. For example: class CreatePersonView < ActiveRecord::Migration def self.up create_view :v_people, "select * from people" do |t| t.column :id t.column :name t.column :social_security end end def self.down drop_view :v_people end end This extension also adds support for views in the ActiveRecord::SchemaDumper class. The following drivers are supported: MySQL PostgreSQL (Native and Pure Ruby) Oracle SQL Server == Known Issues * Drivers not mentioned above are not supported. If you find any issues please send an email to firstname.lastname@example.org . == Contributing If you would like to implement view support for other adapters then please drop me an email. Better yet, write up the adapter modifications and send them to me. :-)