Split big sql file

split_sql.rb

filename = 'flowdata_201803052230.sql'

INSERT_MATCHER = 'INSERT INTO'
file = 1
counter = 1

File.open(filename, 'r').each do |line|
  next unless line.include? INSERT_MATCHER

  File.open(file.to_s + '.sql', 'a+') { |file| file.write("\n" + line) }
  counter += 1
  if counter == 100
    file += 1
    counter = 1
  end
end