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: