Mysql2QueryFilter::Plugin::CasualLog

Plug-in that colorize the bad query for Mysql2QueryFilter. It is porting of MySQLCasualLog.pm.

see http://kamipo.github.io/talks/20140711-mysqlcasual6

Installation

Add this line to your application's Gemfile:

gem 'mysql2_query_filter-plugin-casual_log'

And then execute:

$ bundle

Or install it yourself as:

$ gem install mysql2_query_filter-plugin-casual_log

Usage

require 'mysql2_query_filter'

Mysql2QueryFilter.configure do |filter|
  filter.plugin :casual_log #, client: Mysql2::Client.new(...)
end

Mysql2QueryFilter.enable!

client = Mysql2::Client.new(host: 'localhost', username: 'root', database: 'mysql')
client.query('SELECT * FROM user')
# => # SELECT * FROM user
#    ---
#               id: 1
#      select_type: SIMPLE
#            table: user
#             type: ALL # <- red/bold
#    possible_keys:
#              key:
#          key_len:
#              ref:
#             rows: 4
#            Extra: