DB connection debugging

db_debug.rake

namespace(:db) do
  def query(sql)
    ActiveRecord::Base.connection.query(sql)
  end

  Rake::Task['db:create'].enhance do
    config = Rails.application.config.database_configuration[Rails.env]
    puts "Config #{config}"
    conn = ActiveRecord::Base.establish_connection(config)

    puts "Connection #{conn}"
    puts "DB version #{ActiveRecord::Base.connection.database_version}"
    puts "Sanity #{query('select 1')}"
    puts "PG Users #{query('select * from pg_catalog.pg_user')}"
    puts "AR metadata #{query('select * from ar_internal_metadata')}"
  end
end