forked from Undev/rails_sql_views
-
Notifications
You must be signed in to change notification settings - Fork 1
Rails SQL Views project extracted from ActiveWarehouse
License
AVPJack/rails_sql_views
Folders and files
| Name | Name | Last commit message | Last commit date | |
|---|---|---|---|---|
Repository files navigation
== 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 anthonyeden@gmail.com .
== 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. :-)About
Rails SQL Views project extracted from ActiveWarehouse
Resources
License
Stars
Watchers
Forks
Releases
No releases published
Packages 0
No packages published
Languages
- Ruby 100.0%