GitPedia
scenic-views

scenic-views/scenic

Versioned database views for Rails

10 Releases
Latest: 9y ago
1.4.0 - lit-brook-38160v1.4.0Latest
calebhearthcalebhearth·9y ago·May 19, 2017
GitHub

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.
1.3.0 - Sassy Pandav1.3.0
calebhearthcalebhearth·10y ago·May 27, 2016
GitHub

📋 Changes

  • Add replace_view migration statement, which issues `CREATE OR REPLACE
  • Schema-qualify views outside the 'public' namespace, such as
  • Singularize generated model name when injecting into class.
  • Convert shell-based smoke tests to RSpec syntax.
v1.2.0
derekpriorderekprior·10y ago·February 6, 2016
GitHub

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
  • + 2 more
v1.1.1
derekpriorderekprior·10y ago·January 29, 2016
GitHub

🐛 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](https://github.com/thoughtbot/scenic/compare/v1.1.0...v1.1.1)
v1.1.0
calebhearthcalebhearth·10y ago·January 8, 2016
GitHub

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](http://www.postgresql.org/support/versioning/) 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](v1.0.0...v1.1.0)
v1.0.0
derekpriorderekprior·10y ago·December 3, 2015
GitHub

Added

  • Added support for [materialized views](https://github.com/thoughtbot/scenic/blob/v1.0.0/README.md).
  • 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](https://github.com/thoughtbot/scenic/compare/v0.3.0...v1.0.0)
v0.3.0Pre-release
derekpriorderekprior·10y ago·November 6, 2015
GitHub

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](https://github.com/thoughtbot/scenic/compare/v0.2.1...v0.3.0)
v0.2.1Pre-release
derekpriorderekprior·10y ago·November 6, 2015
GitHub

🐛 Fixed

  • View generator will now create `db/views` directory if necessary.
Scenic v0.2.0v0.2.0Pre-release
calebhearthcalebhearth·11y ago·October 29, 2014
GitHub

📋 Changes

  • 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
scenic v0.1.0v0.1.0Pre-release
calebhearthcalebhearth·11y ago·October 29, 2014
GitHub

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.