require 'earth/eia'
require 'earth/locality'
MecsEnergy.class_eval do
  const_set(:CENSUS_REGIONS, {
    'Total US' =>  {
      :crop => (15..93),
      :code => nil
    },
    'Northeast' => {
      :crop => (99..177),
      :code => 1
    },
    'Midwest' => {
      :crop => (184..262),
      :code => 2
    },
    'South' =>  {
      :crop => (267..345),
      :code => 3
    },
    'West' => {
      :crop => (351..429),
      :code => 4
    }
  })

  data_miner do
    MecsEnergy::CENSUS_REGIONS.each do |region, data|
      import("MECS table 3.2 #{region}",
        :url => "http://205.254.135.24/emeu/mecs/mecs2006/excel/Table3_2.xls",
        :crop => data[:crop], :headers => false, :skip => 1) do
        key 'name', :synthesize => Proc.new { |row| "#{Industry.format_naics_code(row[0])}-#{data[:code]}" }
        store 'naics_code', :field_number => 0
        store :total, :field_number => 2
        store :net_electricity, :field_number => 4
        store :residual_fuel_oil, :field_number => 5
        store :distillate_fuel_oil, :field_number => 6
        store :natural_gas, :field_number => 8
        store :lpg_and_ngl, :field_number => 10
        store :coal, :field_number => 12
        store :coke_and_breeze, :field_number => 13
        store :other, :field_number => 14
        store 'census_region', :static => data[:code]
      end
    end

    process :normalize_fuels do
      Earth::EIA.normalize(MecsEnergy, MecsEnergy::FUELS)
    end
  end
end