0.01
No commit activity in last 3 years
No release in over 3 years
Adds support for MySQL views in ActiveRecord via the Scenic gem
2005
2006
2007
2008
2009
2010
2011
2012
2013
2014
2015
2016
2017
2018
2019
2020
2021
2022
2023
2024
 Dependencies

Development

~> 1.10
~> 10.0
>= 0

Runtime

~> 1.1.1
 Project Readme

Scenic Mysql Adapter

This gem adds MySQL support for the wonderful Scenic gem by Thoughtbot.

Installation

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

Usage

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.

Contributing

Bug reports and pull requests are welcome on GitHub at https://github.com/startweaving/scenic_mysql.

License

The gem is available as open source under the terms of the MIT License.