Generate clean sql migrations from lol_dba

migrations.rake

namespace :migrations do

  desc 'Generate clean SQL migrations from lol_dba'

  task clean_sql: :environment do
    Rake::Task["db:migrate_sql"].invoke

    sql_migration_files = Dir[Rails.root.join("db", "migrate_sql")+"*.sql"]

    sql_migration_files.each_with_index do |sql_file,i|
      cleaned_lines = []
      lines = File.read(sql_file).split("\n")

      lines.each do |line|
        next if line.include?("information_schema.tables")
        next if line.include?("schema_migrations")
        cleaned_lines << line
      end

      File.open(sql_file,"w") do |file|
        cleaned_lines.each do |cl|
          file.write(cl)
        end
      end

      puts "Cleaned #{sql_file}"
    end

  end
end

This generates clean migrations without cluttering up a shared DB with information_schema.tables queries and schema_migrations modifications.