Join GitHub today
GitHub is home to over 20 million developers working together to host and review code, manage projects, and build software together.
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. :-)