Mysql2QueryFilter
Filtering framework for Mysql2.
Installation
Add this line to your application's Gemfile:
gem 'mysql2_query_filter'
And then execute:
$ bundle
Or install it yourself as:
$ gem install mysql2_query_filter
Usage
require 'mysql2_query_filter'
class MyFilter < Mysql2QueryFilter::Base
def filter(sql, client)
p sql
p client
end
end
Mysql2QueryFilter.configure do |filter|
filter.add MyFilter
end
Mysql2QueryFilter.enable!
client = Mysql2::Client.new(host: 'localhost', username: 'root')
client.query('show databases')
Use plug-in
see mysql2_query_filter-plugin-log.
require 'mysql2_query_filter'
Mysql2QueryFilter.configure do |filter|
filter.plugin :log #, out: $stderr
end
Mysql2QueryFilter.enable!
client = Mysql2::Client.new(host: 'localhost', username: 'root')
client.query('show databases')