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')