Script to check if migrations in the structure.sql file match the ones on the file system

check_migrations.rb

IO.readlines("db/structure.sql").each do |line|
  if line["INSERT INTO schema_migrations"]
    migration_id = line.split(/'/)[1]
    puts "#{migration_id} is missing" if Dir.glob("db/migrate/#{migration_id}_*.rb").empty?
  end
end