Contents

DishwasherUse.class_eval do
  data_miner do
    schema do
      string 'name'
      float 'annual_energy_from_electricity_for_dishwashers'
      string 'annual_energy_from_electricity_for_dishwashers_units'
    end
    
    process "derive from ResidentialEnergyConsumptionSurveyResponse" do
      ResidentialEnergyConsumptionSurveyResponse.run_data_miner!
      connection.execute %{
        INSERT IGNORE INTO dishwasher_uses(name)
        SELECT DISTINCT recs_responses.dishwasher_use_id FROM recs_responses WHERE LENGTH(recs_responses.dishwasher_use_id) > 0
      }
    end
    
    # sabshere 5/25/10 weird that this uses cohort
    process "precalculate annual energy" do
      find_in_batches do |batch|
        batch.each do |record|
          record.annual_energy_from_electricity_for_dishwashers = ResidentialEnergyConsumptionSurveyResponse.big_cohort(:dishwasher_use => record).weighted_average :annual_energy_from_electricity_for_dishwashers
          record.annual_energy_from_electricity_for_dishwashers_units = 'joules'
          record.save!
        end
      end
    end
  end
end

Version data entries

5 entries across 5 versions & 1 rubygems

Version	Path
earth-0.4.1	lib/earth/residence/dishwasher_use/data_miner.rb
earth-0.4.0	lib/earth/residence/dishwasher_use/data_miner.rb
earth-0.3.15	lib/earth/residence/dishwasher_use/data_miner.rb
earth-0.3.14	lib/earth/residence/dishwasher_use/data_miner.rb
earth-0.3.13	lib/earth/residence/dishwasher_use/data_miner.rb