ActiveRecord

Inspect rails tables and columns en masse hacks

ActiveRecord::Base.connection.tables.flat_map do |table_name|
 ActiveRecord::Base.connection.columns(table_name).map do |c|
    [table_name, c.name, c.sql_type_metadata.sql_type, c.sql_type_metadata.type]
 end
end

Time an ActiveRecord Query hacks

def time_query(q)
  start = Time.now
  r = ActiveRecord::Base.connection.execute(q)
  puts "Duration: #{Time.now - start}"
  return r
end