class FillJobsCategoriesTables < ActiveRecord::Migration
  def self.up
    Job.all.each do |j|
      Rails.logger.error "Jobs #{j.id}"
      region = j.region.split("-").each(&:strip!).join(" - ")

      r = Region.where( :name => region ) || Region.new( :name => region )
      r.save

      pCode = j.postal_code.split(":").each( &:strip! )
      pCode = pCode[0] if pCode

      pBox  = j.postal_code.split(":").each( &:strip! )
      pBox  = pBox[0] if pBox

      b = Business.new

      b.manager     = j.manager     #1
      b.phone       = j.phone       #2
      b.fax         = j.fax         #3
      b.telefax     = j.telefax     #4
      b.mobile      = j.mobile      #5
      b.address     = j.address     #6
      b.postal_code = pCode         #7
      b.po_box      = pBox          #8
      b.website     = j.website     #9
      b.email       = j.email       #10
      b.category_id = j.category_id #11
      b.name        = j.name        #12
      b.region_id   = r.id          #13

      b.save
      # id, guid, region
    end
  end

  def self.down
  end
end