detect inconsistencies between migrations in codebase and database

gistfile1.txt

db_versions = ActiveRecord::Base.connection.execute('select * from schema_migrations').map {|r| r['version']}
migrations = Dir.glob('db/migrate/*').map {|f| File.basename(f).split('_').first }

unrun_migrations = migrations.reject {|m| db_versions.include?(m) }
unreverted_migrations = db_versions.reject {|v| migrations.include?(v) }