count queries

count_queries.rb

#!/usr/bin/env ruby

require 'pp'

h = { :select => 0, :insert => 0, :delete => 0, :update => 0}
ARGF.each do |line|
  case line
  when /SELECT.*FROM/i then
    h[:select] += 1
  when /INSERT.*INTO/i then
    h[:insert] += 1
  when /DELETE.*FROM/i then
    h[:delete] += 1
  when /UPDATE.*SET/i then
    h[:update] += 1
  end
end

pp h