Sha256: 8773b9f0a2fc424fb90ba5626e5cbac25c5e9d2106f6b489776e4fdc2336767d
Contents?: true
Size: 1.04 KB
Versions: 8
Compression:
Stored size: 1.04 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!
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
8 entries across 8 versions & 1 rubygems