Parse json and store the results to a database

fetcher.rb

require 'rubygems'
require 'json'
require 'httparty'
require 'active_record'
require 'pry'

ActiveRecord::Base.establish_connection(
  :adapter  => 'mysql2',
  :database => 'lol',
  :username => 'yourusername',
  :password => 'yourpass',
  :host     => 'localhost')

class Hero < ActiveRecord::Base
end


response = HTTParty.get('http://localhost/championFull.json')
json = JSON.parse(response.body)

json["data"].each do |hero|
  unless Hero.where(name: hero[1]["name"]).first
    power = hero[1]["info"]["attack"] + hero[1]["info"]["defense"] + hero[1]["info"]["magic"]
    hero = Hero.new(name: hero[1]["name"], title: hero[1]["title"], category: hero[1]["tags"].first, attack: hero[1]["info"]["attack"], defense: hero[1]["info"]["defense"], magic: hero[1]["info"]["magic"], difficulty: hero[1]["info"]["difficulty"], power: power)
    hero.save
  end
end