This gem adds MySQL support for the wonderful Scenic gem by Thoughtbot.
Add this line to your application's Gemfile:
gem 'scenic'
gem 'scenic_mysql'
And then execute:
$ bundle
Or install it yourself as:
$ gem install scenic_mysql
Add an initializer with the following code:
# This code overwrites Mysql2Adapter's `database` method,
# which pulls back all tables with views.
#
# The new method returns only tables, without the views.
#
ActiveRecord::ConnectionAdapters::Mysql2Adapter.send(
:include, Scenic::Adapters::Mysql::TablesDefinition
)
# Tell Scenic to use MySQL instead of the defaulted PostgreSQL.
Scenic.configure do |config|
config.database = Scenic::Adapters::Mysql.new
end
Note that the adapter currently does not support materialized views for MySQL.
Bug reports and pull requests are welcome on GitHub at https://github.com/startweaving/scenic_mysql.
The gem is available as open source under the terms of the MIT License.