Skip to content


Subversion checkout URL

You can clone with HTTPS or Subversion.

Download ZIP
Rails SQL Views project extracted from ActiveWarehouse
branch: master

Merge pull request #15 from pisaruk/master

Deal with create view sql where tabs, newlines or space are used and retrieve view_definition from sys.objects
latest commit bb531df6d7
@aeden aeden authored
Failed to load latest commit information.
rails Made it work with Rails 2.3.2, at least for MySQL and PostgreSQL adap…
test optionally specify the order in which views are created
.gitignore Moving configuration of drivers into a YAML file.
CHANGELOG added nonview_tables where missing. need to get tests running again
CONTRIB initial checkin to git
LICENSE added license
README initial checkin to git
Rakefile Gemified with jeweler
TODO Renamed Adapter#nonview_tables to #base_tables with an alias to the o…
VERSION Version bump to 0.8.0
init.rb Adding init.rb.
rails_sql_views.gemspec Gemified with jeweler


== 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

    def self.down
      drop_view :v_people
This extension also adds support for views in the ActiveRecord::SchemaDumper class.

The following drivers are supported:

 PostgreSQL (Native and Pure Ruby)
 SQL Server

== Known Issues

* Drivers not mentioned above are not supported.

If you find any issues please send an email to .

== 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. :-)
Something went wrong with that request. Please try again.