check for integer columns in a rails schema

bigint_check.rake

desc "Check for integer columns that should be migrated to bigint"
task bigint_check: :environment do

  ActiveRecord::Base.connection.tables.each do |table_name|
    ActiveRecord::Base.connection.columns(table_name).each do |column|
      if column.sql_type == "integer"
        puts "Warning: #{table_name}.#{column.name} is of type integer rather than bigint"
      end
    end
  end
end