Description:

Create a new database view in your application.

To create a materialized view, pass the '--materialized' option.

Examples:

rails generate sql_view:view ActiveUser 'User.where(active: true)'

  create: app/sql_views/search_view.rb
  create: db/migrate/20140803191158_create_active_users_views.rb

Examples:

rails generate sql_view:view ArchivedAccount Account.archived --materialized --view-name=inactive_accounts

  create: app/sql_views/search_view.rb
  create: db/migrate/20140803191158_create_search_views.rb