Sha256: a193984aa919fe33f7dd6462746a83e07803d2ada906a9caf49924ba4900ab3f
Contents?: true
Size: 1.07 KB
Versions: 5
Compression:
Stored size: 1.07 KB
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