class ActiveRecord::TestCase

def assert_sql(*patterns_to_match)
  SQLCounter.clear_log
  yield
  SQLCounter.log_all
ensure
  failed_patterns = []
  patterns_to_match.each do |pattern|
    failed_patterns << pattern unless SQLCounter.log_all.any?{ |sql| pattern === sql }
  end
  assert failed_patterns.empty?, "Query pattern(s) #{failed_patterns.map{ |p| p.inspect }.join(', ')} not found.#{SQLCounter.log.size == 0 ? '' : "\nQueries:\n#{SQLCounter.log.join("\n")}"}"
end