Script to reset all tables primary keys for a rails app

reset_tables_identity.rb

ActiveRecord::Base.connection.tables.each do |table_name|
  next if table_name == 'ar_internal_metadata'
  next unless ActiveRecord::Base.connection.columns(table_name).map(&:name).include?('id')
  ActiveRecord::Base.connection.execute "SELECT setval('#{table_name}_id_seq', (SELECT MAX(id) FROM #{table_name}));"
end