Scenic Versions Save

Added

• refresh_materialized_view now accepts a cascade option, which defaults to false. Setting this option to true will refresh any materialized views the current view depends on first, ensuring the view being refreshed has the most up-to-date information.
• sql_definition argument is now supported when using update_view.

Fixed

• View migrations created under Rails 5 and newer will no longer result in warnings.
• ar_internal_metadata is no longer included in the schema dump for Rails 5 and newer apps.
• Using the scenic:model generator will no longer create a fixture or factory.

Added

• Add replace_view migration statement, which issues CREATE OR REPLACE VIEW rather than CREATE VIEW or DROP VIEW and CREATE VIEW.
• Schema-qualify views outside the 'public' namespace, such as scenic.searches

Fixed

• Singularize generated model name when injecting into class. Previously, pluralized names would issue a warning and Scenic would attempt to insert model code into the pluralized model file.
• Convert shell-based smoke tests to RSpec syntax.

Added

• The generators now accept namespaced view definitions. For example: rails generate scenic:view my_app.users.

Fixed

• Materialized view indexes are now properly dumped to db/schema.rb. This was an oversight in previous releases, meaning rake db:schema:load was missing indexes.
• Calling update_view for a materialized view now properly finds associated indexes for automatic reapplication. An issue in the previous index query was returning no indexes.

Note: Dumping materialized view indexes will produce an invalid db/schema.rb file under Rails 5 beta 1 and beta 2. This is fixed on Rails master.

Full Changelog

Fixed

• Some schema operations were failing with a PG::ConnectionBad: connection is closed error. This has been fixed by ensuring we grab a fresh connection for all operations.

Full Changelog

Added

• Added support for updating materialized view definitions while maintaining existing indexes that are still applicable after the update.
• Added support for refreshing materialized views concurrently (requires Postgres 9.4 or newer).

Fixed

• The schema dumper will now dump views and materialized views together in the order they are returned by Postgres. This fixes issues when loading views that depend on other views via rake db:schema:load.
• Scenic now works on supported versions of Postgres older than 9.3.0. Attempts to use database features not supported by your specific version of Postgres will raise descriptive errors.
• Fixed inability to dump materialized views in Rails 5.0.0.beta1.

Full Changelog

We've arrived at 1.0. Please enjoy!

Added

• Added support for materialized views.
• Allow changing the database adapter via Scenic::Configuration.

Fixed

• Improved formatting of the view when dumped to schema.rb.
• Fixed generation of namespaced models by using ActiveRecord's own model generator.
• Eliminated alias_method_chain deprecation when running with Rails master (5.0).

Full Changelog

Added

• Previous view definition is copied into new view definition file when updating an existing view.

Fixed

• We avoid dumping views that belong to Postgres extensions.
• db/schema.rb is prettier thanks to a blank line after each view definition.

Full Changelog

Fixed

• View generator will now create db/views directory if necessary.

• scenic:view generator is now smart enough to update existing views.
• Add API documentation for Scenic::Statements.
• Raise error for missing view definition (rather than letting the database raise the error)

Scenic makes it easier to work with Postgres views in Rails.

It introduces view methods to ActiveRecord::Migration and allows views to be dumped to db/schema.rb.

It provides generators for models, view definitions, and migrations.

It is build around a basic versioning system for view definition files.

In short, go add a view to your app.